Okay
  Public Ticket #2759260
global settings for MANY tables
Closed

Comments

  • kim started the conversation


    The website is currently behind a coming soon page, and not visible to the public.

    I will be creating many tables using google spreadsheets. Most likely hundreds of tables. 

    Is there a way to pre-define how the data in columns are treated based on the column heading? Or some other way?

    Here are examples of what we need:

    If the column heading is GEM, treat the data type of the column as an image.

    If the column heading is AUDIO, treat the data type as a URL, make it a button, with the label LISTEN.

    If the column heading is MORE INFO , treat the data type as a URL, make it a button, with the label DETAILS.


    Along the same lines, is it possible to set default value for all the tables rather than having to set them on each table?

    Examples of what we need:

    • Default display for overall table
      • Uncheck “Show table title on page”
      • Default rows per page = 50
      • Uncheck “Show information block below the table”
      • Uncheck “Enable table tools”


    Thank you for any help

  •  2,507
    Aleksandar replied

    Hello Kim

    Thank you for your purchase.

    Unfortunately, wpDataTables doesn't yet have any templates you can use for multiple tables, nor can you predefine a column based on the header, in any way.

    Images added to Google Spreadsheets (or Excel, CSV, XML, JSON, or Serialized PHP Arrays) won't be recognized as images unless you add the path to the image with the IMG tag, like:

    <img src="url-to-the-image">

    Only when you add images like that, would it actually import images correctly in wpDataTables.

    For Audio and More Info columns - the data in that column needs to be a full URL in each cell, so HTTP:// or HTTPS:// included. Then you would be able to save the column as URL Link, which (in column settings) allows you to show the URL as a button, with a custom label.

    As mentioned above, the default settings for all tables can't yet be changed, to apply to new tables, so, unfortunately, until our developers include this option, you will need to configure each table manually.

    Kind Regards, 

    Aleksandar Vuković
    [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