I am the manager of the Makerspace at a University. We run our space/machine reservation system on Airtable and Integromat. The users fill out a Form view to register as a user first. Then they do another form anytime they want to reserve something. Part of the problem is that when they go to select who they are in the reservation form, they have access to everyone else’s name as well. This is security issue as well as a nuisance for us on the back-end.
My question is would it be possible to create conditional fields only within a Form view? For instance, if the user selects their name from the list, they must also put their password into a “Password” type field that they set when they register as a user. If it matches what’s in the record , then the form is accepted. It would work almost like a modified Lookup field combined with conditions.
This would allow us to securely have hundreds of “users” without them needing to have an Airtable account or really even any special permissions. We have almost 300 Makerspace users and having to pay for that many users in Airtable would be our entire budget - and they don’t even need access to Airtable really…
There could many other uses for this for businesses with clients, returning survey participants, etc.