0

What I am aiming to do

I am organizing a big event with many invited friends. This big event is subdivided into smaller sub-events and I need to send out a questionnaire to know who wants to come to which sub-event (and where do they want to sleep) and then send an invoice for paying the amount corresponding to the sub-events they registered for.

My computer skills

I can code in Bash and in a series of other programming languages (C, C++, R, Python, Julia and Mathematica). I have some knowledge in HTML and CSS but know nothing about Javascript. Globally speaking, I know little about anything that involves the internet!

How I think about doing it

I am thinking about using a Google Form to record the answers. Then, I would have a Bash script that would:

  1. Download the answers every 3 minutes
  2. Check if there are new answers in the past 3 minutes
  3. Calculate their bill
  4. Send an email with a paypal invoice.

I am currently having issues with this last part (see this post), Google Form is not as flexible as I would like it to be and the whole process seems a little cumbersome to me.

Can you think of a better solution for someone like me who knows nothing about Javascript?

fixer1234
  • 28,064
Remi.b
  • 2,721
  • 4
  • 23
  • 30

1 Answers1

2
  1. Use curl to fetch Google Forms or skip this step and get them directly into Spreadsheet.
  2. Use watch command, cron task or while-loop to check new answers each 3 minutes.
  3. Calculate their bill in Spreadsheet (where the forms are populated) then fetch data via Sheets API (either using curl, PHP or googlecl-like command).
  4. Use PayPal Invoicing API to create invoices and send them. Check this for examples.

So no need for Javascript.

Community
  • 1
kenorb
  • 26,615