How to get data from formtools

[heinzelrumpel]

Hi,

I discovered foormtools whilst searching for an opportunity to create a database. On the formtools homepage I found a demo of somebody having created a movie search webpage with formtools. This is exactly what I needed, so I installed formtools and created my first form. This is pretty easy. But now I am stuck. I would like to get the data somewhere presented on a webpage, which the forms stored in mysql database. I have no clue how tho achieve this with formtools. All I pretty much need is a page, where I can fill in some search criteria and a button which will retrieve the answers.

Who can help m out with this? Thanks

[benkeen]

Hey @heinzelrumpel, hmm which homepage was this? Not formtools.org!

To get the data out of the Form Tools database, check out the API:
https://docs.formtools.org/api/v2/

That has a bunch of methods to query the database and get data. Specifically, check out this method:
https://docs.formtools.org/api/v2/show_submissions/

That sounds just like what you want: it uses the Export Manager module to handle rendering the list of form data in the page.

Ben