USK Piesendorf
Member
Hello everybody,
I've been struggling a lot recently to create a functioning workflow regarding Payable Forms.
Here's the deal:
I am in the middle of organizing an event and I therefore want to sell the tickets online in advance. I have set up a Google Form and linked it to the add-on Payable Forms.
What I try to achieve:
I want customers to fill out the Google Form and get redirected to Payable Forms in order to complete the purchase of the ticket. Once the purchase is successful, the ticket for the event should be sent to the customer in form of a PDF Google Doc via Gmail.
The Workflow:
So far I've set up the following workflow in a nutshell:
1. Google Sheets - New or Updated Spreadsheet Row (THIS IS THE GOOGLE SHEET CONNECTED TO GOOGLE FORMS)
2. Google Docs - Create Document from Template (THIS IS THE TICKET TEMPLATE WHICH WILL BE ADAPTED TO THE DATA FROM THE CUSTOMER)
3. Google Drive - Share a File with Anyone (THIS IS THE ADAPTED TICKET WHICH SHOULD BE SENT TO THE CUSTOMER)
4. Gmail - Send Email (THIS IS THE EMAIL THE CUSTOMER RECEIVES WITH THE LINK TO DOWNLOAD THE TICKET)
What I can't work out is:
The problems I have are rather small in my opinion, but detrimental.
The Data will be implemented from Google Forms into the Spreadsheet at the same time the Google Form is submitted, whether a purchase was completed or not.
When the purchase is completed, the purchase-related data will be filled into the Spreadsheet later than the data on Google Form submission.
The Webhook I used in Google Sheets has the Trigger Column M, which would be the Payable Transaction ID. However, even if this column is empty, the workflow sends a mail with the ticket to the given e-mail adress. (NO PAYMENT WOULD MEAN NO TICKET - THE WORKFLOW DOES THE OPPOSITE)
What I want to know:
How can I adapt my workflow so it solves the problem I have?
Is it even possible?
ACKNOWLEDGEMENT
I WOULD REALLY APPRECCIATE EVERY HELP I CAN GET AND I WOULD LIKE TO TAKE THIS CHANCE TO THANK YOU IN ADVANCE FOR HELPING ME!
I SINCERELY HOPE I COULD EXPRESS THE PROBLEM I HAVE THE BEST WAY POSSIBLE!
I've been struggling a lot recently to create a functioning workflow regarding Payable Forms.
Here's the deal:
I am in the middle of organizing an event and I therefore want to sell the tickets online in advance. I have set up a Google Form and linked it to the add-on Payable Forms.
What I try to achieve:
I want customers to fill out the Google Form and get redirected to Payable Forms in order to complete the purchase of the ticket. Once the purchase is successful, the ticket for the event should be sent to the customer in form of a PDF Google Doc via Gmail.
The Workflow:
So far I've set up the following workflow in a nutshell:
1. Google Sheets - New or Updated Spreadsheet Row (THIS IS THE GOOGLE SHEET CONNECTED TO GOOGLE FORMS)
2. Google Docs - Create Document from Template (THIS IS THE TICKET TEMPLATE WHICH WILL BE ADAPTED TO THE DATA FROM THE CUSTOMER)
3. Google Drive - Share a File with Anyone (THIS IS THE ADAPTED TICKET WHICH SHOULD BE SENT TO THE CUSTOMER)
4. Gmail - Send Email (THIS IS THE EMAIL THE CUSTOMER RECEIVES WITH THE LINK TO DOWNLOAD THE TICKET)
What I can't work out is:
The problems I have are rather small in my opinion, but detrimental.
The Data will be implemented from Google Forms into the Spreadsheet at the same time the Google Form is submitted, whether a purchase was completed or not.
When the purchase is completed, the purchase-related data will be filled into the Spreadsheet later than the data on Google Form submission.
The Webhook I used in Google Sheets has the Trigger Column M, which would be the Payable Transaction ID. However, even if this column is empty, the workflow sends a mail with the ticket to the given e-mail adress. (NO PAYMENT WOULD MEAN NO TICKET - THE WORKFLOW DOES THE OPPOSITE)
What I want to know:
How can I adapt my workflow so it solves the problem I have?
Is it even possible?
ACKNOWLEDGEMENT
I WOULD REALLY APPRECCIATE EVERY HELP I CAN GET AND I WOULD LIKE TO TAKE THIS CHANCE TO THANK YOU IN ADVANCE FOR HELPING ME!
I SINCERELY HOPE I COULD EXPRESS THE PROBLEM I HAVE THE BEST WAY POSSIBLE!
