Okay
  Public Ticket #2782783
Formula
Closed

Comments

  • Darren started the conversation

    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

    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 | 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