I have some calendar events that I’m importing into Panorama X using a procedure.
The events have an ID, but sometimes they may have more than one. So the id field is really a textarray that might look like any one of these examples:
aaa;bbb
ccc
ddd;eee;fff
When a new event comes along, I’d like to check if it’s already in the database - e.g if any one (or more) of its ids appears.
I wanted to do this using arrayboth:
local newItemToAdd
newItemToAdd="ccc;xxx;yyy"
find arraysize(arrayboth(A,newItemToAdd,";"),";") > 0
I was expecting that this would find the “ccc” row, above. I’ve tested the formula outside of find, and it does work (displays a 1 for the matching row). But it doesn’t work in a find statement. The error I get is:
Find Formula Error “cache( unable to access formulalocal variables”
Is there a way to use arrayboth in a find statement? Or is there a good workaround I can use?
I’m considering using looparray, but it feels a bit messy to do this, and it would be nice if there’s a better way.