Configurable list widget: put a formula in the Total column

  • cwec
    Asked on October 12, 2021 at 2:51 AM
    i would assume they would want (and i have interest as well) for example

    column 1 x (or +/-) column 2 = the answer to be placed in column 3

  • Tommaso_F
    Replied on October 12, 2021 at 2:54 AM

    Hi, thank you for contacting support.

    Could you please give us more details about your concern so we can assist you properly?

    Unfortunately, your description doesn't let us provide the best support. Could you please rephrase?

    We look forward to your response.

  • cwec
    Replied on October 12, 2021 at 4:28 AM

    Hi Tommaso

    Using the configurable list widget

    For example

    Qty : 2

    Price: $4.00

    Total:

    Is it possible to put a formula in the Total column?

    Total : qty x price (gives the answer) $8.00








  • Tommaso_F
    Replied on October 12, 2021 at 5:02 AM

    I would like to inform you that, unfortunately, you can't do a calculation in configurable list widget. Since there is an Add button on the widget, the value of the second, third, fourth, etc... that is added is already hard to get.

    However, you can achieve your requirements using basic fields and then show/hide fields based on user response.


    So let us know if you have any other questions.

    Thanks.