General

Re: Subtract existing column before form submission

Miggi03 — Mon, 01 Dec 2014 12:03:40 GMT

Thanks Patrick The goal is to minus minutes from the "Hours field" based on the text input from the "Break taken field" The trick part is the "Hours" field is a sum created from the "time from" and "time to" fields. Hope this makes a bit more sense? Thanks again for your reply.

Re: Subtract existing column before form submission

Patrick Halstead — Mon, 01 Dec 2014 11:53:37 GMT

Hi Miggi03,

This should be easy to do. You can convert strings to numbers using the number() function. In addition, you can sum a column using the sum() function.

So, to extract the total of a column, just use sum(field) where field is the column in the repeating group or section.

You can use default values for the column to auto calculate the fields in advance before summing.

I'm a little confused about exactly what you are trying to do, so if this doesn't help, please email me.

Good luck!

Subtract existing column before form submission

Miggi03 — Mon, 01 Dec 2014 10:35:14 GMT

Hi all I am looking for a way to subtract the total of a column using a formula. The formula for which I need to subtract the time from is as follows using another text input field. translate(addSeconds(timetoRT, -1 * (substring(timeFromRT, 1, 2) * 3600 + substring(timeFromRT, 4, 2) * 60 + substring(timeFromRT, 7, 2))), "ER?", "") This is a text string and as such the amount subtracted for Lunch breaks etc would also need to be. I'm not sure how to go about this. Any suggestions? Thank you.