{"id":89307,"date":"2017-05-22T13:35:24","date_gmt":"2017-05-22T11:35:24","guid":{"rendered":"https:\/\/kizeoformscom.kinsta.cloud\/line-table\/"},"modified":"2021-01-28T12:26:44","modified_gmt":"2021-01-28T11:26:44","slug":"line-table","status":"publish","type":"post","link":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/","title":{"rendered":"How to calculate the number of lines in your table ?"},"content":{"rendered":"

 <\/p>\n

\n

This Kiz’Tip comes along with the new \u00abNear Miss Report\u00bb<\/a> form\u00a0available\u00a0in the library so that you can see a specific example. Feel free to download this form!<\/p>\n<\/blockquote>\n

You wonder how to know\u00a0how many lines<\/strong> you have in your table<\/strong>\u00a0after you collected your data? How to make this figure\u00a0appear<\/strong> 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.<\/p>\n

How to calculate the number of lines you have in your table\u00a0from your cell phone or tablet?<\/h2>\n

Thanks to the Checkbox<\/strong> and Calculation<\/strong> element, you can easily figure out the number of lines<\/strong> you have in your table\u00a0while you are entering your data.<\/p>\n

To do so, you need to insert an invisible<\/a> checkbox in your table<\/a>. In this case, we created a\u00a0column 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\u00a0go 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!<\/p>\n

\"Number<\/p>\n

How to display the number of lines your have in your table\u00a0inside your customized Word and Excel reports?<\/h2>\n

You can make the number of lines of your table\u00a0appear in both Excel<\/a> and Word<\/a> customized<\/span> files\u00a0by adding the ##_line_number##<\/code>\u00a0tag (see picture below).<\/p>\n

If you happen to have several tables\u00a0in your form, you need to mention the one that you are referring to by using the following tag:\u00a0##_line_number:tag_of_your_table##<\/code>.<\/p>\n

 <\/p>\n

\"Display

How to display the line number of your table in your customized Excel file<\/p><\/div>\n

 <\/p>\n

\"Display<\/p>\n

 <\/p>\n

Tip: How to retrieve a specific element\u00a0you entered\u00a0in your table.<\/h2>\n

The\u00a0##id_of_element[n]##<\/code>\u00a0tag allows you to retrieve a\u00a0specific element you entered in your table. For instance, you would like to mention in the subject line\u00a0of your e-mail the first and last name of the first witness of the near miss? You will then use the\u00a0##witness[1]:lastname##<\/code>\u00a0and\u00a0##witness[1]:firstname##<\/code>\u00a0tag in order to inform more efficiently your manager by putting this information in a key part of your e-mail.<\/p>\n

\"Display<\/a><\/p>\n

\n
\n

\u00a0Feel free to comment this article!
\n<\/span>We would be glad to hear any question, comment or suggestion you may have !<\/p>\n<\/blockquote>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

  This Kiz’Tip comes along with the new \u00abNear Miss Report\u00bb form\u00a0available\u00a0in the library so that you can see a specific example. Feel free to download this form! You wonder how to know\u00a0how many lines you have in your table\u00a0after you collected your data? How to make this figure\u00a0appear in your customized report? Well, it is totally possible to set your Kizeo Form once so […]<\/p>\n","protected":false},"author":31,"featured_media":89299,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[796,723],"tags":[905,906,824],"class_list":["post-89307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tipsandtricks","category-tutorials","tag-kiztips-en-us","tag-near-miss-report-en-us","tag-table-en-us"],"yoast_head":"\nDisplay the number of lines in your table inside your Kizeo Form<\/title>\n<meta name=\"description\" content=\"Today our Kiz'Tip will help you set your form in order to calculate how many lines your table has. We will take as an example our new Near Miss Form.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Display the number of lines in your table inside your Kizeo Form\" \/>\n<meta property=\"og:description\" content=\"Today our Kiz'Tip will help you set your form in order to calculate how many lines your table has. We will take as an example our new Near Miss Form.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Kizeo Forms\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-22T11:35:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-28T11:26:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/astuces-kizeo-forms-copie3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"835\" \/>\n\t<meta property=\"og:image:height\" content=\"284\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Greilysu Moreno\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greilysu Moreno\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/\",\"url\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/\",\"name\":\"Display the number of lines in your table inside your Kizeo Form\",\"isPartOf\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/astuces-kizeo-forms-copie3.jpg\",\"datePublished\":\"2017-05-22T11:35:24+00:00\",\"dateModified\":\"2021-01-28T11:26:44+00:00\",\"author\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/b6367021074ad87d9908172faec13817\"},\"description\":\"Today our Kiz'Tip will help you set your form in order to calculate how many lines your table has. We will take as an example our new Near Miss Form.\",\"breadcrumb\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#primaryimage\",\"url\":\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/astuces-kizeo-forms-copie3.jpg\",\"contentUrl\":\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/astuces-kizeo-forms-copie3.jpg\",\"width\":835,\"height\":284},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to calculate the number of lines in your table ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#website\",\"url\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/\",\"name\":\"Kizeo Forms\",\"description\":\"Mobile Solutions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/b6367021074ad87d9908172faec13817\",\"name\":\"Greilysu Moreno\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4bef31654d04190c3cb1519f9fdf4c14?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4bef31654d04190c3cb1519f9fdf4c14?s=96&r=g\",\"caption\":\"Greilysu Moreno\"},\"url\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/author\/greily\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Display the number of lines in your table inside your Kizeo Form","description":"Today our Kiz'Tip will help you set your form in order to calculate how many lines your table has. We will take as an example our new Near Miss Form.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/","og_locale":"en_US","og_type":"article","og_title":"Display the number of lines in your table inside your Kizeo Form","og_description":"Today our Kiz'Tip will help you set your form in order to calculate how many lines your table has. We will take as an example our new Near Miss Form.","og_url":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/","og_site_name":"Kizeo Forms","article_published_time":"2017-05-22T11:35:24+00:00","article_modified_time":"2021-01-28T11:26:44+00:00","og_image":[{"width":835,"height":284,"url":"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/astuces-kizeo-forms-copie3.jpg","type":"image\/jpeg"}],"author":"Greilysu Moreno","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greilysu Moreno","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/","url":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/","name":"Display the number of lines in your table inside your Kizeo Form","isPartOf":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#primaryimage"},"image":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#primaryimage"},"thumbnailUrl":"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/astuces-kizeo-forms-copie3.jpg","datePublished":"2017-05-22T11:35:24+00:00","dateModified":"2021-01-28T11:26:44+00:00","author":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/b6367021074ad87d9908172faec13817"},"description":"Today our Kiz'Tip will help you set your form in order to calculate how many lines your table has. We will take as an example our new Near Miss Form.","breadcrumb":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#primaryimage","url":"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/astuces-kizeo-forms-copie3.jpg","contentUrl":"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/astuces-kizeo-forms-copie3.jpg","width":835,"height":284},{"@type":"BreadcrumbList","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/line-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/"},{"@type":"ListItem","position":2,"name":"How to calculate the number of lines in your table ?"}]},{"@type":"WebSite","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#website","url":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/","name":"Kizeo Forms","description":"Mobile Solutions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/b6367021074ad87d9908172faec13817","name":"Greilysu Moreno","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4bef31654d04190c3cb1519f9fdf4c14?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4bef31654d04190c3cb1519f9fdf4c14?s=96&r=g","caption":"Greilysu Moreno"},"url":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/author\/greily\/"}]}},"_links":{"self":[{"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/posts\/89307"}],"collection":[{"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/users\/31"}],"replies":[{"embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/comments?post=89307"}],"version-history":[{"count":0,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/posts\/89307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/media\/89299"}],"wp:attachment":[{"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/media?parent=89307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/categories?post=89307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/tags?post=89307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}