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
Best answer by Justin_Barrett
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.
+21Welcome 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.