How to calculate the number of lines in your table ?
This Kiz’Tip comes along with the new «Near Miss Report» form available in the library so that you can see a specific example. Feel free to download this form!
You wonder how to know how many lines you have in your table after you collected your data? How to make this figure appear in your customized report? Well, it is totally possible to set your Kizeo Form once so that you won’t have to worry about it anymore.
Thanks to the Checkbox and Calculation element, you can easily figure out the number of lines you have in your table while you are entering your data.
To do so, you need to insert an invisible checkbox in your table. In this case, we created a column called “Action Number” that, as you can see in the picture below, appears empty. Before that, you need to put special settings by clicking the “Action number” element, then go to the features tab and check the “Default Value” checkbox. Then, you just have to calculate -outside your table- the sum of your “Checkbox” and you are good to go!
If you happen to have several tables in your form, you need to mention the one that you are referring to by using the following tag:
##id_of_element[n]## tag allows you to retrieve a specific element you entered in your table. For instance, you would like to mention in the subject line of your e-mail the first and last name of the first witness of the near miss? You will then use the
##witness:firstname## tag in order to inform more efficiently your manager by putting this information in a key part of your e-mail.
Feel free to comment this article!
We would be glad to hear any question, comment or suggestion you may have !