Okay
  Public Ticket #3625188
ask
Closed

Comments

  • Oscar started the conversation

    Hello,

     

    I would like to know if when a change is made in my google sheet there is the possibility that the user see the change in real time or it is necessary for the user to refresh the page.

     

    Thanks

  •  1,819
    Miloš replied

    Hello,

    - Auto-refresh feature for the tables, using the built-in functionality of our plugin is only possible for server-side enabled tables, such as a manual table, or a server-side SQL query-based table. 

    This option will appear on the "Data source" tab above the table.

    7551443052.png

    You can add the interval (in seconds) after which the table will refresh itself, thus displaying any changes that happened in that time period.

    -


    2. But for tables linked to a data source such as Google Sheets - you will not be able to enable server-side processing, so this requires a custom JQuery solution. 

    Unfortunately, we don't have any built-in solution for that at this time.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    -

    If you need a solution for it now, maybe it can be done with a high level of custom work, but I am not sure, to be honest. 

    Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.

    We can recommend reaching out to someone who does custom solutions, such as WP Kraken, but we can't advise on their pricing.

    -

    I can only share an idea for a custom workaround which one of our users came up with.

    ( we can't guarantee that it works, but the user claims it worked for him) 

    This is what he said :

    "Create a filter. Make sure that you choose "above the table". it is because we'll need the filter id for this trick. 

           jQuery("#filterBox_table_5").hide(); 

     //if you don't want to see this filter, check your table id and use it here.        

    jQuery("input[placeholder='YOUR FIELD NAME']").trigger('keyup'); 

    // this refresh your table. 

    Call this jQuery line each time you want to refresh it. "

    - I hope that this can help, to at least give you an idea for a workaround.


    Of course, you can always research resources such as Stack Overflow, and similar,

    or you can reach out to WP Kraken to ask them if they could create a solution, but as we said, we can't advise on their pricing.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables