Skip to main content

Concatenate Not Working for Prefill Form

  • January 29, 2024
  • 1 reply
  • 2 views
R

Hi Everyone, 

I am trying to prefill a form with a range of record information and just can't seem to get it to work. 

I would like to produce a unique prefilled form link for each record and fill the invoice number in for each. 

 

 
My current formula:
CONCATENATE({Base Form Link},'?prefill_Invoice=',{Record ID})
 
But when I click the concatenated form link it is putting the record number in the invoice field (which is supposed to be just a 5 digit number)
 
I tried moving the invoice number from the primary field (a number) to a single line text field but still wont work
 
Any help would be much appreciated. Thanks

1 reply

ScottWorld
Forum|alt.badge.img+20
  • ScottWorld
  • Brainy
  • 8721 replies
  • January 30, 2024

Instead of referencing the Record ID, you’ll want to reference the Invoice field itself.

If you need more help designing your prefill link, check out @kuovonne’s Prefilled Forms extension. Her extension is designed to build the entire prefill link for you.

p.s. It sounds like you’re trying to add new records into Airtable, but if you’re trying to update Airtable records, you can skip the prefilling altogether by using Fillout’s advanced forms for Airtable, which lets you update Airtable records from a form (and other cool things).

Reply


Most helpful members this week

Terms & Conditions