Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 04, 2021 02:02 PM
Hi,
I have a table with around 100 rows of Animals (Duck, Dog, Lizard, Shark…) . Now I like to crowdsource people adding images to those Animals rows. I like people to go to a form, pick a Category (Birds, Mammals, Reptiles, Fish) first then, depending of what Category they pick (e.g. Mammals), they see a list of available Animals (Dog, Cat, Monkey, ) for which users can add pictures.
Is that possible in Airtable with Airtable forms?
Note: At the Category > Animal relationship is 1-to-1. I.e. each Animal only belongs to one Category.
Thanks! :slightly_smiling_face:
Apr 04, 2021 04:42 PM
Dynamic conditional value lists like this can only be done with:
or
Alternatively, if you want to stick with a native Airtable form, this is what I would recommend:
Since your animals & categories are a one-to-one relationship, then I would put the mammals & categories into the same table, and then combine them together as a formula field for your primary field. Then, make your Airtable form come from another table that links to this first table, and your users would get a dropdown list of all the (combined) animals & categories that you have already combined together for them.
Apr 05, 2021 08:32 AM
Brilliant, thanks so much, Scott! I will try it!