{"id":154181,"date":"2023-11-07T16:56:35","date_gmt":"2023-11-07T07:56:35","guid":{"rendered":"https:\/\/support.questetra.com\/?p=154181"},"modified":"2023-11-07T16:56:38","modified_gmt":"2023-11-07T07:56:38","slug":"approval-flow-20211025","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/templates\/approval-flow-20211025\/","title":{"rendered":"Approval Flow"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#0b6305;border-radius:3px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#3E9638;color:#FFFFFF;border-top-left-radius:1px;border-top-right-radius:1px\">Approval Flow 20211025<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:1px;border-bottom-right-radius:1px\">This approval flow determines approvers based on an externally managed list.\nApprover information is obtained from an external list based on the project selected by the applicant and the approvers are determined.\nThis makes it easy to deal with frequent changes in approvers.<\/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: 4)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul wp-block-list\">\n<li><strong>Applicant<\/strong>\n<ul class=\"wp-block-list\">\n<li>The person in charge of drafting a request for approval.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>System Administrator<\/strong>\n<ul class=\"wp-block-list\">\n<li>System administrators who provide recovery support in the event of an error.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Project Leader<\/strong>\n<ul class=\"wp-block-list\">\n<li>Leader of the relevant project to approve the request.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Director<\/strong>\n<ul class=\"wp-block-list\">\n<li>The officer in charge of the relevant project who approves the request.<\/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 Flow (Complexity of Workflow: 24)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul wp-block-list\">\n<li><strong>1. Submit a request<\/strong>\n<ul class=\"wp-block-list\">\n<li>The applicant drafts a request for approval.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>1x. Respond to a rejection<\/strong>\n<ul class=\"wp-block-list\">\n<li>The applicant revises the draft and resubmits or withdraws it.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>1y. Error Recovery<\/strong>\n<ul class=\"wp-block-list\">\n<li>The system administrator recovers from problems in the approver decision process by manually selecting the approver.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>2. Approve<\/strong>\n<ul class=\"wp-block-list\">\n<li>The project leader approves the draft. If there are any deficiencies, it is sent back.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>3. Executive approval<\/strong>\n<ul class=\"wp-block-list\">\n<li>External payments of more than $5,000 are approved by the executive.<\/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\">31<\/span><\/span><\/span><strong>x1-1. Project ID conversion<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform converts the ID of the selected project into character data.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>x1-2. Identify the relevant rows in the database<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform identifies the row with the relevant project ID from a list in Google Sheets.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>x1-3. Acquire data from the relevant rows of the database<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform retrieves the data from the relevant row in Google Sheets.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>x1-4. User acquisition from email address<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform sets user type data based on the email address retrieved.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>x2. Record of withdrawal<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform overwrites the &#8216;Status&#8217; (Select-type) data item to show &#8216;Withdrawn&#8217;.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>x3a. Leader approval records<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform overwrites the &#8216;Status&#8217; (Select-type) data item to show &#8216;Approved&#8217;.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>x3b. Director approval record<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform overwrites the &#8216;Status&#8217; (Select-type) data item to show &#8216;Director Approved&#8217;.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>x4. Director rejecton record<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform overwrites the &#8216;Status&#8217; (Select-type) data item to show &#8216;Director Rejected&#8217;.<\/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 Process Variables (#of Data Item: 24)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul wp-block-list\">\n<li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>\u25bc Application \u25bc<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>0<\/code> <\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-sitemap fa-lg\" style=\"color:#04B4AE;\" title=\"Organization\"><\/i><\/span><strong>Applicant Affiliation<\/strong> <span style=\"font-style:italic; color:#009900\">q_Affiliation<\/span> <code>1<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li>The department to which the originator belongs is stored. (&#8220;Organisation&#8221; in the workflow platform).<\/li>\n\n\n\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 (Search Select Box)\"><\/i><\/span><strong>Drafter<\/strong> <span style=\"font-style:italic; color:#009900\">q_Drafter<\/span> <code>2<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li>The drafter is stored in the system. (&#8220;user&#8221; in the workflow platform).<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">${processInstance.initQuserId}<\/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>Time of Submission<\/strong> <span style=\"font-style:italic; color:#009900\">q_Submission<\/span> <code>3<\/code>\n<ul class=\"wp-block-list\">\n<li>The date and time of the submission is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-list-alt fa-lg\" style=\"color:#AEB404;\" title=\"Select (Select Box)\"><\/i><\/span><strong>Select Related Projects<\/strong> <span style=\"font-style:italic; color:#009900\">q_Project<\/span> <code>29<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li>Stores which project the draft relates to.<\/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>Contents<\/strong> <span style=\"font-style:italic; color:#009900\">q_Contents<\/span> <code>4<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li>The contents of the draft and the reasons for it are stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-copy fa-lg\" style=\"color:#04B404;\" title=\"File\"><\/i><\/span><strong>Attachments<\/strong> <span style=\"font-style:italic; color:#009900\">q_Attachment<\/span> <code>5<\/code>\n<ul class=\"wp-block-list\">\n<li>It contains attachments relating to the content of the draft.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-percent fa-lg\" style=\"color:#B45F04;\" title=\"Numeric\"><\/i><\/span><strong>External Payment<\/strong> <span style=\"font-style:italic; color:#009900\">q_Payment<\/span> <code>6<\/code>\n<ul class=\"wp-block-list\">\n<li>The amount of the external payment is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-percent fa-lg\" style=\"color:#B45F04;\" title=\"Numeric\"><\/i><\/span><strong>Internal Man-Hours<\/strong> <span style=\"font-style:italic; color:#009900\">q_Hours<\/span> <code>7<\/code>\n<ul class=\"wp-block-list\">\n<li>The amount of internal man-hours is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-list-alt fa-lg\" style=\"color:#AEB404;\" title=\"Select (Radio Button)\"><\/i><\/span><strong>Budgetary Classification<\/strong> <span style=\"font-style:italic; color:#009900\">q_Budget<\/span> <code>8<\/code>\n<ul class=\"wp-block-list\">\n<li>The budget category of the draft is 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 single line)\"><\/i><\/span><strong>Budget Category Remarks<\/strong> <span style=\"font-style:italic; color:#009900\">q_Remarks<\/span> <code>9<\/code>\n<ul class=\"wp-block-list\">\n<li>The remarks of the budget category of the draft content are stored.<\/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>\u25bc Leader Approval and Executive Approval \u25bc<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>10<\/code> <\/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>Approving Leader<\/strong> <span style=\"font-style:italic; color:#009900\">q_Superior<\/span> <code>11<\/code>\n<ul class=\"wp-block-list\">\n<li>The project leader who approves the draft is stored.<\/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>Leader Approval Time<\/strong> <span style=\"font-style:italic; color:#009900\">q_Approval<\/span> <code>12<\/code>\n<ul class=\"wp-block-list\">\n<li>Automatically set in &#8216;2. Approve&#8217;<\/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>Approving Executive<\/strong> <span style=\"font-style:italic; color:#009900\">q_Officer<\/span> <code>14<\/code>\n<ul class=\"wp-block-list\">\n<li>The executive officer in charge of approving the draft is stored.<\/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>Executive Decision Time<\/strong> <span style=\"font-style:italic; color:#009900\">q_Decision<\/span> <code>15<\/code>\n<ul class=\"wp-block-list\">\n<li>Automatically set in &#8220;3. Executive approval&#8221;<\/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>\u25bc Results of the Approval Process \u25bc<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>16<\/code> <\/li>\n\n\n\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>17<\/code>\n<ul class=\"wp-block-list\">\n<li>The status of the approval process is stored. It will be automatically overwritten at x2, x3, and x4.<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">1<\/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>\u25bc Internal Communication \u25bc<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>20<\/code> <\/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>Comments \/ Messages<\/strong> <span style=\"font-style:italic; color:#009900\">q_Message<\/span> <code>21<\/code>\n<ul class=\"wp-block-list\">\n<li>Internal comments and messages 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 single line)\"><\/i><\/span><strong>Project ID (String-type)<\/strong> <span style=\"font-style:italic; color:#009900\">q_ProjectId<\/span> <code>26<\/code>\n<ul class=\"wp-block-list\">\n<li>The project ID (String-type data) is stored.<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">222<\/span><\/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>Project Row in Database<\/strong> <span style=\"font-style:italic; color:#009900\">q_ProjectRow<\/span> <code>28<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the corresponding number of rows of related project information in Google Sheets.<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">4<\/span><\/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>Approver 1 Email Address<\/strong> <span style=\"font-style:italic; color:#009900\">q_Email1<\/span> <code>27<\/code>\n<ul class=\"wp-block-list\">\n<li>Contains the email address of the project leader who will approve the project.<\/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>Approver 2 Email Address<\/strong> <span style=\"font-style:italic; color:#009900\">q_Email2<\/span> <code>30<\/code>\n<ul class=\"wp-block-list\">\n<li>Contains the email address of the executive officer in charge of approving the project.<\/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:\/\/drive.google.com\/uc?id=18cA_smXyRaE3m6JR2fHfTUDJQqCrjZtA&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">approval-flow-20211025-en.qar<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/drive.google.com\/uc?id=13HKIARzcHuRiCG8pFbx9lBlnnJHuHhI1&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">approval-flow-20211025-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 icon, which is only available in the Professional 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>A Google Sheets list needs to be created beforehand to manage the relevant project and approver email addresses. At the very least, the control list should have columns for project ID, leader email address and executive email address. Set the properties of &#8220;x1-2. Identify relevant row in DB&#8221; and &#8220;x1-3. Get data from relevant row in DB&#8221; accordingly with that Google Sheet.<\/li>\n\n\n\n<li>You can also take the &#8216;Select Related Project&#8217; option from the Google Sheets list to avoid a divergence from the admin list. In this case, the project name column is also required in the control list. This can be achieved by preparing a separate workflow application using [<a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-getidslabels\/\" target=\"_blank\">Google Sheets: Download Choice Data<\/a>].<\/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\" loading=\"lazy\" decoding=\"async\" width=\"775\" height=\"630\" data-attachment-id=\"154191\" data-permalink=\"https:\/\/support.questetra.com\/en\/templates\/approval-flow-20211025\/attachment\/approval-flow-20211025-capture1-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/approval-flow-20211025-capture1-en.jpg?fit=916%2C745&amp;ssl=1\" data-orig-size=\"916,745\" 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=\"approval-flow-20211025-capture1-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/approval-flow-20211025-capture1-en.jpg?fit=775%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/approval-flow-20211025-capture1-en-775x630.jpg?resize=775%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-154191\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/approval-flow-20211025-capture1-en.jpg?resize=775%2C630&amp;ssl=1 775w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/approval-flow-20211025-capture1-en.jpg?resize=387%2C315&amp;ssl=1 387w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/approval-flow-20211025-capture1-en.jpg?resize=768%2C625&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/approval-flow-20211025-capture1-en.jpg?w=916&amp;ssl=1 916w\" sizes=\"auto, (max-width: 775px) 100vw, 775px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/approval-flow-20211025-capture2-en.png?ssl=1\" alt=\"\"\/><\/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=\"ZWMZOuD0pt\"><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-sheets-row-get\/\">Google Sheets: Get Row<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Google Sheets: Get Row&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/bpmn-icons\/service-task-google-sheets-row-get\/embed\/#?secret=MbqK2CmI2c#?secret=ZWMZOuD0pt\" data-secret=\"ZWMZOuD0pt\" 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=\"YEJ7mh8SrT\"><a href=\"https:\/\/support.questetra.com\/en\/templates\/approval-flow-budget-control-20160920\/\">Approval Flow-Budget Control<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Approval Flow-Budget Control&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/templates\/approval-flow-budget-control-20160920\/embed\/#?secret=Rp5SUlMain#?secret=YEJ7mh8SrT\" data-secret=\"YEJ7mh8SrT\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This approval flow determines approvers based on an externally managed list.<br \/>\nApprover information is obtained from an external list based on the project selected by the applicant and the approvers are determined.<br \/>\nThis makes it easy to deal with frequent changes in approvers.<\/p>\n","protected":false},"author":9,"featured_media":154189,"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":"{title}\n\n{excerpt}\n\n{url}","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,501,396,3162],"class_list":["post-154181","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-templates","tag-approval-flows","tag-budget-control","tag-google-sheets-api-v4","tag-google-workspace"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?fit=960%2C540&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?fit=960%2C540&ssl=1",960,540,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?fit=960%2C540&ssl=1",960,540,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?fit=960%2C540&ssl=1",960,540,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?fit=960%2C540&ssl=1",960,540,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=960%2C540&ssl=1",960,540,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=900%2C540&ssl=1",900,540,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=960%2C540&ssl=1",960,540,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=800%2C540&ssl=1",800,540,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=600%2C540&ssl=1",600,540,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=800%2C540&ssl=1",800,540,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=450%2C540&ssl=1",450,540,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=600%2C540&ssl=1",600,540,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/11\/eyecatch-approval-flow-20211025-2-en.png?fit=960%2C540&ssl=1",960,540,true]},"uagb_author_info":{"display_name":"Tsuyoshi Kusaka","author_link":"https:\/\/support.questetra.com\/en\/author\/kusaka0211\/"},"uagb_comment_info":0,"uagb_excerpt":"This approval flow determines approvers based on an externally managed list. Approver information is obtained from an external list based on the project selected by the applicant and the approvers are determined. This makes it easy to deal with frequent changes in approvers.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-E6N","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":79916,"url":"https:\/\/support.questetra.com\/en\/templates\/approval-request-flow-20160222\/","url_meta":{"origin":154181,"position":0},"title":"Approval Request Flow","author":"Hirotaka NISHI","date":"2021-03-11","format":false,"excerpt":"Records Processes beginning from the request for approval to the final approval. A director with approval authority can make a record of approval by simply processing the Step of [2x. Request from the Director] without going through the Steps of Submit and Approve. However, even the proposal was from a\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/eye-catch-approval-request-flow-20160222-220-14.2-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\/03\/eye-catch-approval-request-flow-20160222-220-14.2-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/eye-catch-approval-request-flow-20160222-220-14.2-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/eye-catch-approval-request-flow-20160222-220-14.2-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/eye-catch-approval-request-flow-20160222-220-14.2-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":77695,"url":"https:\/\/support.questetra.com\/en\/templates\/approval-flow-budget-control-20160920\/","url_meta":{"origin":154181,"position":1},"title":"Approval Flow-Budget Control","author":"Hirotaka NISHI","date":"2022-01-17","format":false,"excerpt":"A Proposal-approval flow that automatically records the approved spending in a Google Sheet. When a new Issue is entered at the [1. Submit plan draft] Step, the \u201cBudget Consumption Log\u201d (Google sheet) is referred to, and the total expenditure so far is calculated automatically. At the Step of [2. Decision],\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-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\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":74103,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/first-questetra-bpm-suite-step3\/","url_meta":{"origin":154181,"position":2},"title":"Your first step in Questetra BPM Suite \/ Chpt.3: Creating a Travel Request App","author":"Hirotaka NISHI","date":"2020-03-06","format":false,"excerpt":"This is the 3rd tutorial for beginners of Questetra BPM Suite. Through refinement of the Travel Request App created in Chapter 2, we will deal with somewhat advanced contents. I will describe the setting related to the data item and the method of automatically determining \"boss of the applicant\".","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\/2020\/03\/step3.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\/03\/step3.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/step3.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/step3.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/step3.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":74974,"url":"https:\/\/support.questetra.com\/en\/templates\/decision-making-request-flow-20160314\/","url_meta":{"origin":154181,"position":3},"title":"Decision-making Request Flow","author":"Hirotaka NISHI","date":"2021-01-14","format":false,"excerpt":"Realizes \"proxy approval\" by the deputy manager. That is, requests of less than 1 million yen proceed to [3a. Approval], and the deputy manager will also be able to give approval. Applications for between 1 to 5 million yen will be also accepted after 24 hours. Meanwhile, for applications over\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-decision-making-request-flow-20160314-209-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\/2019\/02\/eye-catch-decision-making-request-flow-20160314-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-decision-making-request-flow-20160314-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-decision-making-request-flow-20160314-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-decision-making-request-flow-20160314-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":75216,"url":"https:\/\/support.questetra.com\/en\/templates\/travel-request-flow-20160118\/","url_meta":{"origin":154181,"position":4},"title":"Travel Request Flow","author":"Hirotaka NISHI","date":"2021-04-08","format":false,"excerpt":"Allows multiple personnel to make an approval. By registering the deputy manager and assistant manager as \"leader of the department (supervisor)\", other than the department manager become able to undertake the Task of [2. Approval on Travel]. Incidentally, the Operation of [2. Approval on Travel] will be allocated to a\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-travel-request-flow-20160118-209-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\/2019\/02\/eye-catch-travel-request-flow-20160118-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-travel-request-flow-20160118-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-travel-request-flow-20160118-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-travel-request-flow-20160118-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84944,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/freee-questetra\/","url_meta":{"origin":154181,"position":5},"title":"API Settings Between the Accounting Software freee and Questetra","author":"Tsuyoshi Kusaka","date":"2020-03-05","format":false,"excerpt":"I summarized the methods of Questetra BPM Suite's connection with freee, an accounting software via REST API","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\/2020\/03\/freee-questetra.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\/03\/freee-questetra.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/freee-questetra.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/freee-questetra.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/freee-questetra.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/154181","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=154181"}],"version-history":[{"count":7,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/154181\/revisions"}],"predecessor-version":[{"id":154197,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/154181\/revisions\/154197"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/154189"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=154181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=154181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=154181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}