Help

View field in form based on previous data

Topic Labels: Automations Data Formulas
195 2
cancel
Showing results for 
Search instead for 
Did you mean: 
danvalia
4 - Data Explorer
4 - Data Explorer

Hi, I' trying to figure out something with the form.

I need my salesteam to submit sales info in the form.

Lets suppoer we have to submit 2 field:
1) sale price
2) cost

I would like that after the user typing the 2 infos above, a field called "profit" will show the result of the equation: "sale price" - "cost"

Is this possible?

I'm trying to insert not editable fields in the form, but I couldnt figure it..

thanks

2 Replies 2

Unfortunately, that is not possible with Airtable's native forms.

That is only possible with Fillout’s advanced forms for Airtable.

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

TheTimeSavingCo
18 - Pluto
18 - Pluto

Nope I'm afraid not.  The problem is that the data doesn't actually exist yet in Airtable before the form's submitted, and so displaying calculations based off of them isn't possible.  You could try doing workarounds where you create an Interface that looks like a form, but then you'd need to pay for one seat per salesperson which I think we want to avoid here

Fillout's probably the easiest option here (https://www.fillout.com/), and you'd set up a calculation for it that would take into account the data from the form fields like so:

Create the calculation (You can get the popup to appear by typing "@"):

Screenshot 2024-11-08 at 10.45.49 AM.png

Setting it up:

Screenshot 2024-11-08 at 10.46.27 AM.png

With the conditional logic looking like this:

Screenshot 2024-11-08 at 10.46.30 AM.png

And you'd add it to your form like this:
Screenshot 2024-11-08 at 10.46.50 AM.png

And it'd look like this:

Screenshot 2024-11-08 at 10.47.09 AM.png