Save form data in custom table.

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?

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

Hi,

Thanks for help.