Discussions

 View Only
  • 1.  User input formula field

    Posted 09-28-2022 06:48
    Edited by ammba 09-28-2022 06:55
    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?


  • 2.  RE: User input formula field

    Posted 09-28-2022 08:03
    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
    ------------------------------



  • 3.  RE: User input formula field

    Posted 09-28-2022 09:02
    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
    ------------------------------



  • 4.  RE: User input formula field

    Posted 09-28-2022 09:05

    Dynamic form rules are called dynamic form rules because they only work on forms. 

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