Regarding Status in a form
Hello, I am trying to build a form from my current main sheet. The sheet has a status column (RYG). The purpose of the form is to allow super's to select available units in status green. Red and Yellow are occupied or in service units.
My question is:
1) Is it possible for users to only have the options to select units in the green status? - thus only select addresses associated with the green status while they are submitting the requests for units?
Can a form be utilized this way to get requests from submitters and match to availability?