Adding back column with same ID after deletion

[manishaghosh (Manisha)]

If a column with a specific id was deleted (currently in trash), will it not be possible to add a column with same id using mutation and api?

[dvdsmpsn (David @ David Simpson Apps)]

Try it! Then add a comment with the mutation and whether it worked. Share your findings🙃

[manishaghosh (Manisha)]

Hey! I tried it. Only getting graphql error that the “column id is invalid”. I’m guessing the logic is that since the column is in trash and can be added back, same id is not being allowed. Not sure though.

[Matias.Monday (Matias)]

Hello there @manishaghosh,

Once an ID is used for a column, it can not be used again (even if the column is deleted).

Cheers,
Matias

[dvdsmpsn (David @ David Simpson Apps)]

Creating column ids as GUIDs or incrementing integers from the start would stop all this confusion.

I’ve read several posts on here where people think that the column id means something, whereas in reality, it’s just an id that happens to initially look similar to the column name/title on creation.

See also:

Rename of column IDs

Great tip @JeroenV. The column ID is currently set when the column is created, and follows these rules: Column IDs are immutable and generated when a column is created. To generate the ID, we take the column title at column creation, lowercase it and add underscores for any special characters or whitespace, and then add a random digit to the end (if the resulting ID is not unique). Since the ID comes from the title at creation, the column ID will be the column type when you add a colum…

[Matias.Monday (Matias)]

Thank you for the feedback @dvdsmpsn !

It will be shared with the team