Cannot be done via a form. Dependent lists feature is possible with this scheme:
- Create screen 1 for user select. Screen1 should have one enrty done to let things happen
- Create dependent lists there
- Create a form button that shows when a user did the last choice
- Use prefilled fields inside a form. The form should link a separate sheet to collect results.
Nice that is works in a such way! Thank you Glide and experts!
Note: list in screen1 could be user-specific to show the last selected item for each user. Nice bonus!
Iβve updated my sample to show how itβs possible: