Default value in forms

[Jeff_Hager]

No it will not work. Computed columns, like a relation/lookup will only work once the data is written to the table. If you haven’t submitted the form yet, then the data is not in the table, so there will be no lookup to refer to. If you need something like this, you would be better off creating a custom form.

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…