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?

markshnier__you · 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
------------------------------

ammba · Answer

Yes, I've tried the dynamic form rules but i'm trying to apply it in the Grid edit mode.
I've also added the form under Grid edit (full site) to the "Set how different roles use these forms" but unfortunately this doesn't work either..

------------------------------
ammba
------------------------------

markshnier__you · Answer

Dynamic form rules are called dynamic form rules because they only work on forms.&nbsp;
So there is not a way to have it work how are you want it to without the use of some kind of pipeline.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

User input formula field