Summary for user-related fields
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...
Forum Discussion
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.
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.
Yes. You said there is only one record per user in the Performance table, so you can select the user from that table. The Operations table is a child to the Performance table correct? So your Related Performance record picker can be customised to show Username - # of Operations.