I’m attempting to create a public form for tracking the decon of equipment. I want the user to select from a subset of a master list based on their answer in the first field. Ie., field 1 on the form asks for the user’s department (via link to record). Based on their answer, the next selection item (link to record) would only show the item records with that department as the owner.
I tried building this using locked views, but I’m not getting it to restrict or show the items of interest.
Thoughts?