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 #2614085
Formula column with front-end editing table
Closed

Comments

  • Saulat started the conversation
    November 27, 2020 at 5:44pm

    Hi,

    I'm having few issues / have some questions. Any help will be appreciated.

    • Is there a way to autofill a column based on another column of the same table? In a front-end editable table, I want the user to select one of the value from the list in column A and based on that selection, the value in column B should change. The user is selecting a string in Column A but I need an integer to be use in a formula, so I was thinking if that selection in column A can auto-populate an integer value in column B, which I can then use in a formula.
    • In a formula column, I don't see a way to enable calculation function. I need to put the total sum like its possible in a normal integer column.
    • Does formula work on data from another table. I have a main table which has a list of order and I want to add all of them and simply display the total order value out side the table on the same page. The idea is that the total should be bold on the page to tell the end-client that the total order value is this much, and then the table below on the same page will have the breakup of all the orders.
    • The general settings have a color setting but thats applicable to all the table. How can I change colors/fonts of one single table instead of all?

    Thank you!

  •  2,576
    Aleksandar replied
    November 30, 2020 at 11:55am

    Hello Saulat

    Thank you for your purchase.

    1. I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.

    There are no conditional editing options between columns. You can only add some Conditional Formatting for values in a column, but not between columns.

    2. Unfortunately, like noted in our documentation, using calculation functions in formula columns is not possible.

    3. I'm not sure I understand the question. If you're using the Foreign Key feature to pull the data from another table, Formula columns will not work because foreign key columns are basically "String" type columns, and their data can't be used in formulas.

    4. Changing the colors of individual tables can be done only with some custom CSS. We will work on adding new options, so you can style tables individually, but I can't say when that will be included in the provided features of the plugin.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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