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 #1642640
Field specific logic
Closed

Comments

  •  1
    Randy Colbert started the conversation

    I have a question about field specific logic capabilities.  Example: Can I have a cell (not a column) show or not show data based on the content of a cell in another column.  So if I have a date column and an amount column, I would like the amount cell to be blank if the date cell in the same row is blank.  Otherwise, the amount cell would display the predefined content.  I know there is conditional formatting but that is not really helpful in this scenario.  The key would be for cell specificity versus the entire column.


    Thanks in advance! 

  • [deleted] replied

    Hi Randy,
    Thank you for your inquire.

    Unfortunately we do not have feature like this built in at the moment. If you just want to hide some values in the frontend and you are skillful with code you could possible do it with JavaScript. If you are using standard table preview (and not Excel-like) frontend engine behind the scene is Datatables jQuery plugin. They have built in callbacks which allows you to manipulate the data like - rowCallback. Our plugin renders standard HTML table in the fronted so any solution which will remove data from one cell based on the data in other will work

  •  1
    Randy Colbert replied

    Thanks for the really quick reply Miljko.  In reference to your mention of Datatables jQuery plugin, are you saying that it is possible to use the plugin in parallel with the WPDataTables plugin to accomplish this additional functionality or that Datatables jQuery plugin is already being used as the frontend engine and that it is what can be manipulated using JS?  Sorry if this is a silly question, I just want to make sure I understand you completely.


    Thanks again Miljko!  

  • [deleted] replied

    Hi Randy,

    Sorry for not gave you a clearer answer in the first place. I meant that Datatables is already being used as frontend engine and it can be manipulated from the frontend with JS by using their built in callback function or vanila JS 

  •   Randy Colbert replied privately
  • [deleted] replied

    Hi Randy,

    Based on data source that you plan to use it can depend what would be more appropriate for conditional showing of data but in most cases JS developer should be able to do it. 

    We are offering customization services for our customers for both JS as well as PHP tasks (and some more :-))

  •   Randy Colbert replied privately