Page 1 of 1

Calculated Fields not empty when i open a new form

Posted: 12 Jan 2017
by TWendt
Hi,

when i open a new form, the calculated fields are not empty.

I test this with a second list, the same result.

Without Forms Designer everything is okay.

Please help.

Best wishes

Tom

Re: Calculated Fields not empty when i open a new form

Posted: 13 Jan 2017
by Dmitry Kozlov
Hi Tom,

What is the need to use a calculated column in a new form? Does its formula contain other columns of the item?

Re: Calculated Fields not empty when i open a new form

Posted: 13 Jan 2017
by TWendt
Hi Dmitry,

yes it's a calculated field with a formula

=[Days Training Customer]*500

Best wishes

Tom

Re: Calculated Fields not empty when i open a new form

Posted: 13 Jan 2017
by Dmitry Kozlov
But [Days Training Customer] is not populated yet. You cannot use calculated columns in a new form. If you need to calculate some value dynamically and refresh it in a form while a user is editing other fields, use JavaScript.

Re: Calculated Fields not empty when i open a new form

Posted: 13 Jan 2017
by TWendt
Hi Dmitry,

thanks for the information. Can you give me an javascript example?

Best wishes

Tom