Topic: CALCULATED FIELDS

HELLO MVD!

I have a calculated fields in my database, in the Form, on the onChange event, is there a possibility to automatically change the calculated field?  By default after you close the form that is the time you can see the changes.. I want it real time.

Please Help!

Thanks!

2 (edited by derek 2019-07-12 11:27:28)

Re: CALCULATED FIELDS

Hi Manix,
If I understand your question corrrectly, putting the 'onchange' event against the calculated field itself won't work because a calculated field, by definition, can only change if the fields involved in its calculation are themselves changed - the 'onchange' event needs to be placed against these fields, not the calculated field. 
Please see attached which uses a small script so you can see the changes to the calculated field real time.
Regards,
Derek.

Post's attachments

Attachment icon manix calc fields.zip 336.56 kb, 517 downloads since 2019-07-12 

Re: CALCULATED FIELDS

ok derek thanks so much!