Appnitro Software Forums » MachForm 2

Problem with report when drop down values are changed in


  1. shardak
    Member

    We have a form with drop downs. IT was working fine initially. Now as the data changed we had to delete some options from the dropdown and add some new. Now the problem is that the report for enteries does not pick up the newly added values... the report is a mess with missing values. The email notification still picks up those newly added values but not the report. There are so many records out there and we cannot retreive those values.

    PLEASE HELP!!!!!

    Thanks,
    -Sharda

    Posted 7 months ago #
  2. redityo

    Hi Sharda,

    This seem to be a bug, the deleted drop down option was hidden when you see the entries. To fix this, you will need to edit some machform files, try to follow these steps :

    1. Edit "manage_entries.php" and go to around line 107 for these code :

    $query = "select element_id,option_id,<code>option</code> from ap_element_options where form_id='$form_id' and live=1 order by element_id,option_id asc";

    then change it to

    $query = "select element_id,option_id,<code>option</code> from ap_element_options where form_id='$form_id'  order by element_id,option_id asc";

    2. Edit "includes/entry-functions.php" file and go to around line 260 for this code :

    $query = "select element_id,option_id,<code>option</code> from ap_element_options where form_id='$form_id' and live=1 order by position asc";

    then change it to

    $query = "select element_id,option_id,<code>option</code> from ap_element_options where form_id='$form_id'  order by position asc";

    However, if you have any difficulty with this, you can mail us directly to here :

    customer.service[at]appnitro.com

    we will help you with the fix


    MachForm Support

    Posted 7 months ago #
  3. shardak
    Member

    Redityo,

    We are having big problem here. All the reports generated is having data inaccuracy. The email notification that we got are many times not matching with the data that we see in entries. The excel report and the web entries report show different number of records. In the web report the number of enteries we are seeing is 269, but when we export it gives us only 236 records. It is a big mess. Can you please help with this discrepancy?

    Thanks,
    Sharda

    Posted 7 months ago #
  4. I've replied to your email. Please check it there.


    MachForm Founder

    Posted 7 months ago #

RSS feed for this topic

Reply