Discussions

 View Only
  • 1.  dynamic formula to add selection to multi select text

    Posted 12-23-2019 15:07
    Is it possible to add a selection to a multi select text field via a dynamic form rule? I know you can set the multi select field, but can you add a selection to what is currently selected?

    My use case is I have a multi select for requirements (Scope, Fall Protection Plan, Work Plan, Safety Plan, etc). I want to say, if complexity field is high, include work plan.

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: dynamic formula to add selection to multi select text

    Posted 12-23-2019 16:26
    One solution would be to have a form rule that is sort of the opposite.

    If the choice includes Work Plan and the complexity is not High, then block the save and display a message,.....

    Sorry, Work Plan is only an option for High Complexity

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: dynamic formula to add selection to multi select text

    Posted 04-04-2022 12:22
    How do you block a save?

    ------------------------------
    MALANG MAANE
    ------------------------------



  • 4.  RE: dynamic formula to add selection to multi select text

    Posted 04-04-2022 12:38
    You can use a Form rule.
    When the record is saved
    and
    there conditions are true
    condition 1
    condition 2

    Abort the sane and display a message.

    There is editing to the records being done through grid edit than forum rules do not apply to grid edit. Your alternative there would be to use what is called a Custom Data Rule on the table.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: dynamic formula to add selection to multi select text

    Posted 04-04-2022 12:45

    I have looked at the Dynamic form rules and can't seem to find how to abort the save and display a message...

     

    I see how I can display a message but struggling with how to abort the save.

     






  • 6.  RE: dynamic formula to add selection to multi select text

    Posted 04-04-2022 16:54
    If you have a genetic form rule that begins with when the record is saved, then there will be an option to abort the save if conditions are true.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: dynamic formula to add selection to multi select text

    Posted 04-04-2022 17:15
    Ok thank you very much