On Change

[Matthew_Saragusa]

When I have someone fill out a form, I want them to be able to see some calculations before they submit. Is there a way to do that?

For instance, I would like to have a field that submits the amount of widgets made, these widgets are made in bundles of 50. If they enter 10 bundles into the “Number of Bundles” field, then they would see 500 in the “Number of Widgets” field … but, if they wanted to manually enter 253 (say they overran a bundle by 3) then they would be able to.

“Number of Widgets” would be submitted to the record, “Number of Bundles” is just a helper so they don’t have to do the math in their head.

[Jeff_Hager]

This would allow you to do what you want.

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…