This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
Airtable has the useful feature of tracking the field names in formulas.
Thus when we change the name of a field it’s automatically changed in formulas.
When we create a formula field containing a URL to the pre-filled form we must type the name of a field that we want to pre-fill in a formula:
"https://airtable.com/shr123456?prefill_My+field=" & {Another field}
If we rename the field but forget to change the formula we will end up with the old field name in the URL and the pre-filling won’t work.
The improvement I’d like to request is to add a new formula for getting the field name as a string by its reference. When we have it we can use it in the formula field:
"https://airtable.com/shr123456?prefill_" & ENCODE_URL_COMPONENT(FIELD_NAME({My field})) & "=" & {Another field}
and the field name in the URL will be updated each time when we rename the field.