{"id":79781,"date":"2021-01-22T15:14:00","date_gmt":"2021-01-22T06:14:00","guid":{"rendered":"https:\/\/support.questetra.com\/?p=79781"},"modified":"2025-12-09T11:39:47","modified_gmt":"2025-12-09T02:39:47","slug":"table-type","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","title":{"rendered":"Table-Type"},"content":{"rendered":"\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"58\" data-attachment-id=\"113114\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/first-questetra-bpm-suite-step1\/attachment\/basic-banner-new-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"basic-banner-new-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en-1024x58.png?resize=1024%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-113114\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=768%2C44&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#66cc66;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#99FF99;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Data Item: Table-Type<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">\n\n\n\n<p class=\"wp-block-paragraph\">Displays a table that allows input to String, Numeric, Select or Date-type Data Item formats. Any number of rows can be added when entering data.<\/p>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs: Common<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"wp-block-list\">\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Item Name<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Field Name <span style=\"color:#990000;\"><strong>*<\/strong><\/span><\/li>\n\n\n\n<li>Data Type<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Description\n<ul class=\"wp-block-list\">\n<li>Correct Errors and Format<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Note<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs: Table (Table-Type)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"wp-block-list\">\n<li><i class=\"fal fa-check-square fa-lg\"><\/i> Required<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Minimum Rows<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Maximum Rows<\/li>\n\n\n\n<li>Table Columns<\/li>\n\n\n\n<li><i class=\"fal fa-caret-square-down fa-lg\"><\/i> Add Table Column\n<ul class=\"wp-block-list\">\n<li>String\n<ul class=\"wp-block-list\">\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Item Name<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Field Name<\/li>\n\n\n\n<li><i class=\"fal fa-check-square fa-lg\"><\/i> Required<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Minimum Length<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Maximum Length<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Regular expression to be satisfied<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Numeric\n<ul class=\"wp-block-list\">\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Item Name<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Field Name<\/li>\n\n\n\n<li><i class=\"fal fa-check-square fa-lg\"><\/i> Required<\/li>\n\n\n\n<li><i class=\"fal fa-caret-square-down fa-lg\"><\/i> Number Format\n<ul class=\"wp-block-list\">\n<li>1234567.89<\/li>\n\n\n\n<li>1,234,567.89<\/li>\n\n\n\n<li>1234567,89<\/li>\n\n\n\n<li>1.234.567,89<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Range of decimal places<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Prefix<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Suffix<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Minimum Value<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Maximum Value<\/li>\n\n\n\n<li><i class=\"fal fa-check-square fa-lg\"><\/i> Show calculated value <em>(appears only when two or more numeric columns are set)<\/em>\n<ul class=\"wp-block-list\">\n<li><i class=\"fal fa-caret-square-down fa-lg\"><\/i> <em>(select numeric column)<\/em><\/li>\n\n\n\n<li><i class=\"fal fa-caret-square-down fa-lg\"><\/i> <em>(operator)<\/em>\n<ul class=\"wp-block-list\">\n<li>* <em>(multiplication)<\/em><\/li>\n\n\n\n<li>+ <em>(addition)<\/em><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><i class=\"fal fa-caret-square-down fa-lg\"><\/i> <em>(type a fixed Number\/select numeric column)<\/em><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><i class=\"fal fa-check-square fa-lg\"><\/i> Show total value at the bottom of list<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Select\n<ul class=\"wp-block-list\">\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Item Name<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Field Name<\/li>\n\n\n\n<li><i class=\"fal fa-check-square fa-lg\"><\/i> Required<\/li>\n\n\n\n<li><i class=\"fal fa-plus-square fa-lg\"><\/i> Choices\n<ul class=\"wp-block-list\">\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Choice ID<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Label<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Edit in CSV format<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Date\n<ul class=\"wp-block-list\">\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Item Name<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Field Name<\/li>\n\n\n\n<li><i class=\"fal fa-check-square fa-lg\"><\/i> Required<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Minimum Value<\/li>\n\n\n\n<li><i class=\"fal fa-pen-square fa-lg\"><\/i> Maximum Value<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Settings Screen<\/h4>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Table-type_v12.3-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"953\" height=\"953\" data-attachment-id=\"100687\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/table-type_v12-3-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Table-type_v12.3-en.png?fit=953%2C953&amp;ssl=1\" data-orig-size=\"953,953\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Table-type_v12.3-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Table-type_v12.3-en.png?fit=630%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Table-type_v12.3-en.png?resize=953%2C953&#038;ssl=1\" alt=\"\" class=\"wp-image-100687\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Table-type_v12.3-en.png?w=953&amp;ssl=1 953w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Table-type_v12.3-en.png?resize=315%2C315&amp;ssl=1 315w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Table-type_v12.3-en.png?resize=630%2C630&amp;ssl=1 630w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Table-type_v12.3-en.png?resize=440%2C440&amp;ssl=1 440w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Table-type_v12.3-en.png?resize=768%2C768&amp;ssl=1 768w\" sizes=\"auto, (max-width: 953px) 100vw, 953px\" \/><\/a><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Input Screen<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/Table-type_v114.2-input-1-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"452\" data-attachment-id=\"140366\" data-permalink=\"https:\/\/support.questetra.com\/en\/data-items\/table-type\/attachment\/table-type_v114-2-input-1-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/Table-type_v114.2-input-1-en.png?fit=1043%2C460&amp;ssl=1\" data-orig-size=\"1043,460\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Table-type_v114.2-input-1-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/Table-type_v114.2-input-1-en.png?fit=1024%2C452&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/Table-type_v114.2-input-1-en-1024x452.png?resize=1024%2C452&#038;ssl=1\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" alt=\"\" class=\"wp-image-140366\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/Table-type_v114.2-input-1-en.png?resize=1024%2C452&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/Table-type_v114.2-input-1-en.png?resize=600%2C265&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/Table-type_v114.2-input-1-en.png?resize=768%2C339&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/Table-type_v114.2-input-1-en.png?w=1043&amp;ssl=1 1043w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To input \/ edit data items, the editing authority in the task must be set to \u201cEditable\u201d<\/li>\n\n\n\n<li>Columns must be configured in the Table Columns section on the property screen of the Data Item\n<ul class=\"wp-block-list\">\n<li>Item Name is displayed in the title row of the column<\/li>\n\n\n\n<li>Field Name is used for reference from other Data Items, etc\n<ul class=\"wp-block-list\">\n<li>Specify an arbitrary single-byte alphanumeric character string<\/li>\n\n\n\n<li>Required if [Show total value] is checked in \u201cnumeric\u201d column, optional for other columns<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Formulas can be set to automatically calculate cell values between numeric columns<\/li>\n\n\n\n<li>The number of rows that can be added depends on the limits set in the property<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The Task Operator can add table rows and can input table contents\n<ul class=\"wp-block-list\">\n<li>Double-click on the desired line to start typing<\/li>\n\n\n\n<li>Select-type columns will present a dropdown menu displaying the options set in the property<\/li>\n\n\n\n<li>In Date-type columns, the possible values for the years that can be entered are between 1900 and 2100<\/li>\n\n\n\n<li>The buttons on the top left respectively have the following functions\n<ul class=\"wp-block-list\">\n<li><span class=\"material-icons-outlined\">add<\/span> (add) : A row is added to the bottom<\/li>\n\n\n\n<li><span class=\"material-icons\">input<\/span> (insert) : A row is inserted above the checked row (invalid if unchecked))<\/li>\n\n\n\n<li><span class=\"material-icons\">delete<\/span> (delete) : Checked rows are deleted<\/li>\n\n\n\n<li><span class=\"material-icons\">file_copy<\/span> (Copy to clipboard) : The values of all cells in the table except for the summary row are copied to the clipboard (TSV format)<\/li>\n\n\n\n<li><span class=\"material-icons\">content_paste_go<\/span> (Paste from clipboard) : The contents of the clipboard are pasted expanding from the focused cell <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>In the clipboard, values are handled in the following format according to the type of sub-data item\n<ul class=\"wp-block-list\">\n<li>String-type: character string as it is<\/li>\n\n\n\n<li>Numeric-type: character string of the standard format (period as the decimal point, no thousand delimiter)<\/li>\n\n\n\n<li>Select-type: character string of the Choice ID<\/li>\n\n\n\n<li>Date-type: string in the format yyyy-MM-dd<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The copied content can be pasted to other Table-type Data Items with equivalent column definitions\n<ul class=\"wp-block-list\">\n<li>Click a cell to be the first to focus it, and click <span class=\"material-icons\">content_paste_go<\/span> to insert<\/li>\n\n\n\n<li>Values already entered in the table will not be overwritten<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>You can batch insert values copied from Google Sheets or Excel into a Table-type Data Item<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Table-type data items are intended for human input and validation in the WebUI<\/li>\n\n\n\n<li>If the only purpose is to process data in a table or array format in auto-processing tasks, save the data in TSV or CSV format as String-type (multiple lines) or File-type data items\n<ul class=\"wp-block-list\">\n<li>Advantages of saving as String-type data items\n<ul class=\"wp-block-list\">\n<li>Easier data processing such as merging and rearranging tables by [Script Tasks], etc.<\/li>\n\n\n\n<li>Consistent performance even as data size increases<\/li>\n\n\n\n<li>Easier table structure changes, as there is no need to define table columns<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Advantages of saving as File-type data items\n<ul class=\"wp-block-list\">\n<li>Easy conversion to String-type data items using a Converter<\/li>\n\n\n\n<li>Easy sharing of data by email, etc. with people who are not involved in the process<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/\">Tutorial: Let\u2019s Calculate the Total Amount Automatically<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/view-the-detailed-process-and-record-data\/\">Tutorial: Who Can View Business Data of the Issue, and Who Can\u2019t?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024615831\" target=\"_blank\" rel=\"noreferrer noopener\">R2131: HTML Elements Available in Markdown<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002259971-M205-Business-Data-Items\">M205: Business Data Items<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002245192-M206-Mandatory-Check-and-Input-Format-Check-on-Each-Data-Item\">M206: Mandatory Check and Input Format Check on Each Data Item<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002245252-M213-Guidance-Descriptions-on-the-Operating-Screen-HTML-JavaScript-\">M213: Guidance Descriptions on the Operating Screen (HTML\/JavaScript)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/googlesheets-appendtsv\/\">Download: New Record to Google Sheets (TSV)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/googlesheets-appendtable\/\">Download: Row Addition to Google Sheet (Table)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-options-table\/\">Download: Converter (Options to Table)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/tables-diff\/\">Download: Diff (Table and Table)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/email-sendexcelcsvsjis\/\">Download: Email a Excel-CSV (Table) sjis<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/duplicator-table\/\">Download: Data Duplicator (Table)<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Displays a table that can use the String, Numeric, Select or Date formats.<\/p>\n","protected":false},"author":30,"featured_media":81430,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[2343],"tags":[],"class_list":["post-79781","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-items"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Peter Glover","author_link":"https:\/\/support.questetra.com\/en\/author\/petergloverquestetra\/"},"uagb_comment_info":1,"uagb_excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-kKN","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":76339,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-data-assignment\/","url_meta":{"origin":79781,"position":0},"title":"Update Data","author":"Hirotaka NISHI","date":"2021-09-28","format":false,"excerpt":"Automatically updates Business Data with the specified value or the evaluation result of the formula. Capable of updating several Data Items also in one automatic Step.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69682,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-tabletoexcelcsv\/","url_meta":{"origin":79781,"position":1},"title":"Converter (Table type data to Excel-CSV File)","author":"Shiho Tatsumi","date":"2024-07-05","format":false,"excerpt":"This item stores the values in a Table type data item into a File type data item as an Excel compatible CSV. The file is added and does not affect existing files.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":116684,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/google-sheet-table-add-sum\/","url_meta":{"origin":79781,"position":2},"title":"Adding Table Values to Google Sheets and Getting the Aggregate Value","author":"Hirotaka NISHI","date":"2021-11-11","format":false,"excerpt":"Adds the contents of a Table-type Data Item to a Google Sheet and retrieves the aggregated value. Various aggregations can be performed automatically depending on the spreadsheet settings.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69064,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tabletotsv\/","url_meta":{"origin":79781,"position":3},"title":"Converter (Table to TSV)","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Converts the value of a Table type data item to the tab delimited format (TSV) and stores it in a String type data item","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-tsv-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82453,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-excelcsv-to-table\/","url_meta":{"origin":79781,"position":4},"title":"Converter (TSV File to Table type data)","author":"Shiho Tatsumi","date":"2024-08-01","format":false,"excerpt":"This item overwrites the value of a Table type data item with a contents of an Excel compatible CSV file (TSV UTF-16 LE with BOM) stored in a File type data item.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":169910,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/","url_meta":{"origin":79781,"position":5},"title":"Update CSV Data","author":"Hirotaka NISHI","date":"2025-01-15","format":false,"excerpt":"CSV\/TSV data entered as String-type (multiple lines) is treated as an RDB table, and the data is manipulated by queries (SQL). The results of the query are saved in the specified String-type (multiple lines) Data Item. Two data can also be combined.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/79781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=79781"}],"version-history":[{"count":87,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/79781\/revisions"}],"predecessor-version":[{"id":179255,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/79781\/revisions\/179255"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/81430"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=79781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=79781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=79781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}