Confiforms combine multi-user fields and loop through them

Question

Hi, i've seen a similar question here before but not everything is clear to me

I have a form with 3 identical user select fields, all mandatory
I want to combine data from those 3 fields in all records into 1 list, then loop through it, find duplicates and display in an order of most duplicates to least

How could i best do that?

And if i do get the list and get the amount of duplicates, how could i display it in confiforms?

@Alex Medved _ConfiForms_

Alex Medved _ConfiForms_ · Answer

The best option for something like this would be to use a REST API, and creating a report realtime with a bit of scripting and HTML right on the Confluence page

Humashankar VJ · Answer

Hi @John

You can create a formula field using the CONCAT function. This will merge the values from the three fields into a single list.

* To process this list, find duplicates, and sort by frequency, you'll need to utilize custom JavaScript.
* To achieve this, create a new formula field and use a JavaScript code that splits the combined user list into an array, counts the occurrences of each user, sorts the users by their frequency, and returns a formatted string with users and their counts.
* Once you've set up this JavaScript formula field, you can display the results in ConfiForms using the ConfiForms Table View macro. Simply set up a column to show the result of your JavaScript formula field.

If you want to display this information across all records, you may need to use the ConfiForms Aggregation macro to combine results from multiple entries.

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards