• In short, I’m trying to display the sum of the contents of a particular field.

    In long, I have a list field called ‘Amount of Apples’ with the numbers 1 through 20. I want the user to send the form and then later when I view the data, I want to display the total number of ‘Amount of Apples’ that have been submitted to that form. I would also like to then display that number multiplied by five.

    Can you point me in the right direction?

    http://wordpress.org/extend/plugins/wordpress-form-manager/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author hoffcamp

    (@hoffcamp)

    There isn’t a simple way of doing this. Essentially you would have to hijack form manager and use it to build a calculator. This has been requested a few times, so I’m trying to think of a good way of doing simple things like what you are saying, but for now there isn’t really a solution.

    Thread Starter andy789

    (@andy789)

    Hey, I’ve been tinkering with the plugin quite a bit. And basically all I would need to finish figuring it out is finding out how to call database rows by their nickname, and not that automatic name with the numbers.

    Or at least, is there a way to change those automatic names and automatically name them the name of the row it corresponds. I tried changing the names manually phpmyadmin, but the forms stopped working as they were still looking for the automatic names.

    Any advice would be greatly appreciated. I would also be willing to schedule and pay for a few hours of your time if need be.

    Thanks so much for your response.

    Plugin Author hoffcamp

    (@hoffcamp)

    Andy, this is actually fairly easy. The nicknames are paired with the automatically generated names ( I call them ‘unique names’ ) in the table wp_fm_items. So you would run the following query to find an item with the nickname “the-text”:

    SELECT unique_name FROM wp_fm_items WHERE nickname = 'the-text'

    You can also grab the data table name for a form by slug, in this example “form-1”:

    SELECT data_table FROM wp_fm_forms WHERE shortcode = 'form-1'

    The entries for ‘unique_name’ in wp_fm_items need to correspond to the field names in the data tables. This is why changing them manually didn’t work, but if you make sure you change these entries you can make the field names anything you want.

    The unique names are generated on line 791 of db.php (as of 1.6.25), in a function called ‘getUniqueItemID’. The only argument, $type, is just the slug for the item type (something like ‘text’, ‘textarea’, ‘checkbox’ ), so you will have to include something extra in order to guarantee unique names are created.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘[Plugin: WordPress Form Manager] Adding and displaying form results’ is closed to new replies.