Is there a way (whether through an integration or within Airtable) that I can use a user’s submitted text data to link to a record in another table? I can’t have a normal “link to record” field on the form because then the form user can see all records. I need to use their submitted answer to link to a record without them being able to see all possible records that it could link to, if that makes sense.
Example: a table of secret organizations and a table of people, with the form being a view of the table of people
Form question: Which secret organization are you in? (ask this without showing them choices for secret organizations but still use answer to link to a record of one of the organizations)
