Help

Re: Prefill Form Formula

438 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Simon_By
4 - Data Explorer
4 - Data Explorer

Hi

Trying to get a prepopulated airtable form URL to prefill a certain field, per this link.

The problem is that the form is generating a new record, not updating the old one. Do I need to use a separate sheet for the submissions, is this causing the issue?

The formula used is

CONCATENATE('https://airtable.com/shrxxxxxxxx?’, ‘prefill_StatusC=’,{Record ID})

Record ID = formula field = RECORD_ID()
StatusC = Single select field which is also included in the form

1 Reply 1

Hi @Simon_By ,

Welcome to Airtable Community!

Yes, you need to use a new table for the form, because Airtable forms are creating new records. This work around just lets you update the original record using the new record with the help of an automation.