I am completely new to Glide.
I have some choice drop-downs that are tied to relation columns and they don’t update with the related options until l submit previous drop-down. For example: I have a “System” data column which is selected first, if this isn’t selected and submitted, then the appropriate “Sub-System Type” choices are not available.
Can anyone advise on a workaround or solution?
Are you trying to filter the second choice? Are you filtering by the table value or the screen value?
What do you mean by this action? Do you mean navigating away from the drop-down for the first choice?
I thought l would provide some context and an overview of what l am trying to do.
If l submit the [system] choice only and then edit, choosing the other drop-down options- sub-system choice and classification choice, all is well.
What l would like to do is choose the [system], [sub-system] and [classification] the options are provided relevant to the previous choice.
Here is an overview of my setup, a share link to a Word doc with screen captures: iCloud Drive - Apple iCloud
Just sharing again…
I would not use a relation for the sub-system choice. Instead, point it to the entire table and filter it by the screen value of the first choice.
Thank you Jeff, that is actually a far simpler solution. Much appreciated.