Skip to main content
Question

Can I filter a Report Link with multiple filters?

  • January 13, 2021
  • 0 replies
  • 51 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • January 13, 2021
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
------------------------------