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.

Query database using form fields (taxonomies)

  1. Hello, thanks for your work.

    During last year using gravity forms, I have been wondering if we can use gravity form not only to populate and pre-populate a value but to filter these values, I mean, to filter posts database.

    For example, I have three custom taxonomies (fruits, regions and quality) and I can filter and order them using these taxonomies (it is the same that you get via admin ui or using query multiple taxonomies plugins: http://wordpress.org/extend/plugins/query-multiple-taxonomies/screenshots/).

    Using gravity, I have three form fields populated with these taxonomies and I can create new posts with its taxonomies and so on; what I am asking if once I choose a taxonomy (for example: apple), it could be used to filter the rest (for example: in the following taxonomy, region, showing just regions containing apples; in the post content, showing post contents with apple taxonomy; in the post title, showing post titles with apple taxonomy; etc). Now, If I choose apple, having them just in California and Florida regions, region taxonomy show me "California, Nevada, Indiana, Florida" and It would be great if it could be queried and filtered on the fly, showing just California and Florida. I have checked and tried to pass data via a query string, but not sure that it would be the best way, because you are redirected to another url and the pick is to stay in the form in order to continue populating it.

    Furthermore, in accordance to aforesaid, I am struggling to find the way to prepopulate fields when you have a unique value. For example, if I have an apple class, named "Gravinia", with its features (colour, shape, weight, period, taste, etc), I want to populate these features-values each time "Gravinia" type is chosen, cause "Gravinia" apple is a unique value in the database (Gravinia would be like the ID). I am thinking, for more example, in the way Freshbooks invoicing system let you "save items" that you could use later, saving you having to write some invoices features again and again; other example could be found in Paypal invoicing system where you could save item descriptions, populating theme once you write item ID, item title (or your item reference).

    My goal is to produce all my company documents through wordpress, and gravity forms could be a solid way to get it.

    I appreciate your support. Thank you.

    Posted 6 years ago on Tuesday April 30, 2013 | Permalink
  2. David Peralty
    Administrator

    Everything you've listed here would require custom coding well beyond anything we could support. Gravity Forms doesn't have any built-in ways to manage or retrieve custom taxonomies, nor any way to create "saved" form profiles like you've mentioned. Your best bet would be to contact a developer on our Job Board or via sites like jobs.wordpress.net or odesk.com.

    Posted 6 years ago on Tuesday April 30, 2013 | Permalink