Is there a way to “pre-fill” or “customize” one field of public form before sending?
- I have table with Clients (email is unique ID).
- Then every month I want to collect info from them into “Feedback-table”.
[Client 1] - [N Feedback-table] (linked through email)
Now if I show the email field in public form of Feedback-table,
they can choose, their email from the select, put the info inside, and send it… it will add the information from the form into Feedback-table, and link it correctly to Client table.
- BUT : I really don’t want them to see emails of other people (from the selector of linked Client table).
So how can I collect and link the info to correct record, without exposing other records from the linked table?
Or in other words: How can I use “personalized” public form to insert data into specific record?