Form Tools
use api to query by field - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: API (https://forums.formtools.org/forumdisplay.php?fid=17)
+--- Thread: use api to query by field (/showthread.php?tid=360)



use api to query by field - bighoppymonster - Nov 5th, 2009

I'm storing a randomly generated hash code in formtools when the record is inserted. The person that submits the form gets this unique value that can then be used to get the record from form tools.

The user queries for their record using a key, to avoid viewing other records:
registration.php?key=aTa7X4opkEJeeyRWXiEjNqHzkU9iqp

I have some custom php code that queries mysql directly, but I'd like to see if the api can do this using something like the show_submissions api function, or if there are some ideas out there.

Thanks for any ideas you might have.

-B


RE: use api to query by field - Ben - Nov 24th, 2009

Hey BigHoppy,

I'm afraid the API doesn't offer this functionality yet, but it's definitely near the top of the list (a couple of other people have recently requested the same feature).

Just as you suggested, I'm going to be updating the ft_api_show_submissions function to allow custom searches.

However, did you want to get the row as a row of values, or to actually display the content, like ft_api_show_submission and ft_api_show_submissions?

- Ben