Is there a shapesheet function to parse arrays?

[healthNut]

I'm trying to check if a Shape Data  choice (Prop.Specialty) is a match in an existing list of strings (User.Specialties).

Currently, I would have to do:

Code Select Expand

OR( STRSAME ( "Prop.Specialty", string1 ), STRSAME( "Prop.Specialty" , string2 ), ... )
This is tedious due to the
-Repeated STRSAME calls
-the manual string entries
-this check is repeated in multiple places

It is ideal if I could:

Code Select Expand

OR ( Iterate through Specialties Array (STRSAME ( "Prop.Specialty", Specialties[ i ] ) ) )

This could be done in Code but I'm trying to stick to shapesheet formulas to keep it optimized

[healthNut]

Found Index() which helps but still have to manually iterate through list

[Jumpy]

The trick is to use INDEX together with LOOKUP.

[healthNut]

Thanks for lookup, playing with it right now.

[HRGunn]

Thanks for lookup, playing with it right now.

Hello healthNut,

Did you find a solution for this?

[healthNut]

Yes

Code Select Expand

=IF(-1<LOOKUP(User.Specialty,User.Specialties),TRUE,FALSE)

[Yacine]

Better never than too late?

[healthNut]

Haha, I'm a finisher!