Have two fields depend on one another
-
Hi,
Firstly, fantastic plugin! It’s been really easy to use, I’ve just hit one little problem. I’m using the plugin to create an online “calculator”. The user puts in their building’s area and then either their total rent or their rent per square foot.
Now they could calculate it themselves and put it in, but I wanted to give them the option. So the “Total rent” and “Rent per square foot” fields should be separate but if one is filled in, then the other should be updated so I have two calculated fields, one with:
prec((fieldname16*fieldname9),2)
and the other with:
prec((fieldname17/fieldname9),2)
However, this does not work as when I save it, the second isn’t saving it’s formula and reverts to:
prec((fieldname10/fieldname9),2)
For some reason, I don’t even have a fieldname10! I presume this is because it recognises that they’re clashing. Any ideas?
- The topic ‘Have two fields depend on one another’ is closed to new replies.