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

  • Profile Image
    Ricou056
    Asked on July 02, 2019 at 07: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


  • Profile Image
    Welvin
    Answered on July 02, 2019 at 09: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.png

    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.png

    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.