Drop Down filter

Question

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". I am trying to figure out how to create a report filter that will exclude this one request code from being displayed accept for project type "A".

Thanks for the help!

------------------------------
Christine White
------------------------------

markshnier__you · Answer

Here is a low tech solution.Make a Dynamic form rule.When Related Project is (select the Project A from the drop down).andRequest Type is (the one that is not allowed)&nbsp;Action:1. Change request type to blank.2. Display a message:&nbsp; "Sorry, but this request type is not allowed to be select for Project Type".&nbsp; Please select a valid request Type.&nbsp;and then uncheck the box below to ensure that the Rule fires "all the time".Note that Dynamic form rules only work on forms.&nbsp; If you need this enforced in Grid Edit, you can make a Custom Data Rule.&nbsp; If you ned help with setting that up, there is a discussion here with a link to the help article.&nbsp; https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=16323550-ed0f-459e-97b3-a00125f52646&amp;CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&amp;tab=digestviewer------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Drop Down filter

Related Content

Embedded Grid Edit Report Pre-filtered Conditional Dropdown

Update report filters when drop down options change

Filter out some records on related table

Dynamic Filter - Default Date Range? (without filtering)

Filter records based on table connection