Formidable Forms Community Site

The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk
Subscribe

Adding non-Formidable WordPress Data Into Form

Labels

This Discussion is public

Notifications

I'm wondering if there is a way to add data from a non-Formidable WordPress table into a Formidable form... I'm very new to using Formidable Forms and am not quite certain what can and can't be done. If it is possible, and there is some type of basic information somewhere, I should be able to work out the custom coding involved. For an overview, this is what I am trying to achieve: my client wants a member directory. Most of the member data comes from a Formidable registration form. She also wants to display all WooCommerce products (which are actually FooEvents) that each member purchases. And I need to make each column sortable (I think using the Google table will be fine if I can somehow get the event data into a form).

Thanks

Hi Jason,

Are you looking to insert the data into a form or a view?

You can use various short codes in your forms to pull information from tables in your DB like [user_meta key=whatever].

You can also get values from URL parameters with [get param=whatever] if you wanted to load the information via the URL.

It sounds as though you want to build a view using the data from your form and other places though to build a user directory. You can do that and make the tables sortable directly within Formidable so you don't have to use Google Tables if you don't want to.

There's an article i wrote HERE on building an invoicing system which isn't quite what you're after but it does have some information on building a view to display your list of customers.

Hope that helps.

Chris

Thanks for the response Chris. I can create a view from my custom registration form that shows all of the data from that form no problem. The real issue I'm having is trying to get data from WooCommerce. I looked at your article. Really cool stuff, but it looks like you are dealing only with Formidable forms? It seems like this is way more difficult than it should be...

You can use the frm_setup_new_fields_vars hook to execute a SQL query against any table, even those not in WordPress: http://community.formidableforms.com/knowledgebase/frm_setup_new_fields_vars/

In WordPress use the global $wpdb object to execute your SQL statement.

Discussion closed.