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://karasuma-oike-000.questetra.net/System/Event/MessageStart/123/0/start"; var payload = "key=WWWWWWWW"; payload += '&title=' + encodeURIComponent(e.values[1]); payload += '&data[1].input=' + encodeURIComponent(e.values[2]); payload += '&data[2].input=' + encodeURIComponent(e.values[3]); payload += '&data[3].input=' + encodeURIComponent(e.values[6]); payload += '&data[5].input=' + encodeURIComponent(e.values[9]); var params = { method: 'post', payload: payload }; UrlFetchApp.fetch(longurl, params); } catch (ex) { MailApp.sendEmail("ichiro@example.com", "script error", ex.message); } }
Comments
0 comments
Please sign in to leave a comment.