Calculation returns unexpected result: out_267142583_267142620

I'm trying to use a calculation to display text from one app in another app. But the calculation results i'm getting looks like this: out_267142583_267142620. What am I doing wrong?


  • Remove the quotations marks. Never wrap the blue variable tokens in quotes.

    Also:

    1) @all of field name returns an array. You must parse it to a "readable" string by adding .join() or .toString()

    .join() allows you to define the separator between multiple items that are returned by @all of ... , while .string() always sets a comma. A comma is also the default separator for .join(), if you want a semicolon: .join(";") , if a line break .join("\ņ")

    If there is always only one item related, it doesn't matter which one you use:

    @all of field name.join() or @all of field name.toString().

    2) "with nulls" returns also those fields that are empty. You only need "with nulls" for specific use cases.

    Selected as Best
  • Usually that error occurs if you made a typing mistake. Can you please share a screenshot of your calc field?

  • Remove the quotations marks. Never wrap the blue variable tokens in quotes.

    Also:

    1) @all of field name returns an array. You must parse it to a "readable" string by adding .join() or .toString()

    .join() allows you to define the separator between multiple items that are returned by @all of ... , while .string() always sets a comma. A comma is also the default separator for .join(), if you want a semicolon: .join(";") , if a line break .join("\ņ")

    If there is always only one item related, it doesn't matter which one you use:

    @all of field name.join() or @all of field name.toString().

    2) "with nulls" returns also those fields that are empty. You only need "with nulls" for specific use cases.

    Selected as Best