{"id":159227,"date":"2024-03-25T17:55:09","date_gmt":"2024-03-25T08:55:09","guid":{"rendered":"https:\/\/support.questetra.com\/?p=159227"},"modified":"2026-06-03T14:28:31","modified_gmt":"2026-06-03T05:28:31","slug":"regist-service-request-process-with-rpa-tool-202120421","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/templates\/regist-service-request-process-with-rpa-tool-202120421\/","title":{"rendered":"Maintenance Service Request Registration 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\">Maintenance Service Request Registration App 202120421<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:8px;border-bottom-right-radius:8px\">This is a workflow for registering maintenance service requests (SRs) to the central system. SRs are automatically added to a Google Sheet after being checked by the person in charge, and the RPA tool reads the Google Sheet and registers the SRs to the central system.<\/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>Worker (#of Swimlane: 1)<\/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>Receptionist<\/strong> <\/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 Flow (Complexity of Workflow: 17)<\/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. Service request registration<\/strong>\n<ul class=\"wp-block-list\">\n<li>A representative logs a customer service request.<\/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\">10<\/span><\/span><\/span><strong>2. Confirm processing results<\/strong>\n<ul class=\"wp-block-list\">\n<li>The person in charge will confirm that the update results in Google Sheets match the central system registration.<\/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\">7<\/span><\/span><\/span><strong>2x. Check processing status<\/strong>\n<ul class=\"wp-block-list\">\n<li>The person in charge will check the reason why the Google sheet is not updated. After confirmation, we will perform auxiliary work such as manually operating the RPA tool.<\/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\">3<\/span><\/span><\/span><strong>Add record<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform adds one line to the Google Sheet and stores the registered content.<\/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\">16<\/span><\/span><\/span> <strong>Get processing status<\/strong> <\/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\">13<\/span><\/span><\/span><strong>Get registration status<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform acquires service request information (including processing status).<\/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\">15<\/span><\/span><\/span><strong>Processing status: Post-processing completed<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform updates service request information (processing status).<\/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\">4<\/span><\/span><\/span><strong>Status: Processing<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform updates the processing status (processing).<\/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>Status: Processing completion confirmed<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform updates the processing status (confirmation completed).<\/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>Status: Processing confirmation<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform updates the processing status (processing confirmation).<\/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 su-spoiler-closed\" data-anchor=\"diagram\" 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 Diagram (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/03\/regist-service-request-process-with-rpa-tool-diagram-en.jpg?ssl=1\" alt=\"\" class=\"wp-image-98238\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>BPMN Icons\n<ul class=\"wp-block-list\">\n<li>Start Event<\/li>\n\n\n\n<li>End Event<\/li>\n\n\n\n<li>Join Gateway<\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/exclusive-gateway\/\">XOR Gateway<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/timer-intermediate-event\/\">Timer Intermediate Event<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/human-task\/\" target=\"_blank\" rel=\"noreferrer noopener\">Human Task<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-data-assignment\/\">Update Data<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/\">Google Sheets: Append New Row<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-sheets-row-get\/\">Google Sheets: Get Row<\/a><\/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 (#of Data Item: 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\"><i class=\"fal fa-list-alt fa-lg\" style=\"color:#AEB404;\" title=\"Select (Radio Button)\"><\/i><\/span><strong>Status<\/strong><span style=\"font-style:italic; color:#009900\">q_status<\/span><code>5<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the registration and confirmation status of service requests.<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">Reception<\/span><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-clock fa-lg\" style=\"color:#5FB404;\" title=\"Datetime\"><\/i><\/span><strong>Request Date<\/strong><span style=\"font-style:italic; color:#009900\">q_request_datetime<\/span><code>3<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores The date the service request was received.<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">processInstanceStartDatetime<\/span><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>\u25c6 Request Information<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>8<\/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>Company Name<\/strong><span style=\"font-style:italic; color:#009900\">q_corp_name<\/span><code>0<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the customer&#8217;s company name.<\/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>Customer&#8217;s Name<\/strong><span style=\"font-style:italic; color:#009900\">q_person_name<\/span><code>1<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the customer&#8217;s contact name.<\/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>Email Address<\/strong><span style=\"font-style:italic; color:#009900\">q_mail_address<\/span><code>2<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the customer&#8217;s email address.<\/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>Telephone Number<\/strong> <span style=\"font-style:italic; color:#009900\">q_tel_no<\/span> <code>10<\/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 multiple lines)\"><\/i><\/span><strong>Request Content<\/strong><span style=\"font-style:italic; color:#009900\">q_request_description<\/span><code>4<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores service request details.<\/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>Processing Result Evidence<\/strong><span style=\"font-style:italic; color:#009900\">q_evidence<\/span><code>11<\/code>\n<ul class=\"wp-block-list\">\n<li>Contents registered in the core system are 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>Notes on RPA Tool Processing Anomalies<\/strong><span style=\"font-style:italic; color:#009900\">q_error_memo<\/span><code>12<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the specific details of the error and RPA tool logs.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>\u25c6 System Usage Information<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>9<\/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>Insert Line Number<\/strong><span style=\"font-style:italic; color:#009900\">q_insert_row_number<\/span><code>7<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the row number of the Google Sheet. The target line is the line where reception service request information is registered.<\/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>Automatic Processing Status<\/strong><span style=\"font-style:italic; color:#009900\">q_rpa_action_status<\/span><code>13<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the processing status of the RPA tool.<\/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\/m93-Maintenance_Service_Request_Registration_App.qar\">Maintenance_Service_Request_Registration_App.qar<\/a> (Latest)<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/uc?id=1pzkIdX6Kfa8b_baM4P2NNNSGMKvOZtPJ&amp;export=download\" target=\"_blank\" rel=\"noopener\">regist-service-request-app-with-rpa-tool-202120421-en.qar<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/drive.google.com\/uc?id=1Io0sQawqy_IRwgHNhm-WN47XkRtQKE0F&amp;export=download\" target=\"_blank\" rel=\"noopener\">regist-service-request-app-with-rpa-tool-202120421-en.xml.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> This archive contains the BPMN icons that are not available in the Basic 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>You need to associate the Swimlane settings according to your organizational structure upon import<\/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 size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/03\/regist-service-request-process-with-rpa-tool-img1-en.png?ssl=1\" alt=\"\" class=\"wp-image-121736\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\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:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360052780932-Settings-Required-When-Importing-an-Archive\" target=\"_blank\" rel=\"noreferrer noopener\">Settings Required When Importing an Archive<\/a><\/li>\n<\/ul>\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=\"DHVRI15WJI\"><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/\">Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u8ffd\u52a0<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cGoogle \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u8ffd\u52a0\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/googlesheets-appendcells\/embed\/#?secret=NUW0EMyC58#?secret=DHVRI15WJI\" data-secret=\"DHVRI15WJI\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\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=\"1DA5N16ECY\"><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-sheets-row-update\/\">Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u66f4\u65b0<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cGoogle \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u66f4\u65b0\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-google-sheets-row-update\/embed\/#?secret=xxOrzPVEfU#?secret=1DA5N16ECY\" data-secret=\"1DA5N16ECY\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This is a workflow for registering maintenance service requests (SRs) to the central system. SRs are automatically added to a Google Sheet after being checked by the person in charge, and the RPA tool reads the Google Sheet and registers the SRs to the central system.<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","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":[396,3162,493],"class_list":["post-159227","post","type-post","status-publish","format-standard","hentry","category-templates","tag-google-sheets-api-v4","tag-google-workspace","tag-task-request"],"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":"furuzo","author_link":"https:\/\/support.questetra.com\/en\/author\/furuzo\/"},"uagb_comment_info":0,"uagb_excerpt":"This is a workflow for registering maintenance service requests (SRs) to the central system. SRs are automatically added to a Google Sheet after being checked by the person in charge, and the RPA tool reads the Google Sheet and registers the SRs to the central system.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-Fqb","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":67310,"url":"https:\/\/support.questetra.com\/ja\/addons\/googlesheets-appendtsv\/","url_meta":{"origin":159227,"position":0},"title":"Google Sheets \u884c\u8ffd\u52a0 (TSV)","author":"Hirotaka NISHI","date":"2018-09-03","format":false,"excerpt":"2018 \u00a9 Questetra, Inc. (the MIT License) https:\/\/support.questetra.com\/ja\/addons\/googlesheets-appendtsv\/ Download GoogleSheets-appendTsv.xml Capture Notes \u201c0,1,5d,3n,6\u201d \u306f\u3001ID:0\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u3001ID:1\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u3001ID:5\u3092\u65e5\u6642\u3068\u3057\u3066\u3001ID:3\u3092\u6570\u5b57\u3068\u3057\u3066\u3001ID:6\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u8ffd\u8a18\u3059\u308b\u3053\u3068\u3092\u610f\u5473\u3057\u307e\u3059\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 ID \u306f URL \u7b49\u3092\u53c2\u7167\u3057\u307e\u3059https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=0 See also 2016-11-07 \u7b2c508\u8a71\uff1a\u6cd5\u4eba\u756a\u53f7API\u3067\u300c\u9867\u5ba2\u30de\u30b9\u30bf\u30fc\u300d\u3092\u6b63\u5f0f\u5546\u53f7\u53162016-09-20 \u7b2c501\u8a71\uff1a\u4e88\u7b97\u306e\u6d88\u8cbb\u984d\u304c\u30ef\u30ab\u30e9\u30f3\uff01\uff1f\uff01","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\/2018\/09\/Google-Sheets-%E8%A1%8C%E8%BF%BD%E5%8A%A0-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\/09\/Google-Sheets-%E8%A1%8C%E8%BF%BD%E5%8A%A0-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/Google-Sheets-%E8%A1%8C%E8%BF%BD%E5%8A%A0-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/Google-Sheets-%E8%A1%8C%E8%BF%BD%E5%8A%A0-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/Google-Sheets-%E8%A1%8C%E8%BF%BD%E5%8A%A0-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96361,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-append-tsv\/","url_meta":{"origin":159227,"position":1},"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":95590,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-spreadsheets-add-sheet\/","url_meta":{"origin":159227,"position":2},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Spreadsheet, \u30b7\u30fc\u30c8\u3092\u8ffd\u52a0","author":"IMAMURA, Genichi","date":"2020-10-05","format":false,"excerpt":"\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092 Spreadsheet \u5185\u306e\u672b\u5c3e\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002\u6307\u5b9a\u3057\u305f\u30b7\u30fc\u30c8\u540d\u304c\u65e2\u306b\u5b58\u5728\u3059\u308b\u5834\u5408\u3001\u81ea\u52d5\u5de5\u7a0b\u306f\u30a8\u30e9\u30fc\u7d42\u4e86\u3057\u307e\u3059\u3002\u5225\u9014 SheetId \u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\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":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Spreadsheet, \u30b7\u30fc\u30c8\u3092\u8ffd\u52a0","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Spreadsheets-Add-Sheet-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-Spreadsheets-Add-Sheet-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-Spreadsheets-Add-Sheet-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-Spreadsheets-Add-Sheet-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-Spreadsheets-Add-Sheet-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":159227,"position":3},"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":[]},{"id":82159,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":159227,"position":4},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf\u3055\u308c\u305f\u8907\u6570\u306e\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u8907\u6570\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"string:0,date:2,select: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\u4e00\u62ec\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-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-Batch-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-Batch-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-Batch-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-Batch-Extract-as-TSV-ja.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":159227,"position":5},"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":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/159227","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=159227"}],"version-history":[{"count":10,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/159227\/revisions"}],"predecessor-version":[{"id":186184,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/159227\/revisions\/186184"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=159227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=159227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=159227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}