โ04-24-2023 01:52 PM
Hey all, so I'm having some issues, with some logic on my recipe.
The ultimate goal is this: Search Box for existing Year folder first, if there then search for next variable, ClientID, if there then search for MoDaYeBox Folder (All folders based on Airtable fields)Once all those folders are found and or created if NOT found, then finally, a Box shared link is created, and then pasted into an Airtable field (Box Link).
That's the recipe above. The problem is, when search DOES find the folder, how will it know to NOT create the folder, but stay inside that folder as the new parent folder?
Year folder, then ClientID folder, finally, MoDaYeBox folder.
From that final MoDaYeBox folder, a Box shared link is generated.
Then that box link is pasted into an Airtable field.
Any ideas how to proceed differently? Right now I get 404 errors because the previous Folder ID doesn't exist, even though it does.
โ04-24-2023 02:19 PM - edited โ04-24-2023 02:21 PM
It's all mostly in place, I think you just need to implement more variables to store the "ID to use" for each tier regardless of whether that ID already existed or was freshly created.
โ04-25-2023 03:36 PM
I will build upon that. I knew I was missing something, just wasn't sure what it would be. A few of Workato team built over the top of one of my attempts, and it didn't work either, so I got increasingly frustrated. Used if statements, then if/else, but each trial failed.
I really want to write this correctly, as it'll save a lot of time in the long run of a lot of manual work.
Thanks! I'll give it a whirl, and let ya know!
โ04-25-2023 04:07 PM
Based on your initial screenshots, you're very close to having this working. I'm a bit surprised that someone from Workato wouldn't be able to resolve this. If you keep providing updates, I'll help get you over the finish line!
โ04-25-2023 03:41 PM
So when you say implement more variables, you mean create new ones and not write over the initial ones, as they store what Airtable has and would be used eventually in the recipe?