Hello all, I have a single select column named as “City” in all tables of a base. Now I want to have a sync between all “City” columns so that whenever I add a new city as an option it should be updated in all.
Therefore there should be a option sync for single select column.
Please share a solution to it.
There’s no easy way to do it, so I would suggest just having a table for
[Cities] and converting each of your
single select fields into
Link to Another Record-type fields. That way there’s only one source you have to update when you want to add a new city.
In first image, I have created a table named “cities” in which I have created a single select column which has different cities as options.
Now I want to have same column (in sync) in cabs available table and Removal Request table but when I create a linked record with cities table then I am only able to create lookup field and not a single select field (image 2)