New expression: INDEXOF()

[Marc_Dillon]

INDEXOF(item,list) : Returns the index value of item in list.

Example:

INDEXOF( “g” , LIST( “t” , “h” , “g” ) )

returns 3

[GreenFlux]

Agreed, we could really use this function. I’m out of votes though.

What if the value occurs in the list more than once?

Return the LIST of positions, or the first occurrence’s position?

I’d also like to see an optional 3rd parameter for starting position.

This way you wouldn’t have to SPLIT() the list first if you want to search from somewhere in the middle.

[Jonathan_S]

Limited to Votes,
But Im voting on this in my Heart.

[Vigneshvaran_G]

i have two tables table 1 and table 2 i need the value of column(maildId) from table1,that are not present as part of table2
note :both tables can have same mailId

Can you help with expression??

[Koichi_Tsuji]

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

Test dereference

[Vigneshvaran_G]

no not like this
i want to select a list and display that list in dropdown here is my condiiton:
Select(Environment[custrName],Environment[customerMailId]<>CustomerComplete[CstMailId])

but this aint working

[Koichi_Tsuji]

Vigneshvaran_G:

Select(Environment[custrName],Environment[customerMailId]<>CustomerComplete[CstMailId])

This syntax is incorrect and does not make sense.

[Vigneshvaran_G]

No am not facing any syntax error

syntax is fine but am not getting the expected result
can you help out
Select(Environment[custrName],Environment[customerMailId]<>CustomerComplete[CstMailId])

[LeventK]

@Vigneshvaran_G
You may not be getting an error, but your SELECT(…) expression syntax is not correct.

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[WillowMobileSys]

Really could use this today to apply ranking! I found the workarounds and will try one of those.

[Rifad]

Any updates on this ? 

[AleksiAlkio]

COUNT(SPLIT(INDEX(SPLIT("A,B,C,D","C"),1)," , ")) should do the trick.