Using an external form that feeds into a table?

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
I'm wondering if it's possible to email out a link to a form (either a Quick Base form or a Google form, for instance) to someone who is not a user, they fill out the form and submit it, and it goes into a table...? The idea is for event registration - I email out a registration link, they register, and then their data shows up in my registrants table if that makes sense. OR some other way to automate this process. As it stands, we manually add event registrants. We send them a Google form and then we transfer the data into the table that tracks registrants. 
Photo of Suzanne Schaefer

Suzanne Schaefer

  • 150 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
1. I would consider using Zapier integration if you want to use Google Forms.
2. Another option can be to open the application to everyone on the internet, and publish that quickbase form where when people entered data, it would go directly into your quickbase table. Just be careful configuring the internet role to make sure they cannot see or do anything that they are not supposed to.
Photo of Braller

Braller

  • 90 Points 75 badge 2x thumb
We use the quickbase API for such purposes; for example you can write a form in HTML which sends its data to a script (written in node, python, php or otherwise) which then sends the data to your quickbase database using api_addrecord. For any programmer that's an easy and straightforward path. Give me a shout if you need a hand


(Edited)
Photo of Suzanne Schaefer

Suzanne Schaefer

  • 150 Points 100 badge 2x thumb
I don't think I understand this, and I'm not a programmer :/ I'm interest in learning how to do this if you think that's feasible...
Photo of G.Macri

G.Macri

  • 878 Points 500 badge 2x thumb
https://login.quickbase.com/db/6mztyxu8?act=DBPage&pagename=formWizard.html

You can use this wizard to build the html code for a form. It will ask you to sign in and select which fields you want to inlcude as part of the form