To customise your report, you will also need to know the item tags of your form.\u00a0 The item tags represent the reference code for each element (ex. Tips<\/strong>: You can\u00a0download <\/strong>and take inspiration <\/strong>from the Excel example <\/strong>provided by Kizeo.\u00a0<\/strong>We\u00a0strongly<\/strong> advise you to proceed that way. The advantage of this example is that it includes all the item tags for your properly written form.<\/p>\n <\/p>\n \u201cdatetime\u201d corresponds to the tag of your date and time field.<\/p>\n \/!\\<\/span>\u00a0<\/strong>To define the size of your images (photo, signature or drawing), you can choose to define the height and\/or the width. \u00a0The undefined value is automatically defined to conserve the image’s proportions. For example, if you want a signature that appears in 100 pixel (height), you need to insert\u00a0 n corresponds to the image’s number. Numbering starts at 1. Note:\u00a0please, tick\u00a0the “Get the location automatically” checkbox in the options of your\u00a0field in the\u00a0Advanced tab.<\/p>\n The following fields are compatible with the bar code format:<\/p>\n##customer##<\/code>). For more information on item tags, you may consult\u00a0our tutorial on\u00a0Tags Help<\/a>.<\/p>\n\n
![\"You](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/download-example-excel.gif\" "\\"You")
<\/a><\/p>\n\n
![\"excel](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/excel-file.png\")
<\/p>\n\n
Tips for creating your template.<\/h2>\n
Standards\u00a0:<\/h3>\n
\n
##_last_name##<\/code>: user’s surname<\/li>\n##_first_name##<\/code>: user’s first name<\/li>\n##_phone##<\/code>: user’s phone number<\/li>\n##_email##<\/code>: user’s email<\/li>\n##_login##<\/code>:\u00a0user’s ID<\/li>\n##_answer_time##<\/code>: date\u00a0of reply<\/li>\n##_id##<\/code>:\u00a0unique identifier<\/li>\n##_record_number##<\/code>: n\u00b0\u00a0of response to this form (identifier)<\/li>\n##_answer_time##<\/code>: date of response to the form.<\/li>\n##audio##<\/code>: allows you to obtain a link that returns to the audio.<\/li>\n##attachment##<\/code>: allows you to obtain a link that returns to the attachment.<\/li>\n##list:label##<\/code>: allows you to increase the wording (especially for the custom-made Excel that displays the code by default).<\/li>\n##field_id[n]##<\/code>: allows you to retrieve the entry of an element of a specified row (n) in a table<\/span><\/span>.<\/span> If you have a checkbox in your table, for example, and want to retrieve its value on line 3, you can now use the ##checkbox[3]##<\/code> tag.<\/span><\/span><\/li>\n##field:caption##<\/code>: allows you to retrieves the title of a field.<\/span><\/span><\/li>\n<\/ul>\n<\/div>\nDate and time tags:<\/h3>\n
\n
##datetime##<\/code>: numeric format\u00a0(01\/01\/2016).<\/li>\n##datetime:short##<\/code>: short text format\u00a0(1er Jan. 2016).<\/li>\n##datetime:medium##<\/code>: medium text format\u00a0(1 January 2016).<\/li>\n##datetime:long##<\/code>: long text format\u00a0( Friday\u00a01 January 2016).<\/li>\n##datetime:iso##<\/code>: ISO format\u00a0(2016-01-01). (available soon).<\/li>\n<\/ul>\nGeolocation tags:<\/h3>\n
\n
##geoloc##<\/code>:\u00a0allows you to obtain the coordinates.<\/li>\n##geoloc:latitude##<\/code> and\u00a0##geoloc:longitude##<\/code>: allow you to obtain\u00a0latitude and longitude.<\/li>\n##geoloc:link##<\/code>:\u00a0allows you to obtain a link that returns to the map when clicked.<\/li>\n##geoloc:time##<\/code>:\u00a0allows you to obtain the time\u00a0when the geolocation was taken.<\/li>\n##geoloc:map-z12-200x200##<\/code>:\u00a0allows you to display a map on you customised export. Please note that this is the letter “X” and not the multiplication sign.
\n– \u00ab\u00a0-200x200\u00a0\u00bb<\/code>\u00a0corresponds to the dimension of the image.
\n– \u00ab\u00a0z12\u00a0\u00bb<\/code> corresponds to zoom in\/out on the word map. \u00a0To have an idea:\u00a01 displays the word map and 18 displays the corresponding street. 12 displays more or less the neighborhood.<\/li>\n<\/ul>\n\u00a0Photo, drawing and signature tags:<\/h3>\n
Define the size of your images (photo, drawing and signature):<\/h4>\n
##id_element##<\/code>: if one doesn’t want to define the size (default size 250 pixel).
\n##id_element-heightxwidth##<\/code>: if one wants to define the size.
\n##id_element-width##<\/code>: if one wants to define just the width.
\n##id_element-xheight##<\/code>: if one only wants to define the height.<\/p>\n##id_element-x100##<\/code>.<\/p>\nDefine the size of your multiple photos, multiple drawings:<\/h4>\n
##id_element:n##<\/code>: if one doesn’t want to define the size.
\n##id_element:n-widthxheight##<\/code>:\u00a0if one wants to define the size.
\n##id_element:n-widthx##<\/code>:\u00a0if one wants to define just the width.
\n##id_element:n-xheight##<\/code>:\u00a0if one wants to define just the height.<\/p>\n
\nTip:<\/em><\/strong><\/span>\u00a0You can use a table to have a better presentation of you multiple photos!<\/p>\nDisplay the date and time of your photos when they were taken:<\/h4>\n
##photo:time##<\/code>: allows you to obtain the date and time when the picture\u00a0was taken.
\n##photo:time:short##<\/code>: allows you to obtain the date and time in the short text format (1 Jan. 2016).
\n##photo:time:medium##<\/code>:\u00a0allows you to obtain the date and time in the medium\u00a0text format (1 January 2016).
\n##photo:time:long##<\/code>: allows you to obtain the date and time in the long\u00a0text format (Friday 1 January 2016).
\n##photo:time:iso##<\/code>: allows you to obtain the date and time in the ISO\u00a0format\u00a0(2016-01-01).<\/p>\nDisplay the date and time of your signatures:<\/h4>\n
##signature:time##<\/code>: allows you to obtain the date and time when signing your form.
\n##signature:time:short##<\/code>: allows you to obtain the date and time in the short text format (1 Jan. 2016)
\n##signature:time:medium##<\/code>: allows you to obtain the date and time in the medium\u00a0text format (1 January 2016).
\n##signature:time:long##<\/code>:allows you to obtain the date and time in the long\u00a0text format (Friday 1 January 2016).
\n##signature:time:iso##<\/code>: allows you to obtain the date and time in the ISO\u00a0format\u00a0(2016-01-01).<\/p>\nGeolocation display of your photos and signatures:<\/h4>\n
##photo:latitude##<\/code>\u00a0and\u00a0##photo:longitude##<\/code>: allows you to obtain the latitude and longitude when taking a picture.<\/p>\n##signature:latitude##<\/code>\u00a0and\u00a0##signature:longitude##<\/code>: allows you to obtain the latitude and longitude when signing your form.<\/p>\nDisplay a link of your photos and signatures:<\/h4>\n
##photo:link##<\/code>: allows you to obtain a link of your photo when clicked.<\/p>\n##signature:link##<\/code>: allows you to obtain a link of your signature when signed.<\/p>\nBar-code tags:<\/h3>\n
Bar code display in 128B format:<\/h4>\n
##barcode:128##<\/code>: if one doesn’t want to define the size.
\n##barcode:128-width##<\/code>: if one wants to define just the width.
\n##barcode:128-height##<\/code>: if one wants to define just the height.<\/p>\nBar code display in QR code format:<\/h4>\n
##barcode:qrcode##<\/code>: if one doesn’t want to define the size.
\n##barcode:qrcode-widthxheight##<\/code>: if one wants to define the size.
\n##barcode:time##<\/code>:\u00a0allows you to obtain the date and time when the information was taken.<\/p>\nDisplay your fields in 128B bar code or QR Code formats:<\/h4>\n
\n
##field:128##<\/code>:\u00a0to make its fields in QR Code Format.
\n##field:qrcode##<\/code>:\u00a0to make its field in 128B bar code format.<\/p>\nList, slider and choice tags:<\/h3>\n
##list:break##<\/code>\u00a0and\u00a0##choice:break##<\/code>: allow you to duplicate the row and maintain the chip format used.
\n##list:unordered##<\/code>\u00a0and\u00a0##choice:unordered##<\/code>: to make an hyphen\u00a0appears before list or choice field.
\n##list:ordered##<\/code>\u00a0and\u00a0##choice:ordered##<\/code>: allow you to have your\u00a0list or choice field in numerical order.<\/p>\nDisplay of your Hierarchical Lists path:<\/h3>\n
![\"insert](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/Capture-d\u2019\u00e9cran-2016-12-05-\u00e0-09.59.58.png\" "\\"insert")
<\/p>\n![\"insert](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/Screen-Shot-2017-04-05-at-17.51.55.png\" "\\"insert")
<\/p>\n<\/div>\n![\"insert](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/Capture-d\u2019\u00e9cran-2016-12-05-\u00e0-10.03.53.png\" "\\"insert")
<\/p>\n![\"line](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/line-number-excel.png\")
<\/p>\n![\"line](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/line-displayed-excel.png\")
<\/p>\n<\/div><\/div>\n![\"Template](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/Template-Kizeo-Forms-excel.jpg\")
<\/p>\n<\/div>\n![\"Hide\"](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/Hide.png\")
<\/div>\n<\/div>\n![\"drag](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-custom-made-excel.gif\")
<\/a><\/p>\n![\"Do](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/analyse-your-custome-made-report.png\")
<\/a><\/p>\n![\"You](\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/edit-name-export-excel.png\")
<\/a><\/p>\n<\/div>\n