Help with List-User field and reporting
I have 23 list-user fields in one table. Before I go and create 460 formula fields to extract all users into a single field for exporting to Excel (I don't want a single field with multiple names) I ...
Forum Discussion
I'm sure you have your reasons, but it seems odd to have that many fields like that on one table/form. Why not have a joined table? With a joined table you could have much better reporting capabilities and export options.
- All these fields are part of the Task table where the task is assigned to 1, 2, 3, ... people. There are 23 various Tasks & Sub-Tasks that I have set up form rules to show only the relevant Tasks & Sub-Tasks. The number of people assigned varies based on need. The list-user field is to make notifications easier. I have tried a version with a joined table, but settled on the straight forward list-user.
