Hello!I build this form (a timesheet) where I have a dynamic table with variable number of rows (I'm adding instances with a click on a button).All rows contain a totalLinhaRelatorio field, this is a time field, and I need all such fields to be added to get a final total.So I tried these two script lines (FormCalc):var finalTotal = sum(Time2Num(parteInferior.atividades.tabelaAtividades.linhaAtividade[*].totalLinhaRelatorio[*],"HH:MM"))$.formattedValue = Num2Time(finalTotal, "HH:MM")It doesn´t wo...

Hello!I'm building a timesheet form in which I need to calculate the difference between start and end times and present the result.I'm trying to do this with FormCalc but if it is easier with JS it's ok too.So this is what I did on the total field, using the calculate event on a NUMERIC field called decimalValue: elapsed = Time2Num(endTime.formattedValue, "HH:MM") - Time2Num(startTime.formattedValue, "HH:MM") And then I tried to convert into a time field: total = decimalValue.rawValue; $.formatt...

Hello!I'm trying to create a simple timesheet form in Designer but things don't seem to work the way I expected.I have two Time fields where users are supposed to inform start and end times for a task. A third time field should display the elapsed time.So I tried to solve this with FormCalc:var interval = 0interval = Time2Num(endTime.formattedValue, "HH:MM") - Time2Num(startTime.formattedValue, "HH:MM")$.formattedValue = Num2Time(interval, "HH:MM")It doesn't work. I mean, if I inform startTime =...