{"id":147731,"date":"2023-07-04T17:10:06","date_gmt":"2023-07-04T08:10:06","guid":{"rendered":"https:\/\/support.questetra.com\/?p=147731"},"modified":"2026-06-03T13:55:50","modified_gmt":"2026-06-03T04:55:50","slug":"request-report-for-salesforce-opportunity-list-20220901","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/templates\/request-report-for-salesforce-opportunity-list-20220901\/","title":{"rendered":"Project Report Request 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\">Project Report Request App 20220901<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:8px;border-bottom-right-radius:8px\">This workflow instructs the sales representative to report on high-profile deals, automatically creating a weekly list of deals from Salesforce, narrowed down by expected completion date, accuracy, etc. Automatic reporting instructions are given to the sales representative for each item on the list.<\/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>Workers (Number of swimlanes: 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>Sales Manager<\/strong> <\/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>Sales Representative<\/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>Workflow (Complexity of workflow diagram: 23)<\/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-0. Manual Start<\/strong>\n<ul class=\"wp-block-list\">\n<li>The sales manager enters the filter conditions for Salesforce business meeting information. The filter conditions are [Specify the date of completion of the focused business meeting] and [Specify the certainty level].<\/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\">6<\/span><\/span><\/span><strong>1-2. Select Meetings Requiring Reports<\/strong>\n<ul class=\"wp-block-list\">\n<li>The sales manager indicates whether the business meeting needs to be reported or not. (List of noteworthy business meetings, reporting instructions column) Reporting instructions, not stated are treated as unnecessary.<\/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\">9<\/span><\/span><\/span><strong>2-1. Activity Report<\/strong>\n<ul class=\"wp-block-list\">\n<li>The sales representative will provide comments on the activities of the target project and other information.<\/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-2. Report Confirmation<\/strong>\n<ul class=\"wp-block-list\">\n<li>The sales manager notes the points made in response to the sales representative&#8217;s comments.<\/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\">0<\/span><\/span><\/span><strong>x1-1. Extraction of Business Meetings Requiring Attention<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform extracts records from Salesforce business meeting objects using filter conditions. It extracts negotiation records with a scheduled completion date later than the specified completion date and a certainty level higher than the specified certainty level.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fal fa-rectangle-landscape fa-lg\" style=\"color:#666666;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">12<\/span><\/span><\/span><strong>x1-2. Featured Project List Converted to TSV<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform converts and stores the list of noteworthy cases (table type) into a TSV list.<\/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\">27<\/span><\/span><\/span><strong>x1-3. Reported Cases Extracted<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform extracts and stores only the rows in the TSV list that are marked as &#8220;required&#8221; in the first column.<\/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>x1-4. Sort Columns<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform changes the order of the columns in the TSV list and stores them.<\/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\">24<\/span><\/span><\/span><strong>x1-5. Get TSV List Row Count<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform retrieves the number of rows in the TSV list.<\/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\">13<\/span><\/span><\/span><strong>x1-6. Request Activity Report<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform initiates the reporting process, line by line on the TSV list.<\/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\">23<\/span><\/span><\/span><strong>x2-1. Set Subject<\/strong>\n<ul class=\"wp-block-list\">\n<li>The workflow platform sets the subject line.<\/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\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"261\" data-attachment-id=\"147801\" data-permalink=\"https:\/\/support.questetra.com\/en\/templates\/request-report-for-salesforce-opportunity-list-20220901\/attachment\/request-report-for-salesforce-opportunity-list-20220901-diagram-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-diagram-en.jpg?fit=1264%2C322&amp;ssl=1\" data-orig-size=\"1264,322\" 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=\"request-report-for-salesforce-opportunity-list-20220901-diagram-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-diagram-en.jpg?fit=1024%2C261&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-diagram-en-1024x261.jpg?resize=1024%2C261&#038;ssl=1\" alt=\"\" class=\"wp-image-147801\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-diagram-en.jpg?resize=1024%2C261&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-diagram-en.jpg?resize=600%2C153&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-diagram-en.jpg?resize=768%2C196&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-diagram-en.jpg?w=1264&amp;ssl=1 1264w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/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>Merge Gateway (XOR)<\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/exclusive-gateway\/\">Exclusive Gateway\n(XOR)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/message-start-event-http\/\">Message Start Event (HTTP)<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/human-task\/\" target=\"_blank\">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\/addons\/salesforce-object-batchget-to-table-202208\/\">Salesforce: Object Records BatchGet to Table<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-table-to-tsv-string-2021\/\">Converter: Table to TSV-String<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-keywords-2023\/\">TSV String, Filter by Keywords<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-convert-2021\/\">TSV String, Convert<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/multiline-string-get-number-of-lines\/\">Multiline String, Get Number of Lines<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-kick-httpstartevent-by-tsv\/\">Questetra BPMS: Process, Kick HttpStartEvent by TSV<\/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 to be passed on (number of data items: 19)<\/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-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>\u25c6 Report List Creation<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>14<\/code> <\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-calendar-alt fa-lg\" style=\"color:#5FB404;\" title=\"Date (Y\/M\/D)\"><\/i><\/span><strong>Specify Completion Day<\/strong> <span style=\"font-style:italic; color:#009900\">q_active_opportunity_get_date<\/span> <code>0<\/code>\n<ul class=\"wp-block-list\">\n<li>The conditions for extracting negotiation records (expected completion date) and date are stored.<\/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-percent fa-lg\" style=\"color:#B45F04;\" title=\"Numeric\"><\/i><\/span><strong>Confirmation of Accuracy<\/strong> <span style=\"font-style:italic; color:#009900\">q_target_probability<\/span> <code>18<\/code>\n<ul class=\"wp-block-list\">\n<li>The negotiation record extraction conditions (certainty) and numerical values (%) are stored.<\/li>\n\n\n\n<li> <span style=\"color:#9DCCE0;\">20<\/span><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-table fa-lg\" style=\"color:#0404B4;\" title=\"Table\"><\/i><\/span><strong>List of Featured Projects<\/strong> <span style=\"font-style:italic; color:#009900\">q_active_opportunity_list<\/span> <code>1<\/code>\n<ul class=\"wp-block-list\">\n<li>Contains a list of records extracted from the Salesforce business meeting object.<\/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 Activity Report<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>13<\/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>Business Meeting Title<\/strong> <span style=\"font-style:italic; color:#009900\">q_opportunity_title<\/span> <code>12<\/code>\n<ul class=\"wp-block-list\">\n<li>The name of the meeting in the Salesforce record is stored.<\/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>Sales Representative<\/strong> <span style=\"font-style:italic; color:#009900\">q_opportunity_owner_quser<\/span> <code>4<\/code>\n<ul class=\"wp-block-list\">\n<li>The negotiation holder of the Salesforce negotiation record 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>Negotiated Amount<\/strong> <span style=\"font-style:italic; color:#009900\">q_opportunity_amount<\/span> <code>8<\/code>\n<ul class=\"wp-block-list\">\n<li>The amount of the Salesforce negotiation record 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>Type of Business Meeting<\/strong> <span style=\"font-style:italic; color:#009900\">q_opportunity_type<\/span> <code>6<\/code>\n<ul class=\"wp-block-list\">\n<li>The type of Salesforce negotiation record 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>Degree of Accuracy<\/strong> <span style=\"font-style:italic; color:#009900\">q_opportunity_probability<\/span> <code>7<\/code>\n<ul class=\"wp-block-list\">\n<li>The accuracy of the Salesforce negotiation record is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span class=\"fa-li\"><i class=\"fal fa-calendar-alt fa-lg\" style=\"color:#5FB404;\" title=\"Date (Y\/M\/D)\"><\/i><\/span><strong>Expected Completion Date<\/strong> <span style=\"font-style:italic; color:#009900\">q_opportunity_close_date<\/span> <code>9<\/code>\n<ul class=\"wp-block-list\">\n<li>The expected completion date of the Salesforce negotiation record 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 multiple lines)\"><\/i><\/span><strong>Sales Person&#8217;s Comments<\/strong> <span style=\"font-style:italic; color:#009900\">q_sales_person_comment<\/span> <code>16<\/code><span style=\"color:#990000;\">*<\/span>\n<ul class=\"wp-block-list\">\n<li>Current and future activity status comments 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>Director&#8217;s Comments<\/strong> <span style=\"font-style:italic; color:#009900\">q_sales_management_comment<\/span> <code>17<\/code>\n<ul class=\"wp-block-list\">\n<li>Comments on the sales manager&#8217;s report 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>\u25c6 System Information<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>15<\/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>Salesforce Opportunity ID<\/strong> <span style=\"font-style:italic; color:#009900\">q_opportunity_Id<\/span> <code>10<\/code>\n<ul class=\"wp-block-list\">\n<li>The ID of the Salesforce negotiation record 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>Start Case Line Number<\/strong> <span style=\"font-style:italic; color:#009900\">q_start_line_number<\/span> <code>11<\/code>\n<ul class=\"wp-block-list\">\n<li>Start Processed TSV list line number is 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-percent fa-lg\" style=\"color:#B45F04;\" title=\"Numeric\"><\/i><\/span> <strong>Record Count<\/strong> <span style=\"font-style:italic; color:#009900\">q_record_count<\/span> <code>2<\/code> <\/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>Filtered Record Count<\/strong> <span style=\"font-style:italic; color:#009900\">q_filtered_record_count<\/span> <code>19<\/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>Featured Project: TSV List<\/strong> <span style=\"font-style:italic; color:#009900\">q_active_opportunity_tsv_list<\/span> <code>3<\/code>\n<ul class=\"wp-block-list\">\n<li>Report required Item TSV list 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\/m98-Project_Report_Request_App.qar\">Project_Report_Request_App.qar<\/a> (Latest)<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/uc?id=1ku8RjPLl-SM1TMoZ5O70N2NNJPy06YUY&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">request-report-for-salesforce-opportunity-list-20220901-en.qar<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/drive.google.com\/uc?id=1LS75QZZ1YkxSF9l5K87ouI4yFPO7eKvA&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">request-report-for-salesforce-opportunity-list-20220901-en.csv<\/a> (for importing data item definitions)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"><i class=\"fal fa-info-circle\"><\/i> This archive contains the BPMN icons that are 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>Associate the processor settings with the organisational structure on import<\/li>\n\n\n\n<li>&#8220;1-2. Select Meetings Requiring Reports&#8221; process\n<ul class=\"wp-block-list\">\n<li>Select the case that needs to be reported. Select &#8220;Required&#8221; in the reporting instructions in the list of noteworthy cases.<\/li>\n\n\n\n<li>If &#8220;Reporting instructions&#8221; is not selected, it is treated as required.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>&#8220;x1-6. Request Activity Report&#8221; Automated process\n<ul class=\"wp-block-list\">\n<li>Start the reporting process (app included) for the line with the data item &#8220;Featured Project: TSV List&#8221;.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-wrench\"><\/i> Arrangement Tips<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&#8220;x1-1. Extraction of Business Meetings Requiring Attention&#8221; Automatic process\n<ul class=\"wp-block-list\">\n<li>(C:) You can set the extraction conditions in the settings.\n<ul class=\"wp-block-list\">\n<li>E.g.: <em>SELECT id ,name,owner.Name,owner.Email,ownerid,Probability,Type,Amount,CloseDate from Opportunity where CloseDate &gt; #{#q_active_opportunity_get_date} and Probability &gt;= #{#q_target_probability}<\/em>\n<ul class=\"wp-block-list\">\n<li>Extracted from records in the Salesforce Commerce object<\/li>\n\n\n\n<li>(Salesforce) API data item name CloseDate [expected completion date] is after (Questetra) data item &#8220;Expected Completion Date&#8221;.<\/li>\n\n\n\n<li>The Salesforce API Data item name &#8220;Probability&#8221; is greater than or equal to the Questetra Data item &#8220;Degree of Accuracy&#8221;.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"540\" data-attachment-id=\"147813\" data-permalink=\"https:\/\/support.questetra.com\/en\/templates\/request-report-for-salesforce-opportunity-list-20220901\/attachment\/request-report-for-salesforce-opportunity-list-20220901-img1-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-img1-en.png?fit=960%2C540&amp;ssl=1\" data-orig-size=\"960,540\" 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=\"request-report-for-salesforce-opportunity-list-20220901-img1-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-img1-en.png?fit=960%2C540&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-img1-en.png?resize=960%2C540&#038;ssl=1\" alt=\"\" class=\"wp-image-147813\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-img1-en.png?w=960&amp;ssl=1 960w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-img1-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/request-report-for-salesforce-opportunity-list-20220901-img1-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/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 rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360052780932-Settings-Required-When-Importing-an-Archive\" target=\"_blank\">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=\"ahTowVJSwR\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/salesforce-object-batchget-to-table-202208\/\">Salesforce: \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30ec\u30b3\u30fc\u30c9\u62bd\u51fa\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u683c\u7d0d<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cSalesforce: \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30ec\u30b3\u30fc\u30c9\u62bd\u51fa\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u683c\u7d0d\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/ja\/addons\/salesforce-object-batchget-to-table-202208\/embed\/#?secret=ti01ohnWU8#?secret=ahTowVJSwR\" data-secret=\"ahTowVJSwR\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This workflow instructs the sales representative to report on high-profile deals, automatically creating a weekly list of deals from Salesforce, narrowed down by expected completion date, accuracy, etc. Automatic reporting instructions are given to the sales representative for each item on the list.<\/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":[494,345,409],"class_list":["post-147731","post","type-post","status-publish","format-standard","hentry","category-templates","tag-routine-report","tag-salesforce","tag-salesforce-api"],"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":4,"uagb_excerpt":"This workflow instructs the sales representative to report on high-profile deals, automatically creating a weekly list of deals from Salesforce, narrowed down by expected completion date, accuracy, etc. Automatic reporting instructions are given to the sales representative for each item on the list.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-CqL","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":163986,"url":"https:\/\/support.questetra.com\/en\/templates\/update-insert-salesforce-customer-object-20211102\/","url_meta":{"origin":147731,"position":0},"title":"Add\/Update Salesforce Account Object","author":"furuzo","date":"2024-07-30","format":false,"excerpt":"This workflow is for adding and updating a Salesforce trading partner record. In the case of a new registration, the supplier record is added to the supplier object. If the registration information is changed, the supplier record is updated. It is assumed that this workflow is automatically started when 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\/2024\/07\/eyecatch-update-insert-salesforce-customer-object-20211102-en.png?fit=960%2C540&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/07\/eyecatch-update-insert-salesforce-customer-object-20211102-en.png?fit=960%2C540&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/07\/eyecatch-update-insert-salesforce-customer-object-20211102-en.png?fit=960%2C540&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/07\/eyecatch-update-insert-salesforce-customer-object-20211102-en.png?fit=960%2C540&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":166268,"url":"https:\/\/support.questetra.com\/en\/templates\/auto-update-customer-master-20211031\/","url_meta":{"origin":147731,"position":1},"title":"Automatic Update Salesforce Customer Master","author":"furuzo","date":"2024-09-24","format":false,"excerpt":"This workflow automatically imports Salesforce Account objects into the Account Choice Master. It starts automatically every day at 7:00 AM. Salesforce Account objects are added, changed, and deleted through various workflows and direct input from Salesforce. As of 7:00 AM every day, the latest Account information is used as choice\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\/2024\/09\/eyecatch-eyecatch-auto-update-customer-master-20211031-en2.png?fit=960%2C540&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/09\/eyecatch-eyecatch-auto-update-customer-master-20211031-en2.png?fit=960%2C540&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/09\/eyecatch-eyecatch-auto-update-customer-master-20211031-en2.png?fit=960%2C540&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/09\/eyecatch-eyecatch-auto-update-customer-master-20211031-en2.png?fit=960%2C540&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":151437,"url":"https:\/\/support.questetra.com\/en\/templates\/meeting-report-process\/","url_meta":{"origin":147731,"position":2},"title":"Meeting Report App","author":"Tsuyoshi Kusaka","date":"2023-09-21","format":false,"excerpt":"This is the process by which sales representatives record and share the results of meetings with customers. The sales representative registers the appointment in advance and enters the results after the meeting has taken place. After inputting the results, the results of the meeting are automatically shared with the relevant\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\/2023\/09\/meeting-report-20230915-capture-en.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/09\/meeting-report-20230915-capture-en.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/09\/meeting-report-20230915-capture-en.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/09\/meeting-report-20230915-capture-en.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":112377,"url":"https:\/\/support.questetra.com\/en\/templates\/salesforce-cooperation-20210824\/","url_meta":{"origin":147731,"position":3},"title":"Salesforce Cooperation App","author":"furuzo","date":"2021-09-01","format":false,"excerpt":"It accesses various objects stored in Salesforce. Either of search by query\/append records\/update record is done by specifying an access method. It can be initiated by Register\/Retrieve clients or Register\/Retrieve negotiations workflows. It is possible to return the retrieved data to the initiated workflow by specifying the access method to\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\/09\/eye-catch-salesforce-cooperation-20210831-en-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\/2021\/09\/eye-catch-salesforce-cooperation-20210831-en-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/eye-catch-salesforce-cooperation-20210831-en-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/eye-catch-salesforce-cooperation-20210831-en-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/eye-catch-salesforce-cooperation-20210831-en-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76641,"url":"https:\/\/support.questetra.com\/en\/templates\/human-multitasking-workflow-20180101\/","url_meta":{"origin":147731,"position":4},"title":"Human Multitasking Workflow","author":"IMAMURA, Genichi","date":"2021-02-15","format":false,"excerpt":"Cleaning work and cleaning inspection work are carried out. If there is a work in [2. Clean up] or [3. Inspect room], a person who can deal with it will respond. While \"waiting time\" was allowed under the division of labor system, productivity improvement is achieved through multifunctionalization of employees.","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\/01\/eye-catch-human-multitasking-workflow-20180101-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\/01\/eye-catch-human-multitasking-workflow-20180101-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/eye-catch-human-multitasking-workflow-20180101-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/eye-catch-human-multitasking-workflow-20180101-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/eye-catch-human-multitasking-workflow-20180101-220-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":157809,"url":"https:\/\/support.questetra.com\/en\/templates\/subscription-continuation-management-20240126\/","url_meta":{"origin":147731,"position":5},"title":"Subscription Renewal Management","author":"furuzo","date":"2024-02-08","format":false,"excerpt":"This order process manages the automatic renewal of monthly contracts. On the 20th of each month, customers are automatically notified by email of their renewal confirmation. Sales representatives report their intention to cancel to the Administration Department by the 25th of the month. If no report is received, the contract\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\/2024\/02\/eyecatch-subscription-continuation-management-20240126-en.png?fit=960%2C540&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/02\/eyecatch-subscription-continuation-management-20240126-en.png?fit=960%2C540&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/02\/eyecatch-subscription-continuation-management-20240126-en.png?fit=960%2C540&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/02\/eyecatch-subscription-continuation-management-20240126-en.png?fit=960%2C540&ssl=1&resize=700%2C400 2x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/147731","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=147731"}],"version-history":[{"count":25,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/147731\/revisions"}],"predecessor-version":[{"id":186170,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/147731\/revisions\/186170"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=147731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=147731"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=147731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}