{"id":78460,"date":"2020-04-23T16:01:00","date_gmt":"2020-04-23T07:01:00","guid":{"rendered":"https:\/\/support.questetra.com\/developer-blog\/choices-google-sheets\/"},"modified":"2026-06-22T17:09:30","modified_gmt":"2026-06-22T08:09:30","slug":"choices-google-sheets","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-google-sheets\/","title":{"rendered":"Utilize Customer Data on Google Sheets as Choices"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

A useful tool for managing data tables such as customer data is spreadsheet software. I’m sure that you have created a data table with spreadsheet software, as well. In this post, I will show you how to acquire the data on a Google Sheet with Questetra BPM Suite and create an “Options Master” based on it.<\/p>\n\n\n\n

By saving a list of choices as an “Options Master”, you can use it as master data for options in multiple choice Select-type Data Items. If you save the customer data as the “Options Master” for example, you can set the customer data as options for any Select-type data items.<\/p>\n\n\n

\nDuring configuration you will require System Administration authority. Make sure the account you create an App with has been granted System Administrator authorization.
\nFor the account you are using to log in you can confirm it at “Authorization” < “Account Settings.”
\n<\/div><\/div>\n\n\n\n

Spreadsheet to use<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

In this article, we will create an App using an example Google Sheet as shown above in which the unique IDs and customer names given to each customer are written. Please prepare a similar spreadsheet yourself.<\/p>\n\n\n\n

To create a workflow diagram<\/h2>\n\n\n\n

Now, let’s create an App to acquire data from Google Sheets and update\/generate the Options Master. Create a new App with the name “Google Sheet: Choice Acquisition Test.”<\/p>\n\n\n\n

After you launch the Modeler, let’s first create a Workflow diagram.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Name the first Human Task “Start”, and the second one “Check.”<\/p>\n\n\n\n

You can select “Google Sheet: Download Choices Data” and “Update Choices” from the Auto-Processing Task<\/strong> group.<\/p>\n\n\n\n

Data Items settings<\/h3>\n\n\n\n

Next, let’s prepare the data item to be used. In addition to the Title, there are three more Data Items needed.<\/p>\n\n\n\n

Data Item Name<\/th>Data-type<\/th><\/tr>
Customer ID<\/td>String-type multiple lines<\/td><\/tr>
Customer Name<\/td>String-type multiple lines<\/td><\/tr>
Master Data Check<\/td>Select-type Radio Button<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Regarding “Master Data Check”, you need further detail settings. Click on the [Edit] button to open the setting screen and change the Type of data source pulldown where [Fixed choice list] has been selected by default to [String type data item.]<\/strong> As dropdown menus are displayed to specify a String-type Data Item for Choice ID and Label, select “Customer ID” and “Customer Name”.<\/p>\n\n\n\n

Data on the Google Sheet is stored in the String-type Data Items of \u201cCustomer ID\u201d and \u201cCustomer Name\u201d one item per one row using [Google Sheet: Download Choices Data]. “Master Data Check” is a Select-type Data Item which combines these two strings.<\/p>\n\n\n\n

Settings in [Google Sheets: Download Choice Data]<\/h3>\n\n\n\n

We are going to continue configuring the settings in [Google Sheets: Download Choice Data] (hereinafter referred to as just Download Choice Data), which is an important object in this App.<\/p>\n\n\n\n

OAuth 2 setting<\/h4>\n\n\n\n

You need to set up OAuth 2 so that Questetra BPM Suite can retrieve data from the Google Sheet. Open the property screen of “Download Choices Data” then click on the button labeled as [OAuth2 Setting]<\/strong> beneath “C1: OAuth2 Setting Name.”<\/p>\n\n\n

\nThe “OAuth2 Setting” button cannot be clicked unless you are logged in to an account which is granted System Administrator authorization. This OAuth2 configuration will be shared by all Workflow Apps.
\n<\/div><\/div>\n\n\n\n

When you click on the button, the settings page will open in another tab. At first, the OAuth2 configuration list will be empty, so click on the [+ Add]<\/strong> button to create a new OAuth2 configuration. Give the configuration a proper name such as “Connect with {Google USER}”. After you have created a new configuration, click “Get token”<\/strong>. Clicking on the button will open a Google page. Sign in with an account that is able to browse the spreadsheet you are using, then allow Questetra BPM Suite to access it. Once this is done it will return to Questetra BPM Suite OAuth2 Settings page. Check if you’ve gotten a refresh token and if so, close the OAuth2 setting page.<\/p>\n\n\n\n

Go back to the Modeler and see the dropdown window of “C1: OAuth2 Setting Name” to find the configuration name you have created. Select the name and now you have completed the OAuth2 setting.<\/p>\n\n\n\n

ID of the spreadsheet<\/h4>\n\n\n\n

Concerning “C2: Source Spreadsheet ID”, enter the ID of the spreadsheet which contains the data to be retrieved. The ID of the spreadsheet is included in its URL like the following.<\/p>\n\n\n

\nhttps:\/\/docs.google.com\/spreadsheets\/d\/<\/a>SPREADSHEETID<\/strong>\/edit#gid=0
\n<\/div><\/div>\n\n\n\n

Title of the Sheet<\/h4>\n\n\n\n

Into the “C3: Source Sheet Title”, enter the title of the sheet that contains the data cells.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Range of Choice IDs and Choice Labels<\/h4>\n\n\n\n

Regarding “C4: Range of Choice IDs” and “C5: Range of Choice Labels”, enter the range of cells which contain Choice ID data and Choice Label data respectively.”<\/p>\n\n\n\n

\"\"
Confirm the cell range<\/figcaption><\/figure>\n\n\n\n
\"\"
Input the range to the Settings<\/figcaption><\/figure>\n\n\n\n

Save destination for Choice IDs\/Choice Labels<\/h4>\n\n\n\n

You must specify the save destination for the retrieved data. In this example, select “Customer ID”<\/strong> for “C6: STRING Data item that will save Choice IDs” and “Customer Name”<\/strong> for “C7: STRING Data item that will save Choice Labels.”<\/p>\n\n\n\n

Finally, turn on the “Token will move to Error Boundary Event when processing fails”<\/strong> toggle switch above item C1. The Task icon changes to display an Error Boundary Event, a pink circle. If the processing in the “Download Choice Data” event fails, the token moves to this event. Add another End Event and draw a flow as in the following figure.<\/p>\n\n\n\n

\"\"
Add End Event and draw a flow<\/figcaption><\/figure>\n\n\n\n

With this setting a Case can be ended without updating the Options Master if the processing failed such as when “Data could not be retrieved from the Google Sheet.”<\/p>\n\n\n\n

Settings in [Update Choices]<\/h3>\n\n\n\n

“Master file” is a type of add-on that can be used in an App, and can be referenced by Select-type Data Items in an App. If you register this “Master File” as “App Shared Add-on” in Questetra BPM Suite, the registered master data can be referenced from all the Apps. To create\/update a “Master file” [Update Choices] is used.<\/p>\n\n\n\n

\"\"
There are three items to set.<\/figcaption><\/figure>\n\n\n\n

User who updates choices<\/h4>\n\n\n\n

Click on the [Me]<\/strong> button to specify your own account. As it is noted on the screen, System Administrator authority is required for updating a Master file.<\/p>\n\n\n\n

Select-type data item whose choices will be saved as “App-shared Add-on”<\/h4>\n\n\n\n

Specify a Data Item to save as an “App-shared Add-on Master File”. Select “Master Data Check”<\/strong> which stores data that has been acquired from the Google Sheet.<\/p>\n\n\n\n

Name when saving as App-shared Add-on<\/h4>\n\n\n\n

Type “Customer List” to be the name of the Add-on.<\/p>\n\n\n\n

Data editing permission<\/h3>\n\n\n\n

Finally, set up the Data editing permissions. Configure the \u201cStart\u201d and \u201cCheck\u201d Tasks as shown in the following diagram.<\/p>\n\n\n\n

<\/td>Start<\/th>Check<\/th><\/tr>
Title<\/th><\/i><\/span> (Editable)<\/td><\/i><\/span> (Only display)<\/td><\/tr>
Customer ID<\/th><\/i><\/span> (No display)<\/td><\/i><\/span> (Only display)<\/td><\/tr>
Customer Name<\/th><\/i><\/span> (No display)<\/td><\/i><\/span> (Only display)<\/td><\/tr>
Master Data Check<\/th><\/i><\/span> (No display)<\/td><\/i><\/span> (No display)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Operation check<\/h2>\n\n\n\n

Now let’s save and release the App and check its actual operation.<\/p>\n\n\n\n

After you have completed the “Start” Task, a moment later you will be allocated the “Check” Task. Open the Task operating screen to see the displayed String type Data Items of “Customer ID” and “Customer Name” and confirm if data on the Google Sheet has been acquired. If it seems fine, finish the \u201cCheck\u201d Task and wait for the Case to be completed.<\/p>\n\n\n\n

You can check the saved “Options Master” in the “Master file of Select type data item” tab in “App-shared Add-on” < “App Settings.”<\/p>\n\n\n\n

\"\"
You can check the contents of the saved \u201cOptions Master\u201d by clicking on the magnifying glass icon<\/figcaption><\/figure>\n\n\n\n

If it does not work properly<\/h3>\n\n\n\n

If the “Check” Task was not allocated, confirm if the token has advanced to the “Error Boundary Event”. You can see the status of the Case in “Started Cases” in the Workflow page, etc.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If the token has reached the End Event via the “Error Boundary Event” instead of the “Check” Task, you must confirm what kind of error has occurred in the “Download Choices” Service Task. To check the log of Tasks that have been automatically processed enter “Administrator Mode”<\/strong> on the case details or Task details.<\/p>\n\n\n\n

\"\"
When “Administrator mode” is enabled, you can check the automatic processing log<\/figcaption><\/figure>\n\n\n\n

When you check the “Administrator Mode” box, automatically-processed items which were not displayed in the “Operation History” will now be displayed. Now the “Auto-Processing Log” of “Download Choices” can be viewed, so let’s see the error contents.<\/p>\n\n\n\n

\"\"
Mistyped in the sheet name as “Shet1”!<\/figcaption><\/figure>\n\n\n\n

In the message, it says \u201cUnable to parse range\u201d. In this example, an incorrect sheet name has been entered on purpose to cause an error. As a result, the data acquisition range could not be parsed, resulting in an error log. If the App does not work properly, please check the “Auto-Processing Log”.<\/p>\n\n\n\n

\n\n\n\n

Appendix: Setting of Select type Data Item using Options Master<\/h2>\n\n\n\n

Since we have created a choice master, we will briefly introduce an example of setting a select-type Data Item using the choice master. By setting the definition of choices to “Specify by App Shared Add-on”<\/strong> in the choice settings for the Select-type Data Item, the Options Master is read as the choices for that Select-type Data Item.<\/p>\n\n\n\n

\"\"
A simple App only to load the Options Master and to make a selection on the choices at the “Check Choices” Task<\/figcaption><\/figure>\n\n\n\n
\"\"
Click on [Edit] button on Select type Data Item and set as above<\/figcaption><\/figure>\n\n\n\n

For example, create a simple Workflow as shown above, and set the Select type Data Item which loads the Options Master of “Customer List” to be editable at the “Check Choices” Task.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

As a result, the “Customer List” is displayed as a Select type Data Item as in the above figure.<\/p>\n","protected":false},"excerpt":{"rendered":"

Get the Customer List stored in Google Sheet via API, and save\/use it as the Options Master.<\/p>\n","protected":false},"author":3,"featured_media":78039,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[296],"tags":[396,3162],"class_list":["post-78460","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-blog","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\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":8,"uagb_excerpt":"Get the Customer List stored in Google Sheet via API, and save\/use it as the Options Master.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-kpu","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":75420,"url":"https:\/\/support.questetra.com\/en\/templates\/customer-master-data-sync-process-20160719\/","url_meta":{"origin":78460,"position":0},"title":"Customer Master Data Sync Process","author":"Hirotaka NISHI","date":"2021-01-14","format":false,"excerpt":"Synchronizes \"Customer Master\" managed in Google Spreadsheet, automatically. Automatically Starts 1:00 every night, connects to Google spreadsheet API, and acquires \"Customer list\". The acquired customer list is reformatted and updated as \"Customer Master (Options XML)\" on the Workflow platform. It also corresponds to a manually starting by a person or\u2026","rel":"","context":"In "Workflow Apps"","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\/03\/eye-catch-customer-data-master-sync-process-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\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":72429,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/","url_meta":{"origin":78460,"position":1},"title":"Several Ways to Manage Master Data with Questetra","author":"Tsuyoshi Kusaka","date":"2017-09-19","format":false,"excerpt":"Hi there! The topic I am going to talk about this time is related with utilizing Questetra, as well as system collaboration. Management of master data associated with Questetra is one of the common agendas. There are cases where you prepare an approval flow when registering\/modifying\/deleting master data, which Questetra\u2026","rel":"","context":"In "Questetra Developers Blog"","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\/2017\/09\/master-data-management-1200x675-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\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76407,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-choices-update\/","url_meta":{"origin":78460,"position":2},"title":"Update Choices","author":"Hirotaka NISHI","date":"2022-01-13","format":false,"excerpt":"Registers\/updates the list of choices specified in a Select-type Data Item as both a Choice master (App-shared Add-on) commonly used in the workflow platform, but also an App-specific Choice master (Add-on). It needs to be set up by a User with App Administrator authority.","rel":"","context":"In "BPMN Icons"","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/bpmn-icon-service-task-update-choices-2024.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/bpmn-icon-service-task-update-choices-2024.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/bpmn-icon-service-task-update-choices-2024.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/bpmn-icon-service-task-update-choices-2024.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/bpmn-icon-service-task-update-choices-2024.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79731,"url":"https:\/\/support.questetra.com\/en\/data-items\/select-type\/","url_meta":{"origin":78460,"position":3},"title":"Select-Type","author":"Peter Glover","date":"2019-09-30","format":false,"excerpt":"Displays a list of options that can be selected by the person in charge of processing, and stores the selection results.","rel":"","context":"In "Data Items"","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.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\/09\/Select.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":119881,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/google-sheets-employee-master\/","url_meta":{"origin":78460,"position":4},"title":"Managing Employee Information in Google Spreadsheets with Workflow Apps","author":"Peter Glover","date":"2022-05-11","format":false,"excerpt":"Introducing an application to manipulate employee information managed in Google Spreadsheets from Questetra.","rel":"","context":"In "Questetra Developers Blog"","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\/2022\/03\/google-sheet-employee-master-fi-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\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":70597,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-salesforce\/","url_meta":{"origin":78460,"position":5},"title":"How to Use Customer Data in Salesforce as Options","author":"HatanakaAkihiro","date":"2018-08-16","format":false,"excerpt":"How to check details of selected customer data on Salesforce.","rel":"","context":"In "Questetra Developers Blog"","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\/2018\/08\/salesforce-choices-1200x675-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\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-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\/78460","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=78460"}],"version-history":[{"count":23,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/78460\/revisions"}],"predecessor-version":[{"id":187646,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/78460\/revisions\/187646"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/78039"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=78460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=78460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=78460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}