"Grey Out" options based on 1st option chosen
Hello, I'm designing a form where an account manager can request a discount for their client. What I DON'T want is them to be able to select multiple discounts. I have the fields and table set as...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhy not KISS and just have a single drop down field to select a choice of a single discount off a regular multiple choice field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I would LOVE to do that, but unfortunately there's ANOTHER issue that I can't figure out how to make it work with a drop down.
These account managers work with different clients. Some clients don't qualify for ALL the discounts so I was able to make a rule where depending on WHICH client is selected, certain discounts become hidden and the account managers can only select discounts available to that client. But, I could only get it to work with a checkbox for the discounts.
If you know a way I can limit what options show in a drop-down based on the client selected, please tell me as that would solve this issue and give me a layout that's cleaner. FYI. the client list is a separate drop-down field.
------------------------------
Marshall Azar
------------------------------
These account managers work with different clients. Some clients don't qualify for ALL the discounts so I was able to make a rule where depending on WHICH client is selected, certain discounts become hidden and the account managers can only select discounts available to that client. But, I could only get it to work with a checkbox for the discounts.
If you know a way I can limit what options show in a drop-down based on the client selected, please tell me as that would solve this issue and give me a layout that's cleaner. FYI. the client list is a separate drop-down field.
------------------------------
Marshall Azar
------------------------------
- MarkShnier__YouOK,
so back to your original question.
Try scrapping those Read Only rules and starting them over.
Make a Rule for only dealing with 30% being Read Only.
so the rule would be
when any of the following
40% is checked
50% is checked
80% is checked
make Read only 30%
Then duplicate that rule and edit to make a rule to deal only with the Read Only for 40%.
Then duplicate that rule and edit to make a rule to deal only with the Read Only for 50%
Then duplicate that rule and edit to make a rule to deal only with the Read Only for 80%
make a rule that
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- PERFECT !!!
Thank you so much Mark.
------------------------------
Marshall Azar
------------------------------