Skip to main content

Is there a way to make a conditional value list?

  • September 25, 2018
  • 5 replies
  • 72 views

Kim_Trager1
Forum|alt.badge.img+23

I’ve tried to make conditional value lists, but so far failed.
Is there a way to do this?

5 replies

Forum|alt.badge.img+18

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?


Kim_Trager1
Forum|alt.badge.img+23
  • Author
  • Brainy
  • September 26, 2018

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?


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.


Forum|alt.badge.img+18

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.


In that case, no - this isn’t possible with Airtable.


Kim_Trager1
Forum|alt.badge.img+23
  • Author
  • Brainy
  • September 27, 2018

In that case, no - this isn’t possible with Airtable.


I thought so, but thought it would be worth asking, incase there was a way


Forum|alt.badge.img+15
  • Known Participant
  • April 28, 2021

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