Loading a Table from a Form

App Building
1

I have a form where the fields are named FirstInput, LastInput etc. and the Finish Button contains the code below. The error checker says it does not recognize "FirstInput". What am I doing wrong?

insert into Test01 (first, last, add1, city, prov, postal, country, emailaddress01) values (FirstInput, LastInput, AddressInput, CityInput, ProvStateinput, PostalInput, CountryInput,EmailInput)

Mike

2

Is this a direct query into the db?
The values should be in a format like {{FirstInput.value}}
Try that for all values you are inserting into the db

3

Scott:
Thank you so much for this. It worked perfectly.
Thanks again.
Mike