Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Primary Key in Form

Topic Labels: Formulas
Solved
Jump to Solution
337 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m using a formula to populate the PrimaryKey field which looks like

YEAR(Date_form_submitted) &"/"& MONTH(Date_form_submitted) &"/"& {department_code_lookup (from Departments_Lookup)}&"/"& rolling_id

It works perfectly without any issues. What I want to do is add this generate value in a form. So for example, someone is submitting a new form and prior to submission I want to let them know what the PrimaryKey value (labeled as URN) is. Equally is there a way that I can send an email on submission that includes the Primarykey (URN) value to the submitter?

Regards

Simon

1 Solution

Accepted Solutions

Welcome to the Airtable community!

Airtable’s forms cannot show the value of a formula field.
You can use automations to send an email with the value of the formula field after the form is submitted.

See Solution in Thread

1 Reply 1

Welcome to the Airtable community!

Airtable’s forms cannot show the value of a formula field.
You can use automations to send an email with the value of the formula field after the form is submitted.