Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #1460615
Integration with Googlesheets
Closed

Comments

  • Craig started the conversation

    Hi there,

    I have used the Googlesheets option, as this will pull the JSON data every 2 hours. This has the extra data added in extra columns.

    I have a couple of questions I would like to ask about Googlesheets:- http://proofofstake.pro/ site where the wpDataTables is used.

    1. Change the color of the text,  "Show X entries" see here - http://prntscr.com/ib7rn1

    2. Add in images here to refererence each coin - http://prntscr.com/ib7ryt 

    3. Center the column headings - http://prntscr.com/ib7s82

    4. Color the text not the columns - http://prntscr.com/ib7sfg

    Thanks again for your time

  •  471
    Isidora replied

    Hi Craig,
    Thank you for your purchase.

    1.Just add this code in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables.

    .dataTables_length{
    color:red !important;
    }

    This will be affected on all tables, but if you want just for specific one then insert this code on page where is that table between the style tag.(<style>Code here</style>)

    2.If you have in column that contain data for example "text", with Conditional formatting you can add rule if the cell = text then Set cell content and add text that you want and img tag with source where you image is located.

    some text <img src="path_to_the_image_location">

    text and image will be concat so you can add css

    Just add this code in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables.

    table.wpDataTable td img{               
    float:right !important;
    }

    3. You can take a look on our FAQ section.

    4. Every column have specific id which you can find from inspect element of the browser and then use that id and set css rules and property that you need in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables.


    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables