help on saving form data with grid layout

  • Resolved dr.techy

    (@drtechy)


    6 years, 6 months ago

    Hi,

    Thanks for this great plugin. I have a issue which i seek help with.

    I am using the “tabled input sections” in a form to get a list of people with field like “‘Name’ ‘Age’ ‘Address'” text fields which can be repeated by the users according to the number of entries they want to make. This feature is working for me as i expected on the frontend form.

    Now i am using Flamingo Plugin to save the form entries in the database. Here is the problem i face. I actually wanted to get the submitted data so that each entry of the repeating field row is saved as separate row in the CVS or excel sheet. What is happening now is in the output report the entries of repeating fields are saved clubbed together for eq: Name field entries are saved in single column as (John,Harold,Sunny) and age in next column (32,12,34) and so on…

    Is there any way the submission of repeating row be saved in separate rows.

    Thanks in advance. I will appreciate if u can guide me in right direction.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Aurovrata Venet

    (@aurovrata)

    I am not sure about flamingo, never used it. I would recommend instead that you use Post My CF7 Form, a plugin I wrote to map a form to an existing post or a custom post. Post my cf7 plugin, like the Smart-grid, is designed using WP core functionality. Unfortunately the CF7 plugin, built at a time when WP stds where still in evolution, does not use WP core std and therfore does not play nice with other plugins that are built on core stds.

    So how does this answer your question? Plugins that structure/process data using core stds integrate better with one another. Hence, mapping your forms to a custom post means you have all the entire dashboard functionality of posts at your disposal, similarly there are excellent plugins that focus only on data export and likely do a much better job than flamingo to export data, but expect your data to be std post or custom post construct.

    You need to find a CSV exporter plugin that gives you enough flexibility through the use of filter hooks to custom format the data to be exported, therefore allowing you to transform an array (tabbed section fields are stored as arrays in post meta-fields) into rows. Look at WP CSV Exporter Never used it myself, but looks like it has some built-in flexibility.

    Your problem is very specific and I doubt you’ll find a plugin to solve it without some coding required.

    Plugin Author Aurovrata Venet

    (@aurovrata)

    PS: I would look at exporting single field columns in 1 csv file (each submission as 1 row in our csv file. In this csf file I would also export the post id to which the form submission was saved to (assuming you use post My CF7 Form plugin as I suggested) and then export your tabbed fields into a separate CSV file, along with the post ID as well. You will end up with 2 tables all linked through the unique post ID. in the 2nd table your fields will be columns but multiple rows for one given post ID.

    Thread Starter dr.techy

    (@drtechy)

    Thanks for such a detailed suggestions. As per the advice i am using Post My CF7 plugin now. It is better than flamingo. U are right, the issue i am facing cannot be solved without some custom coding because i did not find any ready made solution for that (both free and premium). I am very new with PHP coding so i will have to get some expert custom help on this. Thanks again for suggesting the way to solve this.

    Plugin Author Aurovrata Venet

    (@aurovrata)

    if you require professional help, you can reach out to vrata at syllogic dot in

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘help on saving form data with grid layout’ is closed to new replies.