Mon. - Fri. 9 am - 5 pm Ask a Question
Remember me

Inserting data into customized/own table

6 years 6 months ago #1

  • Vuke's Avatar
  • Vuke
  • Posts: 4
Hi, I have forms working fine BUT I want to store form variables/data into my table which I have created. E.g. take names, surname into my table with fields 'Names' and 'Surnames' so to store my data.

I can see the form stores data in a default "sy0h9_baforms_submissions" table, how can I redirect/link input input to my own table ?. I want to be able to run reports and calculations from the database. :( :( :( :(

Vuke

6 years 6 months ago #2

  • Artem's Avatar
  • Artem
  • Posts: 11016
Hello,

To help you we need to know the table name and fields name which you want to connect between each other.
Also we need to know ID of Forms fields, from which you want to send info

Regards,

6 years 6 months ago #3

  • Vuke's Avatar
  • Vuke
  • Posts: 4
Hi, I have created a table called table_users with the fields below

user_id
user_name
user_passwd
user_group
user_email

It is taking input from a form with ID = 2

Thanks

6 years 6 months ago #4

  • Artem's Avatar
  • Artem
  • Posts: 11016
Okay, but we need little bit more information:

Here is the screen:



As you can see each filed of the form has unique ID, so you need to send us, something like

user_id = Form field ID 6
user_name = Form field ID 3
user_passwd = Form field ID 1
user_group = Form field ID 2
user_email = Form field ID 78

I hope it's can help :)

Regards,
Powered by Kunena Forum