Help

Primary Key in Form

Topic Labels: Formulas
Solved
Jump to Solution
596 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Digital_Dev
4 - Data Explorer
4 - Data Explorer

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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.