Video: Master Smart Scheduling: Live Build-Along Workshop | Duration: 3728s | Summary: Master Smart Scheduling: Live Build-Along Workshop | Chapters: Workshop Welcome (3.7s), Platform Overview (68.01s), Session Introduction (169.51s), Smart Scheduling Reports (278.335s), Recent Updates (424.96s), Screen Sharing Setup (595.03s), Schema Requirements (780.985s), Skills Management Schema (904.005s), Allocation Report Creation (1023.59s), Resource Table Relationships (1180.345s), Report Mapping Configuration (1333.69s), Dynamic Report Filtering (1442.86s), Job Scheduling Workflow (1555.98s), Duration and Defaults (1760.86s), Resource Skills Mapping (1888.365s), Resource Scheduling Automation (2074.11s), Availability Report Setup (2148.845s), Resource Assignments (2275.64s), Assignment Management Features (2391.97s), API Integrations & Exceptions (2519.995s), Time Zone Templates (2742.115s), Custom Rotation Shifts (2822.135s), Allocation Report Integration (2888.96s), Work Allocation Optimization (2966.635s), Pricing and Requirements (3047.035s), Automated Job Assignment (3115.37s), Q&A and Wrap-Up (3190.215s), AI Optimization Settings (3302.915s), Pricing and Availability (3394.515s), Q&A and Wrap-Up (3490.82s), Closing & Feedback (3621.84s)
Transcript for "Master Smart Scheduling: Live Build-Along Workshop":
Hi, everybody, and welcome to our Master Smart Scheduling live build along workshop. For today's session, we're actually going to be doing a build along. So while we're getting everyone settled in, if you would like to follow along with our work... With what we're doing today, you can actually find an application in the exchange that is going to allow you to, work along with us. If you're on business or enterprise plan, you can just use that QR code or the link to go right to the AppExchange and grab it. It is just a... The smart scheduling, like, example that we have built. You can also search for it in the Exchange if you would like. Alternatively, you're on a team plan. You have two options. You could start yourself a actual, trial plan where you can try out the enterprise and business features, and you could start using these features. Or you can also find this available on our builder plan. So if you're somebody who's looking for a way to follow along, don't worry. If you're suddenly saying, like, oh, I gotta do that before I can even pay attention to the webinar. This will be on demand, so anybody who wants to join us will be able to also follow along at their own speed. You don't have to keep up with Sam if that... If he feels a little daunting. I'm gonna do a quick intro of what, Goldcast, where we do our webinars just so that everyone feels comfortable. What you can find here is everything you're gonna see on the screen right up here. Just below it, you'll see an option for light mode. If you're having any audio or visual issues during the webinar, light mode is an excellent option to flip over to a lighter version that's a little bit easier if you run into any issues. Besides that, there's the chat just to the right where you can interact with us and everybody else who's, here for the webinar. You'll also find a section for documents. There'll also be links to all of the things that we're talking about today and some resources to follow along. And then lastly, q and a. That's where you can ask questions. Sam will take some of the questions that are about actual... The actual build that we're doing today and some of the stuff that he's showing, during his presentation. So as he's building stuff, if you have a question about a step that he's working on, feel free to ask it. Anything that's more about, like, the future of of, smart scheduling or more about, like, long term questions or things that are a little more technical, we'll save that for a q and a at the very end. Alright. So let's see. It looks like we've got a good number of people here today, and I'll refresh my memory memory. We are gonna have this on demand, so don't stress out. If you can't keep up, you can always come back and watch this again and do this at your own pace as well. Like I said, everybody who's here today, we're welcoming you to our smart scheduling build along workshop. It'll be run today by Sam. You're probably familiar with him if you've come to many of our sessions before. He is the product manager for this particular area, and he is... Smart Scheduling is sort of his brainchild. So he's the man with all the answers. So I would invite him up on stage so he can join us and actually take over the workshop for today. Hey, everyone. Can you guys hear me? I see, all the all the comments here on the on the chat. Yes, Heather. Hi. Okay. Yeah. Everyone, welcome. I, I'm so excited to be digging into this with you. Just an overview on today's agenda. We're we're gonna overview of the overview, I guess. No. So I'm just gonna overview. If you haven't seen, any presentations on what smart scheduling is, I'm gonna go over briefly what that is. I'm gonna give an update on what's new since Empower Pro. We just had an update go live this morning, which I'm super excited about as well. Then we're gonna get to the, the live build along, which is gonna be the the meat potatoes, the biggest part of this session. And then maybe five, ten minutes towards the end, we'll do q and a. As Evan mentioned, please ask questions as we go. I'm gonna try to be, you know, keeping, keeping eye on the chat, keeping eye on the q a, q and a. So as you have questions when we're when we're, diving into this, please ask them, and I'll and I'll try to get them as as they come up. So, right here, you know, just just again a reminder, there's this app in the Exchange. You can you can scan it with a QR code. It is best to search if you're just in the Exchange, and I'll show it to you guys when I when I start sharing my screen as well. Just type practice into the Exchange search bar, and it will be, one of the items that shows up. Or if you, have a team account and wanna try this out, you can you can either do the enterprise trial or follow along along in a builder program. Okay. So what is smart scheduling? Smart scheduling comes down to two reports and one really awesome optimization capability. So the two reports being, native reports in click based, one being called the allocation report. This is really like the drag and drop type experience where you're dragging tasks and assigning them to resources in a specific date time. And it's, interactive. So you can you can kind of zoom into a day view, zoom back out to a month view. You can reassign them. You can you can click jobs and suggest placement, based on on some details in your app, which I'll get to here. That's the AI optimization section there. And then we also have the availability report. So think like, I need to med... Manage the schedules of my team, not just only, you know, when are their working hours, when are they available? It's in the name. But when are they not available? So what are the constraints there? You know, wanting to be able to say someone's out on PTO or, you know, is going to be, out for two hours because of, you know, a daughter's dance recital. Right? Something like that. Or, you know, if we're wanting to track, like, company, holidays. Right? That is what the the main purpose of the availability report is. Pretty cool. And then the AI optimization. The AI optimization, sits on top of the allocation report, and, you can be looking at, you know, 30, 50, 100 jobs to be assigned to to, you know, for your day and your 30 resources and say, hey. Suggest the best, optimized schedule, and our optimization engine powered powered by Solvus will look at your schedule and kind of test all these different combination, combinations, and it's optimized, with constraints of the skill of the job that's that's required to complete the work, the skill of the resource that is there to complete the work, or available to complete the work, the availability of those resources, and the cost of those resources. And it's all draft. So if you wanted to be able to test one optimization goal, then go back and say, maybe I wanna optimize against, you know, least amount of resources or lowest cost or fair distribution. You you have you have options to kinda play with that before you finalize. Okay. So... And just so you can get a little bit of a view of what what it kind of looks like, before we get into it, you know, these are some of the the views that you can you can see. And, of course, we're gonna dive into it as well. And here's the availability report. Pretty slick. Okay. So some things that have changed since Empower. So we, had a huge update this morning, and, it really... We're trying to, address feedback around, you know, ex... The the navigation experience. So we improved the performance, you know, if if folks are loading in thousand jobs, you know, trying to view it across the weeks, months, you know, you can imagine that's a lot of data to to visualize. So we we made a lot of improvements there. Originally, within the the allocation report, as you switch between day, week, and month views, they were kind of different selections. But as you zoom in and zoom out, you can either pinch and zoom or control and scroll. It will automatically switch between the day, week, and month views. Also, it will... As you pat, tab over or, you know, navigate the the, the date ranges, it'll automatically update the date ranges that are being, being viewed at the top. And as you go to allocate your work or, like, use the AI optimization capability, it will... It'll keep those dates in mind. Yeah. What else here? Some... Yeah. Stability and bug bug fixes. You know, suggest placement is a really, really cool capability. So so, we'll we'll show that a little a little bit here. And some things to explore or we are exploring, from Empower Pro, we got a a fount of feedback from you folks. So these are the things that I wanted to just put on your radar as as things we're considering. So, some more calendar capabilities. We heard loud and clear travel, travel time and location optimization is, is that important to you guys? So so we'll be looking at that in in greater depth as, you know, as we look at this, in the coming months. I also heard a lot of feedback about additional constraints. So we're looking at that and kind of seeing what are the ones that folks are most interested in. You know, when it comes to availability or report, wanting to look at, like, exceptions regionally for for folks rather than just having, exceptions for everybody or or just, you know, an individual. And then some, like, alternative schemas. You know, some people may not have duration fields. Right? They might have start and end dates. You know, so we're looking at different ways we might be able to configure these reports that accommodate to more of your applications. Alright. And, look at me. I'm already answering questions here. Christian, you you absolutely will get, will be able to get access to this presentation afterwards. Totally cool. K? Alright. So I think we're at that point. If you guys don't have the QR codes already, here they are. I'm gonna actually start sharing my screen and, oh, it looks like I do not have the ability to share screen. Oh, there we go. There it is. Okay. Hold on. And... Alright. You guys see my screen now? Where we just were? Okay. So, I'm gonna start us here. Yep. I'm seeing all the thumbs up. Thank you, everyone. Engaged group here. So I'm gonna start us, from the my apps page in Quickbase and navigate over to the Exchange. So if anybody's just, doing this themselves, follow along. I'm gonna type in practice. As I mentioned, practice is a really good way to search for this and select smart scheduling practice app and click install. Now this application will be available on the Exchange. I don't really have intention to take it down. And if you're just doing this, by yourself and maybe don't have this recording handy, I did put in kind of, like, a step by step getting started guide of of, you know, how to kind of go about using this practice application. And it is intentionally light. Right? We only have work orders and resources, and it's it's there to kind of not only just practice or have an application to allow you to practice using these types of reports, but also to configure them. Right? Because, you you... The keen eyed among you may have noticed, these are the first reports in Quickbase that span across multiple tables. You know, historically, the paradigm of reports has always been when you go into a table and you say, like, I would like to create a report. You're creating a report within that table. But these allocation and availability reports as you see in the scheduling reports section, these cross multiple tables, and as a result, have a lot more complexity, but enables so many more features. So okay. Now before I, before I go any further, what I wanted to do is kinda just talk about schema in general. Right? As I mentioned, we have work orders and resources. But without going into the tables, right, it can be a little opaque as to what is required in order to, make these reports. And so, like, I made a quick little lucid chart, that I hoped to, would help dispel any kind of, confusion about it. Okay. So as I mentioned, we have the resources table and the jobs table in that practice app. Right? Now in order to be able to create an allocation report that the the kind of outline in blue here, There's little Venn diagram overlap here between resources, for both allocation and availability report. But all you need on the jobs table is the relationship between jobs and resources. So there so we can say, like, we're signing this job to this resource. You need the duration field of how long it takes, to do the work. And then you also need a start date time field. And, you know, it'll... It calculates end date based on saying, well, if I'm starting at seven and my job duration is two hours, it'll end at nine. Okay? Now... And just to just to make it crystal clear, anything in purple is what's required. The optional fields are in green, and this is where AI optimization comes in as well as some enhanced visualization when it comes to, availability. Once you actually enable or create, and create, an availability report, you'll be able to visualize the availability on the allocation report, and you can link those reports, and we'll we'll walk through that a little bit. So, also, when it comes to things like skills, skills are multi select text fields. But as you see with this, with these relationships, you can absolutely make these, like, say, formula multi select text. You can make them summary fields for multi select text. You know, hourly rate. It can be currency. Right? So, like, I wanted to kind of just show, like, imagine, you know, the... You know, most applications aren't just two tables. Right? They're... They have way more operational complexity, and here's just kind of an example of... Let's say you had a master skills table that you're sharing between both jobs and resources. Here's kind of like a suggested schema to enable some of that. So, like, master skills, which is like your skill categories, the skill names, how... Descriptions of them, and then being able to say, like, okay. I have job templates that are gonna be using multiples of these skills, and I want job templates as I create jobs. You can build in to the... Those, job templates the duration of the jobs, the skills that are multi selected against this master skills list. And so as you relate the job template to the job itself, you can pull down those values as lookup fields down into the into the report. And and, you know, the the... Essentially, the the complexity of your schema can scale with the reports. It doesn't just have to be the simple one. Are we supposed to have access to the jobs table in the demo app? You should have... As you create the app within the, Exchange, you should have access to everything. Yeah. And it's... I believe, Yeah. I believe it's named work orders here. Yep. Right here. Does that answer your question, Todd? Okay. And then same thing on the resources side when it comes to skills. Right? Master skills, maybe you have multiple skills that you have, like, a skills matrix where you're you're measuring the skill level of the the individual that has that that skill. So it's not just do they have the skill, but at what level are they, are they skilled. Right? Maybe there's expiration dates, related to this or additional notes that you're wanting to track. Right? We wanted to make sure that as you're considering... As we're considering, you know, operationally how people manage skills, you know, of their individuals, we wanted to make sure that the reports could accommodate those those alternate schemas. So here's just an example of that. And then, like... Yeah. Yeah. I'll come back to the other view. But let... Let's actually go in and, you know, first, let's create, I'm gonna change it up this time. I'm gonna do... Let's create an allocation report. So I'm gonna go into the work orders table. As you as you may have remembered here, the allocation reports are created within the jobs table or the work orders table. So if I go here and click reports and click new report, you'll see down at the bottom the scheduling reports section, and we're gonna click allocation and click create. Just like anything, we can go and say, like, work orders. Let's say scheduled work orders. You know, you just name it. This top section should look pretty familiar for anybody who's created reports in the past. Where it starts to differ is the data sources section. And if you remember when I talked about what fields are required. Right? The the ones in purple, related resource, estimated time to complete, or, duration, and, actually, I did... I should have called this one start date time. Well, we'll do it now. Boop. Those are the required fields. So if we go back over to the the application, under data sources for the work, we have map the duration field. And this application has two different kinds of duration just to... So you can kind of, get a picture of this. You can use a formula duration field, but that somewhat hobbles some of the capability, which which we can show you here, but I can select estimated duration. Now one of the cool features that we did add to these reports is that when you map the field, we've added this pen icon. So if you wanted to be able to go view the field properties of a field and change some things, you could absolutely do that here. Like, if there's a default value for duration if one hasn't been established, for example. That's cool. And, let's say we didn't have a start date time, which is the other field we need to map. We also added the capability to create one as you're creating a report. We really wanted to reduce the amount of friction folks had when creating these types of reports so they didn't have to go, oh, I didn't know I needed start date time. Let me go back to work orders and go into fields and, oh, I only have a start date and a start time or, like, I only have date. Like, you know, we wanted to kind of get ahead of all that, complexity. Yeah. I think that it's such a great feature. Oh, just looking at your chat here. Yeah. I think it's an awesome feature. Okay. Now one thing that we're not creating for you is the relationship. So, unfortunately, this is the one area where if you don't have a relationship to your resources table, you will have to go and create and then come back. This is something that we're looking at. But, you know, if you're already assigning resources, likely that you have a resources table. If you just have a user field, and trust me, we thought about this pretty heavily, it... You're not able to take advantage of all the good things that this report can do. And so we really optimize this to to be relational with the resources table and a and a and a jobs, kind of, or a work table. So, you know, things like the skills of the resource, you wouldn't be able to do within a user field. Things like the cost of a resource, you wouldn't be able to do with a user field. Right? So, that... That's why we have it as a as a as a table there. So you choose your reference fields, a related resource. When you do that, it automatically looks into that table and checks the reports that you have available. Now why would I map a port... A report... A source report? If you don't map one, that's fine. It's actually, it will use your default report settings for the resources table. But if you think about what's, different about this, right, we are mapping two different tables that have two different filtering needs, you know, dynamic filters, maybe grouping or, sorting needs that the traditional paradigm of, building a report only accommodates the table that you're building this within. Right? Just seeing here. Trying to find the AppExchange, but not sure what to search for. Rob, if you search for practice, if if that link didn't help, you can certainly, you... That's that's a good way to find it. It will... It's called the the smart scheduling practice app. Sorry. Just just getting caught caught up with the queue. I... My, moderators are giving me messages here. So sorry. Okay. Yeah. So there's two different, tables. Right? So we had to think, well, how are we going to bring down all of the dynamic filters, all of, like, the report formulas, right, the grouping, etcetera, and you map the report. So you can say, like, you know, you could choose one that already exists or maybe you could go and create one. And if we go and say, like, you know, create... You know, I'll choose the one that I made for this allocation report. We, also gave you a little pen icon that, like, that brings you into that. And this is where you'd be able to do things like set the first three fields that show up for the resources when you go and create the report. That's that's kind of important. These columns to display, if you think about, you know, some other patterns you may have seen, like, say, Kanban, for example, where it will display on the Kanban card the first three fields or the three fields that you map. This will work similarly with the related resources report. So the... If I'm choosing default columns, it will choose first name, last name, and skill set. Or if I'm remaining with the custom columns, I can choose up to three fields for it to show on the report, and it will show on the on the allocation report, which is pretty cool. And, again, like, any of the filters that you apply here, the grouping, the dynamic, filters that you add, those will all... Once you select that report, will will come down to the the the allocation report as well. Okay. Guys, I know I'm I'm moving through this, pretty detailed, but are there any questions? I wanted to make sure that if there's questions that are in your brains that you're asking them as we go. I don't wanna leave you folks behind. K. I'll keep going. Now because we started with allocation report, I... This availability report, you'll notice there's not one in here because we haven't created one yet. But that's okay. We can come back to this. We we don't have to do this all at once. That pretty much, oh, let me let me get my start date time in there. That pretty much satisfies everything that I need in order to be able to open this report. I can click save, and it'll bring us into the report right here. So you can see I chose a report for the resources that's grouped by role. So you can see I have grouping here on the left. Just, you know, the point about the, the filtering. If you click the filters over here, here are my dynamic filters that I have established for that... For the resources. So I can say, well, I wanna find Bob. Boom. Bob. Or, you know, I'm looking for somebody who has carpentry skills. Boom. Right? You can also, type carpentry over here, and it will start to filter that down, which is pretty cool. That's just a search filter. And then over here for tasks, you have the... When you click that, it also changes the filter out so you can see work order, filters. Or if I wanted to say, I'm looking for jobs that require carpentry. It will it will, reorder this over here. Cool. Any questions so far? Looks like no. You guys are following along? Everyone following along? Have we left anyone behind? No? Laura's good. Good to see. Okay. Dylan's good. Okay. Now if I want to use this and, say, start scheduling carpentry jobs, right, I can just grab from the pad and drag it onto the calendar. So, you know, here's this job. If I double click it, it'll bring me into a model that shows I have Amanda Foster, as the resource for, this carpentry residential edging. Now I happen to schedule it against a resource that's not capable of doing that work. I may wanna unassign that. If I click on assign, it'll bring it back into the the bin over here on the right. But I haven't mapped any skill, capability to this yet. Right? So it doesn't know... Or if I were to click it and say suggest placement, it doesn't know who has the skills because I haven't mapped any of that. It's just gonna suggest people that are available for the day and what time. Right? So it's gonna say, alright. You know, these people are available. And I can say, oh, well, Jane happens to be, you know, a carpenter during that time. Let's let's do that. Where'd you go? Do you guys see it? Let me... Here's a good opportunity to pinch out. Oh, I think once you schedule something, it locks the view. That is one thing that I think we just changed. Let's zoom this out. I'm gonna go to week. Inch zoom, you can see I can navigate around. Oh, yeah. Those those are my my, previous scheduled jobs there. But... Okay. So if I right click, suggest placement, Let's choose that. Yep. So you can see it just popped up on the on the schedule there. And if I were to go and, you know, I can I can open the job from here, which is pretty cool? This is something that we're looking at enhancing, improving in future releases. Also, by the way, once you start adding things, it it blocks your view. This is a temporary bug, but we wanted to get the experience out to you guys, ASAP, the updated experience. So, okay, if a job will take multiple days to complete, we'll map that too. So if... I wonder if I have one of those right here. Let's take one. I'm gonna take, Aaron, and I'm gonna drag this onto Tom Wilson. Right? And if I double click this, it will open up the model. I can say... Let's say this is gonna take thirty six hours to complete. Right? And if I keep pushing this out... Right. You can have... And I think you can even change this to days. Well... Yeah. Man, I just made it sixty four days. So the answer is yes. It will scale it will scale across multiple days. And, you know, as I, you know, if I were to save this and then, pinch out, you'll be able to see that, this job goes off the map. And if I tab over to November, December, you can see it scales all the way out there. Now one of the things I didn't show you guys is you can grab this leading edge and then change your duration automatically here. So we can say, oh, this Aaron's Aaron's job. Let's, you know, say it's gonna take a few weeks. Cool. And save that. So you have you have some options there. Can you set default allocation times? Yes. If you go into the, allocation times, I'm kinda curious what you mean by that. Do you mean duration times? You can set the default value of your duration field if you don't have it established. Let's see here. Can you say... Let's see. Sean, does it account for time off, weekends, holidays, etcetera? Yeah. Let's go... Let... Let's get into that. The colorization appears to be based on a default report. Can those be customized by formula variance reference? Yes. They can. Good question. Yeah. All jobs that last eight hours, for example. You... It's not a report setting, Jeff, to set all jobs at eight hours, but you can make that your default value. Let's let's go back into the config. Right? If you don't have one established already, you could go to the estimated duration field and say, like, hey. The default value is eight. Right? And, you know, just choose hours down here. That... Well, one of the things too to mention there is if you already have those jobs created, it won't absorb that default value of eight. We do have a default value of one hour if there's no, value in the duration field, but it's actually a good piece of feedback. Maybe we could make that a... Like an option, like a default duration if value is blank as an example. That might be that might be a bad idea. Let's see here. Can a job have multiple resources assigned? Yes. But we didn't optimize for that yet. This is our first kind of swag at this. So you can see that there's, you know, you're you're able to map to a related resource. Now one of the ways that I I thought about this is you could have resources related to a team and create your availability report and relate your jobs and and create your allocation report based off of a team table. And this kinda highlights one of the things that's that's really wonderful about this. You notice that we name things resource and work, but we're not prescriptive that you have to have your resource be a person. It could be, you know, a conveyor belt. It could be a team. It could be a truck. But if you're looking for it to affect, like, maybe, an individual resources, what you could do is you could have, you know, multiple, resource tables. So you could have one for carpenters, one for plumbers, and relate them to the jobs. So if the... If you had multiple, relationships between resources and jobs, you could have multiple allocation reports, one for plumbers, one for electricians as an example. But we don't currently have kind of, like, a many to many, UI for for the scheduling and for multiple resources. Not like that yet. Not yet. We wanna do a little bit more research on that. Okay. Now that we're kind of in this, building experience, I just kinda wanna go back to, you know, field mapping. Let's let's go to the AI optimization section. What I'm gonna do is... We talked about skills. Let's add skills. If I say, you know, from that drop down, add constraint, I'm gonna I'm gonna do it again because I I know that I did that quickly. I can say I'd like to add skills, and it will prompt me, well, what are the fields for the work table and the resources table that I wanna I wanna select here? So on the work table, I can say, oh, perfect. Required skills or, again, you could create one. Or resources here, skill set. Cool. I just added those. I'm gonna click save. Now what you will see on the task side is that it adds the, skills required for the job over there on the right. Now I happen to have the skills, identified on my on my, report. So it shows electrical and flooring, semicolon, delimited. There will be updates, soon that will actually render this with the the correct rendering. We just have it kind of rendering as text now, but you will see it like these pills are on the right, here shortly. But what you can do now is if I were to click this job and suggest placement, it will look for people that have the painting role and suggest them. So now we can say, oh, Sarah, at 12AM. I haven't... I... We haven't mapped allocation yet or availability yet, so it's it's suggesting weird times. You know, has the ability to do it then. So we could say, yeah, let's do that 12AM. And if we go over to and save, you'll see... Where is she? I don't see that job. What date was that for? Let's try this again. Suggest placement, October 28, which is the Wednesday. Okay. Yep. That... Yeah. Yeah. Yeah. Yeah. Let's look at the... We currently use Brintam's scheduler tool, and this is very similar. Thank you. They have they have really, really awesome tools. Cool example, Sam. That makes sense. So you have people and a truck, and the truck gets jobs. Yeah. Jeff, totally on the spot there. If you have a team of two and the job is one hour, but then the team of two becomes a team of one, and the team of resources... Can the time of the resource then become double the time and automatically update? There's some interesting stuff there. Like, so, you know, in my example here, like, hourly team cost, if you remove folks from the assignment, you could have some automation that changes that. And you could see, like, this this is a summary field, but you could have a formula based on summary, based on number of resources assigned. You know, you could do some some, complexity there for sure. Okay. I I wanna address... I know we're we're, I mean, we're a little more than halfway through. I wanna actually address some of the questions around, resources and their availability. And that really comes in the form of, adding the availability report. So I'm gonna go click the resources. Well, I may as well save my allocation there. I'll go into resources, click into reports, new report, and in this case, I'm gonna click the availability report. Click create. And this one, we got pretty cool with. You can see this blurb up here on the top. We will be creating four new tables called availability assignments, availability exceptions, global exceptions, and availability templates automatically for you with the relationships all needed to be able to stand this up. So in essence, all you need to do is, you know, name it and click save. And you'll notice over on the left, the four tables come into view, and you're ready to go. This this is, probably the easiest report to create in Quickbase, but it's also the most complicated one, which we're very proud of, honestly. So... But just to orient you here, some of you might actually have, you know, like, a Pendo guide where it's guiding you with... Through clicks of, like, hey. Click here to, you know, view availability. I've dismissed them so many times at this point that, I don't think they pester me anymore. But you may... If it's your first time going in here, you may have noticed, some of that in your environment. But... So you have kind of the the dates here in the middle. So this is our current week. It's Tuesday. So we're viewing the week of October 26. And you have your resources down on the left. You have templates over here on the right. And then when you click on a resource, you can do two things. You can either create an assignment for that resource or create exceptions. So think assignments as, like, what's their recurring schedule? And what's cool about assignments, we're we're gonna say let's create a custom assignment here, is that they have, sorry. Yeah. When we look at Amanda, we have a start date. Right? So... And we'll say, like, your normal working hours. We can establish... We want this assignment to start maybe... Maybe we wanted it to start October 1. Okay? Oh, October 1. There we go. And you can choose when it ends. So, you know, for, you know, let's say contract work, you could have it end on, you know, maybe the end of your contract date or maybe you're on a specific project. Right? So you can say, oh, I know this ends January 1. Right? So you could have a temporary assignment that has these specific hours, and you can apply them. And on the normal assignment pattern, you have weekly, where you can, you know, toggle on or toggle off when you're gonna be working. Now this right here would suggest that every week between October 1 and January 1, I will have availability to work Monday, Tuesday, and Wednesday from nine to five. And then Tuesday through Sunday, I will not have any availability to work. Following so far? So far so good? Feels like this tool will allow to build email notifications. Oh, I think that's from the allocation report. Yeah. I mean, we we didn't add any, additional capability on the email report stuff, or on the email capabilities. Remember, it's Quickbase. Right? So you can use notifications, subscriptions, reminders as jobs get scheduled to send notifications to folks. Is there a way to assign these templates across the entire team, or can you do... Only do these individually? We're actually exploring that, Laura. Perfect question. I I would say, yeah. We're gonna we're gonna be doing that. But remember, we're still in beta. We're we're we're filling out how people are going to wanna use this and how they are using it. And so we're gonna get way cooler with with how folks can, make these assignments. If you have, one thing I'll do here. I'll just put in an assignment here. Click save assignment and click done. Just so you guys get to see, hey. We made the cake. Amanda's availability, nine to five. As I pan through the days. Oh, past January, Amanda's no longer available. Right? That's how it works. It ends up being one record in the availability, assignments table, which is pretty cool. We thought really, slick on how to make this efficient use of your, your app space. Right? So, you know, in order to be able to assign that, we would have one record, and we just have one is the pattern start, one is the pattern end, which is pretty cool. To answer your question, though, about, like, assigning to, say, multiple people, if you have Quickbase Intelligence today, what you can do is you can say, hey. I have an, availability assignment for Amanda that I would like to copy over to the rest of the resources. Can you do that for me? Right? Quick based intelligence is incredible. If you don't have this already within your environment, I would strongly suggest to get it. It, like, really shortens the distance between two points. You know, if you were to do this alternatively, what you could do is you could go into the availability assignments table and literally copy, you know, and and multiply the existing assignment record and just change through the related resources. You could do it pretty quickly. Will this work with APIs, getting information from other systems to help schedule production? Absolutely, Frank. I think that's a that's a really good use case. You know, let's say, for example, let's take exceptions. You know? Someone puts on a shared calendar, hey. I'm gonna be on PTO on the thirtieth. Right? You have, quick based integration that logs someone else's availability in another, you know, system, let's say, like, Workday, for example. And then when that record gets created, go and create it into the, availability exceptions table relating to the correct resource. You can totally do that. Exceptions appear only to be for unavailability. Could this be made smarter? If an exception falls on a day that resource is not usually available, they'd be available or vice versa. So if an exception fall... So, Laura, I think you may be my audience plan. When I was thinking about availability, I was also thinking about, like, exceptions being working exceptions, not just nonworking exceptions. My moderators are messaging each other right now, like, oh, first request. Yeah. No. I think that's a really, really great idea. So more to come on that, Laura. Thank you for asking it. Is there anything in here to skip holidays? Can you talk about skip holidays? What do you mean skip? Oh, looks like my my AI chat flopped. Nice. Avoid assigning people to work that... Oh, yeah. Absolutely. I'm... Laura, thank you for asking. If I go to global exceptions and say I'd like for everyone to have Friday Halloween off, let's put Halloween with a big old pumpkin and a ghost, and let's say it's on Friday. It's an all day event. I save the global exception and click done. Everybody has now been blocked off for Friday. No one will be working. Also, if I go... Let's let's go, to the availability assignments, that we were we were talking about here. If I go into availability assignments, you can see the record that was created for Amanda. We have a, we have, like, an expression of how to how to have the recurrence work. We're gonna be, documenting this and sharing with you. So if you guys wanna use pipelines to say create these outside of the report, you'll be able to do that. Let's see here. If I go into edit this and... Let's see here. Let's add records. Yeah. And I copy this and bring that down, paste it, and, oh, I need to add a field. Let's just save this for now. Columns, related resource, cool. And now I can go and say, I'd like to add this one to Bob, this one to Christopher, David, James. Right. Now if I go back into my resources and pull up my team schedules, and you can see their availability starts filling out pretty quickly. Can this account for resources or work in areas that cover multiple time zones? That's actually kind of the point in a sense. If I go to templates, and we haven't shown you this yet. If you go to templates and click plus and say, like, you know, Pacific working hours. Now you're... You... This is a... It considers time based on what your app's time zone is set at, today. So if I wanted to say, you know, this is an Eastern app, but I'm I'm gonna say, well, someone who's working Pacific is gonna be working 12PM to, you know, maybe... What is that? Eight? Twelve to eight? Does that make sense? Yeah. And we can go in here and copy. This is the... Currently, the fastest way that I've found is I, like, grab the top here and paste. We will be looking at implementing something that will help you to, like, copy, you know, an availability from one day into multiple days on a template. By the way, you can click this plus button, add splits. So if you wanted to work like the, the post office and have, you know, an hour break in the middle of your day, you could you could map availability with that little of complexity. Also, I didn't actually show you this. Well, I'll save this template first by a plus, and go in and say custom rotation. Let's say you are doing, you know, fireman shifts where you're doing four days on and four days off. You can have a kind of, like, nonstandard, weekly rotation. So let's just call this fireman shifts, and we'll do... What is that? Nine to seven. Yeah. Cool. Save template. Okay. Now I got two templates here that I can go into and say, apartment shifts starting. Monday. Pattern starts date on Monday. No one in sight. Save assignment. This is really cool. So you can see four days on. Well, they wouldn't have worked Halloween anyway. But you'll see as they start scrolling through, it kind of maintains that pattern. Four days on, four days off, so they keep on edging forward. Cool. Now let's close the loop on all of this because I know I've been talking a lot about availability here, but, how does it apply to the allocation report? If I go to reports, go back into the allocation report, and we go into the configuration, we can now map the availability report, team schedules. And I can turn it on in the app. While I'm here, I might as well add the resource cost, which is pretty cool. So now I can know what the hourly rate is of my resources. Now we have a fully capable app where you can see the availability for these resources is now identified in white. Right? Only out of it for a few people. But because I've done this, now when I go and then say suggest placement for Aaron, it will say, hey. We have a job that's HVAC residential blowout. Bob is the only person that can do this because he's available. And what is their cost? So if you had multiple resources that had, the same sort of skill sets, it would give you an option of, like, this person's available, and here are the people that are... These people are available. They are skilled. Here's the, here's the cost of them, which is pretty cool. Additionally, what you can do is now you can say, I wanna allocate work, working hours between eight and five. Yeah. Let's allocate it for today. I'm gonna, actually choose, yeah, eight to five. Let's do eight to seven. I can choose an optimization goal. So I can say, I'd like to either minimize cost, use fewer resources, so we'll try to fill up the resources that... You know, the least amount of resources so you can kind of manage a lean day or fair distribution. Let's see. Fair distribution. I click allocate. Now we're sending this off to Solvus, and it's looking at all of the jobs that need to be completed. 702 jobs across six resources that are available for that day. And, you can see we we put an estimator here, a time estimation of... Well, what's interesting about the, the way this works is it's not just testing things. It is running every scenario of how these jobs are caught... Are are assigned and coming up with the best result. So it's literally testing kind of like, if you guys like Marvel, like doctor Strange playing on all the ways defeat... To defeat Thanos. He's actually playing on every scenario in order to be able to choose the best one. That resonates. While this is continuing on, I'm gonna look at the chat here. Can the account for resources you work on areas that cover multiple time? Oh, yeah. That's right. Yes. Yes. Oh, Sammy, I love it with the with the with the with the meme. That's great. Let's see here. For example, we have some technicians who will do work in the morning eastern and then, after in central. Yep. The templates really help to to accommodate for that. But I think we're we're wanting to kinda dig a layer deeper when it comes to time zones. So that way, if someone who logs in who's on Pacific, they're not getting this weird dissonance. Is that cost optional only available if you have AI tools? No. Actually, this is one thing that's really important to call out. You do not need AI at all to use any of these features. The Allocate work will work whether you have, Intel pack or not. All you need to have in order to be able to use these features is either business or enterprise. That's it. Everything else just comes with it. Yes, Sammy. It's been too long. Okay. So you can see the optimization came down. It it assigned or suggested, placement for all these jobs. I like it. Maybe what I'm gonna do instead of this, I'm gonna click this and unassign that job. There we go. Bob's good. I click save. Now that just assigned 23 jobs across all my resources considering what their cost is, what their availability is, whether they are skilled to do the work, and I just saved it. So, you know, within a matter of minutes, I not only would have had to, within a normal form, say, you know, who is the assigned resource? I need to choose what day, what time the job is gonna be occurring within. And I'd have to do that against 23 records. My gosh. That would have taken so long. And I wouldn't have even... Imagine all the work I would have had to have done in order to be able to know, are they the right skilled person? Are they the lowest cost resource? Are they available? Like, the intersection of all those complexities just doesn't exist or hasn't existed in Quickbase or other tools for that matter, up until this point. So it is absolutely incredible. Okay. So that essentially covers off the line share of what I wanted to talk with you about. I think we have a few... We have five minutes left. We go back to our slides. You know, I wanted to provide you guys an opportunity to ask any final questions. You know, let's see here. I just wanna see... Laura, I tried to add global exception for twenty ninth and then modified the Aaron, job to the multiple day job, but doesn't split the job. Does the day split? Oh, that's interesting. That's an interesting thing to consider. The availability of a resource doesn't affect splitting of work. I'd be interested to know more about how you would want that to work because I can also see people not wanting it to split and actually causing... Like, surfacing a warning. Like, hey. You have work assigned to a resource that's not available. Do you wanna reassign this? Right? One thing to call out about AI optimization, AI optimization only works for jobs that are under a twenty four hour window. This is intended for task based scheduling. So a a lot of it kind of lends to, you know, the logistics of travel. Right? But we are looking at, obviously, being able to AI optimize against, jobs that exceed the twenty four hour window, let's say, three days a week, two weeks a month. But, I think that may best be served in a different report or maybe a new report. That would be cool. Some more to come with that. But, Laura, I'd be interested to know more about how you wanna how how you wanna run that. Sammy asked, AI optimization. Proposers assignments based on constraints you can figure in the allocation report, including availability, skill, and cost. It goes to a set of assignments. You review them, change what you want, and save when the result is right. Nothing is assigned until you save it. Hey. It's a good summary, man. AI optimization is on by default in a new allocation report. Your account administrator can turn AI optimization off. Yeah. That's actually, an important thing to call out. If I go into... Oh, I'm no longer sharing. But if you go into the config page, you can turn off AI optimization entirely. The button won't show up. You can shut it off in your, admin console and say, like, AI optimization is not something you want, to have on your realm. You could do that too. If you just wanna get the good old fashioned drag and drop time scheduling, you can certainly do that. Robert, hey. Would you be able to go back to the settings page for the allocation report? I'm not able to see the checkbox to show cost on my example. Yeah. I could. What about downtime or equipment failures? I would think, Frank, downtime or equipment failures may be exceptions. You know, imagine you could use an availability report to manage the availability of a of, you know, an a piece of equipment. Oh, that's kind of a fun thing. I'd want... I wanna rabbit hole down that idea. Sam, could you see the questions in the QA also? Yeah. How are we doing on time? We have, like, a minute and a half. Yeah. We're just about... You have a couple you have a couple minutes to go. Okay. Evan, do you have any... Do you see any questions that maybe I didn't get? While you're pulling up your example, I'll just bring up the one that came up a bunch that people might not have seen in the q and a. People were asking about what is the, availability for this based on, like, plan? Is it on a package? So in order to use these features, it's on business and enterprise plans. You don't have to have intelligence package or a separate AI package to use AI optimization. This smart scheduling, which Sam was showing off today, is just under business and enterprise. So you'd be able to use this. And to Sam's point, it would follow the same rules of you could still restrict access to it. You could say, I don't want the AI to be available in my app, if it was, like, a permissions concern. So it'll be available, but you'll still have a way to say I don't wanna opt out of this if it's... If you're an account that's not comfortable with features while they're in beta or if they have features if they're not, approved by your teams. So you think about it as, like, way more about the level of plan you run than about buying a package. But to Sam's point, it is more powerful if you can combine it with QBI because then you can do some of these things like a machine breaks, I need to move jobs. That's something that, like, the AI agent might be able to help you with, stuff like that. And we have ideas on ways we'd be able to use the intelligence to surface up insights about how optimization's going. Right? So, yeah, more to come there. But I I wanted to address two questions. I know we're we're pretty much at time, but here's here's the one thing. You know, if we look at the... You guys can see it. There we go. If I go back into the settings, what you should see when you get into the allocation report and scroll down under AI optimization, there's, ad constraints. If if the cost wasn't here and I click the ad constraint, it should show if it hasn't already been mapped cost. And then under the resources section, it should say select field. Oh, I found a bug. Look at this. It's no longer showing me the ability to create a new field. Oh, that's a good one. But, yeah, you'd be able to select your field. Or if this is your first time doing it, I guess, we have a bug to fix. You'd be able to click create the field for me. And then when you save, it'll create the field. I hope that answered that question. And then one... Just one more. I'm sorry. I know we're out of time. But we did receive a question that was about, is there an option to assign multiple jobs to a time window? Let me just stop sharing my screen here. Is there, the option to assign multiple jobs to a time window without specifying the exact time frame? For example, hey. The work needs to be done on a specific day, but when it happens during that day, it doesn't matter so much. This is a question that I'm getting a lot, and I think it kinda comes down to maybe, a different use case, which is more around, like, capacity planning of resources. It's something that we, are passionate about. It's something that we hope to address. But, currently, the schema for this report requires date and time. So, might be able to hack it with the existing report, but I'd wanna know more about how you wanna do that in the future. So that's that's that's all I got for for my bit, Evan. Sorry for taking the extra two minutes. Not a problem at all. So for those of you who are still with us, thank you for joining. Like I said, everything will be available on demand. Also importantly, we will be going through these questions to see if we can get answers for some of the ones that have popped up and follow-up with you if there's something that was very specific to your build or not. I will say if you have future questions and, insights for us and feedback, it's super easy to give that feedback. Anytime you're on an allocation report or an availability report, you'll see a help us improve this report at the very top. That banner is actually clickable. And when you click it, you get an option to either let us know about a bug or give us your future feedback. So, like, while you're in there using it, send us your thoughts. It's super easy. It's right in the reports. So anytime you're in there, if you run into a problem, have a thought, send them to us. We really want your feedback when it comes to these betas. In particular, I know Sam is really excited to hear about your thoughts on the AI optimization. So test it out. Try it. Give us your thoughts. Let us know. Is there more constraints? Is there more things you'd like? Is there things working the way you're not... They're not supposed to be thinking? Sam is absorbing all of this feedback to make it even better. So that's my, like, very end plug is give us your thoughts. Yeah. I... If I were to assign homework to anybody, go and use allocate work. We want more feedback on people using that optimization functionality. Is it helping you schedule your jobs? Is it giving you results you didn't expect? Are there additional functionalities you wish it did? Right? We want more feedback on that. So if you could do anything in this report, please use that, try it out, and see if it helps your business. Thank you, everybody. for joining us. We hope you have a great rest of your day, and thank you, Sam, for presenting. Yeah. Absolutely. My pleasure. Bye, everyone.