 For the best experience, it is strongly recommended that you participate in this web seminar with at least a broadband connection. 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 will have the opportunity to type in and ask questions, so let's talk briefly about how to do that. You want to go to the control panel, click on the question section, enter your question, and click send. And 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, you can submit a question anytime. Okay, so your requests were similar to the ones that you were seeing on your screen right now, but based on the popularity of your submissions, the winning entry is an event management solution. Now, there are numerous tasks that can fall under the event management umbrella. Maybe you want to create a conference schedule and associate attendees to the pre-registered events, or maybe you want to create attendee badges, track staff billing, budget drafting, or lodging. So there are a lot of approaches and needs in an event management solution, but in the interest of time, we're going to focus on an event details interface for staff and a vendor page listing allocated resources. So let's go ahead and pick someone from today's attendee list. Okay, let's assume that we're all part of an event management company and Eric is our boss. We run multiple events a year and for the most part, things run fairly smooth in the eyes of our attendees. But behind the scenes, it's a bit of a mess and we know that we could run a little bit more efficiently. And probably like most of us today, almost all of our data is on their own island. So we have a spreadsheet for the events that we've currently booked. We have a spreadsheet for vendors, the resources allocated to each of our vendors. We also have our floor plans, photos for the contacts, photos for the different locations that we're at. Again, all of our information is on their own island. It's really difficult to find out related information and connecting that related information. It can really be a nightmare when all this information is distributed across so many spreadsheets and maintaining accurate data can be a headache when multiple people are updating spreadsheets. Now, Eric knows that every year we're spending too many wasted cycles on this and it's costing the company time and money. And that's when I get called into his office. So Eric understands the importance of a mobile solution moving forward and he wants the following. He wants a tool that allows the staff easily access event detail information on the go, a solution that maximizes our workflow, and he wants to connect related information all into one custom solution. So the first thing that I want to do is make sure that I can get this on an iPad. So I'm going to create a new database, share it with FileMaker server, and connect to it with FileMaker Go on the iPad. And let's go ahead and demo how we would do that. So there's a lot of different ways that we can approach creating a new database in FileMaker. But one method is just if you have a spreadsheet, to take that spreadsheet, we'll start with the events spreadsheet and just drag that right into FileMaker. And right off the bat, FileMaker recognizes that this is an Excel spreadsheet and we're going to choose the first row to be used to name the fields and click OK. And I'll save this on the desktop and I'll change this name to Event Management and click Save. And just like that, we have a FileMaker database. And what you're looking at right now is what we call TableView. It kind of looks like we're still in that spreadsheet world, right? We also have another layout when we drag that spreadsheet over. And this is what we call FormView and you can look at one record at a time. And there's a lot of things that we could do to get started here. Maybe we want to start building out some security, start creating some accounts and privileges into the solution. But really what we want to do right off the bat is make sure that we can actually get this on a mobile device. So what I'm going to do is up at the top here, I'm going to click on the Share button and select Upload to FileMaker Server. Now I have FileMaker Server installed in the background of my machine and FileMaker Server is really the hub of your solution. It provides the security, the performance and reliability. That's what you're going to use when you host your solutions. So I'm going to click OK. And I'm going to choose my computer. Enter my FileMaker Server credentials. Okay, ready to be uploaded. So we'll upload that and open the FileMaker Pro. Done. Now you'll notice at the top the Name Events Management now has in parentheses, Ryan Minook's FileMaker Server. So that's letting us know, hey, you're currently accessing a file that's hosted with FileMaker Server. Now let's talk about how we can access this from FileMaker Go. What I'm going to do is launch this third-party reflector app, and this is going to allow me to share my iPad Air that I currently have in my hands over to the screen. So just give me one moment to do that. Okay, there we go. And that's my iPad right there. And I'm going to go ahead and tap on the FileMaker Go icon right there in the bottom of the screen. So I'll tap on that, FileMaker Go. And this is FileMaker Go 13. And you'll see on the left-hand side with a few icons. I'll tap on Recent that shows me the current servers or files that I've accessed. If I tap on the Device icon, this shows me files that I have stored locally on the device, which is a great option if I want to access, or if I want to continue entering data in areas that don't have a great network connection, if any network connection at all. Then I'm going to tap on the Hosts icon. And this shows me all of the hosts that are on the local area network that are hosting FileMaker Solutions. If I want to access a solution that's outside the local area network, I'll just tap that Add Host option at the top. Let me go ahead and scroll through this list. And here we go right at the top. I'll see Rhymanux FileMaker Server. So I'll go ahead and tap on that. All right. And we'll see that Events Management Database that I uploaded to FileMaker Server. So I'll tap on that. All right. And in just a matter of minutes, really one minute without talking, we have a custom iOS solution. I can even pinch and zoom like you would expect on the iOS device. Now remember how we talked about earlier with all of our information in multiple spreadsheets, and it's really difficult to maintain accurate information when we have a lot of people trying to update a single spreadsheet. We'll take a look at this. Let's say that I have my mobile device here and I want to make a change to this particular event, this tech industry event that we're planning. And let's say that I'm talking to the contact Sue and she gave me a new phone number. So I'm going to go ahead and tap on the field. Okay. And she has changed her name from her number, updated it to 8737. All right. Now before I commit this record, go ahead and take a look at my screen here on the FileMaker Pro side. Okay. I'm going to go ahead and commit that. And just like that, the FileMaker Pro displays that change. It doesn't matter where you are in the world or how you're accessing the solution, Mac, Windows, iOS or web browser, everybody sees that change. Let's go ahead and take that a step further. Okay. Let's say that we want to update Sue's email. Okay. I'm going to start editing that on the mobile side. But meanwhile in the office, we've made some changes as well. Bill has logged in. He's a coordinator for this event. And he wants to make a change to the end date. Okay. So we'll go back to the FileMaker Pro side and watch what happens when he tries to make a change. We get a message saying that, hey, you can't make a change because someone else is already modifying this record. So you could have hundreds of people looking at your record, but only one person is able to modify it. Okay. And once you commit that edit, then someone else can modify that record. But what that is showing us is we're always going to have one version of the truth. And that's what we call automatic record locking. Okay. So we dragged the Excel spreadsheet into FileMaker. We shared it with FileMaker Server and we connected it to FileMaker Go on the iPad. And really, it was just two things, dragging and dropping a file into FileMaker and hosting it with FileMaker Server. So in just a few minutes, I was able to provide access to our information on a computer or iOS device from anywhere on the world. And any changes made are seen everywhere immediately, unlike having all of our information spread across multiple spreadsheets. So I'm feeling pretty good that I can prove to Eric that the first set of criteria is met. But now I want to make sure that I can create a layout designed for our workflow and optimize for the iOS that just split, optimize for the iOS. So I'm going to create a new layout on FileMaker and use tools like popover buttons, tab controls and container fields to optimize workflow. Let's go ahead and talk about how we would do that. So I'm going to go ahead and close this reflector and jump back into FileMaker Pro. And any time that we're trying to make changes to the database or the database schema that always happens in FileMaker Pro or FileMaker Pro Advanced. What I'm going to do is I'm going to click on this edit layout button and this takes us to layout mode. And this is the view where you can make the design changes or design and look of your your database. So I'm going to click on layouts new layout report. Okay, we have this nice wizard appear. And I want to create an event detail layout for the iPad device or iOS device. Okay, so I'm going to choose touch device. I'm going to choose iPad iPad mini is going to be a form and then finally I can choose do I want to build out in or in a portrait mode or landscape mode. So I'm going to choose landscape. And then I'll click finish. So what happened? Well, FileMaker has given us a layout that matches the dimensions of the iPad in a landscape mode. And it's also given us a touch theme. There's 61 themes that you can choose from in FileMaker and they're completely customizable. You notice that some of these are marked as touch was let's take a look at the difference. If I'd go to enlightened, then enlightened touch, luminous, luminous touch, sophisticated, sophisticated touch. All of the touch themes, they they have larger fonts and larger objects like you would expect for the iOS device. So we're going to go ahead and stick with a sophisticated touch. And now I need to get all of my information onto this layout. So I'm going to click on this little tool right here called the field picker. And here are all the fields that I have that were created automatically for me when I drug that Excel spreadsheet over into FileMaker. Certainly I could have created these by hand. But since we drug that spreadsheet over, FileMaker just created these for us. And if I want to bring them over into the layout, all you have to do is just grab a field and bring it over just like that. I can even grab multiple fields at the same time, just drag them right over. And you'll see that these blue lines that appear, this is what we call dynamic guides. And they help you quickly align your objects. Now one thing to note is there's a lot of information that I want to put on this layout. I probably still want the contact information of the event location. And I don't want to take up much of the space here on the right because I'm going to put things in there for my workflow like a floor plan and a map and list other items. So what I'm going to do is we have these great features that are designed for iOS that were introduced in FileMaker 13 like popover buttons. And it's a great way to save some space on your layouts. I'm going to go ahead and remove these fields and up at the top by clicking hold on this button icon. You'll see I have two options, a traditional button icon or the popover button. So let's go ahead and click on the popover button and we'll just draw it out just like that. So now what happens is every time you click on this button, this little popover window will appear and we can place any type of object in there. Objects, fields, it's a great way again to save some space. So we'll call this one event info. I can choose where I want the window to appear from. I'm just going to choose to appear on the right of that button. So this is event info as well. And maybe I want to make it a little bit larger. I'm going to change that color as well. I really want it to stand out when the window appears. So I'm going to choose a new style. We'll choose that. And now again, I'm back to my field picker object. I'm just going to grab a few fields. Let's go ahead and change this so that the labels are on top. And we'll grab the event as well. Just bring that right over onto the popover. Just like that. It looks like our location field used to be brought over a bit. Now I'm using again the dynamic guides. Perfect. And I can save some space some more by bringing the start date and end date onto the same line. There we go. I like that better. Again, using the dynamic guides to help me prop align this quickly. Okay, so we have our event info there. I'm going to go ahead and just duplicate this button. I'm just doing a command D or control D on Windows just to save some time. And I'm going to call this one contact info. And it's going to have the contact information of the location that we're going to be running this event in. Let me just highlight all of these. Remove that. Okay, so I'm going to take the contact email and phone. Bring this right over onto the layout. Let's go ahead and make this window a little bit smaller and align that. Okay, looks good. I'll use this text tool to change the name. Contact info and there we go. Pretty good start. Okay, we probably want an image of the location as well. But if we look at the current fields that we have, we don't have a photo field. That's okay. We'll just click on this new field button right here. And I'll call this photo and then I'll change the type from text to container. The container field allows us to store images, sound files, PDF files, document files, even movie files. So I'm going to go ahead and remove the label and just bring that over onto my layout. Okay, and make this a little bit larger. Okay, and using the dynamic guidance to align. It looks pretty good. All right, and let's go ahead and give this layout. A title, we'll call this event details. And we'll use the formatting tool up here to make the font a little bit larger. 36 font looks good. Okay, and now I'll go ahead and add my company logo. And I'm not going to put a this image in a container field because I want to make sure that this image is on every record of my layout. So I'm just going to treat it like an object on my layout. Okay, so let's put this up here like that. Perfect. And let's go ahead and we'll add. Let's go ahead and add a title for this, this page as well. We really want the event name and the start date to really pop out on this, even though it's buried in this event info button. So what I'm going to do is instead of adding the fields, I'm just going to insert a merge field. And a merge field just grabs the, we'll just grab the data out of the field. And these are really great if you want to, if you have any type of layouts that are like, you know, letters or things like that, where you don't want anyone to really be able to enter information you just want the data to be grabbed. So I'm going to go ahead and choose event. Okay, so that's a merge field. Okay, indicated by those double brackets. I'm going to make this the length of that. And we'll make the size 24 points. And let's bring up our inspector and we'll make this text right in the middle. There we go. And I'm going to insert another merge field. Okay, again, just grabbing the data of this particular field. Get a start date. Again, use the dynamic guides to align here. Put that in the center. All right. Pretty good start. Let's go ahead and exit layout mode, jump back into browse mode and see what we've done with our changes. Exit layout mode and this is browse mode. And this is where you enter your and modify your data. Okay. And if I click on the event info button, there we go. There's the information that was pulled over from the spreadsheet. Okay, and scroll through as well. See the different types of data. Again, this is a great way to save some space on an iOS device where the real estate isn't really, you don't really don't have that much. Okay, let's go back to the first field. You see that the merge field also updates as well. Okay, again, just grabbing that data. Now, what can we do with this photo field that we created? Well, let's go ahead and go back to our event management assets that we have. We have this photo location. And here is an image of where our event will be held. And just like that, we're already starting to really connect all of our data. All right, so let's keep building out. We have all the space right here. And I had mentioned earlier that we want to track things like the floor plans for this event. Maybe we want to incorporate a map so we have directions, easy for our staff to view. And we also want to track things like vendors for each event who will be attending. So let's go ahead and there's different approaches for this as well. You know, you could create multiple layouts, but I'm going to use this tool called a tab control. And it's exactly what it sounds like. It just allows you to create tabs on your layout. Okay. So I'll just create that right here. And different tab names. We'll say floor plan. Create. We'll say location. We'll have a vendor. And, you know, you can even have additional tabs for attendees, panelists, things like that. But again, in interest of time, we're just going to stick with the vendors. Again, that'll give us an idea of how we want to approach adding those other type of things that we would want to track. But again, for interest of time, we're just going to stick with vendors. All right. So I'm going to choose a full justification here and click OK. And as you can see, we have these different tabs. And what we would do is just put different objects on each tab. And the only way you would be able to see each object is if you click on the appropriate tab. So you're kind of like stacking them. All right. So click staying with the floor plan. We want to add an image of this particular floor plan. So let's go back to field picker. We don't have a container field set for the floor plan. But again, that's OK. We'll just click on new field. And we'll call this floor plan changes to container. All right. Make sure there's no label. It looks good. And we'll just bring that right over onto the layout. OK. And we'll just grab these handles, change the height. All right. That looks good. Now, in terms of location, maybe we want to show again where this is on a map. And we have this great tool called a web viewer tool, which allows you to put a web browser directly onto your layout. OK. So I'm going to just draw this right onto my layout. OK. And after I draw that, we get this web viewer setup window. And so you can choose custom websites you can enter in. I mean, we have preset websites. You can enter your own custom websites. By default, it's set to Google Maps. And that's great because we can also pull information from current fields into the Google Maps. So for the address field, I want to tell them FileMaker to grab the information that's currently in this address. City, the current information in my city field. Same thing with state. OK. Just auto-populate that information for me. Zip. Good. All right. And maybe I'm going to just drag the field out here just to kind of restate where this is. Let's keep this out. OK. And we'll leave the vendor tab blank for now. So let's go ahead and jump back into browse mode and see what we've done with these changes. So we'll exit this layout. OK. Again, we have this empty container field. Again, all we need to do is just drag and drop. So we have floor plans. I'll just take this plan right here just like that. If we go to location, click on this tab, you'll see automatically it picks up the address information for this particular record. And if we scroll through, you can see that it will automatically update. So it's a great way for our staff to get that information if you want to build an interface for attendees to take a look at event information. It's another great way that we can populate where it's located. You can get directions easily. OK. And we have the name of where we're staying up here at the top just to kind of set home where it is. OK. So we created a layout optimized for iOS and used popover buttons, tab controls and container fields to optimize our workflow. So we're almost ready to send Eric our solution and head out of the office well under an hour. But our final task is to connect our related information. So I'm going to connect event information to vendors and allocated resources to each vendor. And I'm also going to create a new layout for the vendors for a better interface for them. So let's go ahead and talk about how we can do that. Again, we're going to stick in FileMaker Pro because this is where all of the design changes are made, right? So I'm going to go back to Edit Layout Mode. And remember, we have a space here for vendor information. And we showed you earlier that's currently located in spreadsheet. So what I'm going to do is instead of dragging and dropping that into FileMaker, I'm just going to import that right into FileMaker. So I'm going to import. And I'm going to choose the vendors file. Click Open. OK. And I'm actually going to create a new table called Vendors. And I'm going to choose not to import the first record. That includes the field names. So I'm going to go ahead and import that. All right. And we have 140 records. We go back to Browse Mode. Here they are. We have a brand new table, brand new layout for the vendors. But again, I want all that information right here on this vendor tab. And in order to do that, the first thing I need to do is create a relationship between the tables. So how do we create a relationship? I'm going to go up to File, Manage, Database. And there's different ways that you can access this particular window. But in this window, this is where you can change a database schema. OK. So we have tables. You can add tables. You can associate fields with those tables. And you can create relationships. And here we have two graphical representations of our tables, the events management table and the vendors table. And to create a relationship, it's really as simple as just finding fields with common information. And in this scenario, it's the event ID. So I'm just going to click and hold the event ID field from the events management table and drag that over to the event ID field in the vendors table. OK. Again, I'm just going to delete that and show you how easy it was. Just click and hold and drag it over there. So I'm telling FileMaker, hey, when the events ID field equals the events ID field, allow me to share all that information. And I'm on the vendor page. And the events ID field matches the event ID field in events management. Let me show all of those particular vendors. OK. So let's go ahead and we'll click OK. And jump back into layout mode. And in order to show related records on a layout, we have this great tool called a portal. Again, it just does what it sounds like. It's just a portal, a view into another table. OK. So show related records from vendors. We just created that relationship. Show vertical scroll bar. OK. And just show six records. And click OK. And then we can choose which fields we want to display. We probably want to display name and company. But I'm going to go ahead and cancel that because I want to show you that. In Field Picker, you can also grab fields from other tables, related tables or unrelated tables. So I'm going to choose the company and name. And I'm going to have this come out horizontally and put the labels on top. This is a great way to quickly create a portal using the Field Picker tool. All right. And just like that. You have that list. Let me bring that down a second. All right. That looks good. And I'm actually going to change the style of these fields. Change it to minimal edit box so that all the white background and lines are removed. So let's go ahead and go to exit layout to the vendors. And there we have it. All the vendors associated with this particular event probably align these a little bit better. And use the dynamic guides. Sounds good. All right. Now we have the space open here. We left that open for a reason. But what we're going to do now is tackle, hey, this is great. We can show the vendors for each event, but now I want to show what resources are allocated to each vendor. So what I'm going to do is first we're going to import the resources spreadsheet. Okay. So I'm going to go file, import records, file. And we'll import that resources open. Okay. It's going to be a new table as well. And we'll choose not to import the first records. Okay. Okay. And we have again, all of these resource information in its own table, a brand new layout was created. But we want to show this to vendors, but right now we don't have a layout for the vendors. So we're going to go ahead and quickly create one using the same type of techniques that we just did. So I'm going to go to layouts, new layout report. Okay. This is going to be for the vendors. Look, I'll just call this vendor detail for iPad. It's going to be for a touch device, right? Form, build on the orientation mode. Finish. Again, we have that layout that has already prebuilt to the dimensions of the iOS device and landscape. And we'll change this theme to sophisticated touch. All right. And we bring our information over by the field picker, right? And in this case, we don't have that much information that we want to show. Let's make this vertical. So we don't need to create buttons for this. We can just show the field just like that on the layout. Let's bring this down a little bit. Okay. I do want to create a photo field for this. So I want to make sure that when our staff takes a look at the vendor page, they're talking to the proper contact. Okay. And we'll remove a label and bring that over onto our layout. Okay. Again, using the dynamic guides to align. There we go. Actually, you know what? Let's bring this up a bit. Okay. And we'll add a title here for the layout page. Vendor detail. Okay. And we'll make this 36 font as well. Try to make it look as similar to our previous layout as possible. And we'll also put our logo on here as well. Again, looking for that unified look across our layouts. Okay. And just dragging and dropping right there. Perfect. And we'll have some tabs on this layout as well. So let's draw that tool right here. Okay. And we probably want to show the floor plan as well for the current event. We probably want to add some event details for this as well to show which vendors associated to which event. I want to add contracts. Okay. And then we want to add resources. Just make this a full justification. Create and click. Okay. And we have our tabs just like we had in the previous layout. So floor plan. We're going to need to create another field like we did last time. So let's call this floor plan. And again, we'll change this to containers is going to be a image is going to store an image. And let's just draw this out quickly. Move this out here. Then event details. I want to show a map right of where the event is located. So let's go ahead and actually before we do that, we probably want to add the name of the event. And we'll add the location. Bring that over here. Okay. And actually need some labels. Then in location. All right. We'll add the coordinator as well. Actually, let's change this to event location and start date here. Again, using dynamic guys to align. All right. Let's move this out of the way over here. Looks good. Okay. Now we can draw our WebViewer object onto the tab. And I'm going to choose different fields. This time I'm going to choose the event management address. Right. Management city. The event management state. And the event management zip code. Click okay. All right. Contract. We probably need another container field. It's going to store our contract PDF files. Okay. So we'll change that to container. Okay. And we'll have this out here as well. Let's draw that out a bit. Okay. And then our resources tab. And again, we want to show all of the resources allocated to each vendor. Right. So it sounds like we probably need a portal again. Right. So related records from the resources table. So let's draw this portal out here. Okay. And we're going to choose, oh, we didn't create a relationship yet. That's okay. So we'll go back to file and manage database relationships. There's the graphical representation of our tables. And again, it's all about finding that common information. Right. When vendor ID equals vendor ID, allow me to share the information or allow me to pull those records from resources. We'll click okay. And let's draw that portal again. Okay. Now the resources table appears. Show a vertical scroll bar. I'll just show six here. And again, you probably want to grab the resources ID, which will be the serial number item and model. We're going to cancel that because it's just easier to grab the fields from the field picker. Because again, they give us the option to put our fields horizontally and put the labels above the fields. So just like that. You could have those fields on a layout and we'll just change this to serial number. Okay. Okay. So let's go ahead and go to browse mode and take a look at our changes. So we added a few photo fields. Right. So again, all we need to do is just drag and drop. We have photos of our contacts and we have Doris's picture right here. Again, all of our information is now being put into one custom solution. Okay. We have the floor plans. So I'll just grab this image and put it right here. Okay. So they know the event breakdown. Okay. Event details. Click on this tab. You'll see that it already pulls that information from the event management table. Okay. So we have that listed here. Contract. Again, we can just drag and drop. We have our contract here for the vendor exhibitor contracts. Okay. We can just place that there. And resources. We have all of the resources allocated to each person. Let's go ahead and edit this here. And I'm going to minimize this bit changes to a minimal edit box. And let's go ahead and add a signature field. Okay. Now with a signature field, you can actually sign within a container field, but only in Fonic or Go. I'm going to demonstrate that in a second. So let's go ahead and we'll grab these fields here. So we want to make sure that we allocate these resources. And we also want the individual to verify that this is the list that they received for responsibility. Okay. So date field and we'll just put this out here as well. Okay. So we have those fields right there. Now let's go ahead and I want to minimize this and bring up reflector again and bring up the iPad. And again, give me one second to air play that over to my screen. All right. And it's coming over right now. Reflector is a little crazy here right now. Let me go ahead and reopen this. Okay. There we go. All right. So I'm going to tap on Fonic or Go down at the bottom. Okay. This up here. And this is the original layout that we were working with. So down at the bottom left hand side, let me go ahead and tap on the vendor detail for iPad that we created. Okay. Like all those changes that we made again, like we're talking about earlier are automatically reflected on the iOS device. We have the floor plan. I can tap on the event details tab. Okay. And just like we'd expect, we have all the information pulling over. Looks like my, my wifi connection is a little bit down for my iPad. It's okay. We have our contract image here. And then we have our resources again, listing the resources for each vendor. So what can we do with the signature field? I'm just going to go ahead and tap onto that container field. And you'll see we have a new pop up window. We have a few options here. I'm just going to tap on signature. Okay. We have this signature interface. So I'm just going to sign this for doors. Okay. Accept. All right. And then for the date, let's say it's, there we go. 20 second 2014. So doors can verify that she has that this is the all of the equipment that is allocated to her. And again, get to our event detail for iPad. All of the changes that we made are immediately displayed onto this iOS device. This popovers really stand out and look great on the iOS device. Because again, this is a, it's all a touch driven. Right. Okay. So one final piece in terms of connecting our data, jump back into FileMaker Pro. How do we jump from layout to layout? There's a few different approaches. I mean, you could create buttons that capture which record you were on and jumping back and forth using like a little script and a button. Just one way to approach it. Let's go back to the event detail for iPad. I'm going to go to the vendor tab and I'm going to go to layout mode. And I'm going to create a button. Okay. And just draw that onto my layouts. And I'm going to say, have this button go to related record. And I want to choose a related record from the vendors source. Right. And I want to show the record using the vendors detail for iPad layout. Click OK. And we'll just say a view. Okay. Resides us a bit because I'm going to place this in my portal. Okay. Just like that. All right. And let's go ahead and do the same thing on the vendor detail for iPad page. And I'm actually going to put that here on the event details. Okay. Let's go ahead and create a new button and go to related record. From the events management. Then detail for iPad. Okay. I want to show it based off of that layout. Okay. Let's say. Say view. Add that right here. Okay. So let's go ahead and exit layout. See that our buttons stick here. Okay. And then detail for iPad. It shows up in all of our portal. Looks great. Let's go ahead and minimize that and come back to our iOS device. Okay. And let me show this over to my screen. There we go. So if I tap on the vendor tab. Let's bring this up to the screen a little bit. If I want to see Doris's record, I'm going to tap on view. And just like that, there's Doris's record. The event details. Maybe you wanted to create a little interface for the vendors. Maybe you want to give them a sign on so they can view this particular record. And you want them to see the event details. They can just tap on that view button. And just like that, the go to related record button takes us exactly where we want to go. Okay. So we created relationships between events and vendors and resources and vendors and we used a portal to display related information. We also created a new layout for vendors. So we can now go to Eric and showing him the solution that we can access anywhere we want. It's built for our needs. And it has all of our data in one custom solution. And for Eric, that means we're spending less time bogged down on inefficient processes and freeing up more time and focus on productive tasks that generate our company more money. All right. So I'd like to open it up to Q&A now. If you haven't already, you can go to the control panel and enter your question. And in the meantime, to give you a little bit more time to do so, I'm going to go over a few resources slides. Okay. So if you haven't already, we have the Fondaker training series, which has been released. The Fondaker training basic series, which is free to download on iBooks or the Fondaker website. And we have the Fondaker training series advanced, which I believe is 1999. It's a great next step for building out your solutions and building out a foundation and discovering what you can do with a Fondaker platform. Some other resources, if you haven't already, you can download Fondaker Go 13 for free on the App Store. You can download the Fondaker Pro 13 trial, Fondaker.com. There are more web seminars like this in the Fondaker.com for support webinars, paid and not just IDDA iPads. There's a lot of great content there as well. That again is a great resource for you to learn about the Fondaker platform and enhance your skills too. And then if you're ready for licensing, you can contact your Fondaker volume licensing sales rep at the URL above. We're called 800-725-2747. We have a great annual volume licensing agreement program, which Fondaker Pro starts at just $9. And Fondaker Server is just $29. And this is billed annually as well. All right, so let me go ahead and we'll jump into the Q&A. Let me bring up my control panel here really quick so I can view your questions. Second here. Okay. All right, first question. I have Fondaker Go being shared on a home office Wi-Fi. Can I connect to that hosted Fondaker Go solution when I'm using a different Wi connection away from the office? Great question. And yes, you can. What you saw me do today, I was connecting on the local area network, kind of like your home office. But if I'm outside of the home office, what you need to do is, there's two different options. And one is set up port forwarding on the host machine's router for port 5003. And that's going to allow any machine from anywhere in the world to access your solution. So wherever you are, you can access your solution. The second option is a VPN connection, which allows you to connect directly to your local area network. Your home office, most likely you're not going to have that. But for anyone else out there, if you're working with a company that has VPN access, you can connect to your host solution that way as well. So again, port forwarding for port 5003 on the host machine router or VPN connection, which allows you to join your local area network. Can I use Fondaker Go to edit layouts of the solution? We touched on this a bit. Fondaker Go is strictly a client application. So you're just connecting to a hosted database. You're editing the information, modifying the information. But if you want to make changes to the database schema, like we did where we added fields and created relationships. Or if you want to make changes to the design and look of the solution, you know how we're adding those tab controls and adding those buttons and changing colors. All of that happens within the Fondaker Pro where Fondaker Pro advanced applications. All right, next question. Can I use Fondaker Go with Fondaker Pro using peer-to-peer network sharing with three users connecting? You can. In Fondaker Pro, if you host, it actually allows five connections. What you saw me do today was host with Fondaker Server. And really, when you're hosting a solution in production, you want Fondaker Server. One, it's built to be a server, so you're getting better performance. It's multi-threaded. So if you have multiple users and you're performing tasks at the same time, Fondaker Pro, if it's the host, is going to set up a queue. Fondaker Server is going to handle them all at once. It offers the reliability. It has automatic backups. So it takes that responsibility out of your hands. You can set up as many backup schedules as you want. If you're hosting with Fondaker Pro, that means you have to create the backups yourself and test them yourself. And if you can do that, kudos to you. I know that I will not be able to... I wouldn't trust myself to consistently create backups. And most importantly, security. If you are accessing your solution outside of your local area network, then you definitely need Fondaker Server. And that's not just a recommendation because I'm a solution consultant. You need it. Fondaker Pro, if it's the host and you're connecting outside of the local area network, it sends that information in plain text. There's no security. There's no encryption. Fondaker Server is just a checkbox. It enables an SSL encryption from client to the database server. And if you want to set up a web environment, it encrypts the web publishing agent to the database server, which you can use in conjunction with your typical SSL certificate so that web browser to database server is all secure as well. So technically, yes, you can host with Fondaker Pro using peer-to-peer network, but I never value concurrency over security, reliability, and performance. All right. Can Fondaker also do barcode scanning? Great question. And an appropriate question as well. Fondaker 13 just introduced the ability to leverage the iOS devices camera so you can scan items so you don't need a third-party solution. Now, that being said, there are scenarios where having a third-party solution dealing with a Bluetooth device is going to be more appropriate than using the iOS scanner. Let's say you're in a warehouse and you have to continually fill orders. And it's just really fast-paced. And that scenario, a handheld Bluetooth scanner is going to be more perfect because you can quickly scan a lot of items. If you're doing some local inventory or if you're doing some point of purchase in your store, that's not super high-demand or a high influx of people, then that would be a good option for you. Okay. The next question. Can you have a back button that would bring you back from View Vendor to the record you were just on? Yeah, you can. And this is what I alluded to in different approaches. This is how you will require some scripting to do. We don't have a button or a script step that just says, go back to where I just was, right? We have a button that says go to layout. You can specify that layout, but you may not go to the particular record that you want. But what you can do is you can set a script using the set variable script steps. So set variable is a script that allows you to grab dynamic data. So if you point it out of field, you don't want to hard-code information. You just want that dynamic information for the record that you're currently on. But you could set a variable to capture the layout you're on and then set a variable to capture the record that you're on. And then you can have that button run that script. You would set it up as global variables. And then you would run that script. It points to the global variable and then you shoot you back to where you were. Okay, the next question. Is FunMaker Server normally hosted on a server farm or a desktop laptop? Okay, great question. With FunMaker Server, there's two options. You can host it yourself. And this question put desktop or laptop. Yeah, typically you would want it on a desktop machine or like a Mac Pro machine or Windows Server machine. But yeah, you can host it in-house where you maintain the FunMaker Server and you set up the backup schedules. You administer the solutions, things like that. There are also options like the hosting solutions. There's hosting providers out there that offer a FunMaker service. So all you have to do is provide the clients and maintain the database. But on the back end, they will handle the FunMaker Server solution. Or there's places like, there's like a rack space that offers just like a space that you can install software on. Like you can install FunMaker Server on their space where you still administer it. But the software itself would be hosted elsewhere. So you have those different options to go with. If you're thinking about a hosting company, just keep in mind, it has to provide a FunMaker service. So FunMaker shares software in a host client model. So you have FunMaker Server as a host like you saw. And then the client applications connect to that host like FunMaker Pro, FunMaker Go for iOS, or a web browser. So places like a GoDaddy, for example, that just offer like websites. If they don't have FunMaker on the back end and can't complete that FunMaker host client model, then you wouldn't go with them. You will want to specifically look for a hosting company that offers a FunMaker service. Okay, the last question and really great questions, guys. Is the barcode scanning automatic in the container field, or do I have to script it? You can set it up so that, well, you'll have to script it because you'll need to grab, you'll need to parse out the information. So you can set up a container field so that it automatically points to the barcode. It will scan it, but then you want to use scripting and calculations to grab the information and, you know, point it to, you know, the different fields and how you want to break down whatever information is returned as well. All right, actually, we have one last question. Can we rewatch this session? Yes, and it will be posted to www.funmaker.com forward slash support forward slash webinars. Again, there are a lot of great resources there as well, not just ID to iPad that you should check out. And again, yeah, yeah, check them out. And I think, yeah, that's all the questions. That's all the time we have for today for the questions. On behalf of FunMaker, it was my pleasure to chat with you all again. And I'll see you next time. Thanks.