I’ve searched various threads for this answer and I’m still not sure if this is possible or not. I have Table 1 (let’s say) that has a formula field which constructs a url from another field and the record id. It looks like this
With an automation I email this url (a form in another table - let’s sayTable 2) to potential respondents. Table 2 also has a field called “BD Link” which references Table 1.
When a respondent submits the form, “BD Link” is never populated. Can someone point out what I’m doing incorrectly? Thanks!
Ha, you can’t. It’s one of the many flaws of Airtable. I would suggest writing email@example.com and ask them to support hidden fields on forms, but they don’t typically listen to customer requests.
Your only real option would be to use an external form service like MiniExtensions.com or JotForm. You could also combine JotForm with the power of On2Air Forms for dynamic Airtable integration.