Include formula fields in your miniExtensions form. For example, show a calculated price total or generate a URL. Let your employees/customers see their input results immediately. You can enable this feature by turning on ‘Compute Mode‘ in your form’s settings.
In addition to enabling form fields that require computation, including formula fields and rollups. This feature also allows users to save their progress automatically in Airtable so they can pause and resume without worrying about data loss. You can also require user confirmation before the final form submission.
Demo
Here is a form that has a formula field to show the order’s total.
💡 Tip
You can combine this feature with our Stripe integration to build an entire checkout solution with payment!
Use Cases
This extension can be useful in a lot of scenarios. You can use it to build:
- Invoice/estimate
- Shopping cart
- URL generator.
- Use it as a Data Validator
- Instant quote calculator
If you click on the sample view below, you’ll see the table that’s used for the demo above.
The secondary line item form has calculation mode on, but the calculation it shows on the form is based on a rollup value from the main record. When the form is submitted, the calculation works well. But when calculated before submission, it behaves as if it was not linked to the main record. Is this the normal expected behavior?
Yes, this is the intended behavior. Created linked records don’t get linked unless the record is actually submitted. If it only got ‘calculated’ then it won’t be linked.
We are planning to use this extension to present real estate listings. We want to add live calculator containing the data from Airtable.
Yes, doing live calculations inside the form would be possible by using this function.
I switched on the Computed field which contains a formula from Airtable. But a new record gets created when it is only computed in the form. Before I see the success message.
That’s the default behavior for this feature. The records need to be added to Airtable in order to get the formula values. Please watch the demo video on our website to learn more about this functionality.