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

View auto number in forms

Topic Labels: Extensions
Solved
Jump to Solution
483 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, just started out on here so please excuse if this is an old topic! I would like to see the autonumber on a form so that when an operative places an order from the form template he is able to provide the supplier with the number. Is this possible or is there another way around this?

Many thanks

1 Solution

Accepted Solutions

Welcome to the community, @andrew_wilson! :grinning_face_with_big_eyes: Airtable doesn’t allow any calculated fields to be displayed in forms. This is because at the point the form is presented to the user, the new record hasn’t yet been added to Airtable. The record is only added—and its unique number generated—after the form has been submitted.

Using this knowledge, though, you could create an automation that triggers when a new record is created in the table populated by the form, and emails the supplier with the number of their order.

See Solution in Thread

2 Replies 2

Welcome to the community, @andrew_wilson! :grinning_face_with_big_eyes: Airtable doesn’t allow any calculated fields to be displayed in forms. This is because at the point the form is presented to the user, the new record hasn’t yet been added to Airtable. The record is only added—and its unique number generated—after the form has been submitted.

Using this knowledge, though, you could create an automation that triggers when a new record is created in the table populated by the form, and emails the supplier with the number of their order.

Thanks Justin, I guessed this was the case.