Linking Google Drive (Google Spreadsheet Form) and the HTTP start mechanism [Message Start Event (HTTP)] will automatically generate a workflow item that incorporates the content entered in the Google Form. For example, you will be able to start the "Payment confirmation and thank-you mail sending process" at the same time as accepting event participation.
1. Differences from Form Start
- 1. Utilization of the System Assets
- You can continue to use the existing Google Form
- 2. Differential Absorption of Necessary Items
- You can separate data receiving (Google) and data processing (Questetra)
- Send data to Questetra with the script functions (Google Apps Script) in the Google Form
- It is possible to convey to the Workflow only the data you need from the data that has been input
- Receive data with the performance (service level) of Google Form
2. Setting HTTP Start
- 1. Data Receiving Item
- Set the Data editing permission to Editable
- After releasing the App you will be able to see the Starting URL (request URL) and names of the parameters, etc. in URL/Parameter Details
BPMN Icons: Message Start Event (HTTP)
3. Setting Data Transmission
- 1. Setting at Google Form
- Configure data transmission script at Google Form (Example of Google Apps Script)
function startWorkflow(e) { try{ var longurl = "https://XXXXX.questetra.net/System/Event/MessageStart/XXXX/XX/start"; var payload = "key=XXXXX"; var itemResponses = e.response.getItemResponses(); payload += '&q_name=' + encodeURIComponent(itemResponses[0].getResponse()); payload += '&q_company=' + encodeURIComponent(itemResponses[1].getResponse()); payload += '&q_email=' + encodeURIComponent(itemResponses[2].getResponse()); payload += '&q_tel=' + encodeURIComponent(itemResponses[3].getResponse()); payload += '&q_inquiryDetail=' + encodeURIComponent(itemResponses[4].getResponse()); var params = { method: 'post', payload: payload }; UrlFetchApp.fetch(longurl, params); } catch (ex) { MailApp.sendEmail("XXXXX@example.com", "script error", ex.message); } }
Comments
0 comments
Please sign in to leave a comment.