https://legacy.forums.gravityhelp.com/topic/database-storage-order Gravity Support Forums Topic: Database storage order en-US Wed, 22 Apr 2026 19:22:43 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/database-storage-order#post-36241 Mon, 26 Sep 2011 15:28:42 +0000 Carl Hancock 36241@https://legacy.forums.gravityhelp.com/ <p>I'm not aware of any scripts that are already created that do this. Hook wise there are no export related hooks. You'd have to duplicate the existing export code and use that as a base to write your own custom export functionality. </p> https://legacy.forums.gravityhelp.com/topic/database-storage-order#post-36179 Sun, 25 Sep 2011 13:49:29 +0000 skyrocket 36179@https://legacy.forums.gravityhelp.com/ <p>We're looking to do something similar, except in a "batch" mode. So the user would log in to FileMaker and click a button, which would run a script to:</p> <p> - export all the new (unread) entries from Gravity Forms since the last time the script was run<br /> - mark all of those entries as "read" inside GF<br /> - import all the entries into FM</p> <p>This is a little different than the way the GF Add-ons work, since we're not exporting the data when the form is submitted -- instead, we're exporting only when the user requests it</p> <p>Are you guys aware of any GF hooks we should be using to do this? Or perhaps any scripts that are already created that are similar? </p> https://legacy.forums.gravityhelp.com/topic/database-storage-order#post-4419 Thu, 01 Apr 2010 16:32:48 +0000 Carl Hancock 4419@https://legacy.forums.gravityhelp.com/ <p>Of course, anything is possible. Our Add-Ons for MailChimp, Campaign Monitor and FreshBooks basically do exactly that only instead of pushing data from a form to another database they push it to these 3rd party services via their API.</p> <p>So it's entirely possible to create an Add-On that would allow you to map fields on a form to columns in another database and then push that data to that database when a form is submitted.</p> <p>It could be done by reverse engineering one of our add-ons and then customize it to do whatever you want. </p> https://legacy.forums.gravityhelp.com/topic/database-storage-order#post-4416 Thu, 01 Apr 2010 14:20:11 +0000 tdiaz 4416@https://legacy.forums.gravityhelp.com/ <p>Hmmm... okay, you raise a valid point. It's a lot easier to add a row before a column with regards to being dynamic and flexible. </p> <p>Now on the other angle, yes, Gravity Forms is a form builder and submission tool, and since most of the time data is collected for another use .. Yes, the collection would like nice and be easy to generate, it still means we have to work with the data in some other way. </p> <p>Perhaps a "converter" can be crafted to push the input data over to another database and then drop it from where it was put originally by the plugin. </p> https://legacy.forums.gravityhelp.com/topic/database-storage-order#post-4376 Tue, 30 Mar 2010 15:10:36 +0000 Carl Hancock 4376@https://legacy.forums.gravityhelp.com/ <p>Forms are 100% configurable by the end user. Because of that the form entry data is stored at as an array in a single row to account for the fact that no 2 forms could be a like.</p> <p>The ideal situation is a column for each field, however that then means each form needs it's own table and database tables would be added, modified and deleted on the fly as you create and edit forms. This poses technical hurdles and support issues that would have to be tackled because things would be much more complex.</p> <p>Because of the fact the forms are configurable and each one is unique the data is stored in a consistent format, in the same tables, as an array. The plugin then knows how to display and work with this data format.</p> <p>Gravity Forms is a form builder and form submission tool, it isn't designed to be a database data capture tool. It's primary focus is contact forms and user submitted post creation.</p> <p>The data can be exported as CSV and our export tool code could be reproduced to do this on the fly if you wanted to write custom code that could be pulled from a 3rd party application.</p> <p>Or the other option is using an API hook and custom PHP to do whatever you want with the data when the form is submitted. </p> https://legacy.forums.gravityhelp.com/topic/database-storage-order#post-4367 Tue, 30 Mar 2010 13:39:55 +0000 tdiaz 4367@https://legacy.forums.gravityhelp.com/ <p>Okay, so it's not configurable. But, am I correct in how it does it now? </p> <p>In which case, thats a deal killer outright for me, almost better to store it in a flat csv file, at least a whole row is a single record unlike this where it's a record for each entry. </p> <p>The idea here is to access the form data on the back end with something like FileMaker, using the mysql database as the storage point. This method of data storage sounds nuts. Maybe I'm wrong, but I've never ever seen form data stored across records. </p> https://legacy.forums.gravityhelp.com/topic/database-storage-order#post-4344 Tue, 30 Mar 2010 00:44:36 +0000 Carl Hancock 4344@https://legacy.forums.gravityhelp.com/ <p>The data structure for Gravity Forms is not configurable. You can use available API hooks to store the data wherever you want when a form is submitted, but that requires custom PHP and there isn't a built in point-and-click configuration tool for doing this. You would have to do it with custom PHP. </p> https://legacy.forums.gravityhelp.com/topic/database-storage-order#post-4343 Mon, 29 Mar 2010 23:04:16 +0000 tdiaz 4343@https://legacy.forums.gravityhelp.com/ <p>Is this a hard question? </p> https://legacy.forums.gravityhelp.com/topic/database-storage-order#post-4126 Thu, 18 Mar 2010 18:51:25 +0000 tdiaz 4126@https://legacy.forums.gravityhelp.com/ <p>Is it possible to store the form data all in a single record instead of each line item on it's own record?</p> <p>Key, First, Last, Address, City, ..<br /> 1, Fred, Flintstone, 2020 Rocky Way, Bedrock .. </p> <p>Instead of the way it (appears to do it)<br /> Key, ID, item, content<br /> 1, 1, first, Fred<br /> 2, 1, last, Flintstone<br /> 3, 1, address, 2020 Rocky Way<br /> 4, 1, city, Bedrock</p> <p>The former is a whole lot easier to work with other database front ends, to move data in and out, etc. </p>