• Profile Image
    Asked on February 16, 2016 at 04:14 PM

    I have a form w/ widget in it. My client wants to have the product cells split up to have the product amount and product cost in two separate cells in the excel form. I have attached what I get when it outputs to excel. Is it possible to split them up, or can you think of a way to do this? I'm trying to rack my brain how to edit the widget or figure out a way around it.


    This is what they are looking to do, this is from a current excel form...

  • Profile Image
    Answered on February 16, 2016 at 10:03 PM

    I do believe it is not possible to separate the output of the widget in the spreadsheet. However, a possible workaround would be to add 3 fields that will display the required data from your form. Simply follow the steps below:

    1. Add the three fields that will display the data 

    2. Set the default value of Amount field to 5

    3. The data captured from the widget will be the total price, so to display the packet instead, you will need to perform a calculation for the Packets field. The input field is from the widget, and we will divide that with the amount field to get the number of packets. Here's a guide to help you set it up: How to perform calculation in the form?

    4. For the Total field, you can simply capture the data again from the widget.

    5. After that, you're all set. This is how the fields should appear.

    You can check out this cloned form to see it in action:

    To clone the form to your account, simply follow this guide: How To Clone A Form

    Do let us know if you need further assistance.