M222: Auto Start Triggered by Google Form Entry

 

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("[e-mail]", "script error", ex.message);
  }
}

---

X. Tutorial

• Starting a Process from Outside of Questetra BPM Suite