Re: Automatically submit form? (prefilled by URL)

Nathans · ‎Jan 14, 2020

Is it possible to automatically submit a form?
I’m creating a series of links that have the form input prefilled. Each can take me to the form with the info I want ready and waiting (which is terrific).
At that point I have to click Submit.
I’m using this for class attendance, so it’s a quick rundown of 25 entries at a time. It would be ideal to load the prefilled URL and have that submit automatically. Is that possible?

TIA,
Nathan

Nathans · ‎Jan 23, 2020

Still working on this, and I seem to have a new problem. Or maybe I’ve uncovered a problem that’s been there all along. I have links that submit to a Google form and that auto-submits (to Airtable via IFTTT). I still have to close each window, but that’s fine for now.

The problem is that the info I’m submitting isn’t connecting to the related record, it’s creating a new one. I’m not sure if it’s due to the form submission process, so I’m continuing in this thread rather than starting a new one.

Including a drawing to show the tables and relationships. I omitted fields that seem irrelevant.

What’s supposed to happen is the Check-Ins table has a new record added by the Google form via IFTTT. That works. But the new record in Check-Ins doesn’t associate with the existing Session, it creates a new record there, too. I thought it might be that the formatting of the date was somehow different coming in. But if I submit the form multiple times, they each create a new record in Sessions (it seems like they would at least have identical data in the linked field?!?).

I’m wide open to any suggestions. If there’s a better way to structure all this, that’s fine with me.

Bill_French · ‎Jan 23, 2020

Yep - it’s a kludge.

It’s common to see well-intended and seemingly simple processes get bogged down with code-free integration platforms.

This is the recipe in IFTTT making assumptions about the relationships and trying to maintain relational integrity.