Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

dynamic formula to add selection to multi select text

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

6 Replies

  • 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
    ------------------------------
    • MALANGMAANE's avatar
      MALANGMAANE
      Qrew Trainee
      How do you block a save?

      ------------------------------
      MALANG MAANE
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------