Save form data in custom table.

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Save form data in custom table.

Bharamani
Hi Friends,

Currently, i am able to save data in default table like orbeon_form_data.

If I want to save the same info in my custom table.

How can we achieve this?
Thanks
Bharamani
Reply | Threaded
Open this post in threaded view
|

Re: Save form data in custom table.

Alessandro  Vernet
Administrator
Hi Bharamani,

You could use a database trigger to populate your table when the Orbeon Forms table is updated. There is a discussion of this, with an example for MySQL, towards the end of this page:

https://doc.orbeon.com/form-runner/overview/accessing-data.html

This being said, instead of saving the data in your own table, there might be other ways for you to achieve the requirement that calls for that table. For instance, you might be able to directly access the data in the Orbeon Forms table, or have Orbeon Forms send the data to a service you provide on form submission. There is a discussion of those techniques in the page linked earlier.

I hope this helps,

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: Save form data in custom table.

Bharamani
Hi,

Thanks for help.

Thanks
Bharamani