Automated email with Button to Fillout Form

[JCG]

I have created a fillout for a registration form. I have a table of people I am inviting, and would like add the fillout button to an email so that most information is pre-filled, and then the registration info updates in the existing line in the table.

Please see below - the token is not working - either inserting a formula field or using the button field in the database. Can you help me correct this please to add into my automated email?

<a href="(token)" style="background-color: #4CAF50; color: white; padding: 10px 20px; text-align: center; text-decoration: none; display: inline-block; border-radius: 5px;"> Register Here </a> 

[ScottWorld]

In Fillout, you would create an "update record form" instead of a "create new record form".

Then Fillout will give you a formula that you would copy and paste into a formula field in Airtable.

That formula field is what you would insert into your email.

Here's Fillout's instructions on how to do this.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

[JCG]

Thanks Scott. I've done all that, but it still isn't pre-filling the data. It works when I click the button within the Airtable record, but not when I simply cut/paste the formula to the email. Is there a way to solve that?

[JCG]

And if I add the field value to the email, it doesn't even show in my preview.

[ScottWorld]

Airtable's automations don't understand formulas, so you always have to reference the formula field itself in your email.

[JCG]

If I just put in the fillout formula, how do I connect it back to the record?

[ScottWorld]

You need 2 different forms in Fillout, and this is the order you do it in:

1. The person will originally fill out your "create record form" in Fillout, which will create the new record for the very first time in Airtable.

2. Then, in Airtable, the formula field will get populated for that new record. Send the email using Airtable's automations AFTER the record is created. The email using that formula field will take the person to the "update record form" in Fillout.