Okay
  Public Ticket #3514385
Functionalities
Closed

Comments

  • Duc Tran started the conversation

    Hello,

    I want to use wpDtata Tables to create a simple directories listing and would like to know if following features are available:

    - conditional format (display different color or text) based on Opening/closing time

    - filter /show/hide row based on Opening/closing time 

    - searchable/filterable hidden column

    - get geodata filled to search/address filed

    - hide data on load, only show results when user use search/filter

    - limit how many row user can create

    - clickable row to link to their own page

    - show data in tooltip when mouse hover a cell with long content (Example: cell only show max 20 characters, and show all vailable content in tooltip on mouse hover )

    - user can pay to get premium status to list/display their row on top of result


    Thanks.

    Best regards

  •  1,846
    Miloš replied


    Hello,

    To begin, I want to extend my heartfelt apologies for the delayed reply, 

    which is due to an unexpectedly high volume of inquiries. 

    We truly value your patience during this period.

    -

    We will now answer multiple subjects on the same ticket, but if you need us to go in more details on any of them, please open separate tickets for each of the questions so we can have better focus.

    When you have multiple questions or issues which are for different subjects/topics,

     please open a new ticket for each subject, and we will help/advise more effectively. 

    In that way, issues and questions which are related to different subjects will be in separate tickets so other users or our support agents can find them easily. 

    Our policy is to have one issue or question per ticket for the reasons described already.

    Thank you for understanding.

    -

    1. - conditional format (display different color or text) based on Opening/closing time

    Yes, we have Conditional Formatting which you can use to change different color of the text in certain cell depending on the cell value.

    There can be various different conditional rules, and you can set different things to happen, such as set cell color, row color, show or hide row, show or hide column;

    add custom CSS class etc;

    Please check more here.

    Just be aware that a Condition can only look in the cells of its one Column - If you need a Condition to look between several Columns at the same time, right now we still don't have that option, so it depends what you need exactly.

    If you need more details about a specific scenario with a Conditional Rule - please open a separate ticket, it will get assigned to me, so we can just proceed on that subject in more details there.



    2. - filter /show/hide row based on Opening/closing time :

    You can show/ or hide a row based on a value from a Cell using the Conditional Formatting, as mentioned above.

    Please let us know if you need more details about something specific, you can open an additional/separate ticket for that subject and we will be happy to advise.



    3 - searchable/filterable hidden column

    Yes, you can use Global Table search and you can use a Column filter on a Hidden Column, if you activate the Filters to show above the Table.

    Please check more about filtering here.



    4 - get geodata filled to search/address filed

     I am not sure what you mean by this.  If you can please open a new ticket and write more details about this subject, if you can provide any examples that can help, so we will advise if that's possible with our Plugin?



    5 - hide data on load, only show results when user use search/filter

    Yes. You can do this with our Powerful Filters Add-on, it has a special option called "Hide Table before Filtering".

    Please check more here.https://wpdatatables.com/documentation/addons/powerful-filtering/

    Before purchase, you can test all plugin and Add-on features on our sandbox site.

    6 - limit how many row user can create:

    At the moment, that is not possible.

    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.



    7 - clickable row to link to their own page

    You can make hyperlinks/links with our Plugin in Tables.

    If you need to make just simple URL Links, then check out our URL Columns.

    It depends exactly how you plan to construct the data for that link, if you will combine values from several Columns/ or several Tables and Columns in the link cell.

    If that is the case, you can only do that in SQL Tables  with a CONCAT function.

    Please check this Video that shows an example of this.


    But our developers are almost finished adding a new 'out of the box' feature which will allow our users to combine values from several Columns together in the same cell - it should be released very soon.

    When that is added, then you won't have to use SQL CONCAT, if you just need to combine values from multiple columns of the same Table.



    8 - show data in tooltip when mouse hover a cell with long content (Example: cell only show max 20 characters, and show all vailable content in tooltip on mouse hover )


    We don't currently have any built-in feature to create tooltips on hover.

    If you wish to see that in the future,

    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.

     At this time, i can only suggest a custom workaround. 

    Please be advised custom solutions are not provided by our Support, but i will share this to get you started in the right direction, if you wish to try it.


    It is quite a custom solution, but, with some effort, it can be done,

    and all of this requires some level of skill with HTML and CSS.

    -

    In this example, i made a String column in a table,

    7391992101.png

     and, directly in the table cell, i type in this HTML.

    The hover text will be placed inside a "SPAN" HTML element, we give it ID as "tooltiphover";

    and the main Text of the cell,  we will add next to it, it is this "mainText" inside a HTML DIV with ID of "tooltipwrapper"

    -

    <div id="tooltipwrapper">mainText<span id="tooltiphover">hovertext</span></div>
    

    6739079521.png

    On this screenshot, as you see - i have taken that HMTL code, and added this directly in a cell of a String Column of the table.

    -

    Then with some custom CSS, I created a hover text above the field; 

    now, depending on exactly where you want to position it, you can experiment with some styles;

     I positioned it somewhere at the "middle top" above the cell, and you can choose whether to use px for pixels, or % for percentages of the screen for the values, such as width, positioning, margin, etc.

    Place the following CSS in the Table Customize section/Custom CSS:

    div#tooltipwrapper{  
      position:relative;
    }
    span#tooltiphover{
    visibility: hidden;  
    width: 120px;  
    background-color:
     black;  
    color: #fff; 
     text-align: center; 
     padding: 5px 0;  
    border-radius: 6px;  
      position: absolute;
      z-index: 1; 
     bottom: 100%; 
       left: 55%;  
      margin-left: -100px
    }
    div#tooltipwrapper:hover span#tooltiphover {  
      visibility: visible;
    }
    .wpDataTablesWrapper table.wpDataTable td { 
       overflow: unset !important;
    }
    
    9251889619.png

    And, this will be the result in the table :

    7546428881.png

    If i hold my mouse over one of the cells that say "mainText",  this "hover text" element with white text and black background will appear above.

    -

    I got this idea because I read from this resource about how to make hover text with HTML and CSS.

    If you wish to learn in more detail how to create CSS tooltips, it is explained here in full detail:

    https://www.w3schools.com/css/css_tooltip.asp

    -

    And, you will have to do this method for each cell that you need a hover tooltip for.

    I hope that this helps.



    9 . - user can pay to get premium status to list/display their row on top of result

    - If you mean to have some Payment system work through our Plugin directly, we do not have anything like that.

    You can only try to use something else outside of our Plugin for this solution to have users pay to get a premium Status.


    I hope that helps as an introduction, but if you need more details, please don't hesitate to open separate tickets for each of these points and you can ask additional questions.

    Thank you.


    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)




    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