Is it possible to populate a spreadsheet wizard based on answers in the same form?

  • Profile Image
    niclawrence
    Asked on March 06, 2018 at 07:21 PM

    I want to have a form filled with yes or no questions, some of which have a 'if yes, enter number of hours condition. I was hoping to include a spreadsheet widget at the bottom of the survey in order to give a quick summary of the answers (i.e. show all yes's or no's and a number of hours for the yes's). It needs to be in the spreadsheet wizard to so that I can do some calculations (hours*cost per hour etc). 

    Is it possible to use the answers generated in a form to fill a spreadsheet within the form itself?

  • Profile Image
    Welvin
    Answered on March 06, 2018 at 10:02 PM

    Unfortunately, the spreadsheet widget cannot do that. The widget is used to populate fields using a passkey/code. A workaround would be to use the calculation widget to get the costs, etc. Then use our Text Field to create a summary. You can customize the text field to have a table.

    In the text field, you have the option to insert field tags to show inputs in it:

    Here's a demo:

    https://form.jotform.co/80648288220863 

    For calculation: https://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    Let us know if you need further assistance. 


  • Profile Image
    niclawrence
    Answered on March 07, 2018 at 08:50 PM

    Thanks, that is very helpful and I will be using that method. A further question based on the above, is it possible to add this text table to a PDF export as is? The format of this table is the way i would like data to be reported

  • Profile Image
    Welvin
    Answered on March 08, 2018 at 12:30 AM

    Yes, you can include this text in the PDF output. You can even have it alone by unchecking the other fields in the submissions settings.

    You need to check Show Headers and Texts in the settings to show texts, images, and headers in the PDF output: