I think you will need to create a custom form .
You cannot achieve what you want with a native form, since with a native form the data can only be computed after it is submitted, whereas you need to compute it before .
Darren explains custom forms here:
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…
3 Likes