Building Summary Report for List User Field
Hi! I recently added a List User field ("Estimator(s)") to my table where the person adding a new Project record can indicate one or more individuals involved in quoting a project. I would like to cr...
Forum Discussion
Unfortunately since the data you're reporting on is a list-user field you're going to have to report on this in another way. My best recommendation if you're able to swing it - is to try and report via some kind of 'Employees' table where you have a dataset of the actual team members. In that table, there are lots of ways you could do it but the easiest might be a formula query that counts the number of records where the user in question is listed in the list-user field and then you can build your report from that value in the Employees table.
------------------------------
Chayce Duncan
------------------------------
Thank you, Chayce. That is an interesting solution. I can create an employees table. How would I create the link between that table and the User-List field? I know how to create a table relationship, if needed. Would the "Estimators" field need to feed off the employee table, rather than my User list, or would I need to make the connection between the Estimators Field and the Employee table in my report?
------------------------------
Sherri Large
------------------------------
Since the List-User can contain multiple users you can't establish a direct relationship - hence the idea of the formula queries. In this case you would tag the user or the email of the Employee in their record in this new table, and then use formula queries to do a count of the records in your quoting table where the list-user field contains the employee in question using their user/email.
------------------------------
Chayce Duncan
------------------------------