On Demand Webinars
Integration & automations in monday.com with Make (2021)
460 views
View transcript
Very much. Welcome to tonight's webinar all today about Integromat And monday.com in combination and actually building on top of the capabilities which are already good with monday.com. But that can be fantastic bit of use of integromat on the side as well. So stick around uh, towards the end. And I will also share with you a rather nicely present at the end. And this is only for those of you who are actually here with us tonight. Most of you know me, I'm Fredrik Kastenholm, I'm the CRO. That means I'm the head of sales and marketing, basically here at Omnitas. Uh, and with me here today is Viggo Kalandaridis, which is one of our main top guys when it comes to automation and especially automation in integromat. Big to present yourself. Yeah. Thank you very much for the interaction. Very happy. Yeah. Nice meeting you all. Uh, I have, uh, some of you might recognize me from other webinars as well. Uh, I was attending or. Uh, yeah, I had one, uh, together with Thomas last week, for example. Uh, I had another webinar in September and one in June, but the one in June was in Swedish. So, uh, some of you might recognize me already from that. Exactly. Uh, yeah. You joined Thomas for his last webinar, and then you and me, the Fort Knox, one way back when. Yes. You are a repeat customer here with us. -Yeah. -I could say. So. Uh, we ain't going to take up your time much more with that. There we go. I want to take us away. Yeah, sure. So let's get started. First, let's talk about why we're having this, uh, webinar, uh, monday.com automation as they can do a lot, but, uh, we all, all of us who use monday.com, we also sometimes run into the limitations of the native automations where you think that, okay, if I could just add this one single thing to the automation, then all of this would be perfect, right? -Uh oh, yeah, I've done that. So. -Right. Why can't I do this? Yeah. So that is, uh, why, uh, this possibility exists, integrating with the integral model as well, so that we can extend the breadth of automations that are possible for us. And even import completely new logic. Right? Yeah, exactly. And, uh, the second reason then would be that sometimes you need to click a lot in a board that you have a lot of columns that are, uh, um, for some reason not able to automate with each other and so on and so on. And then you need to also fill in, like for example, if you have a we will look at this later. If you have a project board and you want to connect all of these items to a specific high level, uh, all of these kind of, uh, repetitive tasks we can build an integral model for and run it once you have to have the test over with. So similar to how you would run a script if you're into programing. And I think the third reason, the main reason at least, would be that sometimes the monday.com integration, uh, automation, uh, integration of uh or not complex enough, for example, if you integrate with uh, we will not do this a lot today. But for example, if you integrate with, uh, uh, for example, Facebook Live, then maybe the new very nice Facebook lead integration. I mean, it could fulfill most of what you want to do, but, uh, maybe you also want to pull in fields in a kind of different way or with a mapping, uh, that is not, uh, exactly what monday.com offers or what you want to do. -Some kind of calculation. -I have one for you. -Yeah. -But with the automation built within monday.com, you can do and functionality. Right. But you can't -do if or else. -Exactly that kind of stuff. So then we can make more complex automations and integrations with, uh, integromat as well. And also one thing that is very nice is that we can have no limits on which board we can fetch the information and put it in as well, while monday.com is a little bit more limited on it. So yeah, basically we can do this impossible automations. And uh, you can see here that I put this in a bracket because we will not go through it that much today. Instead, we will focus on live birth to, uh, capabilities. That's integral offers together with monthly integral modern uh, for those of you who have not used it before, it is a tool where you could. Yeah, kind of, uh, manipulate any monday.com data. You can receive a webhook signal from monday.com in a same way from a photo change or from a column change in the same way that you would from an automation and from that. You could do all kinds of stuff. So we have a few real world examples here. One is that is simply scheduled that straight after midnight, it's, uh, starts a certain, uh, chain of events. That is the most simple, uh, scenario I've ever built. Uh. -It's one thing. -Do this one thing, and it's scheduled for, uh, a specific date on a specific time. Then we have more advanced ones. The largest, uh, we built was actually not this one with 275 right before this, uh, webinar. We found an even bigger one that I had created that totally forgot about. How big -was that? Over 300 something. -322 modules. So to explain a bit to all of you, what you're actually looking at, all those colorful blobs is one module. So basically if we take the middle one and we first have a webhook, then we have a data retrieve a set of three data retrievals from monday.com, which we route to different places and spread out information, stuff like that, so they can get very, -very large. -Yeah. So here, for example, I mean, you in this scenario that we see here in front of us, then it will always go through these four first modules, and then it will pick a route and go through four more before it ends. But uh, as you can see then, uh, these can be quite large and uh, in a huge spider net, which if the one with a 300 and something was, for example, where we needed to check for a lot of conditionals, for a lot of data before ending up where we actually wanted to end -up the right. -Data in the end. Yeah, yeah. It also took a while for me to build that for over 300. I don't know how many hours I didn't count. So anyway, that's a brief introduction. And also basically for those of you who are completely new to it, it's a tool to integrate between different stuff. But also we can basically integrate monday.com into itself. And in the loop they're adding extra logic, which monday.com doesn't contain itself. Correct. And uh, I mean, right now we are talking about high picture stuff. We're looking at this, we will get down and, uh, into the specifics in a short while. So don't worry about that if you don't get it right now. So let's start with a simple automation that where we pull the item name in a monday.com board and we update it with another column field. I will show you in a example here. Yeah. So actually to explain to. All of you where we go is going with this, we are actually going to show you how to do this within integromat. -Correct. -Uh, so it's not showing you what can be done. It's actually showing you how to do it. So I will share my screen here now. And we can have a look at a monday.com board that I have prepared. So here we have a field in monday.com called project ID. Uh so my idea here is that we would, uh, fill in the project idea and then in, uh, so let's say that I fill this with a number like this, uh, theory, one. And then automatically we want this to fill in as project name. Tremendous heroes of, you know, so let's create that one together. Uh, so we don't have to do that manually. The first thing we do is that we open integromat also prepared here, and we go and open a new scenario. I'm just going to call it scenario one for now. So the first thing we want to do is to receive a signal from monday.com, uh, what we will use then if the webhook module, not the monday.com module at this stage, instead we will click on webhook down here and create a new custom webhook. We will add it and we call it. Scenario one I usually take the same as if in name, so I know where it belongs, and now it has created a webhook. But the webhook also received a URL endpoint for those of you who know what that is, but that is basically a way to send the information to where monday.com will send a signal to, so you can see that money will need to integrate outcomes like a impossible to remember ID. So we will copy this address to the clipboard by clicking here. And then we will go back into monday.com and we will tell monday.com when to send this thing lol. We click on in the integrations view here. On monday.com we click on webhooks. And we want it to be triggered when a column changes. So directly, when I put in a, uh, new, uh, project ID, I want it directly to end up in front of the name. So we click on that one and we, I always use another account, even though it's in the list here, because it's impossible to find the right one in the list. Um, and I put my webhook in here. Right. So I copy paste that, uh, sorry, I paste it in here and I click connect. So now many know where to send a signal. And now it asked me, when do you want to send it? I say, when we change this column and product ID and then we click Add to Board rate, it sets up in monday.com Let's uh, but we can hear that it's still listening inside of, um, integromat for the signal to be sent. So let's remove the old, uh, or let's add a product ID here. We would send a signal to integral mods that is right now listening. Um. Seems to take a little while sometimes. I didn't put it on. Oh, yeah. There we go. -You didn't run. -Run it. No, no, no, but it should just listen at this stage. Yeah. And now, uh, you said we want to run it in order to get the right metadata into the module. Right. This is a module I told you earlier. What? Uh. And I will show you later why we want metadata in here. So I will again trigger it by removing this value, because that is also the same as changing it. And then I will see when it pops into integromat. Sometimes it takes a little while. First of all, the metadata is what appears here. So now we received a signal. We want to see what it contains. Then we click on the fourth bubble up here. And we can see that this is basically a tree of data. So we see that the user ID of me who sent the signal or my user within monday.com we see the name of the project here project x, y, z. It's the same as the one in monday.com, project x, y, z. Uh, we also get something called uh, and this is very important pulse ID that's the one that we're going to use. Now we get the column ID uh, text where I put the uh, is basically where I put the, uh, um, you can also feed the column ID here if you have the developer mode on in monday.com So you know the exact ID for the column, uh, inside this board, and you get the title, and of course, we get the value, which is empty because I removed a value and then the previous value which will fill or to the one that I removed, I will try to remember not to speak so quickly now. So now we will, uh, change something within monday.com. So with, uh, what we do is that we click on add another module and we search for monday.com here if we find it and I click on it, what I want to do is to update a specific column. So I click on update column value. On a specific item. I go and select demo one here. Good. For the connection, you can have several connections to several monday.com accounts here, which we do at Omnitas. Board ID. So now I want to select the project overview I'm going to call it webinar. I will update the list of boards because what's nice and integral is that they actually get the names of the boards like this. So I can just, uh, type in PR to get to project. And with the project overview webinar here and I click on it and here we will start loading all the metadata for that board. First I will map in the item ID if the name of the pool ID that's why I said it was important earlier. So in order to change the same row that we actually sent the signal from, then we need to, uh, select the pools ID from the metadata that we received. And then what I want to change is what I specified here. So I want to change the name or the row. And I want it to become the new value, uh, which is actually I want, uh, new metadata in here. So I'm going to run it one more time approach with the existing webhook, because now I will see metadata from, uh, when I add a value instead, which is a bit more pedagogically logical pedagogical compared to, um, compared to using functions to retrieve it. So in here we have the new value, uh, 0002. It gives me also an example, which is very nice. And I put it in here. And then I want to have a space dash space. And then I want it to say the same, uh, name again, project X, y set of good. And I click add and I click okay. And so this is basically it I'm going to save this now. And then I'm gonna put it on a. So at any point now, it will run immediately. So let's go back to monday.com and do that. I'm going to put in fear of your fear free here for the third row. And then maybe up within a few hours of your funeral for where you see the magic happen. So we get 003. Pretty fantastic, for example. And zero for projects. Romeo and so on. So that's it. That's the first integration or automation, whatever you want to call it. Uh, have we, uh um, uh, received any questions so far? Uh, no. Just us and us. Not great. So let's pause the sharing for a little bit and look again at the next automation that we're going to do. Yeah. This would be an example of what we could do with integer mode as well, which is to automate quickly the automation, uh, to quickly fill in for a lot of items for a specific value. So, uh, in this example, then, uh, let me share the screen again. Yeah. Let's, uh, just empty all these projects and then we can show you how to fill them in. Even though we can do this specific thing with batch action. There is a there are other specific scenarios where we want to do this dynamically. And that's why it's always good to learn how to do it in integral models. So later you can do it with different conditionals as well based on routes. But uh, just to give you now a quick overview on how to fill in some uh, values, then we will select here a monday.com module. For example, lists. In this case, I want to list all the boards, uh, item. And uh, the board is called projects man or Vino project board. So I will go to, uh, demo one and put the limit on basically unlimited. Project board. Mano vino. What? Do we have it there? And here, uh, I want to output, uh, in order to save some time. When we run it, I only gonna output the, uh, uh, actual, uh, column that I'm later gonna change, uh, what we call again, it's called project overview column. Okay. There we go. And here we go. Okay. And then I'm gonna manipulate that column by updating it again. I select the update column values of a specific item module, and I select demo one. And it will be the same board. Uh, Project Dynamo. And, y'know. And, uh, the item ID of course, will be dynamic based on the ID that we're going to iterate through. So to give a little bit of background here, what if leaf sports item what you'll do if that it's will get all the items from a specific board, in this case our project board, and uh, iterate through them and then one at a time to the next, um, module. And here in this, uh, module we want to change the product overview and in it add a specific item. Let's see here we could we will add this one product. Or we could map the exact item ID like this which is the way I prefer it because then you can do it more dynamic. Right. And if you want to add more than just one item, then you could map in a whole array of items in here. For those of you that are advanced enough to know about arrays in remote, but in order to go through that now or need a whole second webinar, to be honest. Okay, now what we will do is one by one, we will fill in the item here with that specific link back to the overview to view in the overview column. I'm just gonna run it. And here we see that it takes one at a time. And we can also see it in a board where it just appears like that. And that is the basic principle behind how you could add values into, um, a board without, you know, clicking or copy pasting or doing anything. It goes the same for, for example, if you have a Google Sheet or an Excel sheet and then you want to map that into a monday.com board, then you do the same principle. It's just that you iterate through the sheet row, row, row wise instead, and then you find the correct item and fill in the value. So that was the shortest kind of introduction to how to do that. And then you can just build on it. Anything else that we have here? Uh, any other questions? We actually got a question. We can take it now and kind of an interval and, uh, let's, uh, Huang, uh, who wonders if if there's a weekday functionality like you find in Excel or actually in monday.com within, uh, that you can use from within, uh, -integromat. -Uh, integromat itself. The doesn't really have a weekday function, but I mean, it is something that you could calculate with the help of different functions inside. I've done that myself. So for example, if you have a time span of, uh, x amount of days, then you know that you always subtract two of them. And then if you have, for example, uh, you know, over specific holiday, maybe January 1st, then you can see the, then you can see the order of the days during the year. And the first day, of course, is, you know, the first. And you know that that one should be subtract that always and so on and so on. So it's a lot of you put a lot of if functions in there, which you can do in integromat. But that function itself is not -present I'm afraid. -Yeah, I know Luke has actually built, uh, that functionality for me and a client, uh, just recently where we actually picked out. So they have a very strict schedule that starts. So they know that certain things should always take place on the project day with a certain number. So project day one will always be the first day of the project, whether it's a Monday or a Friday. Then Project day two should not if they want it to Friday. Project day two is actually the Saturday. It's the Monday. So we needed to like loop those in and actually count that. And that is. Yeah. But uh you you're straight on point. That one. It's basically if else uh okay. Let's uh check the other uh, impossible automation. To answer you one. It's very, very doable. And Lucas did it for me uh, rather quickly. So when you got a hang of -it, you can sort it out. -Exactly. So let's, uh, monday.com have amazing formula columns, but sometimes for certain widget or use cases or even monday.com's own automations, then you need to have a number column instead. And it's difficult to do that uh, calculation by hand for all the items. So instead we will do that with integer mode. So we will do a formula that takes two values and put it in another uh number column. So let's get to it. We want to calculate the body. Here we have a formula column that calculates uh approved budget minus total expense. We want to do the same. I'll put the result here in a number column. Uh, instead here we have project budget and total expense, or here this is quite, uh, advanced one. Then because then you would need to also go to the board beneath and, uh, summarize all those numbers, but, uh, sure, let's do it. So scenario number three, I'm going to do this a little bit more quicker now so that hopefully we can have time to do another uh, uh, scenario as well. Uh, one asks if Integromat can actually operate towards -sub items. -Yeah, it can as well. -Uh. -What Vega is all about doing right -now. So, uh. -Anyway, yeah, I mean, the principle is the same. First of all, you can get the trigger from sub Python with both the webhooks here. But also, uh, you could find sub item through the principle that I will show you quite soon, uh, on how to find sub item and pull the data from there. So I will put this on, uh, when you change the budget, uh, I know it's a not the best, uh, trigger, but for now, it will do. And we are then going to. Yeah. It's listening. Good. So then we're going to change this to 450,000 right. Uh, then we're going to pull uh through a monday.com module. We're going to get the whole row. So we get an item. It's a very useful, uh, this is a very useful module that I like a lot that -just. -And get a. ID and you get the item with all its column value, right? And from there you can do whatever you want. Really. So now we're going to run this once in order. You have to get an item. And some metadata in here. As you can see, I get all the item values like this. And here you have the column ID I mentioned earlier text. And you can see that it contains this, uh, number here. And here we also have connected boards. Uh, so which is why I'm actually going to trigger this again. But on one, this one here instead. That connect have all the connections that we did earlier with the integral models. And from here we can see that the connect board is now filled with a lot of linked pool videos. So it's just the idea of the underlying pools. And that's also how you find the top items because they are in a similar column as a connect board. Uh, we want to iterate these connections. So we put in the whole array. And array is a bunch of is a list of, uh, IDs in this case. And then for each of both, we want to get the underlying item in the other board. Notice now that I'm actually going into the other board and fetching one item at a time here. Uh, that's. Slowed down because we had a bit of a video lag. But what we did was he is here again getting an item. Yeah, I'm getting an item. In this case, I'm getting the underlying linked item. So for example I will get each of these 25 items now. Uh, as you can see here. Just iterate through each item like that. Very nice. We can stop it. And then we're gonna put this together with a numeric aggregator. So that will be, uh, again summarizing all the items. I'm gonna use some. In this case, you see that we have other functions, too, and we're gonna summarize the, uh, expensive. We select the expensive here. Good. Uh, so this will output a sum of all the expenses, and then we want to put that back on the original item where it triggered it. So in the product overview we want to put it in the right number column. So we once again select the product overview. Webinar and, uh, we map in the pools ID and here we select the column call budget left. And here we also put the results of the numeric aggregation. And we click on add. And we click okay. And we test it out. So let's put it on. There we go. So now it's activated. This will take a little bit longer because as you can see when it iterates it takes about a second for each of these items. So it might take 25 seconds for this. Now to fill in this budget. The left column here, I'm going to clear it so that it's empty. You see, that left has nothing in it right now. And if the number is column, let's trigger it by putting 220. Ah, I almost forgot. Uh, actually, we don't want to put the result in that. We want to put the result minus, uh, or we want to put the budget minus the result. Right. We want to do a. -Calculation that would. -Help that part now. Uh, so we have the numbers which if in this case the approved budget. It has the ID numbers here. Good. So then we go back here and we put the numbers and then we select mathematical functions. Up here you have a bunch of nice functions. Here we have mathematical ones plus minus and so on. Here we have for text for dates and also for arrays. For those of you that want to progress later than use a lot of functions, it's a very nice feature that's uh, makes integromat very powerful. Okay. Now let's trigger it okay. So let's put 220,000 here and let's, let's have it collect the, uh, results. So right now if we, uh, you can see that the status of Integromat is running here, even though I'm not inside integral mode now myself. And, uh, but it is running in the background. And now that I updated the page, I can also say that it was active, and I took 11 seconds for it to go for all the items and put back the result here, which is 200 2530 225,000, minus the total expense, which we can see here in the mirror column 6550 2500. So it will put there by integromat which is quite nice. And if the number is calling. So we can do pivot table and everything on it. So yeah. Uh do we have -any question for for on that for Eric. -No. We got even more Woolson was and I think Juan is about to explode -over there. -Nice. Nice to see you. Not. Not long says currently, a lot of mine of businesses actually have having to have a spreadsheet in between, but. Well, now you know how to ditch that spreadsheet. Yeah. I mean, having a spreadsheet if okay, as a data dump or if you want, you know, full data from that as well. But, uh, in general, you would not need to have it for that use case. Let's progress and look at how to do this again. But in another currency. So what we're going to do now, uh, we're going to go back to integromat here. And I'm gonna hold shift and click on all these. -We can see your screen mate. -Oh sorry. Sorry. So I'm going to go back to scenario number three the one that I just created. I'm going to hold shift. And I'm going to click on each of these modules. And then I'm gonna right click and copy modules. And then I go to scenario four and I open it. And in here I'm gonna just paste all the modules. There we go. Basically I copy. Then I want to take the trigger, put it here. Uh, I'm gonna delete that one and go back to scenario three. I'm gonna shut it off because I want to use the same webhook. Um. So we're going to do the same now. But we're going to also, uh, make a currency conversion before putting it back into the, uh, into the numbers column. And we're going to do it in a separate numbers column as well. So I'm going to click here on add. And I'm going to search for currency. And there we go. So integromat have a built in currency function here that you can use. Convert an amount for sure. And here we have amounts, which is again uh, okay. Let's get some, uh, metadata in here. Uh, let's remove this and then get. The metadata here. Here. We got 2000 and we get the webhook. I could, uh, stop that, I. Great. So here we went again in the amount we take the numbers column. Uh, we take it minus the, uh, result of or our iteration, uh, the input currency. We had it in US dollar there, and we're gonna output it in, uh, Swedish krona because we are Swedish stuff. And then we're going to input it in, uh, another column that I prepared here called, -but it left in Swedish krona. -Think so? Both put it in, uh, uh, the budget left column and in the budget left column. So they are both here now, and I already specified budget left column. And now I'm going to add also. The body is left in the thick. And I put the result. Uh, I'm on the outward currency here. Uh, I could also put the exchange rate if I want to save that, you know, on the project row, just to see, uh, what that was. But I'm not going to do it right now. Or if I want to use it for a native monday.com formula column. So that's click okay. Yeah. And one thing that you are doing a lot of currency exchange rates and stuff like that, when stuff is final, be sure to make sure it doesn't update the currency because. Uh, your financials will not be complete off of that one if it just comes in. Uh. Continues on. -Exactly. -Exactly. Exactly. That is why it's, uh, bad webhooks to have it on the approved budget. Maybe. Yeah. Uh, um, because, uh. Yeah. You want to do it when a project is finished. So maybe that project closed. Status change. Then you want to do this where you get, you know, the whole difference over in local currency. So you can, uh, book, keep it in your books and so on. A bookkeeper, as it's called. Okay, let's, uh, activate this scenario, make sure that the last one is deactivated. Very good. And then we once again trigger the webhook. You can see that both of these are empty. And I'm going to trigger the webhook over here. Uh, 220,000. Enter. And over here. We will just wait for the results to pop in. On these ones. 11 seconds last time. Oh, I think it took the same. Well, yeah. So here you can see the 2005 hundred left of the budget and in Swedish kronor, that 706,287.79 kroner. Yeah. That would actually be correct with today's currency rates. -So perfect. -So yeah, the currency converter is, uh, quite nice for, uh, a lot of use cases as well that proceed to mandatory fields. I mean, this is something that a lot of clients, uh, our clients are asking for, like, could we have that definitely be filled in before we can change the status to something else? And that is something that we could solve with Entanglement Canada, because what we could do is solve a certain feel. If not feeling, then Integromat can change back to the status again to the previous value. So, uh, let's have a look again in our project overview here, um, where I'm going to do this. So we have budget approved or yeah, project approved budget. Let's say that in order to go from planning or in order to go to execution, you need to have that fill in. So let's empty it. There we go. And then let's go back to integral modes fifth scenario. And we're going to put in webhook. We're going to fill it correctly. There we -go. -I found I have found out that it's much easier to find when you actually spell it correctly. Yeah. You have a point. Yeah. Of course I'm the master of misspellings myself. So yeah. So scenario five we set up a new webhook. Same procedure as earlier. Only difference is that it will be on a status change instead. So I feel like when I start a change of some things and a webhook. Okay. All the way through with another account always pastes the URL, even though even if it's the same. And we go for on project phase and we select when it goes to execution. Send webhook. That's the trigger that we want. Good. Now I'm going to trigger it once. There we go. And we will receive this there. Perfect. And now we can start doing the monday.com module. Get an item. Uh, there we go. And we once again select, uh, our connection, and we select our pull ID to get the item so we can check for certain values. Good. And then we're going to update the column value. If a certain if a certain criteria is not met. So we're going to update it again to let. I will explain as I do it. Uh so we go back to project overview. We select the same item by qualified. We are going to update the status column product phase. To a label which is mapped in as the previous value label. Text. So the web gives us two values. As I said earlier, it gives off a value which is the new value that we put in and the previous value. So if I click okay and okay, so now what this webhook or this scenario will do so far without any conditional. If I go from planning or any status to execution, it will change it back again. The old value to planning in this case. But I only want this to happen in certain cases and that's why we start using filters. Filters are, in my opinion, next to functions here. Then uh, filters are the most valuable part of environments because here they that. -Show again where you clicked. -Uh, sure. Uh, I'm also going to first I'm going to put some data in here. Sorry. Uh, there we go. So what I clicked was in between the two modules. Here we can say that it can only take this route if a certain criteria is met. In this case, you have to have numbers, which we know is the approved budget column. It should not exist because then we change it back. But if it does exist then it will not get past this filter. Let's try it. So I'm going to run this one while we were three grades. And then we have a look while it runs. So let's go execution. And now we will look at the. So here it passed. And that is because as I said earlier I have not filled in our project uh, allowed budget. If I feel the same. And, uh, then I, uh, go to integral mode and I want to do this visually, so I run it once again. This is only when you test it. Then you click on, uh, run once in order to see how it progresses between your modules. Right. If I run it once again, I select execution in here and here I have a look where it doesn't go past the filter, and then you can click on why doesn't it go back? Because this one. If it had a value. Yeah, it had a value. It exists. So it will not go, uh, to um, this last module which would change it back. And we can verify this by looking here. It actually allowed the change to execution here. Uh, we can build upon this and also add that also. Okay. Let's create an update as well. So. Uh, for example, if I go for a full fledged. Uh, fill in through the budget, Steve. There we go. Let's have a look at that for, um. Uh, now it's activated. Very good. So we're going to clear this column. We're going to go back to planning. And then we try to go to execution without feeling this in. And let's have a look at what happens. Oh it gave me a update here saying that sorry. Filling the approved budget please. So that is quite nice. And it also goes back to planning here. So then you know why it goes back. So that way you can have certain criteria, uh, on a status change in order to allow it, or else it will just go back to the old value again. I've got a question here. Uh, can you take remote work with the dependencies and the relations of them, like changing one value from the dependent, for example, a number, then it also changes -its predecessor and vice versa. -I mean, uh, you could do that, uh, because when you access a dependency column, uh, here we have one called predecessor. It's a dependency column. Uh, when you access that, uh, through Integra mod, actually, we did in the scenario for this almost. So let's have a look at that one. Then we get the Mappable column value. So then we will get that the predecessor value as well. So here I can have a look at the map of a column values. And I can look at the dependency. I can see that it gets linked pulls ID so that one I can use in a new get item or a new update column value at the end with an iterator if I have many items dependent, so I can use that one in order to uh, um, uh, actually, uh, update another item that is -this one is dependent on. -Awesome. And then, uh, Thanos asks if, uh, that story changed. Can we actually pull the one? Uh, the information on who the user actually triggered the -event and tag him? -Yeah, we could, uh, we could, uh, let's see if we can tag it. I never tried it. Fun question. So let's get a user. Uh, so here uh, or actually let's put that one after the filter. Otherwise it's unnecessary that it will cost. Yeah. -It's an. -Unnecessary load. Yeah. So here we'll also get the user. And the user in this case will of course be. Mapped in the user ID from the webhook. The one who caused the trigger. And here we will also click on, uh, apps and let's see if it works. I never tried it. If it works, uh, and we put uh, um, the name, then that's usually how we do it. Actually, I'm quite sure it will not work, but let's try it anyway. Now that I think about it, it shouldn't work. But if it works, then I'm -super amazed. -Thank you so much, Dimitri. Um. We've got a comment here for you. We go, uh, the most valuable webinar Dimitri's been to during -2021. -Oh, thank you very much. That's nice to hear. Uh, I tried it. Uh, -it didn't work. I'm sorry. -Uh, uh, it might be something to explore, though, so if we can pull the user ID instead and see what can be done with that, maybe. Yeah. I mean, uh, it will, uh, because, uh, the this module here only sends, uh, plain text. Those of you who know, uh, or advanced in, uh, using monday.com API, you could, uh, um, do some exploration on the documentation from on the API. You could also have a look at, uh, creating a custom app with, uh, integral mode of the, uh, back end. Because if you have an app, then you can send monday.com notifications directly to users. Uh, these kind of notifications, sort of a. So that you could do if you use the app framework that monday.com provides and then connects that app framework to, uh, integrations. -Yeah, but that's a. -Whole nother. -Webinar. Yeah. -But, uh, for now, at least with this, you can at least explain in your update who's -being the ass. -Basically, yeah. You can just have the name there and their phone number and. -Home address and all that thing. -Yeah, no email address, you know, -but good question. Very good question. -Actually, we are nearing that time of the day. We go, I think I don't know if you had one more scenario. I'm gonna see if you guys because I had one more. And maybe this one will be a separate webinar on how to automatically fill a deadline according to a reference table, because we don't have enough time. I'm afraid to do this one right now. -As you could see, if there is. -Time, I don't save it. -For next time. -Right? But now we have a continuation. So we will probably or we will, I can promise you do a pause to to this. So this is a -cliffhanger. -Sort of thing. But with that said everyone be sure to subscribe both to our YouTube channel, because then you will never miss any webinars because you will be updated after the fact. And be sure to also subscribe to our newsletter. It's on our website. You go to Omnitas.com it's all in English guys. Uh, and subscribe to our newsletter and you will get the information when the new webinars are put out there and you will get well in advance. You can reserve your seats because we are always limiting the number of seats. So it's first serve in this case. So be sure to book your seat in time because our webinars are getting to be pretty popular. I don't know when we will do part two, but I know that you are a subscriber to our newsletter, so you will be the first to know. -Yeah. -Thanks. And, uh. I will definitely do a part two. I feel it's I mean, this was a lot of fun. We also received, uh, last question here from Natasha. I really have to take it before we end this for Natasha, or, if possible, to integrate virtually any third party app with monday.com using WebEx with the integrated remote. And the answer is -yes. You can even. -Find. The most obscure API and connect that to monday.com with the help of integromat. -I've done that. -So yeah. And I actually go hinted in uh, on before, uh, earlier on. You can actually do quite a lot if you know, some API code and you we can actually really deep dive into certain things. So we don't even need to rely on pre-built modules and stuff like that. We can actually call on APIs within integromat. So you can do a lot. And yes, just to give you some, some really cool thing that Viggo did, it was a bit back now, but we, we, uh, had a partner of ours, uh, that we work with from time to time, and they were trying to make an, uh, classic custom API and couldn't get their head around it. Really. They were working for a week or something, and then we're like, we can't really do this. And then Viggo said, can I have a go at it with Integromat Three hours later, he had sold what they can do in a week. So it is an incredibly powerful tool when you master it. So, uh, sign up for that account and start playing around. Great link there that you shared for. Yeah. With that said, guys, that's all from Sweden today. So have a lovely evening or a lovely day depending on where in the world you are. And that's all from viggo and me. So take the best of care everyone. -Thank you all very much. -Thanks for watching. If you like our content, remember to subscribe.