Return a list of values from query using dynamic record ID

Question

I am working on a quickbase where people will go and rate thier competence on about 75 different items on a 0-5 scale. i want to be able to create a report where i can select one of these items from a dropdown list and display the people who are rated 5. I made a table with the label and column ID for all the fields that i want to display. Is it possible to write a formula query that will return the list of names for anyone that meets the criteria, using the reference id on each row to point to the coulmn on the rating table?

hueyal · Answer

Below isn't exactly what you described; however, it does give the same information without using formula query (based on my understanding). It is also based on the assumption that there are relationships between various tables.

Table 1: Competencies

Define your 75 competencies

Field: Competency (text)

Field: Label (text)

Table 2: Competency Ratings

Record ratings by person

Field: Rating (numeric)

Table 3: Persons

List of persons defining competencies

Relationships:

Persons Has Many Competency Ratings

Competencies Has Many Competency Ratings

Summary Field: Add Summary Field

Select Summary

Then, Combined User for the field (then select the name field from the Persons table)

Then, under Matching Criteria, select field Rating is equal to the value 5

Then, name the summary field (ex. Has 5 Rating)

Report:

In the Competencies table, create a report to display:

Label, Has 5 Rating

Filters can be applied to the Competency/Label on the report

Sign up

Login to the community