Form Calculation widget - how to apply line breaks

  • oliver771
    Asked on February 20, 2024 at 3:08 PM

    Hello,


    I have seen various threads on this but can't seem to find my error. I am using the Form Calculations Widget to get my form submissions into Trello, but they come through sequentially inline and I would like them in a column with a line break between each answer. In other threads, I read that you could use the <br/> or in another thread <br> to add a line break, but I can't seem to get that to work...

    Form Calculation widget   how to apply line breaks Image 1 Screenshot 30


    gets me this...

    Form Calculation widget   how to apply line breaks Image 2 Screenshot 41


    Any help appreciated.

  • Lesther JotForm Support
    Replied on February 20, 2024 at 3:32 PM

    Hi Oliver,

    Thanks for reaching out to Jotform Support. You should use the forward slash (/) when adding the HTML tag <br/> and should not be attached to other words because it will not read as code, but as regular text. For example: <br/>Broker

    Applying what's mentioned above, see the image below for what it looks like. The Form Calculation widget will not display the line breaks, so I added a Long Text field where it fetches the value from the widget to demonstrate the outcome.

    Form Calculation widget   how to apply line breaks Image 1 Screenshot 30

    To separate the tag from other texts, click on an empty space in your form after you type in the code. It will create a block of text, then start typing in the following text to display. Here's the screencast of my demo form:

    Form Calculation widget   how to apply line breaks Image 2 Screenshot 41

    Clone my form to own a copy and be able to see the entire setup. Here's How to Clone an Existing Form From a URL.

    Let us know if you have any other questions.

  • oliver771
    Replied on February 20, 2024 at 4:42 PM

    Thanks so much for your quick and clear response. Small errors. However, I believe I did what you said and my result was the same. Trello Integration error? After trying a few times, I decided to swallow my pride and import your form, but it said access denied when I pasted the URL. Perhaps I need to create a long text field with the full description and then map that to Trello rather than results of the form calculation...?

    Form Calculation widget   how to apply line breaks Image 1 Screenshot 30


    Form Calculation widget   how to apply line breaks Image 2 Screenshot 41

  • Lesther JotForm Support
    Replied on February 20, 2024 at 5:15 PM

    Hi Oliver,

    Thanks for getting back to us. I apologize, I didn't change the settings that prevent cloning the form after I cloned yours. But you can try and clone my form again, you should be able to clone it this time. I edited the form and applied my suggestion below.

    You're also right to add a Long Text field to concentrate the values from these multiple fields, and then map it to Trello. Now, I'll show you how to arrive at the same result without using the Form Calculation widget. Use the Update/Calculate Field condition with the same formula that is used in the widget.

    1. On the Form Builder page, go to the Settings at the top navigation bar.
    2. Open the Conditions tab on the left and select Update/Calculate field condition.
    3. Add a condition that:
    4. IF all the 7 fields (that need to fill out)
    5. STATE: Filled
    6. IF All OF THE “IF” RULES ARE MATCHED
    7. DO: Calculate Field Value.

    Enter the same formula as in the Form Calculation widget. See the screencast below:

    Form Calculation widget   how to apply line breaks Image 1 Screenshot 20

    I edited my form and applied my suggestion above. Clone it after you receive this message to see the updated version. Here's How to Clone an Existing Form From a URL.

    Let us know if you have any other questions.

  • oliver771
    Replied on February 20, 2024 at 5:21 PM

    I should probably try this before asking - but just in case it's a quick yes or no


    With your solution above, do ALL of the fields need to be filled out, or does the statement mean IF a field is filled ADD it to the calculation.


    (As you can tell, I don't have the mind of a programmer)


    Oliver.

  • oliver771
    Replied on February 20, 2024 at 5:31 PM

    I just copied the form. I guess I need a conditional statement that says "IF ANY is filled then INSERT "ordered by...


    Is that a valid conditional statement?

  • Kyle JotForm Support
    Replied on February 20, 2024 at 5:34 PM

    Hi Oliver,

    Thanks for getting back to us. The IF Conditions that were suggested by my colleague, Lesther, only apply to the 6 fields that were included in his example. Please follow the steps provided by my colleague.

    Give it a try, and let us know how it goes.