Custom Action on Add

[nathanaelb]

@Dan_San

Problem I have is that based on the input, I need to use relations and lookup to pull in some data and then based on that data I need to apply the IF/ELSE column
AND then insert that data into a text column using the “default value” function.

That won’t work. When you are on a Show Form Screen, whatever data you input in the fields doesn’t yet exist in any table until the user hits submit. So you cannot actually compute any of the data until it is submitted.

I think you might need to create a custom form to compute data before it is submitted, courtesy of Darren:

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…