Use on app to check on records from another app

Question

I have two app, one called "QA" with a tabled called "QA Management" and another app called "Support" with a table called "Support Tickets".&nbsp; I created a relationship between the two apps so that way from the support ticket, i can add a new quality&nbsp; control record (created a URL Formula through the relationship).&nbsp; I also created a report call QA Records in the support ticket through the relationship.&nbsp; The issue i'm having is figuring out out how to sort the support tickets that haven't been reviewed for quality control.&nbsp;&nbsp;Below is a pic of a support ticket that has been quality reviewed.&nbsp;&nbsp;

Below is a pic of the quality control record
I tried to changing multiple field properties in the support table to show in QA managment table so i can use them in a reoprt but the field property isn't showing up to select it in the report (regardless of the type of field it is).&nbsp; See pic below:
I also tried a rule in support ticket to mark a checkbox that when the "QA record" report is not empty or the report doesn't say "No qa records found" then a check for "Ticket coded" would occur. see pic below:

I'm out of ideas to try.&nbsp; Any help will be greatly appreciated.&nbsp; Thank you.------------------------------Shane Selasky------------------------------

markshnier__you · Answer

ShaneI think that all you need to do&nbsp;is to go to the relationship where one Support ticket has many QA records. On that relationship on the left side, make a summary field to count the number of QA records.

Then that will give you a field in Support tickets to know if the QA has been done. If a record has no QA children then it has not been QA'd yet.&nbsp;&nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Use on app to check on records from another app

Related Content

Nesting API Button Help (Add record and update another)

Moving Fields from One Table to Another

Custom Record Titles

Using Grid Edit to Edit Multiple Records at Once

Check one field for multiple conditions