PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Pre-Populating Forms from Excel or Access

  1. I have created a membership form for my non-profit. I want to pre-populate these forms with existing data. I have an Access database and my hosting provider as mySQL.

    How do i pre-populate the forms using my Access database? Would appreciate any help.

    Posted 14 years ago on Monday May 10, 2010 | Permalink
  2. Do you mean you want to submit the form (preferably in some automated fashion) so all your existing members are part of your new online database, created by Gravity Forms? Or do you want to add this data to the form some how?

    Posted 14 years ago on Tuesday May 11, 2010 | Permalink
  3. ssteinerX
    Member

    I have almost the same question, maybe I can make it a bit clearer what I'm trying to do.

    I have an existing database table.

    I want to design a form for entering/updating data in it.

    1> Can I generate a form from the database structure?
    2> Is there something in the product that will automatically handle the POST of the form and stuff it into the database from which the form was generated.

    Thanks,

    S

    Posted 14 years ago on Monday December 27, 2010 | Permalink
  4. Gravity Forms only stores data in it's own database tables. It isn't designed to store database in 3rd party tables or externally.

    If you need to store data in a different location you would have to use the gform_post_submission hook and write custom code to store the field values in your external database.

    Posted 14 years ago on Monday December 27, 2010 | Permalink