Edit Form: Calculated Fields

  • Resolved mwokasch

    (@mwokasch)


    1 year, 10 months ago

    Related to editing entries, if I click the “Edit” button on any of the entries, fields that are “calculated” based on other form fields don’t seem to re-calculate like they do on the original entry form.

    Calculated Fields

    For instance, I have a three fields on my form: Adults, Children and Family Size. Family Size is equal to Adults + Children. Changing the values of the form fields doesn’t re-calculate the value for Family Size.

    Repeater Fields

    Same thing for a repeater field. I have a repeater with a calculated number of rows equal to Children. If I add or subtract Children, I do not get new rows in the repeater field.

    Conditions

    This also appears to be true for custom validations or conditions. Changes in values don’t seem to trigger the check against conditions.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author EDGARROJAS

    (@edgarrojas)

    Hello!

    In the entry editor the formulas and conditions are not enabled. It is more like a free edition area, i see that having a repeater that depends on formulas is a problem though so it will be changed so you can add and remove rows at will in the entry editor.

    Regards!

    Thread Starter mwokasch

    (@mwokasch)

    I appreciate the repeater part.

    For the computed fields, I guess that sort of makes sense except that those calculated fields tend to be read-only and so they’re not change-able in the editor. If I increase the number of adults, family size can’t change either.

    Same thing happens for a form field that is the calculated number of days between two dates. Changes in the edit screen will put that computed field out of synch.

    Plugin Author EDGARROJAS

    (@edgarrojas)

    I will also make the read-only fields editable so you can customize them too.

    Yes if you make a change you will also need to do the calculations manually.

    I know this is a pain but enabling formulas in the entries editor would cause other issues with formulas that are not supposed to be calculated in the editor, like formulas that use the current date (it would use the date of the edition instead of the date when it was submitted) or formulas that use the user name(it would use the user that is editing the form instead of the one that submitted it) just to give a few examples.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Edit Form: Calculated Fields’ is closed to new replies.