Summing hours

Douglas Stransky

I have a confiform to capture hours worked on various tasks set up like:

Name: User

Date:  Date

T1Hours:  Numeric

T2Hours:  Numeric

I like to get a table to display the sum of hours like:

Qtr                Name         T1 Hours           T2 Hours ..... 

2025 - 3       Name         150                        0

                     Name 2         10                     30

                      etc.

 

Appreciate the help.

Doug

Alex Medved _ConfiForms_

HI @Douglas Stransky 

How do you calculate a Qtr?

Something like this, may be?

id.evaluateFormula(FLOOR(([entry.Date.formatDate(M)] - 1) / 3, 0) + 1).prepend(Q)

 Then you just can use the TableViewMerger, as for example in this video

Alex