Calculation

[lazysheepmedia]

Folks

I have two fields where number values are added

1. rent_calculator___calc_1
2. rent_calculator___calc_srvc

I then have the calc element with the following code in

$v = '{rent_calculator___calc_1}' + '{rent_calculator___calc_srvc}' * 30; return sprintf("?%01.2f", $v);

What I want to do is to grab the two values, and multiply by 30

rent_calculator___calc_srvc will not always have a value entered

Example 1

Rent Per Month = 800
Service Charge = 60

Total ( x 30) = 25,800

Example 2

Rent Per Month = 800
Service Charge = 0

Total ( x 30) = 24,000

With the current setup the figures are not being returned properly

Can anyone provide me with the right guidance please?

Thanks

 

[jfquestiaux]

Hi Mark.
If you need to multiply the total by 30, your calc should read (you are missing the () ):

$v = ('{rent_calculator___calc_1}' + '{rent_calculator___calc_srvc}' )* 30; return sprintf("?%01.2f", $v);

Word of caution: the 'rent_calculator___calc_1' and 'rent_calculator___calc_srvc' can't be themselves calc elements because you are never sure in what order these calc get triggered.

 

[lazysheepmedia]

Hi jfquestiaux

Thanks very much works perfectly

Trust you are well!

Regards

Mark

 

[lazysheepmedia]

Out of interest is there a javascript or other script that calculates the values as i type them in?

thanks

 

[jfquestiaux]

Thanks Mark, I'm fine.

As far as I know, if you enable "ajax calculation" in the calc element, the value should change, not actually WHEN you type, but when you take the focus out of the field.
If you really need "sync", I guess you have to write your own Javascript to do so.

 

[lazysheepmedia]

Good to hear

I thought as much - I'll take a look around and see what I can find

Thanks again

Regards

Mark


Sent via my iPhone using Tapatalk app

 

[rob]

you could probably adapt a simplified version of the last js example on this wiki page:
http://fabrikar.com/forums/index.php?wiki/form-javascript/

-Rob

 

[lazysheepmedia]

Thanks Rob I'll give it a go

regards