Prefill Form Formula


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('’, ‘prefill_StatusC=’,{Record ID})

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

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.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.