Is it possible to create a form with formulas like a spreadsheet?

  • Profile Image
    archivalarts
    Asked on October 15, 2014 at 01:21 PM

    We currently have a pricing calculator created in Excel that has some semi-complicated formulas.

    Many of our customers won't use it because they see it and are afraid to use it, or they type in the wrong cells and ruin the spreadsheet.  I can't lock individual cells to keep people from ruining the form.

  • Profile Image
    Shadae
    Answered on October 15, 2014 at 02:16 PM

    Hi archivalarts,

    To confirm, you would like to know if it is possible to have a spreadsheet in your form with calculations?

    If that is the case we have a spreadsheet widget that you can place in your form. The calculations will not be changeable by the user as it in done in the back end.

    Spreadsheet Widget

    I hope this is suitable for you. Please inform us if you need further assistance.