How not to display fields with zero value in the reports and email?

  • Ricou056
    Asked on July 2, 2019 at 7:26 AM

    Hello,


    Question 1 : How is it possible to avoid display of form fields with value = 0 in the reports and emails ?

    I noticed the possibility to avoid displaying empty fields, but not for zero value fields.


    Question 2 : is it possible to display form submissions in a table sheet like Excel ?

    I thank you for your answers.

    Kind regards

    Eric


  • Welvin Support Team Lead
    Replied on July 2, 2019 at 9:18 AM

    Hi Eric,

    I presumed you are referring to the calculation. If so, that's possible by removing the default value in the calculation properties, see below:

    15620732242019 07 02 005 Screenshot 10

    But I see you have zeros in your tables, so that is still considered a value once pass to the calculation widget. If you do not want to show up the calculation in the email when all zeros are selected, you have to remove 0 from the calculation values that you have set:

    15620734112019 07 02 006 Screenshot 21

    So, you have to start the calculation with a comma which means you are not adding any value to the first column which is the zero option. 

    Note that you cannot hide the input table when zeros are selected. Zero is a value in the field, therefore, it is included in the submission.