Lectora®

send survey results to database

@mbuitenkamp-4316

September 5, 2021 12:00 AM

Hi,

I really hope someone can help me:

I have a survey with quite a number of variables that I want to send to a mySQL database.

All I can find is that I apparently need to use a custom script and use POST, but to me, that's hocus pocus.

Can anyone help me get all my variables into my database?

Here's a few of my variables:

var_Name

var_DOB

var_City

Thanks in advance x

Discussion (1)

@wheels September 17, 2021 12:00 AM

Hi @mbuitenkamp-4316

From the Lectora side it is pretty straight forward.

Here are two options:

Insert a form.

Insert a Lectora Form object from the Test undefined

The parameters consist of the parameter name expected on the server such as 'name' and then the value of your variable. The JavaScript name of the variable is your variable name var_Name prefixed with Var. The getValue function returns the current value to send to the server.

For the server side you might consider hiring a contractor on Upwork or a similar site.

Another option might be to sign up for Airtable and build your database, it's fairly simple point and click. Then after you have created it they give you an API that you could modify and call easily with the second method above (Run JavaScript).

Here is an example for posting data to Airtable, and I'm sure a little searching can find better ones. Use the getValue() method above to get the values from your variables..