Question about pulling data from a spreadsheet

  • Profile Image
    FASMoeller
    Asked on August 08, 2020 at 10:19 AM

    Hello


    I haven't built the sheet yet but have played with several widgets.

    I'm trying to create a price quoting tool that is based on age, dollar value, type of program, male or female  and they smoke.

    Formulas are not consistent so a data grid would be necessary.

    Can you point me in the right direction?


    Rick Moeller

    rick.moeller73@gmail.com

  • Profile Image
    Vanessa_T
    Answered on August 08, 2020 at 11:11 AM

    If you require data grid, I would suggest you take a look at the Spreadsheet widget.

    https://www.jotform.com/widgets/spreadsheet

    However, based on your requirements, I think you can just simply use regular fields, then assign calculation values to them which can be used by the Form Calculation widget.

    How-to-Assign-Calculation-Value

    How-to-Perform-Form-Calculation-Using-a-Widget