Summarizing fields in view display

HCL Domino Domino Forum
1

I have a form design that populates with users’ names that have requested information. Included with the detail, a field exists that displays the total number of days it took for the person to respond to the request. We have up to 10 fields that will hold the users’ names and the number of days for the person to respond.

I am trying to summarize this so that I can display the information in a view as a summary of the detail.

Here is an example of the detail:

FieldName1 = Sally Jones DaysProcess1 = 3

FieldName2 = John Smith DaysProcess2 = 2

FieldName3 = Fred Johnson DaysProcess3 = 1

FieldName4 = Sally Jones DaysProcess4 = 4

FieldName5 = Fred Johnson DaysProcess5 = 2

I would like to display in a view as such

Name - Number Requests -Total Days

Sally Jones - 2 - 7

John Smith - 1 - 2

Fred Johnson- 2 - 3

Your thoughts are much appreciated

Jean

2

Subject: Whew. Tricky one

Do you know in advance all the possible names of the users?

3

Subject: Still need a solution?

It’s going to take some thought, and experimentation, so I just wanted to check that you still need a solution to this before I get busy thinking :slight_smile:

Phil