Drop Down filter
Hi, I have a projects table with a child request table (with request codes). In general all requests are available to all projects except for 1 request code that is limited to one project type "A". ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHere is a low tech solution.
Make a Dynamic form rule.
When Related Project is (select the Project A from the drop down).
and
Request Type is (the one that is not allowed)
Action:
1. Change request type to blank.
2. Display a message: "Sorry, but this request type is not allowed to be select for Project Type". Please select a valid request Type.
and then uncheck the box below to ensure that the Rule fires "all the time".
Note that Dynamic form rules only work on forms. If you need this enforced in Grid Edit, you can make a Custom Data Rule. If you ned help with setting that up, there is a discussion here with a link to the help article. https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=16323550-ed0f-459e-97b3-a00125f52646&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
------------------------------
Make a Dynamic form rule.
When Related Project is (select the Project A from the drop down).
and
Request Type is (the one that is not allowed)
Action:
1. Change request type to blank.
2. Display a message: "Sorry, but this request type is not allowed to be select for Project Type". Please select a valid request Type.
and then uncheck the box below to ensure that the Rule fires "all the time".
Note that Dynamic form rules only work on forms. If you need this enforced in Grid Edit, you can make a Custom Data Rule. If you ned help with setting that up, there is a discussion here with a link to the help article. https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=16323550-ed0f-459e-97b3-a00125f52646&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
------------------------------