Forum Discussion

frac's avatar
frac
Qrew Member
3 months ago

Return a list of values from query using dynamic record ID

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?

 

 

formula query

1 Reply

  • hueyal's avatar
    hueyal
    Qrew Cadet
    3 months ago

    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