Calculate fields that have text and numeric values

  • bfawcett
    Asked on August 20, 2016 at 12:00 AM

    I want to know how to put a total amount of the fees on the form. The way i have the form set up, the amount is in with text  and will vary depending upon what instrument they rent and if they select to also include the supply pack. For grades 6-8, they can rent more than one instrument so need to account for that as well. https://form.jotform.com/62210966277964

     

    I would like to allow the person to add additional children. i only want the extra fields for additional children to be added to a form, if the person filling them out needs them. How do i set that up with the fewest number of columns (so the response spreadsheet is not unwieldy to work with).

    Finally,

    the form looks awful in the student info area (columns and fields not aligned) until the person selects the grade - i do not like that - please advise on how to fix.

     

    Thanks,

    Pam

     

  • jonathan
    Replied on August 20, 2016 at 1:12 AM

    Hi Pam,

    I think what you want to use is the feature Assign Calculation Value to the selection fields (i.e. Radio button option)

    User guide: How-to-Assign-Calculation-Value

    See this screencast video also.

    Calculate fields that have text and numeric values Image 1 Screenshot 20

    You can use the assign value in the field in calculations.

    Let us know if you have further question on this.

    --

    Since the 2 other questions were about a different feature, I created a separate thread for them here

    https://www.jotform.com/answers/911343

    https://www.jotform.com/answers/911341

    We will attend to each as soon as we can.