WordPress.org

Ready to get started?Download WordPress

Forums

Gravity Forms Directory
Limit directory display by date range (22 posts)

  1. neo2810
    Member
    Posted 2 years ago #

    Hi Zack,

    Excellent Addon first of all, but I'm sure you've heard that before :P

    I have multiple forms all for capturing football results from each specific team to display on separate team pages through the season. I also have a single page where I want to display just the previous week's results for every team. I'll be using a separate directory line for each one but I want to be able to query just the last 7 days worth of results from each form.

    Is there a way to do that using the filters or tags within the directory query line, or can you only apply to the functions.php file and therefore will apply to all forms?

    http://wordpress.org/extend/plugins/gravity-forms-addons/

  2. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    Neat idea - I'll look into how this might be added.

  3. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    It turns out I already added this functionality :-)

    Okay, so you can add the start_date and end_date attributes to your [directory] code to filter by date, formatted like so: 2011-08-26 22:39:10 or 2011-08-26.

    [directory form="#" start_date="2011-08-26" end_date="2011-09-07"] would show listings from August 26 to September 9th.

  4. neo2810
    Member
    Posted 2 years ago #

    Zack, you legend!

    Thanks for that, it's exatcly what I needed!

  5. neo2810
    Member
    Posted 2 years ago #

    Zack... Not working... I've set the filter and the form is still displaying all the results. Can you double check the format you gave me is correct?

  6. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    It worked for me...try using the latest version (3.0) of the plugin and let me know if that helps.

  7. neo2810
    Member
    Posted 2 years ago #

    V3 has killed the plugin!

    I cant approve any of the entries and nothing is displaying as a result. Some of the displays show a PHP fatal error!

    Fatal error: Call to undefined method GFDirectory::get_lead_details_table_name() in /home/********/public_html/wp-content/plugins/gravity-forms-addons/gravity-forms-addons.php on line 2190

  8. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    Thanks for reporting neo. I'll fix tomorrow. If you change self::get_lead_table_name() to RGFormsModel::get_lead_table_name() and self::get_lead_details_table_name() to RGFormsModel::get_lead_details_table_name() around those lines, it should fix that error.

    Like I said, I'll post the fix ASAP.

  9. neo2810
    Member
    Posted 2 years ago #

    I've amended self::get_lead_table_name() to RGFormsModel::get_lead_table_name() and the form displays now but still with no entries, and I get the following error when trying to approve any entries:

    Warning: Invalid argument supplied for foreach() in /home/redhouse/public_html/wp-content/plugins/gravity-forms-addons/gravity-forms-addons.php on line 1739

    Still cant approve anything, and the "approve" field is empty when you select it in the form editor (nothin under "properties", "advanced" or "directory" and you can't even edit the "Untitled" title.

    I love the plugin but I'm thinking this version need a little more work before it's relaunched?

  10. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    Date filtering is better supported in version 3.0.1, just released - it has its own settings in the Insert Directory window.

    Also, please try the Approval process again once upgrading to 3.0.1 and let me know how it goes.

  11. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    @neo - This should be fixed in version 3.0.2, just released.

    There was code that was only compatible with Gravity Forms 1.6, and because I had installed 1.6 already, my database tables were altered by the upgrade. When I downgraded to test for compatibility, the database tables were still in their modified state. So that's why I was unable to replicate the issue.

    Please upgrade to 3.0.2 and let me know if that fixes things for you.

  12. neo2810
    Member
    Posted 2 years ago #

    Almost, but not quite!

    At first the directory was not displaying but I started removing tags and when I removed the "sort" tag the entries appeared. So it looks like you've knocked off the sort tag to sort by specific column?

    Also, the date range is a little erratic. I have a a list of forms with multiple entries and I've set up a row of identical directories to pull the same date range from each form. Most of them display the correct entries for hose dates but there are a few which either include entries outside the date range, or display no entries where there are entries to display in the date range.

  13. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    I didn't modify anything with the sort functionality - also it's working fine for me. Regarding the date range, that's done using the following MySQL code:

    datediff(date_created, '$end_date') <=0 and
    datediff(date_created, '$start_date') >=0

    That uses the date_created field for each entry. Not sure why yours may not be working properly. Sending me links helps; making me a login is better.

  14. neo2810
    Member
    Posted 2 years ago #

    Ahhhhh.... silly me. I have a date field and for some reason I thought it would set the range on that. It makes sense now, however that functionality doesn't help me. Pity, but I'm guessing there's no way to set the date range based on a user entered date field (maybe using the variable function)?

    I'll test the sort issue again but it was def removing the directory when set.

  15. neo2810
    Member
    Posted 2 years ago #

    Tested the sort function again and still the same issue. When I don't use sort, it works fine. As soon as I add sort="8", I get the "form has no entries" message...!??

  16. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    Try adding ?sort=8 to the URL and see if that works.

    Otherwise, send me a link or login. I can't help more otherwise.

  17. neo2810
    Member
    Posted 2 years ago #

    Nope, that didnt work either. What lvl of login do you need? The page in question is at http://redhousefarmjfc.co.uk/?page_id=2013...

  18. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    If you're in europe, the format might be different; it might be yyyy-dd-mm. It's whatever format your date_created field is in in the wp_rg_lead table.

    I need whatever level has access to the Directory. With the Members plugin, that can be specified. Otherwise, it's level 7 (editor?).

  19. neo2810
    Member
    Posted 2 years ago #

    Thanks Zack, the date range is working fine (I didn't realise it was created_date rather than user defined date field). Could I modify the core plugin files to change created_date to "variable for date field in form" so the date range applied is based on the user defined date?

    With the "sort" issue, I've discovered that if I put a field name like "Team" instead of the number 8, it lists the entries (although unsorted) so I'm thinking maybe "8" is not assigned to any field which is why is returns no entries. How can I see what ID is assigned to each field in a form?

    By the way, really appreciate the effort you're putting in to get these issues sorted. So many plug-ins fall down because of lack of support. Credit to you!

  20. Zack Katz
    Member
    Plugin Author

    Posted 2 years ago #

    On the Gravity Forms "Edit Forms" page, hover over the form and click the link called "IDs" that appears. That'll tell you the field IDs.

  21. neo2810
    Member
    Posted 2 years ago #

    Thanks Zack... The team field is def 8 and the entries still disappear when I add sort="8"??!

    I'll email you login details. If you could have a look when you get a change that would be much appreciated.

  22. neo2810
    Member
    Posted 2 years ago #

    Hi Zack,

    Did you have any luck figuring out my "sort" problem?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic