Lookup or Formula Field in a Form

[Erin_Keeffe]

I’m setting up a custom ordering form for a family business, where the options that a customer picks will determine some end results like total price, total items, and/or fulfillment time estimates.

I’m wondering if there is a way to show a formula field within a form to accomplish this.

As a very basic example I might have:

• 3 number fields
• 1 formula field that sums the 3 number fields
• A form that allows users to fill in the 3 number fields

I would like for the customer to be able to see the total (formula sum-ing the three number fields) in real-time as they fill out the form, just as I would if I was creating a new record and filling it in inside of the grid view in Airtable.

Is this possible or is there another way to accomplish this?

[Moe]

This can't be achieved using Airtable form. But it can be done with external tools. If you want to create a purchase order form, you can use miniExtensions. It supports showing computed fields on the form (like rollups for total price). Here's how the option looks: