Discussions

 View Only
  • 1.  Drop Down filter

    Posted 11-20-2020 20:02
    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
    ------------------------------


  • 2.  RE: Drop Down filter

    Posted 11-22-2020 16:54
    Here 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
    ------------------------------