View auto number in forms

[andrew_wilson]

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

[Justin_Barrett · Accepted solution]

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.

[andrew_wilson]

Thanks Justin, I guessed this was the case.