 Hello everyone, thanks for joining me for today's Empowering Mobile Users webinar, where we're gonna focus on why it may make sense to extend your solutions past the desktop, and then we'll jump into a quick 20 to 30 minute demo showcasing how we can leverage the FileMaker platform to quickly address a common mobile task. Now this webinar is designed for those of you new to the FileMaker platform, but keep in mind we will be utilizing some beginner advanced techniques in the demo portion. But first, let's spend about three to four minutes on some brief housekeeping notes and talk about some of the mobile trends in the workplace. So for the best experience, it is strongly recommended that you participate in this webinar with at least a broadband connection. So if you have any problems or require online assistance at any time, please contact Citrix Technical Support at 888-259-8414. Now throughout today's presentation, you're gonna have the opportunity to type it in as questions. So let's talk briefly about how to do that. Just go to the control panel, click on the question section, enter your question and click on send. Now we'll try to answer as many as time allows at the end of our presentation, but remember, you don't need to wait until then to submit a question. So the FileMaker platform is a full line of products that give you all the tools you need to create a custom map that transforms your business in or out of the office. So what does the platform look like? Well to start you have FileMaker Pro Advanced and that's used to create your apps on a Mac or Windows machine. And then when you're ready to share your solutions with your team, well you just upload them to FileMaker Server. This is a software application that you can install on a dedicated machine and it provides the connectivity, the security, the reliability and the performance that you would expect as you in a sense manage your own cloud. Now at this point, the first group you're sharing the solution with is typically the immediate work group in the office. So for your everyday users or the users you expect to be constantly logged into the file making heavy changes to data, they're gonna have a copy of FileMaker Pro on their desktop and they're gonna use that to log into your hosted solutions. But as we'll discuss and which I'm sure you're aware, the demand for mobile access has risen. So how can your remote users access your FileMaker hosted data? Well for your iOS users, FileMaker Go is a fantastic option. We believe that iOS offers the best mobile experience and we truly believe that FileMaker Go offers the best experience on iOS. And FileMaker Go allows you to access your hosted solutions on an iPad, iPhone or even an iPod touch. Additionally, FileMaker's web direct feature is a low code, no code option that provides web browser access to your hosted solutions from a desktop, mobile tablet or phone web browser. That's right, you don't need to know how to code HTML, CSS or PHP. FileMaker will automatically render the layouts to the web for you. And it's available for both iOS and non iOS tablets and phones. So you're given all of the database tools you need to design a better business workflow and a full suite of applications to design a better workplace. So why do companies gravitate toward FileMaker as a strategic mobile option? Well to fully answer that question, let's take a quick look at the current mobile workforce landscape. A recent Citrix article noted that 61% of workers reported working outside of the office at least part of the time. And who here isn't guilty of at least checking their work email on their phone, right? But it makes sense. With the amount of smartphones and tablets being shipped and bought each year, consumers literally transform their personal lives and these mobile expectations have been shifting towards the workplace. And that rise of mobile technology in the workforce has been widely documented. In fact, according to the Citrix sponsored workplace of the future global survey, 91% of respondents plan to have a mobile strategy with 82% estimated to have implemented one by this time. And of course, mobile solutions are integral to a mobile strategy. A CIO article ported to one Hyperion survey noting that 70% of respondents plan to equip 1,000 users with mobile apps and a third of those respondents had plans to deploy 5,000 mobile users by 2016. But businesses aren't just looking for any downloadable app that's out there that may or may not fit their needs. Hyperion's mobile enterprise application survey found that the leading strategy for mobile adoption by IT leaders is creating their own apps to address core business problems. So companies are aware of this trend, they're embracing it, but challenges do exist. So what factors can lead to the suspension or closure of a mobile project? Well, a big variable to any company just like yours is time and cost. Now, Kim V CIO and Mobile Leader State of Enterprise Mobility Survey noted that 76% of the CIO respondents wanted to reduce costs and they wanted to increase productivity for their teams while also creating new revenue opportunities. But they also felt that the mobile app development is costly, it's slow, and it's frustrating. 56% of respondents noted that it takes seven months to a year just to build an app. And we're not even talking about training or adoption or deployment here. And then more than half are paying over $100,000 for an app that they may or may not get off the ground. It's not surprising then that the leading factor for the inability to advance their mobile strategy was lack of budget. And remember how we discussed that IT managers were looking to build their own apps? Well, Cody's Enterprise Mobile Application Report notes that 71% of respondents expect IT to manage these apps. So IT is being expected to step up and extend their traditional support and performance monitoring to these new mobile projects. Their conclusion is a disconnect between aspirations and capabilities. So while they view the role of the IT team as important, a burden IT team may cause the mobile strategy to fall into unplanned development actions resulting in the perusal of other infrastructure strategies. And let's also note that a lot of you may not even have the luxury of an IT team to lean on for assistance and guidance with more complex software. But if the larger companies are feeling the pressures of these challenges, we can only assume the impact these obstacles create on medium and smaller sized companies that have even less resources available to them like some of you today, right? This is what makes the Fomaker platform attractive. Because to solve mobile workforce problems, companies will look to apps that you can easily download and install, but customizing them is extremely difficult if at all possible. And then by using traditional tools, well, companies can get a solution to do exactly what they want, but as we discussed, this can be a very time consuming and costly project. And then just maintaining that solution can be costly as well. But Fomaker is an excellent alternative that makes it easy to create custom apps that cost-effectively bring together all needed information, quickly streamline business processes, and can easily be updated and deployed across different devices and platforms. But don't just let me tell you. Let's take a look at Fomaker's recent state of the custom app report. Remember how we discussed lengthy projects and over reliance on IT? Well, 52% of respondents noted that they built a solution in less than three months. And 93% of respondents noted that they helped build or built one or more Fomaker custom apps in their business. Again, Fomaker allows teams with limited IT resources to do custom development. And this short length of time and hands-on approach hasn't affected the quality of their workflows. 74% of respondents saw increase in productivity for an average of a 60% boost in production levels, while 81% saw a reduction in inefficient tasks. So they're achieving their goals, but they're also getting more done in the same amount of time. And then 60% of respondents saw a return on investment with 20% equaling two times the original investment. So it's a result you want at less cost and better flexibility. And companies have been using Fomaker to build fantastic apps that capture some of the same things that you want to capture, but in a way that makes sense to their unique business workflow. So what do some of these solutions look like? Let's take a look. A private airline in France, well, they use Fomaker based solution for their airplane maintenance process and stock management. Servibar, makers of famous hotel guest room refrigerators, they use a solution to report and view critical maintenance issues from anywhere in the hotel. GlobeNet System Inc. has created a customer management sales management system with an iOS front end that provides features such as registration of new customers, unpaid or paid item information and calculation of total sales. World famous Arturo Montero takes his solution to the field to capture data and record archaeological sites in caves in real time. Valley Oxygen uses a medical sales system allowing medical device sales reps out in the field to track clients and managers while monitoring their sales goals. And Broad Electric has improved job safety by digitizing their job safety analysis process. So it used to be a binder full of pages and now their field team can access safety recommendations and risk assessments just one click away in the field. So six unique mobile business workflows all built on the same file maker platform. The possibilities of mobile solutions are virtually endless. But by now I'm sure you're thinking, okay, I get all the statistics, the examples look great, but can I really deploy a mobile solution that tackle some tasks without diving deep into months and months of coding? Well, the best way to answer that is to show you. And to help frame today's demo, let's assume that we're part of a sales team for an emerging auto parts reseller and one of our biggest sources of income are the automotive trade shows that we're constantly traveling to and participating in. And one of our biggest sources of pain is the quoting process. Now, just to take a step back for a second, the use case for our app isn't particularly important because we're gonna be covering techniques and methodologies that apply to all file maker solutions. But again, our main goal today is to quickly create and deploy solution to our mobile users. Now back to FM auto parts. So there's a lot of work that goes into these trade shows. The process for just planning and prepping for one is very time consuming. And when it comes to the promoting, selling and quoting on the floor, we're certainly not making it easier on ourselves. Pretty much all day, we're on our feet. We're dealing with information scattered across multiple sheets of paper. So we'll have a stack of printed inventory list that we'll hand out to customers, another stack of quote forms, and some spreadsheets of inventory and customer information that we use to update and capture data. And our quoting process typically looks like the following. So when somebody comes by to chat with us at our booth, we'll take a sheet from the inventory stack for him or her to review. And hopefully by the end of the day, we don't run out of these brochures, which has happened a few times, but the alternative is over printing and wasting money on paper that almost immediately out of date after each show. But if they're interested, we'll manually build out a quote cross-referencing our inventory spreadsheet each time to verify availability and we'll calculate on the fly an estimated cost while the customer patiently waits. We'll then hand the clipboard over to the customer who will write in their contact information. And once we've given the customer a copy of the form, we're kind of hoping they don't lose their copy and that their handwriting is legible for follow-up processes. Next, we'll take out the inventory spreadsheet and we'll manually update the list to reflect any changes. And for the most part, we're pretty accurate, but when our booth gets really busy, we do sometimes miss items to update, which causes additional work down the line. But when we get back into the office, which could be days or a few weeks depending on our trade show schedule, we or the admin in the office will manually re-enter that information into an existing system and we'll file away the forms as well. And then when it's time for our next trade show, well, we'll head out to the local print shop to print out the inventory brochures, quote forms and the spreadsheets to start the process all over again. So we do get the job done. It's just a very time-consuming process and we're not working with real-time data. Now, let's go ahead and assume our boss is, well, let me go ahead and just choose someone from our attendees list here. And, okay, today we'll say that Cathy is our boss. Now, Cathy knows that at every show, we're losing customer opportunities because of our paper-based process. And once the data is collected, we're spending way too many wasted cycles on inefficient processes and it's costing our company a lot of time and money. And that's when I get called into her office. Now, Cathy knows there has to be a more effective way to empower our mobile users and she wants the following. We need the sales, the field sales team to be able to access information in real time wherever they are. Now, Cathy's also tired of putting dead money into apps that can only do half of what we need and lengthy projects that have failed to get off the ground. So she wants to make sure we're able to capture the workflow that makes sense to us and it's also gonna make our jobs easier out in the field. She also wants the customer experience to be better too as we help speed up the sales cycle. And finally, she wants to be able to better utilize these iPads that we've purchased for the sales team but haven't really found a way to effectively leverage in our process. Now, that's a lot of moving parts and with the tools I've just been given, I know I'm in for a long string of weeks or months of head working on this project and it's just not even a good day for me to start thinking about the project. It's close to the end of the day on Friday. I'm headed out to another show and if I don't leave soon, I'm gonna be sitting in additional hours and hours of traffic, I'm adding time to my trip. But that's when I remember FileMaker. And the first thing I need to do is make sure I can actually build something that our team can access out in the field. So I'm gonna create a brand new database file. I'm gonna configure appropriate access in my solution, host it with FileMaker server and then connect to that solution via FileMaker Go and WebDirect. So let's go ahead and talk about how we do that. Now, there's a lot of different ways to get started building in FileMaker. But what I'm gonna do is launch the FileMaker programs I have on my machine and we're gonna go ahead and just create a brand new solution. Let's go ahead and give this a name. Now, I am using a Mac, but these are the same steps that you're gonna follow if you wanna start building on a Windows machine as well. Now, we're immediately taken into what we call layout mode and this is where you can design the look and feel or the interface of your solution. And you can create as many layouts as you want. So let's go ahead and create a brand new layout. I'm gonna give this a name. We'll give this, we'll call this quote details here as well. And in this layout wizard, we can choose all right, what is the layout dimension gonna be built for? It's gonna be built for a desktop. Maybe you wanna build a layout for envelopes or some reporting labels. Again, we have a team out in the field and we know that we wanna make a layout design for the iPad. So let's go ahead and select iPad here, choose to build us in a form and I'll choose a landscape orientation. So what happened? Well, we got a layout design to the iPad in a landscape orientation and we're also given a theme. Now there's 61 themes in FileMaker. They're fully customizable so you can modify them, edit them, however you want. And you'll notice that some of these are marked as touch. If we take a look at the difference in lighting to enlightened touch, sophisticated to sophisticated touch, the touch themes have the larger fonts and the larger objects like you'd expect on an iOS device, perfect for what we wanna do. So we'll stick with this enlightened touch, okay? Now the next thing I'm gonna do, we have this blank canvas for us to work on. I love to add a title to this layout. So I'm gonna add some literal text and we'll just say the name of our company, okay? FileMaker auto parts, all right? Now I do have a logo of our company. I love to have that appear on every single record here in the layout. Let's go ahead and drag that logo right onto our layout and you're gonna hear me say that a lot today just dragging and dropping. So we drag and drop that image right onto a layout and it's now gonna appear on every single record just like we want a great way for us to begin extending our brand. At this point, we probably wanna add some information on our layout and in FileMaker, information is stored in what we call fields. Then we have this fantastic tool called the field picker which is gonna allow us to create some fields for this particular table and add them to our layout. Now I'm gonna go ahead and click on this new field button. We probably wanna capture the rep who's the sales rep that is building out this quote. We probably wanna capture the date. Now I'm gonna change the default type from a text to a date field. And I also wanna make sure that every quote that we're building is unique. So I'm gonna create a ID field here which is called this quote ID, all right. And I'm gonna change that back to a text and then I'm gonna control click or right click if you're on the windows to bring up the field options. And we have a calculation function that will automatically generate a unique ID. Let's just get UUID function, okay. So we'll just leverage that. So anytime a new record is created we'll automatically have a calculation value entered for us, all right. Now, how do we get these fields over onto the layout? Well, just like we talked about previously we're just gonna drag and drop. So let's go ahead and highlight these fields and make sure that it's coming out horizontally. We'll put the labels above and we'll drag and drop it right onto our layout that easy. What do you say we take a look at our changes? I'm gonna exit this layout and I'm gonna enter what we call browse mode. This is where you can interact with the layouts that you design and create. So I'm gonna create a brand new record and I'm gonna enter a name here. And just like that we are working with a solution that we created. Now, there's a lot of paths that we could take here. We could start adding some security to this file. We could start locking down who can log into the file. We could create some privilege sets specifying what they can do in the file once they've logged in. But I don't wanna dive too deep into development. Again, we're tired of burning money on apps and solutions that don't do exactly what we wanna do. So if I can't prove that I can get this over onto an iPad or a web browser quickly and easily then it's not gonna be worth it to me to continue spending time on this particular project. So how do I get this over onto an iPad? That's a great question. And the first thing I need to do is share this solution with FileMaker Server. So let's go up to the share button. I'll select upload to FileMaker Server, okay? And again, what is FileMaker Server? It is a software application that runs as services in the background of your machine. It hosts your files, it provides the security, the performance, the reliability that you want, again, in a server software. All right, so I've sent this file up to the FileMaker Server and you'll notice in parentheses that it says my FileMaker Server machine at the top just giving us an indication that we're now accessing a hosted file. So again, that's great. We're accessing it via the desktop FileMaker Pro. How do we get that over onto an iPad? Well, in order to show you, I'm gonna launch this Reflector app and Reflector just allows me to airplay the iPad Air I have in my hands over onto the screen. So give me one second to do that. Okay, and I am selecting my computer right now. And there is the iPad Air I have in my hands. I'm gonna tap on FileMaker Go. That's free to download off of the App Store. And down at the bottom, you'll see three icons that we have. The recent icon shows the recent databases that I've accessed. If I tap on the device icon, this shows databases that are stored locally on this iOS device. Now why is that important? Well, my field team is not always guaranteed a working network connection if any network connection at all when they're out in the field. So in their scenarios, what I can do is store a local copy of the database on this iOS device. I can open it up, add some records, make some changes and then push those changes to the hosted file when I do have a network connection. Speaking of hosted files, if I tap on that third icon hosts, this is where I can access FileMaker software that's hosting databases on the local area network or I can enter an IP address of a remote machine. So here is my FileMaker server. Okay, and you can see that quote details database that we created towards the bottom. So I'm gonna go ahead and tap on that. And there is our solution. Again, it's not the most beautiful solution in the world. We can work on that. It's not the most complex app in the world. We can certainly work on that as well. But what I wanna think about right now is just how much time it would take using traditional tools just to get to this point. We don't have to recode our solution to make it iOS available. FileMaker will handle that for us. And if you wanted to make some changes, let's go ahead and we'll change that name. Okay, I'm gonna go ahead and tap out and commit that record. Let's take a look back in our FileMaker Pro. And just like that, we have that change. We're already solving some of those limitations working in spreadsheets. Again, think about a spreadsheet spread across our entire sales team and we're not getting information in real time. Again, no additional coding to get this to work from a desktop to a mobile device. Now, what about a web browser? Well, let's go ahead and close or hide this iOS device for now. And in order to set this up for the web, first thing I need to do is make sure that we have appropriate permissions to access the solution via a web browser. So I'm gonna go to File, Manage Security, okay? And this is where you can set security within the file. We kinda talk about it really briefly where we talked about creating accounts or who can log into the file and then creating privileged sets or what the users are allowed to do once they're in the file. There's another set of privileges and that we can specify. These extended privileges just specify how a user can access your solution via a specific technology. So whether if the file is hosted, can they access it via the desktop or access via FileMaker Go? And what we're about to do right now is specify whether a user can access this via a web browser. So I'm gonna select the FOMemDirectPrivilege and I'm just gonna specify that the account that we're currently using, the admin is able to access the solution when it's enabled via this technology, okay? So the solution is ready. Let's go ahead and open up a web browser. All right, and there's a specific URL you go to it involves the IP address of the host machine, for slash FMI, for slash WBD, short for web direct and this lands you to the default web direct homepage. You can actually edit your own custom homepage but there's that quick details database that we'll work with. I'm gonna go ahead and click on that. All right, and there is the solution that we created. All right, again, not the most complex or beautiful a web page you've ever seen but again, think about what we'd have to do just to get this point using traditional tools in the web, coding the HTML, coding the CSS to get the different colors here and specifying where we want the fields to appear and adding images. Again, FileMaker will automatically handle this for us. There's no additional coding to get to this point and just like the web browser, if we are just like the FileMaker Go, if we make a change in the rep, change name, if we go back into FileMaker Pro, you can see that a change automatically appear. Again, if you look at side by side, you can see that the web browser and the FileMaker Pro desktop, it's as close to high fidelity as you can get between the two. Again, no additional coding necessary. So in terms of the interest of time, we're probably gonna step out of the web browser. We'll focus more on the desktop and the FileMaker Go pieces. But again, I just wanted to show you what we were able to achieve using the FileMaker platform and how quickly we were able to do that. Again, just using FileMaker skills. Okay, so what do we do? Well, we created a brand new database. We made sure the accounts had appropriate access. We hosted our solution with FileMaker server and then we connected to it via FileMaker Go and a web browser. Really simple stuff, guys. So we're already starting to solve some of the limitations of staying in spreadsheets and paper with real-time updates. So time spent performing double entry can now be spent toward achieving more goals throughout the day. All right, so I'm feeling really good about our progress but the clock is still ticking and I need to make sure I can incorporate our business needs into the solution. Again, Kathy is tired of wasting money on software and apps that has us force-fitting our business into their sandbox. So I'm gonna use features like the field picker, importing, relationships, portals and calculations to create a workflow that makes sense to us. So let's talk about how we do that. All right, we're gonna be making some layout changes and some schema changes and that means we're gonna be working within the FileMaker Pro Advance desktop software. Anytime you need to make those layout and database schema changes, it's always gonna be in your FileMaker Pro Advance product. Now, before we start diving into developing a workflow in here, let's think about the features that we like to add from our previous process. Now we did have the inventory spreadsheet and I'd love to have a way for users to view that list directly in the solution and have the ability to kind of scroll through. Well, in order to make that happen, the first thing I need to do is import that spreadsheet into my FileMaker solution. So let's go up to the file menu, select import records and then we'll browse to the inventory spreadsheet. It's here on my desktop, okay? And it makes sense to have the inventory live in its own table. So we'll tell FileMaker, import all this data into a brand new table, okay? Just like that, we have a brand new import table. We have a brand new import layout and we have about 25 records here. I'm gonna view this record in what FileMaker calls table view, okay? So it's kind of like a spreadsheet like view, but FileMaker calls this table view. Now I also have images that I'd love to appear in every single inventory record, but I need to add a field because I don't have a field right now that can hold a media file. So let's jump back into layout mode, okay? And we'll jump back into the field picker and we know how to add fields. So we'll go ahead and create a new field. We'll just call this photo, all right? And I'm gonna change that field type from a text to a container. Now a container field stores pretty much any media file. So sound files, movie files, document files, PDF files, all of that is stored in a container field type. Okay, so there's our photo field. Here's our images. Let's go ahead and start dragging and dropping a few of these images right into the appropriate record. Okay, so it's that simple. Now I have 25 records here and 25 images. Not that big of a deal to drag and drop all of these into the records, but if you're working with hundreds of records, thousands of records, you probably don't wanna have to do a drag and drop for every single one, that's okay. There's a way to import a folder of images right into FileMaker. Now in the interest of time, we're not gonna drag and drop every single record here. Just the first five is okay. Now what I wanna do at this point is get this inventory information to appear on this quote layout. Now what do you want information to appear from one table onto a layout that's pulling information from a different table? The first thing you need to do is create a relationship between those tables. And where do you do that? There's a lot of different ways to get to this window, but I'm gonna go to File, Manage, Database. And this is where you can build on the backend of your file or the scheme of your file. So you can create tables. You can create fields associated with those tables, and then the real power of FileMaker, you can create relationships between those tables. Now, how do you create a relationship? The first thing you wanna do is find fields that have common values. In this scenario, we don't really have any fields that really match, maybe the ID field. So let's create a relationship between those two, all right? Right now, we are saying that if the values in the two ID fields equate each other, based off this operator, share those records, okay? So let's assume that the quote ID and the inventory ID are both serialized fields, okay? So record one is one, record two is two, record three is three. If we have this set up this way with this type of relationship, we're saying, hey FileMaker, any record in the inventory list table that has a value one, share it with the first quote. Any record in the inventory list that has a value two, share it with the second quote, so on and so forth. Now, in terms of what we wanna do, creating a list, that means that for every quote that we have, based off this type of relationship, we'd have to have an equal amount of records with that same value. So the same quote ID one or same quote ID two to match a full comprehensive list for each quote ID record. That means we could have, you know, hundreds and hundreds of duplicate records in our inventory table, not the most ideal situation. So what I'm gonna do is I'm gonna change the relationship operator here from an equal sign to this X sign. This is a Cartesian relationship and this is essentially telling FileMaker, I don't care what the values are, just share everything between the two tables, okay? So it's perfect for a list type of workflow that we want to create, okay? So we have that relationship set up now between the two. I'm gonna go ahead and click okay. Now, how do we get that information displayed on our layout? Let's jump into the layout mode and we have this great tool called a portal and a portal just allows you to display related records from a related table, okay? It's gonna say allow vertical scrolling and scrolling and we'll say the number was four. Now, what information do you want to show from the inventory list? We want the photo, we want the item, cost, description, pretty much we want all these records, fields here, okay? So now we'll do some light formatting, okay? I'm just gonna make this photo feel a little bit larger and this is just a good glimpse of how you would build your layouts in FileMaker, okay, you're just adding fields and then you are just aligning them, however appropriate for your business workflow, okay? We're gonna do one additional line of formatting for this cost field, okay? I'm gonna make sure that right now it's a number field. Just wanna make sure that it is formatted as a currency, okay? So let's go ahead and exit the layout, take a look at our changes and just like that in our portal, there's every single inventory list item, okay? Again, based off the relationship we created, everything matches everything, okay? So again, perfect for what we wanna achieve in this list-like view and it's not just this first quote, if we click on a new record to create a brand new quote, you can see that the list here appears as well. All right, so we have a nice structure for the inventory list here. Let's think about what else we'd like to capture. We have a spreadsheet of customer information, I'd love to just capture customer information here within the tool so we could view that information in real time. And since we have a list of the inventory here, I'd love to build out a quote based off of the list within this tool as well. Now, we have some space to work with here, but let's jump into layout mode and we'll take advantage of this tool called a tab control and it'll allow us to leverage the space that we do have left on our layout, okay? So we'll create a tab called quote and I'll create another tab called customer. All right, we'll do a full justification and the way it works is you place objects and fields on the tab and they can only be interacted with when you click on the appropriate tab, all right? Now, what I'd like to do at this point, I'm gonna go ahead and close this file out and I'm gonna open up a second file that I created, the interest of time again, all right? So it's the same thing, we have the inventory list here in the portal, I just added additional images, okay? And I added some fields for the customer information. Okay, so if I jump back into layout mode and jump into our field picker, you can see all of the customer fields that we created. Again, we know how to create fields now and we just wanted to save some time here so we can jump into other areas of this tool, all right? So we have the customer info tool, our tab built out, let's focus on the quote, okay? So our goal again is to select items from the inventory list and build out a quote and to get started, what do we learn last time? When you want to display information from a table on a layout that's pulling information from a different table, you have to create a relationship between those tables, right? So let's go back to file manage database, okay? We're here in our relationships tab. Now the inventory table is already being used to create that inventory list, okay? But that's all right, you can create multiple logical instances of a table so you can create different types of relationships to that table. So I'm just gonna go ahead and select command D or control D if you're on Windows, we now have a logical instance of that table, okay? Right now it's called inventory list two and I'm just gonna rename this, call it order inventory so it stands out a little bit more, okay? This is what we're gonna build orders with. All right, now we're gonna fall if we create a relationship between this order inventory and the quote table, we're gonna fall into the same pitfalls and traps that we talked about previously, okay? If we wanted to build out a quote for quote one, for example, we're telling file maker any record in the order inventory table that has a value one, share it with the first quote, any record has a value two, share it with the second quote. So we're susceptible to having duplicates and duplicates of inventory records in this table, which is what we don't want in which each record to be unique. So what we're gonna leverage and here's some of those beginner advanced techniques that we talked about in the beginning of our demo, we're gonna leverage a third table what we call a joint table to create essentially a many to many relationship and you can learn more about this in file maker's knowledge base and look up creating many to many relationships. So I'm gonna call this third table orders, okay? And the name is arbitrary, but this is what we're gonna, doesn't need our joint table. And we're gonna do the same thing where we wanna make sure that every record in the order table is unique, okay? So we're gonna make sure that a unique value is generated here. And I'm gonna create another field, we'll call it a quote ID so I can create a relationship to the quote table and then a inventory ID so I can create a relationship to the inventory table, all right? So now back on our relationships tab, let's go ahead and create a quote, okay? There's equal operator in between, all right? Now in the orders table, we're saying, okay, file maker, anytime that there's a record in the orders table that has a value one, share it with the first quote. Any record that has a value two in the quote ID, share it with the second quote, so on and so forth. And those individual records in the orders table, they could be referencing a different inventory item. So if the first record has an inventory ID 10, grab the 10th inventory item. If the second record in the orders table has a value eight, grab the eighth item in the inventory table, okay? So we can have all of those instances, all those multiples records that are being referenced in the orders table, just making sure that all of the quote and from records are unique and also ensuring that the inventory records are unique as well. Again, this is a many to many relationship. We're using what we call a join table here and you can learn more about how to set this up in FileMaker's Knowledge Base, creating a many to many relationship. Okay, so one thing I wanna do before we save our changes, I'm gonna jump back into the orders table because there's some information that we want to capture. So for example, for each order, we wanna know what's the quantity for the inventory item that we're gonna be purchasing, we'll make that a number, okay? Then I wanna capture the subtotal for each, or you think of this as kind of like the line items and the quotes or an invoice, okay? And I'm gonna make this a calculation field type and the calculation result is gonna be quantity times the order inventory cost, okay? That's a number, perfect. And then I wanna capture a total for the quotes in its entirety. Now, I could use a calculation, but it's gonna be easier just to use a summary field type. It's gonna go to create and I'm gonna tell FileMaker, grab the total of the subtotals for each of those records, all right? Now, let's add that information onto our layout, all right? We're gonna jump into this portal. You know that portals allows to display related information from a related record. So it's gonna be pulling information from the orders table, all right? We'll say six rows, that's fine. Now, what fields do we wanna add? Okay, so you wanna capture the inventory ID that's gonna allow us to create a relationship to the inventory table. You wanna capture the order inventory item. We'll capture the cost, then we'll capture the quantity and then subtotal. All right, so let's go ahead and click okay. Here's all of our fields and let's just do some quick formatting to bring this out here, all right? Quantity can be a little bit smaller and the subtotal will make just a little bit larger, okay? We'll do some formatting here as well. Again, this is a number and we wanna make sure that it's specified as currency. 1,000 separator here and same thing, 1,000 separator here as well, all right? And we'll bring over the total field onto our layout, okay? Now, you may notice these blue lines that appear and these are what we call dynamic guides. They just help you quickly align the objects that you have on your layout. There's nothing that you need to do to set this up. It's just right out of the box. It's there just to help you as a guiding feature. All right, now just some quick formatting here. I'm going to add some labels, okay? And I'm gonna do a command D or control D if you're on a Windows to duplicate that label just to save some time from having to rename or recreate these labels, okay? Cost and then we have quantity and then we have the subtotal here. All right, so let's go ahead, exit the layout, all right? And now there's one additional feature I wanna do. I'm gonna go, okay, we built out the portal but I'm gonna go back into File, Manage, Database, okay? And I'm gonna go into the Relationships tab and click on the relationship between quote and orders, okay? So there's one additional piece I wanna do is I wanna tell FileMaker that from this relationship I want to give you the ability to allow me to create records based off of this relationship, okay? Now why is that important? It's important because now you can interact with that portal. So you can create records directly through this portal which meaning you're creating new records to the orders table in this scenario. So I'm gonna tell FileMaker, all right, I'm looking at the different lists of inventory items here. Oh, you know what? I need some gear shifts for my store, all right? So that's an ID of 10, okay? So I'm gonna enter that in there. You see it's a gear shift and there's the cost. I'm gonna say that I wanna order 15 of these for my store, all right? We'll get 900, all right. Let's do some quick formatting here. Why is this showing a little bit? Question mark, we're just not giving this enough room, okay? We'll make the ID a little bit smaller. It looks like that 10 got caught off there as well, all right? So we'll exit that layout. Okay, we see the ID, we see the quantity there. Let's say that we also want some alternators for the shop as well. Okay, so that's an ID too. There's the alternator, there's the cost. And we'll say that we wanna purchase eight of these for the store. Okay, so we're building out that quote. You can see the total is automatically updating as well. So it's working just like we wanted on the desktop. How does it look on the iOS device? Let's go ahead and take a look. Again, give me one second to air play this over onto my screen via the Reflector app, okay? So I'm giving this a second to do that and connect. All right, and there is the iPad Air I have in my hands. Now, right now we're looking at the previous file that we were working with. So let's close that, all right? And let's open up that quote to file that we just created. All right, there it is, the 15 gear shifts and the eight alternators that we just added. Let's say that he wants to add some car batteries to his quote as well. So this is a item three, okay? There's the car battery and he wants seven of these. Okay, this is gonna be great for our business. And again, you can see it automatically update the subtotal and the total automatically update as well. And if we jump back into the FileMaker Pro side, just like we expected, the car battery information is there, entered on the FileMaker Go side, displaying in the FileMaker Pro side. Again, it doesn't matter if you're accessing this Mac, Windows, other iOS devices, non-IOS devices, web browsers, everybody's gonna see that change in real time, just like we expected. Okay, we did a lot here. We use tools like the FieldPicker, importing, relationships, portals and calculations to create a solution that matches how we do business. So instead of being flustered with the hundreds of features that we don't use or being limited by software that only handles a fraction of what we need, we're able to have full control over what business process is to integrate. So we're not waiting for IT to build in the changes for us and we can continually work at a more productive and efficient rate. All right, so we're almost there, but the last thing I need to do is make sure whether the customer experience is heightened as well. So we're eliminating paper forms, which helps, but I wanna make sure the quote process is as seamless as possible. So I know I can improve how quotes are built and I can also help shorten the sales process by having quotes sent to the customer the minute they leave my booth so they don't have to worry about losing, misfiling, or simply forgetting about their paper copy. So I'm gonna leverage FileMaker scripts, buttons and calculations to do that, and let's talk about how we can approach that. So I'm gonna go ahead and hide this FileMaker ago, again, because we're gonna making some schema and layout changes, and that always happens in the FileMaker Pro advanced software. Now, how can we make this a little bit more streamlined for the customer experience? Well, we're already solving some problems with this quote building, but wouldn't it be great if we could just click on a button that allows us to grab an item from the inventory list and have it automatically appear in our quote instead of having to enter the quote ID every single time. All right, so in order to do so, it's gonna require two moving parts. One, I need an object that I can clip or tap on, so that could be like a button, and then two, I need a script that will perform the action that I want. In this case, grabbing that inventory item and placing it into the quote for us. Well, let's go ahead and focus on the first part. So we're just gonna jump into layout mode, and I'm going to draw a button right onto our layout. Okay, you can specify in a button some text or an icon or both a text and icon. There's 140 icons in FileMaker. The best part is, if you can't find an icon that conveys the message that you want, you can actually import your own icons into FileMaker. In this scenario, we're just gonna use the plus icon here. We could format this a little bit more, but in the interest of time, we'll just leave it in its default formatting. So we don't have any actions to tie to this button yet, so let's just go ahead and close this out, and now I'm gonna go ahead and go to the Scripts menu and Scripts workspace, and we can create a script to attach to our button. And we're gonna call this, we'll just call this add a quote. All right, now let's take a step back for a second. And some of you may not be familiar with the concept of script, so what are scripts? Well, in a general sense, you can think of scripts as a set of instructions that fire off in a sequence that produce a result. And in FileMaker, here are all of the script steps that you can use to build scripts that, again, will fire off in a sequence that will produce results. So let's say that you had a report that you ran frequently, okay? Well, you could build a script that says, all right, FileMaker, go to this particular layout, perform a find for this particular set of records, and then go ahead and print those particular set of records. Now, you could manually go to the appropriate layout, you can manually enter a find mode, enter the search criteria, then you could manually go to the file menu, select print, select the pages that you wanted, or you could just leverage FileMaker's automation capabilities and have FileMaker perform these tasks for you. Throughout your solution, there's gonna be tedious tasks, there's gonna be repetitive tasks where it just makes more sense to leverage FileMaker to do these things for you instead of, you having to manually do these things yourself. It also makes for the better customer experience. In our scenario, what we wanna do is, again, capture an inventory item and have it automatically appear in this quote portal, all right? So the first thing we need to do is capture which inventory item we are actually clicking on. Now, that's gonna be a dynamic value, right? So it's not gonna be a static value that we can just code, hard code into the script. So when you wanna capture a dynamic value, the script step that you wanna use is the set variable script step, okay? So I'm gonna use the set variable script step. This name is just gonna be inventory ID, all right? And then the value is going to be the inventory list, inventory ID, okay? So we're telling FileMaker, capture the ID of that inventory record, all right? Now that we have that, the next thing we wanna do is jump over into this portal. So let's go ahead and we'll give that, this portal object a name, okay? And we'll just keep this really basic, we'll just call it portal object, okay? So we now named that object. So let's go back to our script, all right? So we have the inventory ID and now we're gonna tell FileMaker go to an object and what's the object name? Well, it's just called portal object, all right? And once we're in that portal object, we're gonna tell FileMaker go to portal row, go to the last, okay? Now remember that setting we made between the two quotes and the orders table. It allowed us to interact with the portal, right? And by doing so, what it does is it also leaves an empty row always ready in the portal so that you can start interacting and adding records to that portal. So we're just telling FileMaker, hey, go to that last portal because we're gonna start adding a record there. And once you're in that last record, go ahead and set the inventory ID field from the orders table, okay? All right, and use the value in that inventory ID variable that we created. So it completes a relationship to that inventory table and it will grab that information that we want, all right? Let's go ahead and save that script, all right? And we will attach it to the button, okay? So button action, perform a script, add quote, we'll click okay, exit the layout. All right, so now if we want to add an item, let's say disk calipers, we can click on the button and just like that, the information automatically appears, okay? So it's grabbing this value of the six, it's automatically entering it into that last portal row, right? And then because of the relationship that we created, the appropriate information comes through. So now we can say, okay, we have the disk calipers and we want 10 of these for the store, all right? Same thing on the FileMaker go side, we bring that up. All right, there's the disk calipers there. All right, if we click on the button, let's say that this time we want to add a few exhaust manifold, bring that over, and we can say we want six of these for the store as well and everything is working just like we want on the iOS device. Again, that button, that script, our subtotals and totals, all working without having to recode the solution for iOS. Okay, so we've built that away to streamline the process for building a quote, but I love to have the ability to immediately send a quote out to a customer. Again, once we send that quote out to the customer in our previous process, that paper form could be lost, mis-filed, this way we know for sure that the customer always had it ready and it'll help us out in our followup process as well. So in order to send out a quote, it's gonna require the same moving parts that we just walked through, right? We're gonna need an object to click or tap on and then we're gonna need a script to perform that action of building out that quote. Okay, so what I like to do at this time is open up a second file that I created. Again, in the interest of time, all I've done here is cleaned up the button that we were using and I also created a brand new layout that we'll use to send out as the quote, okay? So all I've done is use the same techniques that we've already learned, adding some literal text, adding a portal and fields here on the layout. It's just a layout designed to the dimensions of a page so that it'll fit in the PDF that we send out to the customer, okay? So what we'd like to do at this point is build out a quote that captures what quote we're on, goes to the appropriate record and the quote, email layout and then sends an email out to the customer, all right? So first thing we need to do, like we discussed, is grab or create a button onto the layout, okay? So I'm gonna go ahead and we, let's use some text and an icon this time, okay? So we'll just say, send quote and then we can use this email icon here, okay? So we have a send quote button but like we discussed previously, this isn't gonna do anything. We don't have any actions tied to this particular button. So let's go back to the scripts menu, select script workspace, all right? We're gonna create a brand new script and we'll just call this send quote, all right? So the first thing we need to do is capture which quotes we are working on, right? And again, this is something that's not gonna be hard coded, all right? We're not always going to, when we run that script, we're not always gonna say go to quote one, go to quote two, go to quote three, right? It's gonna be a dynamic value. So again, when you wanna capture dynamic values, you use that set variable script step, all right? So we'll call this current quotes, all right? And the value will be the quotes ID from the quote table, all right? So now that we have the current quote, we're capturing the current quote ID, the next thing we wanna do is make sure that we go to the email layout version of this quote table, all right? So we're gonna tell file maker, go to layout, go to the quote email, okay? And then we're going to perform a find, okay? Now I only have a few records in here, but you can have hundreds of records. We just wanna make sure that you are always working with the appropriate quote, all right? So we'll say current quote, all right? So once you perform a find for the appropriate record that we're working on, we now wanna start creating that PDF. Now that's gonna take three separate parts, all right? So first thing we need to create a name because that's gonna be dynamic as well. That can be changing every time we build out a quote. Two, we need to save this quote as a PDF. And then three, we need to capture the location of where that PDF was saved so we can then point the file maker email to grab that file and attach it, okay? So the first thing we need to do is create a name. Again, that's gonna change. So we're going to use the set variable, script step, and we'll just call this file name, all right? And let's tell file maker to be quote underscore. I wanna use the current date so we can use the calculation function, get current date. The problem with using the calculation function and we do wanna use it in the name is that it's going to produce a result similar to this, right? Where you have the slashes. Now, why is that a problem is because when you save this file and we tell file maker to look for this file later on, it's gonna be looking for a file as located in the folder six with the sub folder 29, the sub folder 2016, right? So we're actually gonna leverage a second calculation function, all right? It's the substitute functions. We're gonna tell file maker substitute from the current date value, okay? Go ahead and find those slashes and replace it with underscores, okay? So that'll work. And once we have that, we'll add a .pdf extension, okay? So we're gonna have the quote underscore, the current date with underscores that are slashes.pdf as our file name, all right? So we'll go ahead and click okay. So now that we have that file name, okay? We're gonna tell file maker, go ahead and save these records as pdf, all right? And the output file that we're gonna save, go ahead and save the file using the nomenclature that we added in the set variable scripts up here, okay? So now that we have saved the pdf, we then need to capture where the pdf was saved so we can later attach it to an email, okay? So we're gonna create another set variable, a script step or so create another variable. So we'll call this, we'll just call this pdf path, okay? And I'm gonna tell file maker, just go to the default documents path and look for the file name that we captured in the previous file name variable, okay? Now a moment here, why am I just using the get documents path? Because on an iOS device, when you save like a document or file maker go, when you save a document, it goes to a default documents path. You can't specify a different location. Performing the same script on like a Mac or Windows, for example, then you could specify a location. You could specify a particular folder on a particular drive or like the temp folder, however you want to build that out. But in this scenario on the iOS device, it's really straightforward, okay? So we know it's getting saved to the documents path. So we're telling file maker, hey, just go to the documents path and find this particular file that we just saved, okay? So we have the variable of the pdf path there. Before we send that email out, I wanna make sure that my user is back on the layout that they started with, right? So that instead of staying on this email version, email layout, I want them to go back to the quote details layout that we were creating. So I'm gonna tell file maker, go back to the original layout, okay? And we'll say perform a find. Again, just playing it safe here. Perform a find for the current quote value that we originally captured. So that they are always in the same quote that they started in. So now that the user is back in the location that they were in, originally, we can now send off that email, all right? So send mail. And I don't want to have to enter the customer's email address manually. So I'm gonna tell file maker, just go ahead and grab the value in the customer email field, okay? I don't have a field that has a subject message in there. So I'm just gonna add some literal text in here and you can change this however you want. But I'll just call this file maker auto parts quote, all right? And I don't have a field that just captures a message here as well. So we can add some literal text, but you can take that a step further. You can specify a calculation in here as well. So maybe you wanted to grab a value from the quote ID field. So it's listed in the message. Or if you want to grab a value of the address or something, you can put in that message here as well. But again, in the interest of time, we'll just add some literal text here that says, thank you for your business, okay? And then we need to attach the file and we're gonna tell file maker, go ahead and grab that PDF that we captured in that PDF path variable, all right? So I think our script looks good here. Let's go ahead and we'll save that script, okay? And we'll now attach it over to the send quote button that we created, all right? So we'll say, perform script here, send quote. Click okay. Let's exit this layout. Now what I like to do is jump back over into our file maker, go. So give me one second to do that. Okay, so there is the file maker, go again. If we click on the send quote button. All right, so we have the customer's email address automatically populated in the two section. In the subject we have file maker auto parts quotes. We have some literal text, thank you for your business. And we have the PDF quote underscore the current date that PDF, just like we expected. Okay, so what do we do? Well, we use calculations, scripts and buttons to better the customer experience and shorten the sales process. So I can now go to Kathy and present her with a mobile solution that our field team can access in real time at any trade show wherever they are from the iPad that has all of our information in one centralized location and matches a business workflow that makes sense to us. And that betters the overall customer experience. So our trade shows, quote building and follow ups have become much more efficient leveraging this mobile solution that we just built in under an hour. But what about Kathy? How does Kathy benefit? Well, think of the top line and the bottom line we can affect running as a more productive and efficient team. Think about that one more sales call in the office or that one more customer touch of the show. Then roll that up against the entire sales team across the week and month and then think about what we can achieve in a year. All right, so we were able to demonstrate a successful deployment of file maker and how to quickly tackle a small task. And I'd like to share a quote from one of the file makers customers that I think really sums up what we've learned today. George Page is a restaurateur, a cheese maker and the owner of Sea Breeze Farm and organic animal farm. He uses file maker to track and understand daily production levels of cows for his dairy operation. In the wine cellar, file maker goes replaced clipboards and is used to enter and track alcohol levels, pH readings and historic data related to wine lots. His butcher shop uses file maker to track orders and deliveries of custom cuts of meat while file maker acts as a point of sale system in his restaurant. So he's taken full advantage of file maker's platform with fantastic results and he had this to say. File maker pro helps me easily create custom business solutions for iPad using file maker go. The systems we have now are pleasing to look at as well as highly functional and that means our employees genuinely want to use them. And you can read more about George's story on file maker's website in the customer story section along with additional customer stories across multiple industries. All right, some no-brainer next steps. You want to start creating your own solutions and you want to start deploying a file maker go. Start off with the file maker pro trial and file maker go, which you can download off the app store, file maker pro trial, you can download off of file maker's website. As you're learning to build your solutions, watch some videos and explore the star solutions on file maker's website as well. The star solutions can act as a great springboard for what you want to achieve. They ship with the full version of file maker as well as the trial version of file maker. There's 60 of the most common tasks that businesses have to perform to meet their goals like content management, invoices, event management, resource scheduling, all of that can be handled with the star solutions. If you don't have an in-house developer or if you're kind of under a time crunch and you want to get up and running as quickly as possible or if you just need some help kind of getting over a development obstacle, talk to a specialist, talk to a file maker, a business lines partner, talk to a file maker consultant. There's a consultant's page on file maker's website that you can drill down and find a consultant that may be a great fit for you, but they're the experts, they'll help you get up and running really quickly. Some next steps for file maker web direct. You want the file maker pro trial again, but you also want to download the file maker server trial. So all of the web components are part of the file maker server. If you want to test this out in the web browser, you definitely need file maker server. Before you start building and deploying, definitely take the time to read the file maker web direct guide. It talks about the best practices, the different behaviors in web direct, and again, the file maker business alliance, partners, file maker consultants can also help you here as well. You can also contact file maker's technical support team for some assistance with installing and deploying to this technology as well. All right, let's go ahead and open this up to some Q and A. If you haven't already, again, you can enter, go to the Go to our webinar control panel, click on the questions section, enter your question and click on send. In the meantime, to give some of your time who haven't already entered a question, let's talk about a few additional resources. So the file maker training series, this is fantastic resources for building up that foundational knowledge of file maker. There's a free basics guide. It kind of walks you through a story like we did today. And then there's a advanced guide. It's 1999 off of iBooks, which you can download. And it's broken down into different modules. It goes into some more intermediate and advanced topics like scripting, calculations, methodologies for relationships, file maker server and reporting. So again, these are really great resources for building up your foundational knowledge of file maker before you start applying these techniques to your solutions. If you haven't already, definitely join the file maker community. Not only do you have access to a really welcoming and opening and highly active developer community where you can gain some guidance on different approaches, best practices or some help solving some development problems, but you're gonna have access to a ton of free content, some very valuable content like technical briefs, how to articles and white papers. And again, this is all for free. So definitely join the file maker community. Finally, again, FileMaker O15, free to download off the App Store, download FileMaker ProTrial on FileMaker's website. There's additional webinars that you can view. These are for free as well. A ton of great free content on FileMaker's learning webinars page. And you can look for additional instructor led and self-paced training on FileMaker's learning slash training page as well. Okay, and with that, let's go ahead and start jumping into some of your questions. Okay, let's see. We have quite a few people asking about whether you'll get a link to the recording. You will, so after this session is over, we'll send you a link to a recording and you can follow along at your own pace. My users out of the office, they don't always have a network connection. Can they use this app? You don't, especially with FileMaker Go, you don't need to have a network connection. If you're planning on a mobile solution based off of the web and web direct, you'll have to have a network connection. One of the benefits of using FileMaker Go for the iOS is that you can work offline. So you can take databases, store them locally on the device and then sync those changes back up to the hosted solution. You have the local database, you go out in the field, you capture your information and then you push those changes up to the hosted solution or vice versa and the sync is really just a scripted import that you write, okay? So you're just essentially saying, hey, take these offline files and the data that I've changed and import those records into the hosted file and vice versa. Now, if you're making changes to data that no one else is gonna be changing or making changes to records that no one else is gonna be changing, that's a pretty straightforward process, right? You're just saying, take these records that I just created or that I just modified and push them up to the hosted file. Now, if you're gonna be modifying information that other people may be modifying, so whether it's other offline users or other people who are online, if they're making changes, then you have to incorporate some business logic into your script, right? Because your script isn't automatically gonna do that. So you'll have to determine in script whose information are you gonna keep? Is it based off of time? Is it based off of who they are in the company and things like that? Now, there are software out there that kind of take the responsibility of creating this script out of your hands or the sync out of your hands. So I'm thinking about 360Works, their developer, they've created MirrorSync, SeedCode, they've created GoZinc. You do a quick online search for GoZinc or MirrorSync. They have some great videos as well on YouTube that you can kind of view and get an idea of how they work and how to set them up, but those are two good choices that you can use to deploy with the sync. All right, so the next question, can you touch on the differences between iOS and the web version? Well, it's true that with WebDirect, you can actually deploy on a iOS device or an Android device, right? A mobile phone or a mobile tablet, but FileMaker Go also allows you to access your solution via the iOS. Now, between the two, the best experience will be FileMaker Go. What I mean by best experience is that FileMaker Go takes advantage of things more native to the iOS device like gestures, for example, the ability to leverage the iOS devices' camera and scan barcodes, different keyboard types. So, as you're building a solution, you want to deploy with FileMaker Go that's going to give you the best native experience. Okay, the next questions, all right, actually about barcodes. Okay, I want to build a solution that allows me to scan packages using the iOS device. Can you talk about barcodes? Sure. So, you can leverage the iOS device to scan a barcode and you can also scan a barcode using a third-party handheld device as well. Now, regardless of which device you use, there are a few moving parts that are similar. One, FileMaker doesn't have a native barcode font, so you have to create a barcode font if you want to create your own barcode labels. Now, there's plugins available that allow you to do that. There's also a FileMaker barcode add-on that doesn't use a plugin that allows you to create barcodes. So, if you want to create your own labels, you have to go to a third-party vendor to incorporate that into your solution. Then, once you scan that barcode, you can bring the return value into a field and then you can use calculations or scripts to parse information out and perform a task so you could create a brand new record. You could find a new record and add it to a list, things like that. And then you can choose which device you want to use. Again, is it going to be the iOS device's camera or is it going to be a third-party handheld? Now, for scenarios where you're going to be tasked with filling up an order really quickly and it's a fast-paced moving environment, the handheld device is probably going to be the best option, it's just a faster scan. But for other scenarios where it's not in a rush but it's still pretty efficient, then you can go to the iOS camera route. The next question, will I have to do anything different if I go with the cloud version? No, so FileMaker Cloud, we recently released back in September and this is essentially, instead of having the FileMaker Server software, which is a software application you install on a dedicated machine like in your office and you're managing it on-premise, we have the FileMaker Cloud, which is essentially just the FileMaker Cloud, FileMaker Server components bundled with an instance of Amazon web services. So it's up in a, quote unquote, the cloud. So once your databases are hosted from there, your users, the user experience is gonna be the same. They won't know that they're accessing a server that's in the cloud or a server that's in your office. So from their experience, everything's gonna be the same. The only difference really would be where you're managing it, whether it's on-premise or in the cloud and there's different features that are supported and not supported like customer publishing or with PHP and XML, that's not supported in the cloud. Active Directory, that's not supported in the cloud, but the cloud takes advantage of, you know, the Amazon web services infrastructure. So we can do on-demand snapshot restores of files. So advantages to both, but from the user standpoint, they're not gonna be aware that they're accessing a cloud or a on-premise server. Next question, how many users can I have accessing the solution? So we tested and certified 250 for FileMaker Pro, 200 for FileMaker Go and 100 WebDirect. But the user account will also depend on the licensing that you purchase. So we have FileMaker licensing for Teams where every user requires a user connection. So if you purchase 5, 10, 15, 20, 25, for example, you can only have that amount of users connected and for specific users. You also have a concurrent connections model based on the maximum number of estimated users. So you could have a pool of 500 users, for example, but if you purchased 25 concurrent connections, any combination of those 500 users could access your solution up to 25. All right, that's all the time we have for today. On behalf of FileMaker, it was my absolute pleasure chatting with you guys. Definitely hope you learned something and I hope to see all of you soon on another webinar. Have a great day.