Calculated Fields not empty when i open a new form

rss

Posted by TWendt - Jan 12 ’17 at 08:42

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

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 11 months 29 days
    #1 by Dmitry Kozlov Jan 13 ’17 at 05:36

    Hi Tom,

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

  • TWendt
    Member
    Member for: 5 years 11 days
    #2 by TWendt Jan 13 ’17 at 05:40

    Hi Dmitry,

    yes it's a calculated field with a formula

    =[Days Training Customer]*500

    Best wishes

    Tom

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 11 months 29 days
    #3 by Dmitry Kozlov Jan 13 ’17 at 05:45

    [#2]: 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.

  • TWendt
    Member
    Member for: 5 years 11 days
    #4 by TWendt Jan 13 ’17 at 05:50

    Hi Dmitry,

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

    Best wishes

    Tom

  • roman.stratilik
    Member
    Member for: 1 year 7 months 8 days
    #5 by roman.stratilik Feb 11 ’18 at 02:08

    [#4]: Hi Tom,

    below you can find JS for cleaning up value for calculated field.

     

    fd.field('InternalName').control()._el().html("");

Displaying 1 to 5 of 5 messages