Can the selection in a “primary” choice list be used to filter possible selections in a “secondary” choice list?
Technically yes, but it all depends on your situation. I’d say no you can’t in add/edit mode, unless you were willing to use visibility to show/hide several different secondary choice components based on the first selected choice. If you are in view mode, then you can use a choice component where the selected value will be immediately sent to the sheet to allow relations and lookups to update based on that first choice. Then the updated lookup column can be used for the second choice component. If you needed, you could perform all your selections in view mode, then use a form button to pull in those selections into the form to add a record.
Thanks! I had thought about the filter mode for visibility you describe but wasnt sure if or how the first choice selection value would be immediately available as a filter value.
Ditto the timing/delay of the update loop via the backend sheet.
I’m not sure what add/edit versus view mode means …?
When I say add/edit mode, I mean a screen, such as the add screen (plus button), edit screen (pencil button) or form screen (form button). Anything the requires the user to tap on a submit button to submit the changes to the sheet. When I say view mode, I mean a screen such as the detail layout where you are simply displaying the data. View mode does allow for entry components, but any changes to the be value in each component are immediately sent to the sheet without the need to tap on Submit.
Thanks for the clarification.
Makes perfect sense.
This is my issue too. I would like to include filtered lists to an add/edit form. For example, if the user selects “wood” from a dropdown, then the next drop down would only show types of wood (not metals, plastics, etc.).
Is there a work around or any plans to add this feature?
Take a look at my concept app here…it’s close to what you’re talking about:
Robert, thanks for the suggestion. I’m not sure if that approach will work with an Add/Edit screen though.
In my app, I am trying to get the user to add selection data from two drop down lists, sequentially filtered. For example, the first dropdown list selection the user may choose is “Wood” (type of project) and then the next dropdown selection should be filtered to only include types of wood. (no metals, plastics, etc.)
Will your experiment example allow for filtered dropdown lists in the Add/Edit screen?
Yes. If I were to change those choice elements to dropdowns rather than inline selectors, they change dynamically.