
Oleksandr_Kovpa

5 - Automation Enthusiast
Comment Post Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
โOct 03, 2022
08:47 AM
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.
See more ideas labeled with:
3 Comments