Here’s a form:
The Quantity field label includes the premium rate. I look up that rate. However, it won’t populate the lookup col until after the form is submitted. But, I want it to update “live”.
If premium id is 1 then rate is 240 and the Quantity field label = Quantity (default = 240 x 2.00) in this example.
You can see this data is available in the detail screen once a record is created after form is submitted:
This is the edit form for a record and I’m editing three fields of many fields.
If it’s a lookup, then why use a number input?
Is that because you allow the user to change the default?
There is no way to populate that number input based on another input in the same form, but what you could do is either use a custom form, or target the inputs at the user profile row. Either of those would allow you to create a relation/lookup and then display the result in a text-type component (eg. a hint or similar)
There is a default calculation
And there needs to be the ability to overwrite this number so it needs a value (that I wan’t to populate as described) and also that fields needs to be editable.
I think I’m going to use a table to store form inputs and then use those values to create the new record.
That way I can display and edit the value I’m referring to and also store it afterwards.
It still doesn’t “populate” that field automatically when you change the Premium input though. This might need an AI component to tell it to look at the Premium variable, and the Quantity variable, then write into the Quantity variable when the Premium variable changes.
It’s a preview component though, so beware of using it in production.
Yes, that’s essentially what a custom form is. Just be sure to use User Specific columns, otherwise you’ll have users clobbering each others data.
