Prefill Form Formula

[Simon_By]

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

[Mohamed_Swella1]

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.