Skip to main content
Question

Summary for user-related fields

  • February 24, 2019
  • 0 replies
  • 49 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
    • Registered
    • February 25, 2019
    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