Get values from NON related apps/workspaces
Hello,
I have an app which holds a holidays database grouped by month. I need to get those holidays from another app that is on a different workspace. When I type '@' to get fields on a "Calculation" field I only get fields from that specific app.
Is there any way, through javascript, to get fields from other workspace apps?
Thanks,
Eduardo
-
Hi Eduardo.
it's no problem to get values from apps which are in different workspaces - as long as the two are related (either via a relation field in App "HolidayDatabase" to "AnotherApp" or vice versa).
If they are related type in the calculation of "AnotherApp":
@all of NameOfWantedFieldInAnotherApp
If you want to use the result as a "standalone" you have to write .join() behind the field token in your calculation field (like: field1.join()
If you use it like field1 + " " + field2 the .join() isn:t necessary.If the apps are not related you can't get the holidays into your calculation field (only via the API with an extension like Globiflow).
For getting number fields you can also use instead of "all": sum, avg, min, max, for date fields min, max.
Rainer
-
Hi, Rainer,
Thanks for the answer but that's the point I mentioned on the post title. I want to make calculation between NON related apps. I don't want people referencing items by themselves because of two reasons: they might forget to actually do it and they might do it with the wrong items...
Would you have any other out-of-the-box suggestions?
Please sign in to leave a comment.
Comments
4 comments