Page 1 of 1

hour calculation

Posted: Sat Feb 29, 2020 5:26 pm
by joecocs
I would like to make a calculation between hours and an hourly price.

I tried with different format of fields in the table on mysql but I can't do it.

It seems that to make calculations with fields only need numeric format.

if you have a work lead?

Re: hour calculation

Posted: Sat Feb 29, 2020 6:02 pm
by kev1n
Can't you use a Calc Object?

https://wiki.nubuilder.cloud/ ... Tab_-_Calc

Is the "hourly price" stored in a field, what format does it have?

Re: hour calculation

Posted: Mon Mar 02, 2020 10:16 am
by joecocs
yes my hourly price is stored in a field, for him no problem.

For the hour, I want to have an 'hh:mm' input format and I am using a text field, so I cannot calculate in a calc.

I tried the 'Hack' in the setup to add the fields that we want for the calculation but it does not work anyway

Re: hour calculation

Posted: Mon Mar 02, 2020 10:42 am
by kev1n
You can use JavaScript to do the calculation.