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 Email Sending App" 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);
}
}