MachForm Community Forums » MachForm 3

1. sapan
   Member

   Hello,
   is there any way i can filter out results within a given date i.e. if my form became live on Aug 15 and today is Aug 27 the how can i view/export entries from Aug 20 to Aug 25, also i have one more suggestion. Will not be good if instead of displaying 4hors ago or 15 days ago if there is any way to display the actual date and time of the entry submitted/created and updated in the Date Created column i.e. currently in the Date Created column of form entries it shows 4 days ago but how can fix it so it should say 23 August 2012 at 10.35 PM.

   Thanks
   Sapan

   Posted 12 years ago #
2. 

   yuniar

   Hi Sapan,

   There is an option to filter your entries based on the date already. Simply click "Filter Entries" and then set the date conditions.

   To change the format of the "Date Created" column on your entries, you can edit "includes/entry-functions.php" file. Search around line 1321 for this code:

   if($column_name == 'date_created' || $column_name == 'date_updated'){
   	$form_data[$i][$j] = mf_short_relative_date($row[$column_name]);
   }

   change it to become:
   

   if($column_name == 'date_created' || $column_name == 'date_updated'){
   		$form_data[$i][$j] = date('d M Y - H:i A',strtotime($row[$column_name]));
   }

   ---

   MachForm Founder

   Posted 12 years ago #

3. sapan
   Member

   Hello Yuniar,
   thank you for helping me out to solve the Date Created problem.
   The problem for the filter entries remain the same, i am not able to filter out the from-date to to-date, the problem is the date picker in the second line do not come up i.e. first i want to filter "date created is after 20Aug2012" and then "date created is before 25Aug2012" but the problem is in the first filter the date picker pops out but not in the second filter.

   Thanks
   Sapan

   Posted 12 years ago #

4. williamansley
   Member

   Well, well! You have found a bug all right. Any date picker button in a date-based filter after the first one doesn't work (the calendar doesn't pop up). Interestingly enough, if you apply the filter and then edit it, all of the date picker pop ups work. I was able to verify this in the patched version of Machform 3.3.

   However, you can easily work around the bug for now by manually typing in the second date.

   Posted 12 years ago #

5. sapan
   Member

   How can i get the patch?

   Posted 12 years ago #

6. williamansley
   Member

   You misunderstood me. Machform version 3.3 has had a patch released to fix an issue unrelated to the one you are asking about. I am confirming that I can recreate the bug you are reporting in the patched version of 3.3, to try to give the developers as much information as possible. Hopefully, they will fix this issue in a future release, but there is an easy, if somewhat inconvenient workaround (manually typing in the second date), so you can still use filters to view a range of dates.

   Posted 12 years ago #

7. sapan
   Member

   Oh Ok

   Posted 12 years ago #
8. 

   yuniar

   Thank you for finding out this bug! Fortunately the fix is quite simple, you only need to edit the "js/manage_entries.js" file.
   Search around line 287 for this code:

   //reset the filter keyword
   $("#filterkeyword_" + new_id).val('');
   $("#li_" + new_id).data('filter_properties').keyword = '';

   exactly below that block of code, add this code:
   http://pastie.org/4607433

   if you are having difficulty, please contact us directly and we'll send you the updated file.
   This fix will be included as part of v3.4 update.

   ---

   MachForm Founder

   Posted 12 years ago #

9. sapan
   Member

   Hello Yunair,
   i am not able to find the above code in js/manage_entries.js and moreover the manage_entries.js page has only one line. Below is the code as is.

   Posted 12 years ago #
10. 

    yuniar

    sapan -- please contact us directly and I'll send you the updated file.

    http://www.appnitro.com/contact

    ---

    MachForm Founder

    Posted 12 years ago #

11. sapan
    Member

    I have send my request through the contact form, please send me the fix ASAP.

    Posted 12 years ago #
12. 

    yuniar

    I've sent the file.

    ---

    MachForm Founder

    Posted 12 years ago #

13. sapan
    Member

    Hello Yunair,
    it's still not working after i updated the file which you sent me.

    Thanks
    Sapan

    Posted 12 years ago #
14. 

    yuniar

    Try to delete your browser cache and restart it. Most likely your browser still loading the old cached file.

    ---

    MachForm Founder

    Posted 12 years ago #

RSS feed for this topic

Reply

You must log in to post.