How to check if a parameter value is an arrray? | Community
Skip to main content
R
RobertDy
Level 3
January 10, 2024
Solved

How to check if a parameter value is an arrray?

  • January 10, 2024
  • 2 replies
  • 1391 views

Hi, 

In a Fusion Tools Module I'm trying to set a variable with the first item selected in a multi-select dropdown. However, if only one item is selected, Workfront returns the value as a string rather than an array with one value. This is quite frustrating, but I thought I'd just check to see if the value is an array or not, but there don't seem to be any functions to do this.  I've tried length, but that just returns the number of characters if a string is returned.

Does anyone have any advice?

Rob

Best answer by ChrisStephens

You can do something like this

 

if(length(get({variable};1))>1,array,string)

2 replies

ChrisStephens
Community Advisor
ChrisStephensCommunity AdvisorAccepted solution
Community Advisor
January 11, 2024

You can do something like this

 

if(length(get({variable};1))>1,array,string)

    R
    RobertDyAuthor
    Level 3
    February 15, 2024

    @chrisstephens 

    Sorry, I missed your reply. Thank you. I hadn't seen the GET function, this is useful. 

    I know this is a different question slightly... but is there such a function like isArray()? to tell whether the value returned from a multiselect is an array or not?

     

    Currently I use join() using an obscure separator, then I check for the existence of the separator. That's all I could think of.

    F
    FranciscoRuiz
    Level 2
    July 27, 2024

    Hello -

    I've also run into your problem:  multi-select field values are returned as an array if more than 1 item is selected, but as a text string if only 1 item is selected.  In my case, I want the field value to always be an array, but Fusion offers no way to check if the the field value is a string or an array.

    So what I did was:

    (a) convert the field value to a string

    (b) check if that string begins with the left-bracket character "[" which indicates that the field value is an array and therefore is already in the array format I want

    (c) Otherwise, the field value must be a string, in which case I convert that string to an array by splitting it by a delimiter character such as vertical pipe that the string does not have, forcing the string into an array of 1 element.

    Putting this all together, the formula is as follows, which will ensure that the field value is always returned as an array:

    if(contains(toString(FIELD_HERE; "[") ; FIELD_HERE; split(FIELD_HERE; "|")))

    I hope that helps.

     

    Terms & ConditionsAccessibility statement

    Loading footer...