Jun 13, 2021 08:33 PM
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.
Thanks
Jun 13, 2021 08:39 PM
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.
Jun 13, 2021 08:43 PM
Thanks @Kamille_Parks but I tried this and I am stuck at how to convert linked record field into single select field type?
Jun 13, 2021 08:54 PM
Right click the field name, select “configure”, change the field type.
Jun 13, 2021 09:49 PM
@Kamille_Parks sorry to interrupt you again but I am unable to create a linked record which is single select type. Can you please help me.
Jun 13, 2021 10:07 PM
The name of the field type you’re looking for is “Link to another record”. “Single select” is the type you already have.
If you’re still having trouble reply with screenshots of your setup pointing to what problem you’re running into.
Jun 13, 2021 10:47 PM
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)
Jun 13, 2021 11:28 PM
To clarify: you should no longer need any single select fields, anywhere.
Instead of storing cities as options in a single select you would have each city be a record in your [Cities]
table. Then in the [Removal Request]
table, you would use your {Cities}
field to link to the appropriate city.