how to reference in a calculation a related field but coming from multiple workspaces.
Hi, I'm getting an error if I do a "all of Name.join("/")" calculation field if the referenced items can come from multiple APP's but only one is related. The error is "invalid value "" (string) must be at least 1 character long."
I think the errors comes from the fact that I get "All of Name" from each workspace and I make only one relation ...so 1 result is OK but the others are empty. How can I filter this to not get an error?
It works fine if I make the Relationship to only one app.
But I want to on a global Workspace a kind of Summary App referencing the different apps on each workspace ...
-
I am not sure if this suggestion will help, though you might want to check out Andreas Huttenrauch's (andreas@globi.ca) globiflow/globimail (globiflow.com and globimail.com, specifically http://www.globimail.com/blog/podio-super-menu.php)
-
I was able to solve the same issue by testing each entry to be valid:
var tmpExpID = @All of Experiment ID + '' ? @All of Experiment ID + '':@All of Experiment ID2 + ''; tmpExpID
In this case @All of ExperimentID and @All of Experiment ID2 were both apps that were set in a single relationship with the current app.
The addition of + '' was necessary to prevent the empty responses from causing an error. Not sure why but I assume it has something to do with denoting that the value is a string. Hope this helps.
Please sign in to leave a comment.
Comments
2 comments