How do I override a value on a fillout form update?

[JeffJohnVol]

I am trying to create a way for people to subscribe to a newsletter. The first form allows them to put in their name and email address. It works fine. I set a field called "Status" to Unconfirmed (as Single select type).

I will then have an automation that will email them a link to a form update (with the record_id() etc).  I want the form to just have the Submit button (in which I change the label to "Confirm Email".  I can have the Status field on their for them to select "Confirmed", but I'd rather it be passed in, hidden and changed to "Confirmed", so when they submit the form the status gets set to "Confirmed".

So I have the edit form (in fillout), I created the URL id of Status, and I set the formula to

"https://forms.fillout.com/t/rBuRDxxxxus?Status=Confirmed&id=" & RECORD_ID()

But every time the form gets called, the original value from airtable (which is Unconfirmed) stays there, and it doesn't get updated to Confirmed.  Does the pre-fill thing only work on create record, and not update record?

[JeffJohnVol]

Nevermind, I finally figured it out.  Apparently I had to go to the Airtable integration form and do an override on the airtable field like below (had to set it to static text as "Confirmed")

[ScottWorld]

Yes, and one additional note on this topic.

On Fillout's "update record" form, you have the option of EITHER

1. Mapping the URL parameter directly to the field (which is what you showed in your screenshot above)

OR

2. Visibly displaying the field on the form for the user to update themselves.

But you can't do both on an "update record" form. In your case, this worked out perfectly for you, but I just wanted to point out that the choice has to be one or the other.

(However, on a normal "create record" form, you can do both.)

- ScottWorld, Expert Airtable Consultant