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.

Fetch Request to Database in the Advanced Add-On Version

  1. Good evening.
    We recently updated Gravity Forms licence to the Pro version, so that we could implement the Survey Addon (which seems to works very well and happens to be an essential part for the application we are developing). We are trying to use the Google Chart Library to display the results but the Google Chart Library uses specific predefined data formats.
    Our question is: How can we setup the fetch request from the DB and make the neccesary calculations with the results of the querys of the "wp_rg_lead_detail" table?. We noticed that the Advanced Survey Fields generate a custom value for each advanced field.
    We believe there is already a function set up with these calculations (as we can observe on the admin panel, (forms results / survey results).

    Any help, guidance or advice, will be very appreciated.
    Thank you!

    Posted 9 years ago on Thursday June 13, 2013 | Permalink
  2. +1 on this request for guidance or documentation.

    Posted 9 years ago on Wednesday June 19, 2013 | Permalink
  3. This is on our list of feature requests to take a look at. Can you guys give us some more detail regarding your specific use cases? That would be very helpful for us to try to tackle this the correct way.

    Posted 9 years ago on Wednesday June 19, 2013 | Permalink
  4. My example use case:

    We have several publications that we want users to rate based on several criteria (e.g. Fun with ratings of "Boring" up to" Most Fun Ever"). We would like to use a Likert scale for this to collect results and run calculations to get calculations such as Average Fun rating (e.g. Fun -> 3.5).

    So we would need to be able to:

    1) Score each choice, for example 1 - 5.


    2) Have some way to retrieve easily retrieve the counts for each choice in a way that we can pair up that choice to a score for calculation.

    With the Survey Results screen and the option to use the Likert Scale, I sort of assumed their would be some sort of score or average shown for each row/question built-in.

    Posted 9 years ago on Wednesday June 19, 2013 | Permalink
  5. Thanks, we do plan on implementing this but I can't give you a date as to when.

    Posted 9 years ago on Wednesday June 19, 2013 | Permalink
  6. Simple:
    How does gravity generate the results from survey fields?, we would like to do it in a similar way for our custom data needs.

    Posted 9 years ago on Saturday June 22, 2013 | Permalink