Skip to main content
Question

Dynamic form rules not working when using multiple choice field values as trigger

  • March 30, 2020
  • 0 replies
  • 131 views

MattMakris
Forum|alt.badge.img+7
I'm running into an issue when trying to configure dynamic form rules based on the values of a multiple choice dropdown field values as the trigger for the condition. There are three options (4 if you count blank value) in the "Management Fee Settings" multiple choice dropdown field with actions beneath each:

  1. No Management Fee
    1. Show/Require: `EMSC Margin`, `Agency Partner Margin`, `Margin Total`
  2. Invoiced for Management Fee Only
    1. Show/Require: `Management Fee`
      Hide: `EMSC Margin`, `Agency Partner Margin`, `Margin Total`
  3. Invoiced for Ads and Management Fee
    1. Show/Require: `Management Fee`, `EMSC Margin`, `Agency Partner Margin`, `Margin Total`

It's not working the way the conditions would imply. These fields aren't listed in any other rules other than `Management Fee Settings` visibility. Here are screenshots of the form rules described above:


Any help would be greatly appreciated, thank you!




Here is a screenshot of the actual form:




------------------------------
Matt Makris
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np
You need to scrap your rules and start over by making a Rule per field that needs to be controlled  and not a rule per "Management Fee Settings".  So you just gotta get your mind right.

See my Cool Hand Luke posting here. 
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=34759&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer

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