How to Efficiently Transfer User Survey Responses to an SQL Database? – Need Step-by-Step Workflow Insights

Need help APIs
1

Hello,

I’m working on an app where users can submit survey data, and I’d like to send this data to an external SQL database. I’ve set up the SQL database and connected it to Bubble using a SQL database connector plugin. However, I’m struggling with the configuration of the backend workflow that should handle this process.

Here’s what I’ve done so far:

  1. I’ve created a survey form in Bubble with all the necessary input fields.
  2. I’ve installed the SQL database connector plugin and configured it with the connection details of my SQL database.
  3. I’ve attempted to create a backend workflow that gets triggered upon the survey submission.

I’m stuck on the part where I need to define the parameters and write the SQL query within the backend workflow to send the data correctly to my SQL database. The goal is to have the survey data inserted into a specific table in my SQL database whenever a user submits the form.

Could someone guide me on:

  1. How to correctly define the parameters in the backend workflow that correspond to the survey fields?
  2. How to set up the SQL query within the workflow to insert the data into my database?
  3. Any best practices for error handling and security in this setup?

I would greatly appreciate any step-by-step guidance or resources you could share!

Thank you in advance!

2

FWIW, you don’t need a backend workflow to do this. Just kick off a front end workflow after the user submits the form (e.g. “When button is pressed”). Fill in the parameters to the SQL Connector query by sending the fields from the form (e.g. Input Name’s value).