Skip to main content
Question

Summary for user-related fields

  • Feb 24, 2019 11:23 AM UTC
  • 0 replies
  • 74 views
I have an operation table with List-User field and Performance table with 1 record for each user. The operations can be active and expired. I want to see how many active operations are assigned to the specific user. Please advise what is the best way to update records in the performance table and populate them with the number of active operations assigned to the specific user?
    This topic has been closed for replies.

    • DanieGrabe
    • Qrew Crew
    • Feb 25, 2019 10:19 AM UTC
    Hi Inna,

    If you add a summary field in your Performance table that totals the # of Operations for that user, you can include this in your user record picker on Operations table. So it could show you Username - 6 for someone with 6 Operations. You can even go further and show active and expired totals in the same record picker for users.
    Terms & ConditionsAccessibility statement