Oct 03, 2020 11:32 AM
Hello all! I have a Multiple Select column in several tables within a single base, and I’m wondering if there’s a way to automatically sync the available options across the different tables. Hoping to avoid continually having to go in and manually update them to make them consistent. Thanks!
Oct 04, 2020 10:04 AM
Hi Lauren! You might be better served by using a linked record. Create a new table -I’ll name it “Options” - that holds each of the multiple select options that you want in the “Name” column. Then link it to each table where you want to have the same multiple select options. Then, when you want to add options that sync across each table, just add them to the “Options” table. If you want a more visual example, share some more details about your base and I’ll provide an example
Oct 04, 2020 11:23 AM
Thanks, great solution! Not quite as pretty as Multiple Select (gotta love those colors), but definitely way more functional.
Oct 04, 2020 11:28 AM
Welcome. I love the colors too! It would be awesome if linked fields had color :slightly_smiling_face: