[Music] one hello and welcome to live coding happy hour on this fabulous january 29th 2021 i'm your host andrew barnes here with some awesome people and we're gonna do some quebec stuff today so let's start with our intros chuck let the people know who you are hi i'm chuck tomasi senior developer advocate at servicenow been here for about 10 and a half years i was a customer before that for a couple of years and i.t and developing experience back to the early 80s so i am here to learn and have fun i am the designated driver and button masher so if anything goes wrong with the video you're gonna have to tell brad and he'll tell me because i can't keep an eye on everything at once that's as trainee right here right here well awesome thanks chuck and phillip hi good evening thanks for having me i'm phil swann um i'm a principal technical consultant at rangoo been working with servicenow for about six years um and really excited to see what's happening in quebec with flow designer tonight so awesome he's got the woodcup going on back there look at that that is awesome background is that a virtual background or real background i wish it was real nice from chelsea flower show in 2019 i think nice and our other guest drove hi everyone my name is throw and i'm currently working as a senior infra developer at cognizant so my role is like helping clients get on board with utilities of servicenow and as philip mentioned you know i'm very excited to see what we have in cubic awesome and i'm andrew barnes developer advocate here at servicenow i've been doing this role for uh almost two and a half years now i've been on the platform for over six years as a customer a couple of times an implementation partner and now i'm in the platform business unit here at servicenow and i just love building on the platform like it's my favorite thing to do is build stuff on the platform so when i have a choice i build it on the servicenow platform and that's why i'm here [Laughter] so uh chuck you said you're uh you know you're you're learning the ropes of running the uh back into the show today so you're you're uh driving uh our designated driver today so you've got some lovely water only no more for me fans i'm driving you don't want to put a trainee in charge i mean give alcohol to a trainee just i've learned through 15 or so years of podcasting that's just a bad idea well it depends on what you want the outcome to be no audio entertainment could be uh could be the go and around the horn the same order phil uh yeah i've got guinness uh west indies is that not going to show up put it over your face over your face it's a weird effect there you go guinness west indies porter so that's uh coming in at about six percent i think yeah six percent oh i don't think i've had one of those very nice uh wish me luck nice next so i'm it's like 3 a.m for me so it's like too late for a beer and too early for a coffee so even i'll prefer the hot water directly from the kitchen nice well it is prime drinking time here on the east coast in the u.s so i'm gonna have this jalapeno pale ale from uh bird song brewing company i've not had one of these so i'm pretty excited to try it out i like jalapenos i like beer let's see if they mix well i missed it philip where are you from uh near london i'm in the united kingdom so about 30 miles north of london so it's pretty late not too bad well nice half past nine so normally i'm tuned in anyway so not nearly as late as idc is thank you gentlemen for joining us absolutely thank you for joining us so uh it is early access period uh right now with uh servicenow so we've uh last week we moved into early access for the quebec uh release and so i have changed my background to quebec though i am wearing a pair of shirt because we don't have any quebec shirts yet but but i'm but i'm wearing my family family release shirt um and this week i released a blog about some of the changes in flow designer and we're going to look at flow designer today we might accidentally hit on some other things like integration hub just by accident because we'll be inflow designer and so i'm i'm excited to show that if you didn't catch it which is uh probably unlikely at this point last week's episode was on ui builder which has gotten a huge overhaul in quebec and that was a really fun episode that uh brad showed us uh how to make a new page um for use with our artifact manager um but today we're gonna take a look at flow designer is there any before we drop into the screen share um do we have did we release a podcast this week or is it next week chuck i think it's next week i've got you and i talking about quebec next week we do that was a lot of fun february 3rd and uh i've got the next one scheduled up topic decided so we're the pipeline is looking good right now i really enjoyed your discussions with uh two of some of my favorite servicenow developers um paige duffy and maria gabriella so you had those earlier in january and those were really good episodes those were fun yes wonderful to talk to and always open for more discussions coming down the pipe yeah um anything that uh you find gentlemen would like to share like tell us something interesting like what's the coolest thing you build on the platform well i was trying to convert the whole of grc to flow designer i tried to do that in 24 hours and got about 12 hours through and figured that i'd learned enough and i've shared that on on my channel so yeah really good learning and i've done that from kind of through orlando paris and then uh the the kind of finale not so grand finale was in quebec the other day and it's all still working all still hanging together but yeah lots of new features so really that's cool flow variables let's see how that works out and i've been developing one app uh that takes on the security part of the ecosystem basically active directory attacks so managing those things through servicenow in an automated session nice very well that sounds cool well let me uh start my screen share and we'll get rolling with what we're going to do today so let's see if i can do that woohoo so the first thing that i was going to do actually was uh go to a different instance because the first thing i wanted to show was in flow designer when you first launch it now in quebec as a user you're going to get a helpful little tour sorry i meant to have this screen prepped but i accidentally closed it so sad me and let's new flow you know what i'm going to give that i'm trying to find out where you put that little tag in the corner that says ui builder did i not uh did i not i'm seeing flow properties apparently i uh didn't uh do something i already loaded it uh here so i'm gonna have to switch uh to a new user let's go to our user table apparently i already got the tour um on this account so let's uh give uh oh do i have a user in my impersonate list no okay so uh greg here is gonna get some permissions real quick so we can see the screen come on greg let's get some permissions for greg greg apparently has a role that uh doesn't exist anymore [Laughter] all right so now i should be able to impersonate greg there we are and fire up flow designer again you can do it all right here we are yay now we should get the tour now i know i've seen the tour do i have to open something first the tour is pretty cool because your new people will see that and maybe a new flow hello there did you have to set the uh tour up andrew was it something you set up for your instagram it's it's default um so is it something like uh we used to have in guided app tool so it was managed there it it is it is all right so uh took me a second here's the tour so uh you know when they first try and create a new flow uh they can take a tour of flow designer and hey it says steps me through it so we start with a trigger okay cool we can uh you know do created or updated and i'll go ahead and step it through and say next and it says oh okay we'll come down here and you know add some actions and then it's going to tell me what data pills are hello data pills save test and activate sweet well that's a short tour and then the other thing uh that was added is this uh help and do i need to pull in from the side a little bit chuck so they can see all of that you're no you're actually pretty good okay we get we get out to end on the done button oh that's close enough um so uh when you hit this help which is in the top right you get all of these help topics which help you you know learn contextually here what you need right here in flow designer so you don't have to go to the docs for example for learning how to you know deal with flow logic it's right here so those are just some nice uh nice to haves here in flow designer in quebec and here i am in i haven't upgraded that instance yet apparently we'll be using this instance i thought yeah dev program dev and dev program are still in paris before yeah i forgot for some reason uh and but now i remember and but i am i can still do my development here because this is actually a clone of those instances so uh that was the plan anyway so what we're gonna do today and i'll show you a couple more uh flow designer cosmetic things now that i'm back in my regular account i'm gonna launch flow designer what we're going to do today is leverage flow variables um so let's make a new flow we're going to put it we're going to do um get hosts we're going to put this in the artifact manager artifact manager so right here in the right um thanks you wouldn't show me it before but now you want to show me the tour um so let's add a trigger so created or updated we're gonna pick our artifact table artifact table um well let me finish show you what we're gonna do so um there are these new things called flow variables uh so over here in the side in data you can see i have a section i'm going to call flow variables you must scoot that over so we can actually see it oh sure there we are okay i didn't do anything i did oh very good um so we have flow variables and so if you're familiar with the old workflow editor there's the scratch pad that was available to you so you could you know put in any sort of data that you needed to persist across the whole workflow in there and manipulate it and now that has come to a flow designer in the form of flow variables so one thing you might not know even experienced flow users the contents of any of these data pills it matters when that was loaded so for example the trigger or if i did a lookup record and i retrieve the contents and then something else modifies those and i and i try and access that data pill later on in my flow i'm going to get what that was when that was loaded um so i you know it is good or bad that's how that works and so if i need to you know store something or you know manipulate some data that i can leverage in later parts of a flow flow variables are the way to do that and so i'm going to create a flow variable so that i can store some societies in there so that i can concatenate those together so i can put them in a watch list all right so that's that's my goal uh here is when i have an artifact and it's going to be a live type type is live stream and the hosts are empty is empty is what i'm going to execute this um and probably you know something like state is one of these early ones like ready to work and work in progress yeah that looks close enough to what i actually want um so now what i'll need to do is add one of those flow variables before i can access it so up here in the top of the flow so it's part of the you know properties of this flow is flow variables and you see we get this modal and i can create as many flow variables as i need and so i'm going to put the hosts here and they're going to be a string unless i have something better looks like string is probably what i want here for this use case but i could make some other ones so for example i could do like a counter and you know have that be an integer and i can have a reference i don't believe i can have a reference we know oh i did i do have reference so we've got json true false string integer and reference well if you've got json you don't need anything else that's the way i look at it um you know so i could even store the artifact there and it's a reference to the artifact table and i might actually use that for something else so i can set these flow variables here you know and create them and now they'll be available here there's nothing in them but they are there and accessible the other thing that you can notice right off with flow designer here versus flow designer here is we've got a bit of a nice uh reskin i'll even you know show these a little bit side by side [Music] some some shading updates and you know some more rounding of corners and um so a lot of that is uh very cosmetic but one thing that uh is significantly different for me just for ease of use is is i'll show you a little bit later when you're doing flow logic like a four each that's going to render quite a bit differently than it did previously so uh let's let's maximize this and and throw an action together real quick of uh you know this is i know there's nothing in there yet but we're going to pretend like there is greater than you know three i like that you've got next to the properties button on top you've got an active and an active flag so it's it's no longer yeah is activate or deactivate live you can clearly say see is this going to run or not so i i just threw this together arbitrarily but i wanted to show you the difference in how this oh and that was up for each that's all right it still shows this is underneath that thing so the how this is drawn is differently and the if and if else um it's rendered differently um so you'll see i didn't have to to under my if statement um you know do the logic else so over here i have to do flow logic if and then drop you know a condition in greater than three and then below that you know um i get here action ask for approval yeah yeah here we go and then down here we get our else and we'll throw something else here so we can see the difference between these and flow logic else and then we'll add our action creator update record and take a look at not everything is a circle anymore if is a diamond which is the traditional way to show a decision block yep and so just visually to me that this is quite a bit different um because it it really calls out to me oh there's a decision here because as you said chuck this is a diamond um whereas it's not as clear over here um you know what's going on there and i for some reason i just really like the swoopy line like it it makes me happy that this whoopee line makes it smoothy the swoopy line makes me happy do you find that the new skin has got a bit easier to put the little pluses in you know when you hover and you want to add a new step in there it's it feels a bit more intuitive i don't know if it's because i'm getting more used to flow design or the new skin if there's any real difference there well it did it did seem easier for me to get the plus button when i'm trying for it and there's also a little more room there between those two this is the same zoom and resolution and everything and there's there's a bit more room there for me to get to this now do me a favor see if you can put something before step one before action one before that if statement yeah you go no up up oh before action one keep four action one there is a space there um there should be there usually no that's adding a stage right that's to organize your right well there's a plus there there's a plus there's there it is i just had to go higher okay so it's it's still a tight fit but you can make it in there yeah that's still tight much easier which is interesting because the white space is actually reduced on the new ui so that's enough of the graphical compare i think um but but i do like uh the changes to the graphic like i i they're they're top-notch for me um it's been easier to on my eyes to look at larger flows with this so let's get back to the somewhere [Laughter] let's get back to uh what we wanted to do which is i'm going to perform a lookup so let's go look up some records look up records oh i need a space look up records so i'm going to look up some records on the group member table sysuser group member and i want the group is hosts [Music] that not copy ever all right well let us go create that then go to our groups and we'll create a new table i swear i had a host i know i do in fact but we'll have hosts and let's put some members in there there's chuck not him oh nope get out of there and then that troublemaker the abcs all right we've got our hosts in there and so we should be able to go get our hosts so i'm going to look up records the group member table for when group is hosts and now i need to loop through that so i need some flow logic for each and i'm going to grab my records data pill and drop it in oh actually i almost didn't know that notice this like earlier uh they changed the cannonball no more cannonball martini glass cannonball martini uh what did what did y'all call it someone said hunger games like it was a mockingjay kind of thing what was what was your name for the cannonball and if you don't remember what i'm talking about this guy yeah phillip drew what do you call that thing i always thought it was a synapse i love that that's good okay brain surgery what did you call it drove i haven't put any name as such [Laughter] okay fair enough jace called it the ball and joint the ball and joint so now our data pill picker uh you know has a different uh icon uh it's still the data pill picker so we're gonna grab those records and then uh the next step that we're gonna do so what i want to do is uh go get the um user's email or no yeah just the user i need the user cis id and i'm going to store that in the host flow variable so that means flow logic our brand new set flow variables will give me access to modify any of the flow variables that i have set for this flow and we want to modify the host one with some data and we want from our for each the group member records we want to get the user's society society and a comma does that seem reasonable [Laughter] so i'm building an array of cis ids isn't that going to overwrite it oh yes it is i need to actually reference itself first pull the flow variable back yep so i need to put hosts in here come on and then a comma and then a comma uh are you not going to end up with too many commas though uh well i don't need to end with a comma yeah putting it that way around might might work so i'm going to put my mouse back over there and then not scripting flow variables host so normally in scripting you don't want to dot walk down to a sys id that would be a bad practice because if it's a reference field it's going to have a value of a ssid anyway but in this case if you just got you know group dot user what would you get would you get a string field do you think it strings it as it goes or will it push in square brackets glide object right you would get an entire user object because it is a reference i think it would i think it would string it i think i think it would be i think it will grab the cis id we could test it and see but get a leading comma then because the first time through this it's not going to have any your value integer oh i could use a counter you've got one there is it i have a default value when you set a flow variable does it have a default value i wish we could use a flow variable as an array then you could just join them let's see if uh i don't see any like uh normally in flow there's like a drill in if you can set is that a value oh yeah it doesn't look like i can that's okay as a practice in the workflow what we have been doing is like uh at the start of the workflow we have one run script to initialize all the scratchpad variables okay you can do something like that as well make a custom action so i could just set i could just set it before the for each right um so here i can do set flow variable well there you go count zero zero or one or whatever and then here i can if my counter and i want to grab which it shouldn't matter and grab the count is zero do this one and we need to move this one up oh um why don't you look like you can go in hit the x next to the action it looks like it's trying to do an action there ah good call there we go set the flow variables based off of that and then i'm just way behind then we're going to also set the counter to anything other than zero one right so set the counter to one and then uh you know [Music] else we'll set our flow variables two oh and in that case i didn't need host at the beginning or the comma right for the previous one i need hosts comma data pill for each record user i love that typing thing it saves so much time when you're drilling down oh man i love the typing part of that so much so i can x out that and x out this yeah that seems reasonable still prefer an arena join but hey i i do too but i i could script this but the challenge and i'm trying to show off the flow variables part right so uh setting the flow variables for the for each yeah that seems reasonable um yeah i'm fine with that so we set those and then now we want to go update an artifact so we want to update update record and we're going to update our trigger record so we'll grab it right here from our trigger and we're going to set the host to are hosts that should do what i want it to do which is take an artifact that doesn't have any host set and set the host based off the group membership that seems like it should work let's test it that field uh andrew required host is that a single reference so we're just trying to get one of the members nope it's a reference list which is why flow variable is what came in handy here so we're just going to update that for each loop shortly just to because we've got the first one in there for the to sort the comma out and then we haven't said what to do if it's great yeah we did we did both yeah there's there's in the else right apologies sorry no problem yeah yep so the second time through we take what we had add a comma and then add the next one amazing it hidden itself which deals with some of the real estate points that i think some people were bringing up you can collapse things yeah so i can collapse those which is now now that i'm done with this bit hopefully because it works i can i can just move on another cosmetic thing over on the far left where you have the action numbers it does some shading as you expand those a little bit the deeper in the nest you go the darker that see how four and five are darker and two and three that is a little if that's not super obvious on my screen no it's not if you're like me and you get about five or six levels down it's deep deep shades of black all right that's handy so let's save this oh i'm sure brad is flipping over in his grave that i haven't saved yet [Laughter] he'll unmute thank you for that brad um so let's test this so we need to test this against an artifact record that doesn't have any hosts set um so let's go do that artifact live stream so let's go grab one or we'll just in fact empty one out so there's none here so we'll grab this title we'll flip back over to flow designer and we'll say test do we actually use the number field for anything it's not the display value we don't use it for anything chuck so i fixed it today because it was broke and we don't need it we really don't so run test and we're going to run this synchronously the layout here feels a little different or am i imagining things it is a little different the the changed fields i think was in paris but like it's laid out a little differently and spacing-wise like this was never as clearly like separated from that jumping out at me it's like this is very it felt more like a status message that was crammed in at the last second like a debug that's how most of my status messages start life is a debug message well brad made it in okay just brad though hmm well let's go trace our steps yeah we'll go trace it but uh we'll take a look at required host i'm not and it just one got in there but let's go take a look at why in this execution so we loop through three times so we did we did at least uh hit that oh and then not run no that's right your else doesn't need to run on the first one go to number two oh that was deceptive to me and they also still says not run they all ran the first one uh which would just replace it with the single cis id so it would be the last one that was found where did you set your zero where did you set the flow flow variable to zero in the first place step two action oh the if check you're not gonna apply it happens before i set the thing no action two was where you set it to zero did you not um so here let me i don't need the execution anymore i know what i did wrong which was well no i it should it should be it should be there i'll have the questioning but wait wait a second it this should not no longer be zero what did action two do because the counter is one right right right and the next time through yeah it should no longer be zero so where's the increment what we said the whole this we didn't we did did we do a we never incremented count oh you said count i said it you said count okay so the second time through it's one and so it should evaluate here as one yeah is it a scope of variable it got somehow count got reset back to zero maybe maybe i have to grab the data pill better than i did get the data pill better than you did what did you do wrong um do i have to no i it shouldn't be so i was thinking that you know in other cases in flow designer which is what i mentioned uh earlier you know once a thing is set that's what it is um as far as data pills go so what if instead did we have a true false in there i thought or a variable type uh there is a true false but you're reading but but i'm still confused why when i evaluate counter it's not let's see if i just check what it is like down here yeah it might be the scope issue kind of thing right uh the value we are updating in the for each scope and the initial updation we did it outside the added count take a look at how you're incrementing it as well just well i'm not even trying to increment it i'm just trying to set it to one after the first pass it's really a boolean flag at this point yeah it's it's a true false um obviously it doesn't need to be as long as it's over it's just in the comments yeah the first time and then all the others so it's it's really just a flag at that point let me test this uh against that record again and then we will uh because i want to see what it thinks count is outside of the if outside of the 4-h period well that flight-aware application isn't getting a whole lot of use these days is it oh god don't remind me man that was a hard frost it's not being used at all um so update refer count is one dirk is saying one is called count and the other check was to counter we have a mismatch on did i grab the wrong variable because i totally could have grabbed the wrong version you did i think i grab did i grab the number from the lookup records count instead of the counter i think you may have well it says counter flow variables counter okay and then i can only choose four variables in the flow variable setter i thought i saw a count on that screen somewhere so this looks like it should be right because down here is clearly one yep and up here the first time this is fine it should be zero but that's did we initialize uh we started it at zero we initialized variables yeah and set below variables only lets you do flow variables i'm wondering if at this point if this is not a bug it's smelling like a bug that my for each doesn't check to see what the current value of counter is on the subsequent loops like it grabs the data pill you want to try what you're saying at the beginning that once you've got the data pill populated it's it's like a snapshot of it's a snapshot but that's the opposite of what we want flow variables to do so that doesn't feel good snapshot doesn't really fulfill any purpose because outside of the for each it worked fine so that would mean i'd need to like can we validate that by not doing a for each and just update it in several different steps and just i don't know what are we trying to prove i don't know how to prove it without a for each four reaches the only way of looping through glide records in flow designer hmm you could set up a few different checkpoints and say all right set it to one here set it to two here set it to three here and just do some gs logs and make sure that it is checking but with outside of the for each loop i mean it it's it's set it's it's one right here so the counter is one down here outside the four each but the if is failing is that what the if is failing on the second and well if it's succeeding but in the not in the manner i wanted to on the second and third because it thinks it's zero but it's not zero anymore because i said it to be one right and that is disturbing go to record two again go to record two here's where i got two two and it still says zero equals zero yeah like counter and sets it to one and it says you know the left-hand side would be using its values on every iteration what good is that yeah that's what i just yeah that's my position is i feel like that it's not operating in the least surprise here do you think when it's on step four when it does that if it's kind of that's where it snaps like it grabs it and snapshots it right then and you can we just try to modify the condition like instead of using a zero you can use is less than one i mean that could be that will clarify everything well i mean it says it's zero in the subsequent things yeah i was thinking the same thing drew um but but i'll give it a shot it's less than one um so the other way i could think to see is if i could do like um i could fail the first pass through like get to the else so if i do he is not zero and then it hits the else the first time and then one yeah reverse logic reverse first logic so down here set the counter to one and then up here unset it can we actually use the counter as a counter and increment it and then would we see if it actually goes up as well what's that in that case i think we need to use the script thing for yeah i'd have to use the scripting to do that but yes we could try that um let's see an interesting experiment actually change the value via script versus a static value how do you access the flow vars in in scripts is it is it fd data yeah i i don't remember the format but it's it's the same process as any of the data pills so ft data dot and then let it auto complete yeah exactly i remember trigger [Music] so not run which is the uh you know the skips these and then yeah okay no it's just that didn't help it is not adjusting nope it's not adjusting it until it leaves and checks again that is interesting and you determined what it was out at the very end was it one yeah it's still it's still one at the end i wonder if watch this unless it's unless like drew suggested it's scoped because it's set inside of an if and for each comes back and goes oh let me get you the variable you wanted let's see if this does something let's try this jace is giving you a hard time roll up your sleeves and write some script already no that's not the point i could have totally scripted this like 50 times already but i know i i'm trying to use flow designer with the flow variables so uh my thought is that my my lower if has access to the counter as it has been updated and then can can see the counter check to see if it's one it is not run and then oh i'd put it in the wrong spot i'm so bad i reverse the logic so oh that's right is zero brad's saying don't worry about the comma can we just don't worry about the karma yeah i mean if we've got an extra comma what's the what what's the worst yeah i think it'll just take the first 32 characters then looping through the all the members and then as last just at the last step remove the last character of the string bad practice but one of the ways so i didn't set it i'm glad i'm not the only one who works like this i'm doing bad why am i being bad been the last two weeks for me oh forgot this set the counter two one i really will get this test done the right way we're either going to get it to work or determine that it is a bug yeah i'm a variable scope if if a loop of a 4-h can't adjust the counter the or adjust flow variables then they become less useful but we're adjusting the variable value inside the if uh yeah uh so let's see the first run not evaluated and then the second run sticks and set the counter after the if but inside the four each right so i've let's i i'm i'm with phillip on this one so i set it one i'll click check to see if it's one and it was zero right but you don't you don't need to set it inside of the if you could set it outside the if and have the same effect after it's iterated so what i'm trying to show here right now on this screen is i set the flow variable to one and then i check to see right after that what it is and it said it's zero oh okay set flow variables this went into the air where you changed it so i changed it i hit this set flow variable and it changed it to one and then right after that immediately following that i said check my counter is that one and it says no i'm zero is that your screen's got that that's that's uh that's all you need to raise a bug isn't it yeah this right now it thinks flow variable counter is zero immediately after setting it to one i'm sad yeah i just took the wind out my sails [Music] that's a little disappointing that that didn't do what i wanted to do the second favorite uh feature in flow design let's go do a script tracer real quick come on um my second one is actually gonna be next week with flow so it'll be flow designer integration hub which will be that my second favorite flow designer feature is an integration hub feature which is a where is the recipe when you write about on your blog andrew do you need a plugin for this one do i not have like where is it it's supposed to be right here well i'll apparently make sure that i have that for next week um which is uh that you can use uh a rest uh a scripted rest api as a trigger and it will and it will create the uh script addressed api for you right here in flow designer so that's my second favorite feature which is the integration hub feature so i've already been doing that um but you know i have to go create the the rest api and then in the rest api i script calling the flow um and this skips that creation and calling step and just wraps it right up into the trigger so i'll show that next week on the show because i'm definitely going to be using that because we we've been using that so i'm a little a little flummoxed with this but before we wrap up why don't i just adjust this to not worry about the counter and just get the just get up them together mash them together yep but let's just mash them together uh so we'll kill all that and just do uh a set did i i said go didn't i would it not does it take all the dependence away from it if you do that you haven't got to take all the children first really the whole block no i don't know it's a good question that's yeah that's weird you can't delete like the whole if block the else block died okay you've got a whole bunch of things that depend on this are you sure yeah i'm i'm with you uh phil i'm not sure if that was a good thing or a bad thing i i can see it being either way there uh so we're just gonna do host and we're gonna say host uh uh flogar host and you know we'll throw in an extra comma at the end because who cares it's fine and then we'll die walk to nope i said dot walk um group group we got it uh user society not the search oh you we've all been there that's why it's so funny i'll take it you can laugh at me today all right it's host comma there we go they still laugh at my misfortunes save let's see if this just works this should work because the update artifact was was working uh for for count outside of the for each if you say it should work you just cursed it hey i believe so much it's right here there it is the three people abc out of order but it works so it did it did work correctly interesting even with a rogue comma on there do a show xml i want to see if it was in there or if somehow the uh no i didn't it'll just okay so it does do a little cleanup on us it will so what was the difference there sorry a string you can update and it will hold on to it and then you can't or or is there more to this um it is that the the flow we're using two different flow variables there one's a string and it was able to concatenate a set of cis ids but the uh the integer itself it was the fact that i was referencing it outside of the four each and it's happy with that but inside the 4-h like checking the values of these it was not allowing me to see the newer value of it which is weird what's doing the runtime value of these correctly which actually is bothering me a bit because those are getting updated because these are getting updated and can be referenced the counter didn't and the counter didn't it might be string versus integer all right now what now i'm going to take an extra we're going to go over a second because we're going to make a new variable uh string for counter why don't we just try true false i mean yeah i know you're really oh we could do we could do true false because technically that's how we were using it it was yeah it was no i'm going to delete the first record or not and say first so if you didn't have flow variables and you wanted to do this set set up a list of sys ids before quebec what was the alternative scripting okay unscripted or custom action yep right and so i've done that several times in fact so we want to now did you do a set on it step two i haven't yet done that so i'm gonna do a flow logic we're gonna if and we're gonna grab the first and we're going to say well that's not a very nice way to do it did i not set it to it says string i swear you did true false i swear i did true false too hey oh did we hit delete are you sure you want to make this change what can cancel and delete those aren't those those are not the reasonable options in this scenario do you want to back out or really back out what is this what okay that one you i'm gonna hit save and see if it maybe was angry or something this is getting it's getting it's getting a little uh punchy here we're throwing the early access card a few too many times here yeah that is just not reasonable okay well i'm going to create a new one and i'm going to make sure i hit true false this time uh second [Laughter] true false click don't show me this again i'm done with that nope we're good i never want to see that dialogue again we're going to end on a highlight um please we're going to end up on a positive uh note here which is i'm going to show you that you can do um let's do uh what's a what's a reference field uh assigned to i'm glad the chat thinks that's funny we are gonna do a sign to don't let it be said we didn't get egg on our face at least once if you if you thought this show was unscripted there you have it you were right [Laughter] so uh the fun the transforms that are available when i hit the fx on a data pill have been uh you know enhanced uh with quebec and so this is the last flow designer thing we'll show because we're definitely over time now and we added some new ones um so under math there's some new math options nice for you to do math um there's a date and time already existed um there's some new options under string and then somewhere in here is display what there's get there's like a get value that's supposed to be in here absolute value key value map i used that today that was really cool all right well apparently uh that it's early access we can show i have seen it just try saving it first andrew just see if that changes it at all i have seen uh that you can get the display value versus the value for fields reference field that's kind of cool um so that's in here i don't know why it's not showing me but uh it'll be one more thing for success go down to um add action or flow or logic okay click action action i like most popularity okay most recent do we have anything in most recent yes we do no we don't yes we do record a while to update right there we are there's a success for today there's success all right i'm gonna stop the screen share [Laughter] oh goodness well you know it's early access uh i will definitely be uh exploring that some and i will update the uh the probably a comment on here um or in the description uh my findings for this um because that was not not that was not least surprise on the flow variable there so thank you for working through that with me i know it was a little painful but also early access stuff is a little buggy like uh that's part of the the the you know the early testing process is finding these bugs so patch zero is patch zero for a reason and uh we we fix a lot of defects between patch zero and patch one every time um and so we find them sometimes and you the customer uh definitely find them so uh thank you for working through that with me let us go around the horn again um on raiding our drinks but before we go i want to remind you uh if you're watching this fairly currently the call for content for creator con is open and so knowledge and creator con their call for speakers is open right now um if you're a customer or partner reach out to your account executive if you'd like to you know speak at knowledge this year and get your get your content submitted and we look forward to seeing you in may at knowledge because that's a big time for us on the advocacy team and we just love knowledge and we look forward to to seeing all the cool things that you're out there building um and let us rate our beverages how is your h2o today chuck always a five oh it's a five yay and how is your awesome guinness oh maybe not awesome it could be terrible no uh to be honest it's one of my favorites um or it's out five isn't it uh probably four point five oh four point five too high or was that i mean guinness is a good beer and if you like them like four five is good um how how is your delicious water sir oh it's lit's warm i expected it to be a bit more warm but yeah you can say four or five point eight and and now you get to go to sleep ah not no no not yet you've stayed up too long no no let's loop it over to the other side come on tomorrow is saturday you should wake you should sleep at around 5 a.m 6 a.m okay my jalapeno uh pale ale is uh brewed right here in north carolina where i'm at in charlotte uh the city to the south of me uh is it's jalapeno it's it's fine uh it's taking a hit though with uh uh what we had to do on the show today so bonus points it lost bonus points so it is a three five so it took took a small hit um well thank you for joining us thanks for the interactions in the chat uh we really appreciate all of you thank you especially to our guests this is both of your first time on the show so we really appreciated you uh joining us and next week we'll be doing integration hub and that is i've already used most of those things so that should go well so looking forward to seeing you next week uh thank you have a great weekend bye [Music] you