Forum Discussion

SteveKrupp's avatar
SteveKrupp
Qrew Member
5 years ago

Can I filter a Report Link with multiple filters?

I have a database with several different tables. It's setup linking like this: Jobs < Bids > Creators. So jobs can have multiple bids, and creators can have multiple bids.

On each job I have several Ratings. The first is "Awareness", the second is "Customer Relations", etc. Each Creator has the exact same ratings as are on the Job, ("Awareness", "Customer Relations", etc). What I'm trying to do is create a report link which filters the creators based upon the rating each creator has, in relation to the rating requirements which the job has. 

The problem I'm running into is that with a report link I can only match one creator rating to the job rating. And it must be an exact match.
What I'm trying to do is make it so that I can display a report on each job, with a filter which only displays the creator if every one of their ratings are equal or higher than the job requirements.

So if "Awareness" requirement is 3 stars or higher, but Creator 1 only has an "Awareness" of 2.5, he won't show up, even if all other skills are higher than the requirement.

Is there any way I can do an embedded report like the report link does?

------------------------------
Steve Krupp
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Project?

    What's a project?    Is that a Job?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • SteveKrupp's avatar
      SteveKrupp
      Qrew Member
      5 years ago
      That's my bad! I've edited the main post. 
      And you are correct: where I said project I meant job.

      ------------------------------
      Steve Krupp
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        I know how to do this but you would need to push a button on the job to "put it in focus" for the current user.  Then the results would instantly display on the job.   It would probably take an hour or two of consulting time to set up but along the way you would learn the "User Focus" technique. The technique is all native no JavaScript. 

        The basis of the technique is to push a button on the job to put it in focus. By putting it in focus I mean to edit or create a record in a user focus table where the key field is the user ID of the current user.   The attributes of the current job get looked up into the user focus table and then from there the attributes of the current job are then looked up down to the Creators table. Creators which qualify with then  be "illuminated " based on a formula calculation.  

        Then the report link of all creators which would be on the jobs form would have a filter for only the illuminated qualified creators.

        Feel free to contact me directly by the email in my signature line if you would like some one on one assistance to get this set up.   


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