Feature request: Option to add space in calculation widget

  • Profile Image
    Asked on March 11, 2014 at 10:40 AM

    In this test form I have used the calculation widget to build a field containing a mixture of text, field contents as strings and a calculation (the product of the two fields referred to).

    In the text part I want a space before and after each of the field contents. When I first built the calculation the result came out without this spacing. The field contents were absolutely adjacent to the surrounding text with no space before or after them. In order to obtain the space, I have had to insert two spaces at each of those points.

    Watching the line where the resulting formula is shown, the first space before or after a field does nothing to the output, and only susequent consecutive spaces get shown.

    This is annoying (but livable with). Could it be corrected, please.

  • Profile Image
    Answered on March 11, 2014 at 11:28 AM

    Hello NRCsupport,

    Do you mean to say that when you concatenation two sting together, you need a space in between the two texts in the calculation widget?

    I am not sure but this is how the string concatenation works :)

    I have created a feature request ticket and forwarded it your request to our back end team. We will get back to you as soon as we have any update from them.

    Thank you!

  • Profile Image
    Answered on March 11, 2014 at 03:50 PM

    No the problem is not when concatenating two strings, it is when you have a field in string mode adjacent to a literal string, and require a space between them. If you place a single space at the end of the literal string (or at the beginning if the literal string follows the field in text mode) it appears to be ignored. If you put more than one space there, all but the first one are shown correctly.

    If you look at my example there is a field showing

    "1 places at 12.50 each. Total cost = £12.50"

    Initially it came out like this:

    "1places at12.50esch. Total cost = £12.50"

    with no space before "places", after "at" or before "each".

    I had inserted a space at each of those points when building the formula. In order to get the output to appear with spaces, I had to insert two spaces at each of those points.

  • Profile Image
    Answered on March 11, 2014 at 06:39 PM


    Thanks for the clarification. I have added a note on the request ticket with your latest details.


  • Profile Image
    Answered on March 12, 2014 at 10:49 AM


    I'll check it out on my form later.

    Great service yet again!!