We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3162509
Product features
Closed

Comments

  • Amol started the conversation

    Hello!

    I need to publish a directory of companies including their basic profile data (name, location, description, funding metrics, service metrics, etc.) all on separate pages (each company has their own dedicated profile page.  Not too dissimilar to Crunchbase where each company has their own profile page (e.g. https://www.crunchbase.com/organization/agrocenta).  I am currently aggregating all this company profile data in a database (e.g. MS Excel).  

    I'd like to know if WPdataTables can help me here - specifically, can I use WPdataTables to create separate pages from a single database (one page per row) and display data contained in that row?  

    My database has one row per company and I'd need a separate, dedicated page created per row.  e.g.:

    Row 1 contains all the profile data on company 1 and needs to be published to a dedicated page, its own profile page.

    Row 2 contains all the profile data on company 2 and needs to be published to a dedicated page, its own profile page.

    Is this feature available via WPdataTables (publishing individual rows to separate pages?  

    Thank you in advance!

  •  1,895
    Miloš replied


    Hi, Amol 

    Sorry for the late reply

    -

    Yes, i believe you should be able to achieve this by making dynamic SQL Queries with placeholders.

    For example, you could make an SQL Query for a table like this :

    SELECT * FROM my_table
    WHERE my_field = '%VAR1%'

    You can make a field/column that will hold all the Companies names;

    and then you can set different shortcode for each Company page.

    For example, for Company A,  you can set shortcode

    [ wpdatatable id=1 var1='Company A name' ]

    Then, page for company 2

    [ wpdatatable id=1 var1='Company B name' ]

    and so on.

    Let me know if that might work for you?

    And you can check more details on Making dynamic SQL Queries with placeholders here.

    -

    And i just wanted to point out that you can try wpDataTables before purchasing

     on our sandbox Demo sites ( you can find links for the main plugin Demo,  

    as well as add-on Demos, in my signature),

    and there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

    Let me know if you have any additional questions. smile.png


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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