Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #2782783
Formula
Closed

Comments

  • Darren started the conversation
    May 21, 2021 at 10:49am

    Hi there,

    We've got a woocommerce site and when editing a product our client has asked for the following:

    The following fields:

    Height: Width: Depth:
    These are purely for info only and don't relate to shipping etc.

    So when they add values to the fields it then converts them into another field as follows

    Height:  118 (this is in CM) -> converts in second field to 46.5 (this is in inches)
    Width: 450 (this is in CM) -> converts in second field to 177.165 (this is in inches)
    Depth: 200 (this is in CM) -> converts in second field to 78.74 (this is in inches)

    The screenshot below is from their current custom website, which hopefully explains the above better.

    Is this possible to do?

    Thanks,
    Darren

  •  2,572
    Aleksandar replied
    May 24, 2021 at 11:30am

    Hello Darren

    Thank you for your interest in our plugin, and sorry for the late response!

    What I see from your screenshot looks like a form, or simple fields with basic calculations. wpDataTables is a data table management plugin, and it can only work with tables, so something like this is not possible.

    You would be able to create a front-end editable table, that would contain a formula column that would automatically calculate these measures in inches. However, in your screenshots, they are configured as rows, which can't be implemented correctly in wpDataTables. 

    There's no fixed column you could add, that would have 3 fixed rows (for height, width and depth), so these would have to be entered by the user, without having a label on the left, telling them which row is for which measure.

    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