Help with some detailed calculations
Hello,
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.
Cheers,
Stephen
-
Hi Stephen,
You need to perform a few steps to achieve this:
// Create JSON/Concatenated string in app B with all needed fields
// Pull the json data in app A from app B
// In app A you need to iterate our json data and parse it
// Perform required checks that fields are selected and date range is given
// Can display results/count whatever you need once you filtered out results
- Bajarang
Please sign in to leave a comment.
Comments
1 comment