Attempting to do logic on data, custom formulas?

How To
,
1

My goal - to update our Monday.com instance to show the “next operation” for jobs once an operation is completed. We are using our ERP (fulcrumpro) to pull the data from.

I am using a webhook for when an operation is completed, and the webhook seems to provide all of the data that I actually need.

I’ve tried to make various series of API calls to get what I need but I’m still struggling to produce the “next operation” without any luck

My current attempt is to try to do logic on my dataset.

I’m trying to take the operation reference name:

image

Use that name to find the entity full routing step number

image
image384×616 21.1 KB

Increment the step by 1 and return the operation (if it exists, do nothing if it’s the final operation)

image

I’m still very new to utilizing API’s and make.com. So I’m not sure if there is an easy way to do this. Potentially a custom function?

Include screenshots of

  • your scenario setup (functions, mappings, variables, etc.)
  • module configurations and outputs
  • any error messages you are getting
3

Hey Jimmy,

From my understanding, it seems like you want to use the name from the operation Reference to extract and search this steps array, to find the name of the next step. In your example “Stud Weld”?

This IML function would return the name of the next step:
image

Here is the blueprint of my example, so you can import it and understand better.
blueprint (3).json (6.3 KB)

I will break down the IML step by step

Step 1: Map your steps array by Name (here I used Operation.Name, just confirm these are the “raw” values in by downloading the output.

Step 2: Convert this list of names into a string (join step 1 with a comma)

Step 3: Replace the part of the string where the Name = the Name from your Operation Reference (in my screenshot this is TIG_WELD, in your case it would be TIG WELD, but this would be dynamically mapped in your real scenario)

In my IML I am replacing it with “PLACEHOLDER”, but you can replace it with anything string (as long as it will never be the name of a step)

Step 4: Now split this string by the temporary value + ,

Step 5: Get the last item from our output list from step 4 (this will include the next step we want)

Step 6: Split the last item by comma

Step 7: Get the first item from Step 6

Output for each:
image

If I didn’t understand your question properly, please let me know

4 Likes
4

Thank you so much for helping me with this! I will start digging into this right now to see if I can take the information you’ve given me and digest it.

5

This is working perfectly!! I can’t thank you enough. I was spinning my wheels on that little problem for a couple of weeks now.

3 Likes
6

No problem, glad this helped you out

3 Likes