Sep 25, 2018 06:20 AM
I’ve tried to make conditional value lists, but so far failed.
Is there a way to do this?
Sep 25, 2018 09:49 AM
What do you mean by this? Are you trying to make a Single Select field that has varying options available to choose based on certain conditions? Or are you trying to display a list of things in a text field based on certain conditions?
Sep 26, 2018 08:20 AM
Hey Jeremy
Im trying to achieve your first suggestion - making a single select field that’ll pic up information from other places in the database instead of having to ‘hard-code’ all the options as it dosen’t seem to be very dynamic solution.
Sep 26, 2018 09:52 AM
In that case, no - this isn’t possible with Airtable.
Sep 27, 2018 09:07 AM
I thought so, but thought it would be worth asking, incase there was a way
Apr 28, 2021 07:11 AM
Morning Kim ,
What you are referring to is dynamic variable conditions for linked record fields.
Airtable rolled out “Dynamic Variables” to their automation “Find Records”. It enables you to set a condition as dynamic.
IF this were to be rolled out to the the linked record field type, you could accomplish this.
This functionality would look through values in the destination table and filter the linked record options for only those records which match the conditions.
EG:
Field 1: Linked field to Store Table, user selects grocery store from drop down
Field 2: Items, user selects grocery items hardware store items will not display
please be sure to email this to support@airtable.com to push them on this linked record feature