{"id":142579,"date":"2023-03-30T17:05:47","date_gmt":"2023-03-30T08:05:47","guid":{"rendered":"https:\/\/support.questetra.com\/?p=142579"},"modified":"2026-06-01T11:00:42","modified_gmt":"2026-06-01T02:00:42","slug":"training-application-20221227","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/templates\/training-application-20221227\/","title":{"rendered":"Internal Training Application App"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#44bbbb;border-radius:10px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#77eeee;color:#000000;border-top-left-radius:8px;border-top-right-radius:8px\">Internal Training Application App 20221227<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:8px;border-bottom-right-radius:8px\">This app manages applications for participation in in-house training programs. Once the application is received, the applicant is automatically added to the training schedule in the Outlook calendar.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-2\" data-anchor=\"swimlane\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Operators (Number of Swimlanes: 3)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"wp-block-list fa-ul\">\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fas fa-user fa-lg\" style=\"color:#333333;\"><\/i><\/span><\/span><strong>Applicant<\/strong>\n<ul class=\"wp-block-list\">\n<li>An applicant applying to participate in a training program.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fas fa-user fa-lg\" style=\"color:#333333;\"><\/i><\/span><\/span><strong>Approver<\/strong>\n<ul class=\"wp-block-list\">\n<li>The supervisor of the applicant applying to participate in the training.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fas fa-user fa-lg\" style=\"color:#333333;\"><\/i><\/span><\/span><strong>Training Receptionist<\/strong>\n<ul class=\"wp-block-list\">\n<li>Person in charge of accepting training participation.<\/li>\n<\/ul>\n<\/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-2\" data-anchor=\"nodes\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Workflow (Workflow diagram complexity: 13)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"wp-block-list fa-ul\">\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"far fa-rectangle-landscape fa-lg\" style=\"color:#4a86e8;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">1<\/span><\/span><\/span><strong>1. Application<\/strong>\n<ul class=\"wp-block-list\">\n<li>The applicant enters the information required for the training application.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"far fa-rectangle-landscape fa-lg\" style=\"color:#4a86e8;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">4<\/span><\/span><\/span><strong>1x. Re-application<\/strong>\n<ul class=\"wp-block-list\">\n<li>The applicant must revise and resubmit the application or withdraw it.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"far fa-rectangle-landscape fa-lg\" style=\"color:#4a86e8;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">2<\/span><\/span><\/span><strong>2. Approval<\/strong>\n<ul class=\"wp-block-list\">\n<li>The approver will review the application and return it if it is incomplete.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"far fa-rectangle-landscape fa-lg\" style=\"color:#4a86e8;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">3<\/span><\/span><\/span><strong>3. Reception<\/strong>\n<ul class=\"wp-block-list\">\n<li>The training receptionist will accept the application and proceed to process it.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fal fa-rectangle-landscape fa-lg\" style=\"color:#666666;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">12<\/span><\/span><\/span><strong>x1&#8242;. Set Subject (Withdrawn)<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform updates the subject line.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fal fa-rectangle-landscape fa-lg\" style=\"color:#666666;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">10<\/span><\/span><\/span><strong>x1. Set Subject<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform sets the subject line.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fal fa-rectangle-landscape fa-lg\" style=\"color:#666666;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">11<\/span><\/span><\/span><strong>x2. Data Preparation<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform prepares data for event updates in the Outlook calendar.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fal fa-rectangle-landscape fa-lg\" style=\"color:#666666;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">7<\/span><\/span><\/span><strong>x3. Add Participants to the Event<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform adds the applicant to the event participants in the Outlook calendar.<\/li>\n<\/ul>\n<\/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-2\" data-anchor=\"nodes\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Business app variables to be passed (number of data items: 8)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"wp-block-list fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-sitemap fa-lg\" style=\"color:#04B4AE;\" title=\"Organization\"><\/i><\/span> <strong>Applicant Organization<\/strong> <span style=\"font-style:italic; color:#009900\">q_org<\/span> <code>2<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li> <span style=\"color:#9DCCE0;\">processInstanceInitQgroupId<\/span><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-user fa-lg\" style=\"color:#04B45F;\" title=\"User (Select Box)\"><\/i><\/span> <strong>Applicant<\/strong> <span style=\"font-style:italic; color:#009900\">q_user<\/span> <code>0<\/code> <span style=\"color:#990000;\">*<\/span><\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-list-alt fa-lg\" style=\"color:#AEB404;\" title=\"Select (Search Select Box)\"><\/i><\/span><strong>Training Selection<\/strong> <span style=\"font-style:italic; color:#009900\">q_select<\/span> <code>1<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li>The training you wish to participate in will be stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box multiple lines)\"><\/i><\/span> <strong>Reason for Application<\/strong> <span style=\"font-style:italic; color:#009900\">q_reason<\/span> <code>3<\/code> <span style=\"color:#990000;\">*<\/span><\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-comments fa-lg\" style=\"color:#045FB4;\" title=\"Discussion\"><\/i><\/span> <strong>Memo<\/strong> <span style=\"font-style:italic; color:#009900\">q_memo<\/span> <code>4<\/code> <\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box single line)\"><\/i><\/span><strong>Outlook Event ID<\/strong> <span style=\"font-style:italic; color:#009900\">q_eventId<\/span> <code>5<\/code>\n<ul class=\"wp-block-list\">\n<li>The event ID of the training you wish to attend will be stored in the Outlook calendar.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box single line)\"><\/i><\/span> <strong>Applicant&#8217;s Email Address<\/strong> <span style=\"font-style:italic; color:#009900\">q_email<\/span> <code>6<\/code> <\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box single line)\"><\/i><\/span><strong>Outlook Event URL<\/strong> <span style=\"font-style:italic; color:#009900\">q_eventUrl<\/span> <code>7<\/code>\n<ul class=\"wp-block-list\">\n<li>The event URL for the training you wish to attend will be stored in your Outlook calendar.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"><i class=\"fal fa-graduation-cap\"><\/i> <span style=\"font-style:italic; color:#009900\">Field Name<\/span>, <code>Num<\/code>, <span style=\"color:#9DCCE0;\">Initial value<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/qbpms-app-archive.s3.ap-northeast-1.amazonaws.com\/online-demo-en-backup\/m61-Internal_Training_Application_App.qar\">Internal_Training_Application_App.qar<\/a> (Latest)<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/uc?id=1TKbOVPxlI_feeH2vfhIHj0GTl29efw0-&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">training-application-20221227-en.qar<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/drive.google.com\/uc?id=1QVQI5Sah1A5Uk3TIqezZ7VnmoL8ehFIB&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">training-application-20221227-en.csv<\/a> (for importing data item definitions)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"><i class=\"fal fa-info-circle\"><\/i> Only available in <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\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-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For setting up integration with Microsoft365-based services (see also the Add-on XML link in See Also for details on scope, etc.)\n<ul class=\"wp-block-list\">\n<li>How to register applications on the Microsoft365 (Azure Active Directory) side\n<ul class=\"wp-block-list\">\n<li>&#8220;<a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/developer-blog\/office365-app-regist-2\/\" target=\"_blank\">Application Registration Procedure in Office 365 for Linking Office 365 and Questetra Cloud Workflow with API<\/a>&#8220;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>How to Setup HTTP Authentication on Questetra side\n<ul class=\"wp-block-list\">\n<li>&#8220;<a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/developer-blog\/onedrive-questetra\/\" target=\"_blank\">How to Output Files from Cloud-based Workflow Questetra to OneDrive<\/a>&#8221;\n<ul class=\"wp-block-list\">\n<li>&#8220;2.2: OAuth settings on the Questetra side&#8221;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"917\" height=\"336\" data-attachment-id=\"143025\" data-permalink=\"https:\/\/support.questetra.com\/en\/templates\/training-application-20221227\/attachment\/training-application-20221227-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/02\/training-application-20221227-capture-en.jpg?fit=917%2C336&amp;ssl=1\" data-orig-size=\"917,336\" 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=\"training-application-20221227-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/02\/training-application-20221227-capture-en.jpg?fit=917%2C336&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/02\/training-application-20221227-capture-en.jpg?resize=917%2C336&#038;ssl=1\" alt=\"\" class=\"wp-image-143025\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/02\/training-application-20221227-capture-en.jpg?w=917&amp;ssl=1 917w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/02\/training-application-20221227-capture-en.jpg?resize=600%2C220&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/02\/training-application-20221227-capture-en.jpg?resize=768%2C281&amp;ssl=1 768w\" sizes=\"auto, (max-width: 917px) 100vw, 917px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"ta1EI3kuP3\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/outlook-calendar-event-attendees-add\/\">Microsoft 365 Outlook: Add Attendees to Calendar Event<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cMicrosoft 365 Outlook: Add Attendees to Calendar Event\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/outlook-calendar-event-attendees-add\/embed\/#?secret=Z3SvzTKZ3E#?secret=ta1EI3kuP3\" data-secret=\"ta1EI3kuP3\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This process manages applications for participation in in-house training programs.<br \/>\nOnce the application is received, the applicant is automatically added to the training schedule in the Outlook calendar.<\/p>\n","protected":false},"author":9,"featured_media":0,"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":[156],"tags":[485,509,3160],"class_list":["post-142579","post","type-post","status-publish","format-standard","hentry","category-templates","tag-approval-flows","tag-career-development","tag-microsoft-365"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"newspack-article-block-landscape-large":false,"newspack-article-block-portrait-large":false,"newspack-article-block-square-large":false,"newspack-article-block-landscape-medium":false,"newspack-article-block-portrait-medium":false,"newspack-article-block-square-medium":false,"newspack-article-block-landscape-intermediate":false,"newspack-article-block-portrait-intermediate":false,"newspack-article-block-square-intermediate":false,"newspack-article-block-landscape-small":false,"newspack-article-block-portrait-small":false,"newspack-article-block-square-small":false,"newspack-article-block-landscape-tiny":false,"newspack-article-block-portrait-tiny":false,"newspack-article-block-square-tiny":false,"newspack-article-block-uncropped":false},"uagb_author_info":{"display_name":"Tsuyoshi Kusaka","author_link":"https:\/\/support.questetra.com\/en\/author\/kusaka0211\/"},"uagb_comment_info":1,"uagb_excerpt":"This process manages applications for participation in in-house training programs. Once the application is received, the applicant is automatically added to the training schedule in the Outlook calendar.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-B5F","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":96361,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-append-tsv\/","url_meta":{"origin":142579,"position":0},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","author":"IMAMURA, Genichi","date":"2020-10-14","format":false,"excerpt":"\u6700\u7d42\u884c\u306bTSV\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u5fc5\u8981\u3067\u3042\u308c\u3070\u3001\u65b0\u3057\u3044\u884c\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002TSV\u306e\u6307\u5b9a\u5217\u3060\u3051\u304c\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u306a\u304a\u3001\u5217ID\u3092\u6307\u5b9a\u3059\u308b\u969b\u306b\"d\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u65e5\u6642\u30c7\u30fc\u30bf\u3068\u3057\u3066\u3001\"n\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u6570\u5024\u30c7\u30fc\u30bf\u3068\u3057\u3066\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u5217\u6307\u5b9a\u306e\u4f8b: \"0,2d,5n\"\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":142579,"position":1},"title":"Singleline TSV String, Extract Cell","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Singleline TSV String, Extract Cell","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-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\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":99834,"url":"https:\/\/support.questetra.com\/ja\/addons\/googlecalendar-eventslist-get\/","url_meta":{"origin":142579,"position":2},"title":"Google Calendar \u30a4\u30d9\u30f3\u30c8\u30ea\u30b9\u30c8\uff08\u4e88\u5b9a\uff09\u53d6\u5f97","author":"Hirotaka NISHI","date":"2021-01-14","format":false,"excerpt":"Google Calendar \u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001\u6307\u5b9a\u3055\u308c\u305f\u671f\u9593\u306b\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u30a4\u30d9\u30f3\u30c8\u30ea\u30b9\u30c8\uff08\u4e88\u5b9a\uff09\u306e\u4e00\u89a7\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u3068\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3001\u6765\u9031\u306e\u4e88\u5b9a\u3092\u4e00\u62ec\u3067\u53d6\u5f97\u3057\u3001\u30e1\u30fc\u30eb\u3067\u901a\u77e5\uff08\u544a\u77e5\uff09\u3059\u308b\u3068\u3044\u3063\u305f\u4f7f\u3044\u65b9\u304c\u53ef\u80fd\u3067\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Google-Calendar-eventsList-get-2021-01-08-featured-image.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\/Google-Calendar-eventsList-get-2021-01-08-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Google-Calendar-eventsList-get-2021-01-08-featured-image.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Google-Calendar-eventsList-get-2021-01-08-featured-image.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/Google-Calendar-eventsList-get-2021-01-08-featured-image.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":97147,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":142579,"position":3},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","author":"IMAMURA, Genichi","date":"2020-10-28","format":false,"excerpt":"\u5358\u4e00\u884cTSV\u30c7\u30fc\u30bf\u3067Google\u30b7\u30fc\u30c8\u3092\u66f4\u65b0\u3057\u307e\u3059\u3002TSV\u306e\u5148\u982d\u5024\u3068\u5b8c\u5168\u4e00\u81f4\u3059\u308bA\u30bb\u30eb\u3092\u63a2\u7d22\u3057\u3001\u6700\u521d\u306b\u5408\u81f4\u3057\u305f\u884c\u306b\u3064\u3044\u3066\u4e0a\u66f8\u304d\u3057\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u5024\u306f\u3001\u624b\u5165\u529b\u3057\u305f\u969b\u3068\u540c\u69d8\u306b\u81ea\u52d5\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\u3082\u3057\u5408\u81f4\u3059\u308b\u884c\u304c\u7121\u3044\u5834\u5408\u306f\u3001\u672b\u5c3e\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82972,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-drive-file-convert\/","url_meta":{"origin":142579,"position":4},"title":"Google \u30c9\u30e9\u30a4\u30d6: \u30d5\u30a1\u30a4\u30eb, \u30b3\u30f3\u30d0\u30fc\u30c8","author":"IMAMURA, Genichi","date":"2019-12-25","format":false,"excerpt":"Google\u30c9\u30e9\u30a4\u30d6\u5185\u30d5\u30a1\u30a4\u30eb\u3092\u5909\u63db\u3057\u3001\u5225\u306e MimeType \u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u65b0\u898f\u4fdd\u5b58\u3057\u307e\u3059\u3002Google\u30d5\u30a1\u30a4\u30eb\u3068\u4e00\u822c\u30d5\u30a1\u30a4\u30eb\u306e\u4e21\u65b9\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002\u306a\u304a\u3001File ID \u306f URI \u7b49\u304b\u3089\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002\uff08\u4fdd\u5b58\u30d5\u30a9\u30eb\u30c0\u304c\u7121\u6307\u5b9a\u306e\u5834\u5408\u3001\u5143\u30d5\u30a1\u30a4\u30eb\u306e\u6240\u5c5e\u30d5\u30a9\u30eb\u30c0\u60c5\u5831\u3092\u7d99\u627f\u3057\u307e\u3059\uff09","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30c9\u30e9\u30a4\u30d6: \u30d5\u30a1\u30a4\u30eb, \u30b3\u30f3\u30d0\u30fc\u30c8","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Google-Drive-File-Convert-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Google-Drive-File-Convert-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Google-Drive-File-Convert-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Google-Drive-File-Convert-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Google-Drive-File-Convert-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82141,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-extract-as-tsv\/","url_meta":{"origin":142579,"position":5},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u4e00\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"0,2,3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.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\/142579","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=142579"}],"version-history":[{"count":14,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/142579\/revisions"}],"predecessor-version":[{"id":185425,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/142579\/revisions\/185425"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=142579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=142579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=142579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}