Concatenated summary text field using Update/Calculate Field

  • Profile Image
    lisascy
    Asked on January 04, 2016 at 01:47 AM

    I'm trying to build a summary where it will list all the questions which the applicant answered yes to. Therefore I have the conditional logic that if Wages is Yes, then calculate "{Summary} Wages" to the Summary field. However, it seems to be doing it recursively so I have Wages Wages Wages numerous times. How do I fix this?

  • Profile Image
    beril
    Answered on January 04, 2016 at 05:00 AM

    Can you try to change your condition as you see below?

    I hope it works.

    In addition to that I suggest you to check our Preview Before Submit Widget.

    http://widgets.jotform.com/widget/preview_before_submit

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.

  • Profile Image
    lisascy
    Answered on January 04, 2016 at 05:46 AM

    Thanks for the suggestion,beril, but that won't work because I'm trying to add many strings to the summary field, i.e any question that is answered with a yes... So the end result can be a long cumulative string and not just from one field.

  • Profile Image
    beril
    Answered on January 04, 2016 at 05:53 AM

    You are kindly welcome. At that situation, you can choose Copy Multiple Field Values as you see below.

    I hope it works.

  • Profile Image
    lisascy
    Answered on January 04, 2016 at 06:47 AM

    Hmm that doesn't really work in my scenario either because all the other fields return yes or no so i need to look at conditional logic e.g if evidence is yes then add "evidence" and if Tax file number is yes then add "tax file number"

  • Profile Image
    beril
    Answered on January 04, 2016 at 08:52 AM

    Yes, you're correct. When you use like that it will show just Yes. You can add your tax file number as you see below:

    To solve this, your can choose more specific options instead of yes or no.

    I will research about your issue and try to find better solution.

    If I find better solution I will update you via this thread.

  • Profile Image
    lisascy
    Answered on January 04, 2016 at 07:00 PM

    Thanks Beril, hope you can find something. :)

  • Profile Image
    jonathan
    Answered on January 05, 2016 at 12:21 AM

    Please test this form https://form.jotform.com/60040056018946

     

    Will this work for your requirement?

    You can also clone the test form so that you can review on your Form Builder how I setup.

    user guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    We will wait for your updates.

     

  • Profile Image
    jonathan
    Answered on January 05, 2016 at 12:22 AM

    I used the feature Assign Calculation Value.

    user guide: http://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Thanks.

  • Profile Image
    lisascy
    Answered on January 05, 2016 at 12:38 AM

    Thank you Jonathan!!! That will work perfectly in my scenario, so thank you so much for that. I was actually wondering how the calculation value for the fields work and this is great. :)

  • Profile Image
    beril
    Answered on January 05, 2016 at 02:25 AM

    On behalf of my colleague @Jonathan, you are kindly welcome. We are glad to hear that the issue is resolved for you.

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.