Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
6 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 ...
Forms
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
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
4 years ago
How do you block a save?

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

      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.

       



      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        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
        ------------------------------