I'm having trouble getting my head around how i could make this work, does anyone know the code?
We have App A that has 200 entries each with a unique ID in Workspace A. For each unique ID we need to pull data from App B in a workspace B. App B currently references App A, so they are linked. From App B we want to query each of the unique IDs from App A and count or sum the number of occurences that unique ID appears in App B with certain criteria. The criteria is looking at field 1 to identify the type of category then checking field 2 again identifying another category and the third part of the criteria is looking at a date field to see if the date is in the current quarter of the year.
The next thing we need to do is for each of the unique IDs in App A in App C we're looking to retrieve a date field.
Any help would be much appreciated.
Please sign in to leave a comment.