 Thank you for joining us today. This is Steven Day, new business manager at FileMaker. I'm excited to be your host for today's Idea to iPad Web Seminar, where we will build a custom business solution from scratch and deploy it to an iPad using your responses from questions submitted prior to this live event. We're also joined today with Ryan Minook, solution consultant at FileMaker, who will be building the live FileMaker solution using the newly released FileMaker 13. But before we get started, I have some brief housekeeping notes. For the best experience, we strongly recommend that you participate in this Web Seminar with at least a broadband connection. If you experience any problems or require online assistance at any time, please contact Citrix Technical Support at 888-259-8414. During today's presentation, you will have an opportunity to type in questions. Let's talk briefly about how to enter a question. Go to the control panel, click on the question section, and enter your question and send. We will cover as many questions as time allows at the end of our presentation. Now I'll hand over the presentation to Ryan Minook to build our custom solution. Thanks, Steven. And again, thank all of you for the submissions that you sent for today's idea to iPad demonstration. We've been getting a lot at this webinar. The participation rate from you guys has been really high. From the pool of the existing ideas, from all of our idea to iPad webinars, we selected to demo one of the most popular requests. Just as a heads up, FileMaker will continue holding idea to iPad events in the future. So if your idea wasn't selected this time, keep submitting them for use as a potential demo. And while your case may differ from the one shown today, we'll still be covering some common techniques and features that you can still apply to your solution. So we've received a wide range of use cases similar to the topics shown here, but the winning submission is the contact management solution. Now a lot of us in our everyday lives have to manage people and the possibilities of a contact management solution are endless. Maybe you want to track distributors you're purchasing from, you know, maybe you're an artist selling work and you want to track your network of friends and buyers. But today, what we're going to do is we're going to build a staffing solution focusing on the 10th list. Now, wouldn't be great if we had the power to build a custom solution that meets the functionality that we want. They give us access on the go and visibility of information whenever we want it, when we want it. And that's our goal for today. That's our challenge. We want to take the idea of a mobile contact solution and help guide you down the first steps to building and deploying your own custom solution. So we'll begin our demo. And before we jump into that, it's going to give you an idea of what our roadmap for today is going to be. All right. And our first part is focusing on the power to create our own custom solutions. Okay, adding the functionality that we want aligning the file makers features with our needs as a company. So let's go ahead and jump out of this PowerPoint slide. And I'm going to launch file maker pro advanced. And first thing I'm going to do is just create a brand new database. Okay, and we'll call this staffing solution. I'll click save. Now before we begin bailing, let's go ahead and let's create a story so that we can really provide some context for what we're going to do today. And let's go ahead and I'll need a name from our attendee list here. I'll go ahead and choose. Let's use Barry. All right, let's say that Barry is an owner at a staffing company and he's been burned many times because he hasn't had access to his solution after hours before hours when a company needed to fill a position. So he wants a solution that he can access on the go and have up to date information. So that's what we're going to attempt to do today. Okay, first thing we need to do is make sure that we can create the workflow that Barry needs for his staffing solution on the go. So what I'm going to do is go to layouts. And I'm going to select new layout report and I get this new layout wizard. I'm just going to call this temp details. Okay, and we're building for an iOS solution. So I'm going to choose a touch device and select iPad iPad mini and choose to build a form. And then finally, I can choose to build in portrait mode or landscape mode. And in this scenario, I'm going to choose landscape mode. And I'm going to click finish. So what happens file maker gives us this layout that's designed for the dimensions of the iPad in the landscape mode. Okay. And it's also given us this nice touch theme, we can change that if we want. But the difference here between the touch and the themes without touch, you can you can tell that the touch has larger font larger objects just like you would expect in an iOS solution. Okay, so we'll just stick with what we have here then line touch and click okay. You'll notice that when we launch font maker creating new today sort of the first time, we also have this field picture object right here. Okay, and kind of access is from this button right here. And this allows us to start building some database scheme based off of the current table that is created when we create a new database. And get a better view of that I can click on this little database button right here takes us to the manage database window. And there's a few more options. I can create more tables, I can create some fields associated with those tables and I can create some relationships. First thing I'm going to do in this tables menu is just change the table name to make it a little bit more applicable to this particular table. So I'm going to call this template. I'll change that. And then I'll click okay. And back to my field picker, we can now start to adding some fields this table. So what are some things that we want to track? Well, we probably first want to start off with a temp ID. Okay, we want to make sure that everyone is going to be unique. So I'm going to change that to a number. And then we can control click this temp ID and select field options. I want to make sure that every time a record is created, we have a serial number on auto enter, and it's incremented by one so we can always verify that the idea is unique. And then we probably want to track some typical things like the first name, right? And I'll change this to text. And the last name. And how about the full name and I'm going to change this to the calculation field type. Okay. And this is our calculation window and file maker a little bit daunting at first. But really what we're looking at, we're looking at the fields currently in the table, some operators, and we have a list of preset functions and file maker. Okay, so we can combine all of these with you know, even literal text and form different expressions and get different results. But in this scenario, I don't want to say is to get a full name, give me the value in the first name, and a space in between. And add the last name. Okay, I'll click Okay, and that's how we create a calculation and file maker. So let's keep building out. We'll cancel that out. So we have a text, we probably want a ranking an internal ranking of these attempts as well. So let me make sure that we're giving the best attempts to our best clients. Okay, probably want to address field, where is the template located, right? City State zip code, pretty standard stuff. Then you probably want to track their home phone number, mobile phone. How about a main email, an alternate email? Okay. And then it's also important that we track what level of education they've completed. Okay, so we'll say education completed, we'll keep that as a text field as well. I mean, we want to give the the temp a few options to list where they studied. So do education on to education three. And then every time we interview a temp, we have them come into our company, right? And Barry gives them a few different software tests, when he wants to know how many words they can type for per minute, right? So we'll log the typing score. And then the different types of software that they test the temps with. So we'll say software one score and software to score. Okay, and then it's really important that we track the status if they're available if they're currently employed. Okay. And if so, who's their current employer? Okay. And then Barry also wants to make sure he tracks their pay type of their hourly or salary and wage. And then finally, Barry wants to make sure that we have an option to store their resume in his solution. Okay, and for that, I'm going to change his field type to a container field. And a container field allows me to store files, PDF file, files, sound files, media files, things like that. All right. So I think that's a pretty good start. In terms of the structure on the back end of the things that Barry is going to want to track for his staffing solution. Okay, now, in order to get these fields over onto the layout, it's pretty simple. All we need to do is just highlight a field and just drag it right on over to the layout. Again, just highlight a few fields. Okay, I'm going to use the shift key to grab a bunch at the time. And we can also specify down at the bottom, where do we want the fields? How do you want the fields placed with them horizontally? Do you want any labels at all above the field or to the left? We're just going to keep it vertical and have the labels above. And Barry can just drag those fields right onto the layout just like that, you'll see these blue lines that are appearing, those are what we call dynamic guides, they help you align the fields. So you can do it really quickly. Okay, so do you want to extend the layout? Let's not extend the layout. Let's just grab a few of these. See how that works. Okay, that easy, just a few clicks and a few drags. And we already have the start of our solution. Okay. Now, one thing you'll notice is that we have a lot of fields in this field picker in this table. Okay. And we could essentially drag all of these fields right onto this layout, but that probably may not be the most efficient way to look at or to represent our data, you know, it's going to be a huge data dump on the layout. There's got to be a way that we can really maximize the space on the iOS. And luckily with FileMaker 13, we have these really great features that allow you to do so. So what I'm going to do is, let's go ahead and I'm just going to highlight all of these fields and delete them. I'm going to use this brand new feature in FileMaker 13 called popover buttons. Okay, and these are something that you'll find in your iOS solutions or even on the web. These are really standard. So what a popover button is essentially what it looks like. Okay, anytime that you click on this button right here, another window will appear. So how can we use this in our solution? What we can do is essentially just create this popover button, we can decide to break down our fields and different type of categories, show the important information that we want to show on top of the button. And then in the popover window, we can have all of the other fields appear. So for example, actually, you know, before we do that, let's go ahead and I'm going to create this square right here on the left hand side of our solution. This way, I really want to stand out where the navigation is in our solution. Okay, so we have that square, I'm going to bring up the inspector. And in this thing, we have a few different style choices for a square, maybe want that accent color blue, green, red, there's a little mustard here, I'm going to choose gradient one. Okay, so it looks pretty good so far. Now let's go back to our popover button. Okay, select popover button. And I'm just going to draw this right on top here. Okay. And now they can specify, hey, do you want to give this window a title? Well, for sure, let's go ahead and call this general info. All right. Yeah, we want to show the title bar. We can choose where we want the window to appear in relation to the button, but we like where it is to the right of that button. So just cancel out of that. Okay, the window now takes our general info. And let's take this window and drag it out a little bit more. And let's go ahead and grab some fields. Again, I'm just going to choose I see first name, want to use the command or control key on windows to grab a few fields. All right. And then we'll drag them right into our window, just like that. Okay, so how does that work again? Right now, we can't see that window. We click on this. I'm sorry, let's go to browse mode. Okay, click on that button. And we have that nice window appear again, a great way to maximize the space on your iOS solution. And you'll see this again, in a lot of iOS solutions and over the web, maybe in a menu at the top, you'll click on it on a like a little button, and you'll have a window appear below it with the different types of navigation options. But in this scenario, where you just want to show the most important information, this is a really good fit. Okay, so let's go back to a layout mode again, this is the mode where we can design the layout. So we have the information that we want in the pop up window. Now we have to determine what can we do in terms of the button and information that we want to show on that button. Before we do that, let's go ahead and format that a bit. I'm going to go back to the inspector. Okay, and I'm going to go to the appearance tab. And there's a few things I want to do. I want to make sure in the status, I'm just going to choose none, okay, for normal. When the button is hovered over, when it's used none as well. And pressed. I don't want anything. And in focus. Okay, we have none listed there as well. Perfect. The normal, let's go ahead and remove all the lines, but only include the bottom one. Okay. And then finally, we've changed this default style. And I want to go ahead and save this as a new style. And call this Ryan's button. And click okay. Okay, this is a brand new feature in 13, which is really saves you a lot of time in terms of formatting. And now when we create new buttons, we'll be able to choose this option and adopt the changes right off the fly. Okay, so I like the way that's currently formatted. Now, what can we do about the information here? Well, let's go ahead and I'm going to create a label. This says general info. Okay. And I'm just going to put that right over top of my button center that using the dynamic guides. Okay. And then I'm going to create a little bit more labels, I'm going to say name. Okay. And we'll create this on the side first. And I'm going to say location. Okay. And then I'm going to put ranking. All right, use the dynamic guys to align these. Okay. All right. Now, the next thing I'm going to do is use merge fields. Okay, so I go to the insert menu and select merge field. And when and doing so, I can see all of the fields that I just created. And what merge fields allow you to do is just grab the value of those fields. And that's going to be, you know, you can use those in letters, emails, templates, things like that. For something like this where we just want to show information on top of a button. This is perfect. So for the name, I'm going to choose full name. Okay. And drag that out a bit align that with my name. And for location, I think we're going to need another calculation here. So let's go ahead and create a new field. Okay. And we'll call this location. And I'll change this to a calculation. And I really just want to put the city in state so that when Barry looks at the customer's customer's record, he knows automatically, okay, these are the city that's located right where my client is located or close enough that it'll be a good match. Right. So I'm going to say in this scenario, give me the value of the city. And give me a comma and a space. And concatenate that with the state. And the value result should be text. Click okay. All right. So let's go back to the insert merge field. And bring the location calculation. Listed here. Bring that out a bit. Okay. And we'll do the merge field again for the ranking. And again, the ranking is I mean, the merge field is just grabbing the values of the fields. All right. It looks pretty good so far. So let's go ahead and grab all these fields and put them right over top of our button. Okay. Now, you'll notice one thing right off the bat. We have text layering over text, right? In this scenario, if we don't have a value for location, you know, that's probably not going to be a problem. Because we'll be able to say general info. But that general info is always going to be listed there behind this value. So what can we do about that? We probably don't want this name location and ranking to appear as well if these values are empty. So we're going to use another feature in FileMaker 13 called object visibility. So for this general info, I'm going to go to the inspector tab. Okay, and click on the data tab. And we have this option right here in the behavior section hide object when so let's click on that pencil icon. And hey, here we are again to the FileMaker calculation window. So essentially what I want to say is please hide that general info label. When the following is not empty, that's why I have not is empty. Okay, I'll say the first name last name and see state. It's pretty good so far. Okay, first thing last thing you see, click okay. Alright, then what can we do about these labels here? Okay, some object visibility on that. So for the name label, I want to say, okay, please hide that object. If the first name last name or empty, and the location, please hide this when we'll grab the is empty function again, and then ranking will say is empty ranking. Okay, so if there's no value in that ranking, do not show this label, right? We don't have to do anything to these merge fields because again, this is only pulling the values. So if there's no value in the field is not going to show anyway. So let's go ahead and bring this over here. Okay, right on top of our button. All right. And the final thing I want to do is just create a small little edit label. Okay, and we'll bring up the text formatting, change that to font 12. Okay. And we'll choose a lighter color. We'll put that up at the top. And this is just a visual so that our users know, hey, if you tap on this button, you can edit this information. Okay. And then the final thing I want to click on the button. And go back to the inspector position tab. And I want to make sure that the button is on top of everything. Okay, so that's stacked on top of everything. All right, so let's jump into browse mode and see what we just see the result of what we just did. Okay, so I'm going to exit this layout, click Save and browse mode is where we're able to enter and modify data. Right off the bat, we see that general info, right? The name location or ranking are not listed here. Okay, so let's create a new record. And if we click on the general info, we now have the pop over window, right? And all of these fields. So let's go ahead and type a name. Ryan, there we go. General notice that the general info is now disappeared. And we have this name in the merge field appear here. All right, I'm going to leave ranking. I'm going to leave that blank for now. See an address 521 Patrick Henry drive. All right. Santa Clara, California, Santa Clara, California location appears 95050. All right. Just like that. Just in a matter of minutes, I mean, maybe two three minutes without us talking, we're able to really create this nice solution, we're able to maximize the space on our iOS and have this nice navigation so window can, you know, I'm so very can, you know, really focus on the important things in his staffing solution. All right, so what I want to do at this time, I'm going to go ahead. So you jump back into layout mode, I'm going to close this solution out that we just created. Okay, and I'm going to Julia child's a little bit that section. So I'm going to open up this other database that I created here. Okay. And all I did was essentially repeated those efforts into other buttons. Okay, so for example, contact info, here's the home phone, and the emails, the academic history, we have our education information. And then this test scores, this is where Barry can view the software scores and the words per minute. Okay, so if you go to layout mode, again, this is essentially just what we've done. Okay, object visibility on the labels, and the main button category. And then just pop over buttons with the fields, pretty straightforward. Okay, so let's keep building out. Let's go back to fuel picker. And we have a few more things that we want to make sure that we're capturing again, the status, the current employer, pay type and wage. So let's go ahead and highlight those. All right, and I'm going to drag them right over into the layout again. All right, we can use those dynamic guys to align a little bit. Okay, just highlight these fields over here and bring them over just like that. Okay, and I think we're going to bring these guys down a little bit. So I'm just going to highlight all of them and bring them down. Okay, so status, pay type, current employer and wage sounds pretty good. Now, how can we capture the resume? Well, first thing we can do is maybe we could have a big container field here and put the resume in there. But, you know, there's other things that we want to track on this layout. And instead of having to create multiple layouts, I'm going to go ahead and use another feature. And this is brand new 13 as well that allows us to save some space and maximize, you know, the iOS landscape. So up in the formatting bar here, if I just click and hold this type control, I have this option for a slide control. Okay, and I'm just going to draw that right out onto my layout. And if you've, again, if you use iOS or the web, these should be pretty familiar to you. Okay. So this slide controls essentially by default, we get these three panels. Okay, you can add as many panels as you want. And this scenario, I'm just going to bring it down to two. Okay. And essentially, you can put whatever objects, you know, portals, you know, web viewer, whatever you want on a panel and have it access its own space. Okay, and then if I jump to panel one, for example, I'm only going to see the objects and fields that I placed on panel one. So, and then we can also and then we can also select enable swipe gestures, which allow you on the iOS to swipe through these these these panels on. It's not available for trackpads or things like that. It's strictly for the iOS. But considering that's where we're going, that's what we want. So for the first slide, let's go ahead and I'm going to call this notes, because we do want to track the notes. And we're going to come back to this. But for now, let's go ahead and select that. I'm going to jump back to my inspector and choose styles. And there's a different types of looks we have for text blocks. I'm going to choose this notes. This green notes here, I'm just going to blow that up a little bit. Let's do maybe a 24 font. Okay. Put that in the center. All right. So we have notes and we'll come back to that. All right, Barry really wants us to store the resume listed here. Okay, so let's do the same thing. Let's create a text block here that says resume will choose the accent to okay. And we'll put this at a 24 font as well. Then center that using the dynamic guides. Okay. Now, we're going to go over to the field picker with our resume container field and just drag that right over onto our slide control. Okay, so we sell those labels, I'll get rid of that. Let's bring that up a bit. Let's go. While this is highlighted, let's bring up the inspector. And I'm going to go to the data tab and I'm going to make this an interactive container field. Okay, so that way when I have temp submit a PDF of the resume, I'll be able to view it right within this container field. So I'll choose interactive content. Okay, that's pretty good so far. And let's go ahead and we'll personalize this a little bit. Let's go ahead and take our staffing logo. Okay. And we can put that right in the header. Just like that. Perfect. And let's go ahead and add a title. We'll say staffing, templeist. And let's make that guy 36 point. Okay. So let's jump back to browse mode and take a look what we've built so far. So save these changes. Okay. So we have those nice popovers. Okay, we have a nice view of the status of this temp, if they're available or not, we have a note section here, which will build out. And then we can quickly view the resume. Let's go ahead and take a resume sample and just drag that right into the container field. And there you go. Just like that. We can view the resume right within that container field. So Barry can quickly search for his attempts to see if they're a good fit, and also get a quick look of the resume as well. Okay, so final thing we want to do for the workflow, Barry wants to make sure that he's able to contact these employees. Okay, he wants to make sure that, you know, not only can he call them, he wants to be able to email them directly within the solution. So how can we do that? Let's jump back into layout mode. Okay. And we can set up an email directly from this window. So first thing I'm going to do is bring this out a little bit. And I'm actually going to bring up one of our starter solutions. And if we go to file new from starter solution, these are I believe like 14 or 16 completely free star solutions. You know, this whole thing is about idea to iPad. And if you have an idea that it matches these star solutions is a great place to start as well. Okay, so I'm going to go ahead and bring this up. And I'll show you the reason why we go to customer details. I'm going to go to layout mode on this. I really like this email, email icon. So I'm just going to grab that I'm just going to copy that. All right. And I'm going to place that directly onto my layout. Okay. I think that's a pretty cool icon. So the star solutions, they're not just a great point for you to start entering data. That's a great way to reverse engineer get some ideas and also, you know, steal some of this cool stuff that we've added. So thank you and voice the solution. I'm going to close that out. And so now we have this little email icon. Let's go ahead and set that up as a button. Let's say button setup. Okay. And I want to set this up as a email. So we'll choose send email. Click specify. Okay. And I'm going to choose to send this to the main email listed here. Okay. And subject we will leave empty. And the message, you know, let's go ahead and we can add another calculation here as well. Okay, we can add a greetings and a signature. So I'm going to add some literal text that says hi comma space. All right, and give me the value in the first name field. Okay. And then I'm going to add some no return carriage returns. Okay. And then you can add as much white space as you want in the in the calculation window. This doesn't affect your calculation. It just helps you kind of organize a little bit better. So I'm just going to do that. Okay. So we have high comma space the value in the first name a few carriage returns. And then I'm going to add another literal text here in quotes. Thanks for the space. And the carriage return. And I want you to add some more literal text. And the nook. And a carriage return and add another literal text here. I'll make her ink. He looks pretty good. So we'll click okay. Click okay. And I'm just going to duplicate that I just did a command D or control D on windows. We'll put that right up here. Okay. And I'm going to duplicate that again put that next to our ultimate email. Okay. And we'll specify this will change this from the main email to the alternate emails this gets sent out to the alternate email. Okay. All right. So this is a layout save. And let's take a look at some of this workflow we just created again to do. Ryan. Manuk 5201 Patrick Henry drive. Santa Clara California 50 contact info 408. Okay. See. Main email. We'll say school file maker.com. Okay. We have that listed there. Let's see if our email button works. Click on that. Just like that you see it pulled the value from the main email field and it added our literal text right. Hi Ryan. Thanks. Ryan Manuk 5 maker ink looks like we need to make a change there really quickly. Don't save. Let me jump to layout mode. Okay. Specify here. It's a really quick change. Oops. I don't want to feel I want a calculation. I want a high space and first name and a comma there. And okay. We'll do the same thing over here to our calculation. Okay. So we do want to space high space the value in the first name and a comma and a bunch of carriage returns. Beautiful. Okay. All right. It's about what 1015 minutes without talking we're able to create a nice workflow maximize the solution on the iOS putting an email and a nice location for the resume and even give ourselves a little bit of a a personalized feeling of the solution. So I think that's a really good start for explaining the power to create custom solutions right taking file maker and aligning it to the customer's ID because the customer's needs. So now let's go ahead and we'll talk about the data entry in the iOS environment. You saw me just typing information. It's really important that on the iOS you know we kind of limit what are how the users enter data right it's really important that on the iOS everything is really touch driven. So that's what we want to go ahead and do. Okay. So let's go ahead and we will make sure that there's a few things that we can do so that you know they don't have to constantly type on that keyboard. So for example for this ranking let's go ahead and click on this inspector and we'll change this to a pop up menu. Okay. And we'll put a value list and we'll call this ranking and we'll say this guy's a four star three star two star one star temp. Okay. It's good for the home. Okay. We have these new on the inspector data type. We have these brand new keyboards where we can change a a the keyboard that appears to phone type keyboard so only shows the keys that you would expect on the iOS. Right. Same thing for email addresses. This will have the at symbol and the underscore directly on that main keyboard screen. Okay. Education completed. Maybe we want another pop over here as well. Okay. Change that to education completed. We'll say a master's college some college high school some high school click. Okay. All right. On the test scores let's change this to a pop up menu as well. And we'll say words per minute. And this could be greater than 80 72 80 60 to 70 50 to 60 or less than 50. Okay. Okay. Software score. We can change this to a pop up menu as well. We'll say software scores. Let's say 100 90 80 70 or less than 70. Okay. And we can do the same thing for software score to although we can use the value list that we just created called software scores. Okay. So a lot of this stuff again is just going to be tapping and touching like we would want our users to do on the iOS. Okay. Status let's create a set this as a pop up menu and create that a value as well. So status will say if they are available. They're currently employed or if they're do not use right staffing agencies are always have that do not use listed as well if you know maybe they missed an appointment or missed a day of the job. Right. Current employer pay type can change this as a pop up menu as well changes to pay type can be a hourly or a salary. Okay. And then for the wage we can format this as a QBED format this as see if I listed this as a text field. Yes. I want to change this as a number. Okay. Now in the inspector I have the option to change this as a currency and a thousand separator. Okay. So we'll save that jump back to browse mode and you can see the ranking. All right. This guy's a four star academic history college test scores. All right. 70 80 90 software to score. He only scored a 70. Okay. He is available. Okay. It pays that we wouldn't have because he's not employed yet. Okay. But you can imagine and we'll see this in the iOS soon but we can do a lot of things in terms of having everything be touch driven like your users would expect on iOS which means you know faster workflow on your solution more efficient more accurate less errors in the solution. Okay. So I think it's a pretty good idea of how we can leverage the iOS and their formatting. Let's go ahead and we'll talk about relating information. This is really huge. Right. You could have multiple information in or related information across multiple spreadsheets or maybe you know you have your information organized in different tables. How do you bring them together. Well this is a this is the power of farm maker. Right. And to demonstrate that we're going to jump back to solution and this is where we're going to talk about our notes field right here. Right. We one of the most important things in this staffing solution that Barry wants us to capture is you know notes like setting up appointments. Was he a good candidate things like that. So what we're going to do is let's go ahead and go back to layout mode. Okay. And in our field picker we're going to click on this database icon that we showed before. Okay. We're going to create a new table. We're going to call that notes. Okay. And save. Oops. Change that. Templates. Change. Notes. Create. Okay. So now we have the notes table. We're going to create a notes ID and make sure that each note is unique. All right. And just like we did previously is make an auto enter seal. Okay. And I'm building it in this managed window so you can see another way to build out your tables. You want a temp ID so that we can create a relationship with the note to the proper candidate. Okay. I'm going to keep that a number. Click create. And then we want a notes field. And we also want a time stamp. Okay. And we'll change this to a time stamp of field type and click create. Now let's go to the relationships tab. Creating a relationship and file makers just as simple as finding the matching data that you want and dragging the line to that associated field in the other table. So for example, I want the temp ID in this temp list to match the temp ID in the notes. Okay. So I'm going to drag that over. And just like that we have a relationship in file maker. Okay. So I'm telling file maker when temp ID equals temp ID, allow me to share that data. Okay. Allow me to share those notes for the appropriate temp. Okay. So I'm also going to in this relationship make sure that I have this option checked allow creation of records in this table be this relationship. That's going to allow me to create notes for the particular time. Okay. And we'll see that coming to play in a second. So click okay. Now, in order to show multiple related records, we have this object called a portal. Okay. And this is just what it sounds like. A portal into another table. Okay. So I want to show a multiple related records from notes. Okay. Let's go ahead and sort this portal by time stamp, descending and click okay. We'll show a vertical scroll bar. I'm just going to show one note at a time and click okay. Show time stamp and notes. Okay, here. We'll draw this out. Okay. And we'll put the notes listed. And now let's go ahead and exit layout save. Okay. And we can now add a note in this layout. So say called Ryan and set up an interview with the hiring manager. Okay. There we go. One thing I didn't do here is to get our time stamp to automatically create. We need to do an auto enter just like we did with our serial number, right? So I want to say on creation, create that time stamps, we'll click okay. All right. So let's create a new one called Ryan and set up second interview with the hiring manager. Okay. And there we go, right to the top with our time stamp listed there. Okay. Okay. And that's really the power of being able to associate different values and tables and records and tables with each other. I'd like to do the employer as well. But given the time, what I like to do is, you know, this is called idea to iPad. So what I'm going to do is get this solution onto the iPad is pretty quick. But you know, we'll focus on how we can do that now and kind of give an example, how the solution would work right on the iOS. Okay. So first thing we're going to do is click on this share button. Okay. And we have a few options. Upload this to FileMaker server or share with clients and share with clients means you're using your FileMaker provocation as a host and using it as a peer to peer. So first thing I'm going to do actually I'm going to upload this to my FileMaker server. And that's what you want. That's going to be your hub to your FileMaker solutions. That's what's going to allow you to have better performance, security and reliability. So I'm going to upload this to FileMaker server. Okay, close that out. Choose my computer. Alright, don't look at my password. This is highly secure. Alright, next files ready to be uploaded. Okay. And I'm not going to open up with FileMaker just click done. Okay, so it's currently hosted with FileMaker server in the back end. And what I'm going to do now is I'm going to launch my FileMaker go on my iPad but first I want to allow you to see my iPad, the iPad air that I have my hands right now. So I'm going to launch reflector and that's going to allow me to air play my iPad directly over to my screen. There it is. Okay, so what I'm going to do is down to bottom left you'll see FileMaker go. Alright, and let's actually put this in landscape mode. I'm going to tap on FileMaker go. Okay, down at the bottom, I'm going to tap on hosts and find my server. Okay, I see Ryan Minook's FileMaker server. So I'll tap on that. Okay, we'll see the two staffing solution. So I'll tap on that as well. Okay, and there we go just like that. We have our solution right in, right in our hands. Okay, so now Barry, when he can't or when he had issues with fire drills that before hours after hours, he now can access his information no matter where he is, and you know, find the perfect candidates for for a fill. Okay, so let me go ahead and tap on the general info you can see we have works just like expected, right? The home phone may want to tap on this email here. Okay, we have that updated creating and signature listed there. We have it to the value in the main email. Okay, we'll cancel that out. Education completed. Again, we have the drop down menus that allow us to allow the user to quickly move through the solution, right? Okay, then 80 software scores okay. Save is available employed. Okay. We have the notes listed here if we want to add more notes we can. Again, I'm going to take one finger and swipe through and look at the resume on that slide control. Okay, just like that. Alright, without talking, that's what 20 minutes and we have a solution accessing our information that we didn't have before. And in that 20 minutes, I mean, that means what? One extra call one extra order? How much does that add up for a week or a month or even over a year for your business? Okay, I think that's a pretty good place to stop what I like to do now is let's go ahead and jump into some Q&A. And I like to reintroduce Steven Day. And I believe he will go ahead and moderate some of these questions for us and I'll go ahead and answer them. Thanks, Ryan. So we have a question here. Can I use my database on my iPad when I'm not online? This is a very, very good question. So what you saw me do is host my solution up to my filemaker server and I accessed it through my iPad. Okay, that's one way to do it. So what about in areas where you don't have a network connection? You can actually store a local copy of your database on your iPad. Okay, and how do you get it on your iPad? There's a few ways. One, you can use iTunes. Okay, you can email the solution to yourself. You can use a third party application like Dropbox. And you can even, you know, put it up on a website and download it right to your solution. Now, once you have and to take it a step further, once you have it on your solution, you're working on it without a network and you're updating it, you will have to bring it back to the main file and perform some form of sync. So that could be an import. There's a bunch of third party applications that assist with the syncing as well. But it will require some method of syncing to set that or put that information back into your main file. Very good. And do we have to do anything different for databases to work on Windows? Great question. No, filemaker is a completely cross platform for Mac and Windows. Everything that we built today, you could just open it right up on Windows and it should be smooth sailing. There's some minor things, but maybe like one or two fonts may appear a little bit larger on Windows. It's just the way that Windows and Mac render differently, but all of the features and mainly how you design it and things like that should be pretty smooth sailing. Here's a great question. What is the advantage of using merge fields versus regular data fields? Mainly it's the merge fields just allow you to allow you to grab the value. One advantage is that when I put the merge fields on there, the user can't really just edit that information. So for something like in an email template, if I put a merge field at the top and I don't want that name to be messed with by the user, I can definitely put a field in there and I can turn off entry in browse mode, but for the most part, it's just a nice way to have that value without having any user error listed there. And one last question, a custom touch keyboard types available? It's custom touch. We only have the seven keyboards listed there. I believe you're talking about how you saw the email and the phone. We only have the seven available in that inspector. Very good. Thank you, Ryan. Okay, so I had a great time speaking with you guys, and I'll kick it off to Stephen Day, who'd like to wrap things up. Thank you, everyone, for attending. Please keep in mind that you can download FileMaker Go 13 for free. That's available on the App Store. And keep in mind, too, we've actually got the File Training Series Basics for free. That's available on the website in front of you. There are some resources. So with some options with volume licensing, please keep in mind that we have the annual option available to you with pricing, starting at $9 for FileMaker Pro, $15 for Pro Advanced and $29 a month for FileMaker Server. Keep in mind this is billed annually, and there's some minimum requirements with that. Please contact your sales rep, and there's also great bundles available to you to get yourself started to build out your solutions. So thank you again for everyone for attending. On behalf of FileMaker, Ryan and myself, speak to you soon. Thank you.