User input formula field

Question

Is there a way to create a field/column that is a required field, user input and formula field at the same time (without using automations or pipelines)?

The scenario is I have 2 columns:
Column 1 is a required & user input field.
Column 2 is a formula field.
If column 2 has value then column 1 can be left empty
OR
If column 2 has value, copy value to column 1 only if it is empty (since it is a required field)

Or do I not have choice but to manually input a value in Column 1?

MarkShnierYou · Answer

You can do this if editing a single record on a form using Dynamic Form Rules. But are you asking if this can be enforced in Grid Edit mode?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community