{"id":160859,"date":"2024-04-30T17:39:09","date_gmt":"2024-04-30T08:39:09","guid":{"rendered":"https:\/\/support.questetra.com\/?p=160859"},"modified":"2026-06-11T12:35:50","modified_gmt":"2026-06-11T03:35:50","slug":"attendance-reporting-20211006","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/templates\/attendance-reporting-20211006\/","title":{"rendered":"Attendance Reporting App, Automatic Overtime Calculation"},"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\">Attendance Reporting App, Automatic Overtime Calculation 20211006<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:8px;border-bottom-right-radius:8px\">At 7 o&#8217;clock every day, the request for arrival and departure times will be automatically added to &#8220;My Tasks&#8221; (however, company holidays will not be added). Applicant enters work time, clock out time, and break time (h). Working hours (h), overtime hours outside legal hours (h), etc. will be automatically calculated, and a copy will be sent to the applicant by email.<\/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: 2)<\/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>All Employees<\/strong>\n<ul class=\"wp-block-list\">\n<li>Person applying for attendance report. All employees.<\/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>Applicant&#8217;s Supervisor<\/strong>\n<ul class=\"wp-block-list\">\n<li>The applicant&#8217;s supervisor. We guarantee that there are no falsehoods in the application contents. (If the head of the department applies, the supervisor step will be skipped.)<\/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: 20)<\/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\">3<\/span><\/span><\/span><strong>1. Register arrival and departure times<\/strong>\n<ul class=\"wp-block-list\">\n<li>Applicants report work time, clock out time, and break time (h).<\/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\">12<\/span><\/span><\/span><strong>2. Check (auto complete)<\/strong>\n<ul class=\"wp-block-list\">\n<li>Your supervisor will confirm that there are no falsehoods in your application.<\/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\">1<\/span><\/span><\/span><strong>Add names of public holidays<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform sets holiday names such as &#8220;Saturday&#8221;, &#8220;Sunday&#8221;, and &#8220;Coming of Age Day&#8221;.<\/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>Assemble a copy of the email<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform assembles the HTML for notification emails. Insert data such as legal working hours (h) and non-legal working hours (h).<\/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\">5<\/span><\/span><\/span><strong>Legal working hours calculation<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform deducts the break total (h) from the legal limit (h).<\/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>Non-statutory working hours calculation<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform sets \u201cLegal (h)-8\u201d for Non-legal (h) and \u201c8\u201d for Legal (h).<\/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>Working time calculation (clocking out &#8211; clocking in)<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform calculates the elapsed time (h) from the clock-in time to the clock-out time.<\/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: 12)<\/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-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box single line)\"><\/i><\/span><strong>Working Day<\/strong><span style=\"font-style:italic; color:#009900\">q_Date<\/span><code>0<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the attendance days that are subject to the application.<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">#{#format(processInstanceStartDatetime, &#8216;yyyy-MM-dd (E)&#8217;)}<\/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>Holidays<\/strong><span style=\"font-style:italic; color:#009900\">q_Holiday<\/span><code>1<\/code>\n<ul class=\"wp-block-list\">\n<li>If the working day is a Saturday, Sunday, or holiday, the name will be stored.<\/li>\n<\/ul>\n<\/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>Department<\/strong><span style=\"font-style:italic; color:#009900\">q_Div<\/span><code>2<\/code>\n<ul class=\"wp-block-list\">\n<li>Stores the department to which the applicant belongs. (&#8220;Organization&#8221; within the workflow platform)<\/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>Employee<\/strong><span style=\"font-style:italic; color:#009900\">q_Worker<\/span><code>3<\/code>\n<ul class=\"wp-block-list\">\n<li>The applicant is stored. (&#8220;User&#8221; within 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>Work Start Time<\/strong><span style=\"font-style:italic; color:#009900\">q_Attending<\/span><code>4<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li>The time when you started work 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>Work End Time<\/strong><span style=\"font-style:italic; color:#009900\">q_Leaving<\/span><code>5<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li>The time you left work 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>Break Timer (h)<\/strong><span style=\"font-style:italic; color:#009900\">q_Break<\/span><code>6<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li>The total break time (including midday break, etc.) is stored.<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">1.00<\/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 multiple lines)\"><\/i><\/span><strong>Applicant Memo<\/strong><span style=\"font-style:italic; color:#009900\">q_Member_Note<\/span><code>7<\/code>\n<ul class=\"wp-block-list\">\n<li>Contains notes written by the applicant.<\/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>Within Legal Limits (h)<\/strong><span style=\"font-style:italic; color:#009900\">q_Legal<\/span><code>8<\/code>\n<ul class=\"wp-block-list\">\n<li>Legal working hours are 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>Non-statutory (h)<\/strong><span style=\"font-style:italic; color:#009900\">q_Overtime<\/span><code>9<\/code>\n<ul class=\"wp-block-list\">\n<li>Non-statutory working hours are stored.<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">0<\/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 multiple lines)\"><\/i><\/span><strong>Supervisor Memo<\/strong><span style=\"font-style:italic; color:#009900\">q_Leader_Note<\/span><code>10<\/code>\n<ul class=\"wp-block-list\">\n<li>Contains notes from the applicant&#8217;s supervisor.<\/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>(HTML for Email)<\/strong><span style=\"font-style:italic; color:#009900\">q_HTML_for_Email<\/span><code>11<\/code>\n<ul class=\"wp-block-list\">\n<li>The body of the notification email (HTML format) is stored.<\/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\/m89-Attendance_Reporting_App__Automatic_Overtime_Calculation.qar\">Attendance_Reporting_App__Automatic_Overtime_Calculation.qar<\/a> (Latest)<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/uc?id=1lVa9H_9J_lc76HzPaol-FqUALryGPIPV&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">attendance-reporting-20220327-en.qar<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/drive.google.com\/uc?id=1xZS7Lnvhbowq5eww_xX096GRprix5sgG&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">attendance-reporting-20220327-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-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/attendance-reporting-20211006-diagram-en.jpg?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/04\/attendance-reporting-20211006-diagram-en.jpg?ssl=1\" alt=\"At 7 o'clock every day, the request for arrival and departure times will be automatically added to \" class=\"wp-image-114924\"\/><\/a><\/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=\"VMnQBjgcsd\"><a href=\"https:\/\/support.questetra.com\/en\/templates\/weekly-reporting-forced-termination-20210929\/\">\u9031\u6b21\u5831\u544a\u30a2\u30d7\u30ea, \u5f37\u5236\u63d0\u51fa<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201c\u9031\u6b21\u5831\u544a\u30a2\u30d7\u30ea, \u5f37\u5236\u63d0\u51fa\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/ja\/templates\/weekly-reporting-forced-termination-20210929\/embed\/#?secret=AnBaHDZ8KA#?secret=VMnQBjgcsd\" data-secret=\"VMnQBjgcsd\" 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=\"xd3ELBs4Ze\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/date-determine-whether-business-day-2021\/\">#\u65e5\u4ed8: \u55b6\u696d\u65e5\u306e\u5224\u5b9a<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201c#\u65e5\u4ed8: \u55b6\u696d\u65e5\u306e\u5224\u5b9a\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/ja\/addons\/date-determine-whether-business-day-2021\/embed\/#?secret=8TIdH7XtpM#?secret=xd3ELBs4Ze\" data-secret=\"xd3ELBs4Ze\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>At 7 o&#8217;clock every day, the request for arrival and departure times will be automatically added to &#8220;My Tasks&#8221; (however, company holidays will not be added). Applicant enters work time, clock out time, and break time (h). Working hours (h), overtime hours outside legal hours (h), etc. will be automatically calculated, and a copy will be sent to the applicant by email.<\/p>\n","protected":false},"author":2,"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":"{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":[492],"class_list":["post-160859","post","type-post","status-publish","format-standard","hentry","category-templates","tag-attendance-mgmt"],"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":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":1,"uagb_excerpt":"At 7 o'clock every day, the request for arrival and departure times will be automatically added to \"My Tasks\" (however, company holidays will not be added). Applicant enters work time, clock out time, and break time (h). Working hours (h), overtime hours outside legal hours (h), etc. will be automatically calculated, and a copy will&hellip;","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-FQv","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":160859,"position":0},"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":96514,"url":"https:\/\/support.questetra.com\/ja\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":160859,"position":1},"title":"\u5358\u4e00\u884cTSV\u6587\u5b57\u5217, \u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"\u6307\u5b9aID\u306e\u30bb\u30eb\u5024\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002ID\u306f\u30bc\u30ed\u304b\u3089\u59cb\u307e\u308a\u307e\u3059\u3002\u62bd\u51fa\u3057\u305f\u30bb\u30eb\u6587\u5b57\u5217\u306f\u3001\u6587\u5b57\u5217\u578b\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u683c\u7d0d\u3067\u304d\u307e\u3059\u3002\u6570\u5024\u578b\u3001\u65e5\u4ed8\u578b\u3001\u65e5\u6642\u578b\u3001\u5358\u4e00\u9078\u629e\u578b\u3001\u30e6\u30fc\u30b6\u578b\u3001\u7d44\u7e54\u578b\u306e\u5404\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u578b\u5909\u63db\u3057\u3066\u683c\u7d0d\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":"\u5358\u4e00\u884cTSV\u6587\u5b57\u5217, \u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-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\/Singleline-TSV-String-Extract-Cell-ja.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-ja.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-ja.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-ja.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":160859,"position":2},"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":87631,"url":"https:\/\/support.questetra.com\/ja\/addons\/two-datetimes-calculate-duration\/","url_meta":{"origin":160859,"position":3},"title":"2\u3064\u306e\u65e5\u6642, \u7d4c\u904e\u6642\u9593\u306e\u8a08\u7b97","author":"IMAMURA, Genichi","date":"2020-04-23","format":false,"excerpt":"\u65e5\u6642A\u304b\u3089\u65e5\u6642B\u307e\u3067\u306e\u7d4c\u904e\u6642\u9593\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002\u6570\u5024\uff08days\uff09\u30fb\u6570\u5024\uff08hours\uff09\u30fb\u6570\u5024\uff08minutes\uff09\u30fb\u6587\u5b57\u5217\uff08h:mm\uff09\u306e\u3044\u305a\u308c\u304b\u3082\u3057\u304f\u306f\u8907\u6570\u3092\u51fa\u529b\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002B\u304c\u904e\u53bb\u6642\u523b\u3067\u3042\u3063\u305f\u5834\u5408\u306f\u30de\u30a4\u30ca\u30b9\u7b26\u53f7\u304c\u4ed8\u4e0e\u3055\u308c\u307e\u3059\u3002AB\u306b\u306f\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\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":"2\u3064\u306e\u65e5\u6642, \u7d4c\u904e\u6642\u9593\u306e\u8a08\u7b97","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-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\/04\/Two-Datetimes-Calculate-Duration-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Two-Datetimes-Calculate-Duration-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":160859,"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":93657,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/choices-aws-lambda-kintone\/","url_meta":{"origin":160859,"position":5},"title":"kintone \u30a2\u30d7\u30ea\u3092\u5916\u90e8\u30de\u30b9\u30bf\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b","author":"Shiho Tatsumi","date":"2020-08-20","format":false,"excerpt":"kintone \u30a2\u30d7\u30ea\u3067\u7ba1\u7406\u3057\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001Questetra BPM Suite \u306e\u300c\u691c\u7d22\u30bb\u30ec\u30af\u30c8\u30dc\u30c3\u30af\u30b9\u300d\u306e\u5916\u90e8\u30de\u30b9\u30bf\u3068\u3057\u3066\u4f7f\u7528\u3057\u307e\u3059\u3002\u4e2d\u7d99\u3059\u308b AWS \u30ea\u30bd\u30fc\u30b9\u306e\u4f5c\u6210\u306b Terraform \u3092\u4f7f\u7528\u3057\u307e\u3059\u3002","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\/08\/Kintone-as-Master-1.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\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.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\/160859","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=160859"}],"version-history":[{"count":7,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/160859\/revisions"}],"predecessor-version":[{"id":187156,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/160859\/revisions\/187156"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=160859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=160859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=160859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}