 Thank you for joining us today. My name is Ben Coterell. I'm a new business manager here at FileMaker. And I'm your host today for IDA to iPad, where we build a custom solution from scratch and deploy it to iPad in less than an hour. We'll be using one of the most popular responses from our survey posted prior to this live event. We're also joined here today with Ryan Minook. He's a sales solutions consultant at FileMaker, and he will be building live your FileMaker solution. Before we get started, I have some brief housekeeping notes real quick. For the best experience, we recommend that you use a broadband connection. And if you have any problems or require online assistance at any time, please contact Citrix Technical Support. And the numbers listed there for you, it's 1-800-259-8414. And again, the number right there on the screen is 888-259-8414. The presentation, you're going to have the opportunity to ask questions, and we actually encourage you to ask as many questions as possible. Obviously, Ryan's going to be presenting, so I'll either try to answer them live, or we'll save them for the end. And then let's just talk briefly on how to enter the questions. You go to Control Panel and just click on Questions, the question section, and enter your questions, and just click Send. We will cover as many of the questions as possible, and I'll try to get most of them at the end. Just a couple things to go over. If this is a, FileMaker is considered a platform, and FileMaker, you can start out with FileMaker Pro, which is a flagship product, and it is what you use to build your solution. However, if you're building for, or like a team of people or a large group, you might want to use FileMaker Pro Advanced, it's the second product on the right, which comes with Power Tools, such as a script debugger, the data viewer, and database design reports, and it allows customers menus and much more. We also have the next product on there, which is FileMaker 12, and I mean, FileMaker Server 12, and it is the hub of successful FileMaker deployment, which allows you to host your FileMaker solutions for up to 250 people and provides automated backup and remote admission. FileMaker Server Advanced, which is the next product on there, is similar to FileMaker Server, but it allows for FileMaker to be used as an OBDC data source and has other functionality, like instant web publishing, and the reasons we are here today is for FileMaker Go, obviously, which brings your solution to the iPad, and that's available for download at the Apple App Store, and it's 100% free, and just, this is how you would design, deploy, and run your platform, and this is basically what Ryan will be doing today. Here's a vision, you design and build your solution using either FileMaker Pro or FileMaker Pro Advanced, these solutions are then hosted by FileMaker Server so your team could connect over LAN or LAN connection, and finally you can run your FileMaker solution on a variety of devices, which include, with web browser using custom for publishing, including iPad, the iPhone. I'm gonna go ahead and turn it over to Ryan now to start for demo. All right, thanks Ben, and to start, I'd like to thank all of you for the submission that we received for today's idea to iPad demonstration. We had a high participation rate with a wide range of entries from places like the University of Pennsylvania Warren School, and we chose the most popular one for this session. Now, 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 use case may differ, we'll still be covering some common techniques and features that you can still apply to your solution. So we received requests for a job ticketing system, volunteer management system, an application to track time billing, but based on the popularity of your submissions, the leading entry for today's demonstration is a project tracking solution. Now, among other things in this scenario, we would typically wanna track the overall status of projects, allocated tasks and personnel, budget, milestones and have a reporting mechanism, but given our timeframe today, we'll stick to laying the foundation centered on maintaining the schedules and tasks and we'll build additional features if we have time. Now, let's create some context for our solution. Let's assume our boss is requesting a project management tool to coordinate our annual conference event. He wants to make sure we're organized, we're sticking to plan, and he wants everyone involved to have visibility of the project while on the go. So we'll spend the next 40 minutes or so creating this tool for our boss and we're really gonna highlight the ease of building and delivering mobile solutions with FileMaker. So let's get started. Let's exit this out and the first thing I'm gonna do is launch FileMaker Pro Advance 12 here and I'll create a new database, okay? And I'll call this Projects, Project Tracking and save it to my desktop. First thing that happens when we create a new database and FileMakers we're brought to what we call TableView which is a spreadsheet-like view of your data and this is an easy view to start adding, creating, modifying fields and entering data. But today you'll see me building a lot of our database in the Manage Database window. So let's head over there now. I'm gonna go to File, Manage, Database and we have a few more options in terms of building out our database schema. One, I can create additional tables. I can create fields associated with those tables and I can build relationships. So let's jump back to the Tables tab and we have a default table which takes the name of the file and I'm just gonna go ahead and change that to Projects. And now let's add some fields. So I'll click on the Fields tab and the first thing I wanna do is create a unique ID field for the project. I wanna make sure each project has a unique value. I'm gonna change the type to a number field and click Create. Now let's jump to the options for this field. And on the Auto Enter tab, I'm gonna select the serial number option so that every time a new record is created or a new project will get a numerically sequential number, make sure it's a unique value. So I'll click OK. Now if I wanna add a title for our project, change that to a text field and a description, click Create. The submissions are also requested that we track the status of the project and how about the budget? And for the budget, I'll change this to number, create. Any project is gonna have a start date and the end date. So let's create a start date. We'll change that field to date type and I'll create a due date. Now let's take that concept a step further. We know we have a start date and a due date but we really want to emphasize how much time we have left remaining in the project. So I'm gonna create a field called days remaining. And I'm going to make this a calculation field. So I click Create. We are brought to FileMaker specified calculation window. And what we're looking at right now are the fields within my current table, some operators and a list of all of the preset calculation functions in FileMaker. And what we would do is essentially just combine all of these and even with literal text to make different expressions that produce different results. But in this scenario, we're just looking for the time left in our project. So I'm gonna say due date minus, I'm gonna jump to our get functions family and select the get current date function. So essentially in FileMaker, hey, take the value that's in due date minus today's date. Go to storage options and make sure that this is not stored and we'll calculate when necessary. Click OK. All right, that's a pretty good structure that we have for our projects table so far. Let's go ahead and click OK and let's see what we're working with. As you can see, the default layout, a table view layout has adopted the field that we just created. However, the table view spreadsheet like viewers won't necessarily give iOS users the best iOS experience. So let's put a layout that we'll do that for them. And first thing I do is go to view layout mode. And in this mode, this is where we can really change the design and the look of the database. I'm gonna go to the layout menu at the top and click new layout report and I'm brought to the create a layout report wizard. So I'm gonna show records from the projects table I just created. I'll call this project iPad to standard form, quick text. Let's go ahead and grab all the fields in our current table. And next we have the option to choose one of the rich new themes introduced in FileMaker 12 and there's 40 of them. And then scroll through and notice that some of these are marked as touch. And the difference is that you'll notice that the touch has larger objects and larger font like you would expect on your iOS device. So I'm gonna scroll down a bit and choose one of my favorites, ocean touch and quick finish. Okay. And now we have a lab that's a little bit more ready for the iOS. Next thing I'm gonna do is use this screen and dimensions feature. Okay. And what this allows is it gives me guidelines to create a layout that perfectly fits a certain resolution. So let's use the iPad landscape option. And notice I now have these bottom guidelines that represent the iOS and landscape view. Now I need to do is just drag my current layout to those dimensions and just like that. That's customizing in FileMaker. Okay, let's keep building out. I wanna make this a little bit more presentable for the iOS device. So I'm gonna move some fields around. And there's a few ways that we can do that. First thing I'm gonna do is click, hold and drag. And I'm gonna select all these fields and move this down a little bit. I'm gonna do the same thing and move some of these fields over. So you can start designing our layout. I'll bring the project ID field down. And what you saw me do is hold down the shift key, select the multiple field. That's another way we can move fields around. And I'll put these labels right on top of the fields. And what you see right now is these blue lines that appear. That's what we call dynamic guidelines. And they help you align your fields. Just make these fields a little bit larger. The description field is probably gonna be a little bit larger as well. So we can enter more information. And I'll bring this over to the side right here. I'll do the same thing with the status and budget fields. And the start date and the due date. Put these labels right on top. Start date over top of the start date field. So align these a little bit more. And I'll make sure these fields match. Again, I'm using the dynamic guidelines to make sure that everything's aligned properly here. Okay. And draw my field out a little bit more. Perfect. And a click, hold and select all these fields. All right. Now we have a cleaner looking layout for that iOS solution. Let's save these changes and go back to Browsmer where we can enter information. I think it's a pretty good start in just five minutes, right? Okay. Let's keep building out. I'm gonna jump back into a layout mode. I can go to view out mode. I can click on this button here, edit layout. And for iOS solution, for the user experience, it's all about the touch and the tapping. So I think we can do a few things to format our solution better to streamline how users enter our data. But first thing I'm gonna do is go to our budget field and I'll bring up the inspector. And if you accidentally click on your inspector, you can open again by clicking on this higher information button right here. And I'm gonna data tab down at the bottom. I'm gonna format this number field as a currency. And I'll choose the thousand separator. Now, in terms of that tapping and touching iOS-like experience, for the date fields, let's go ahead and make that a dropdown calendar. Right now, it configures the edit box where you click into a field and you start typing away. There's a few different options that we can choose. You can make it a dropdown list, pop-up menu. But down at the bottom, we'll have a dropdown calendar option. So we'll choose that. And for the due date, we'll just do the same thing. Turn that into a dropdown calendar. For the status button, instead of having our users enter the progress of the status every time, we can also stream that, stream on that a little bit. So I'm gonna turn that into a pop-up menu. And I now have a new option to associate a value list with this field. So I'm gonna create a new value list. And we'll call this status. There's a few options I could pull from another field, another table. But for this scenario, we can just create custom values. So I'll say in progress, completed, and closed. I'll click okay. So it looks good. Let's go ahead and save this layout and jump back to browse mode. Okay, we'll exit this layout. And there's a few things we can do now. We can start building security for our file, adding accounts and account privileges, determining who can access our file and what they can do in our file. We can host this with FileMakerServe and have people all around the control around the world accessing our file. Let's go ahead and throw it up on a FileMaker network and see what it looks like on our iOS device. So we'll do a file, sharing, FileMaker network. Okay, make sure it's sharing's on. All users selected for project tracking. That looks good. And what you're seeing me do right now is hosting this file with FileMakerPros peer-to-peer workgroup-like sharing capability. In your solution, you would be hosting this with a FileMaker server for added security and reliability. But for this demonstration, hosting with FileMaker Pro will be good. Okay, so now I'm going to launch my reflector app, which is gonna allow me to air play the iOS or iPad device they have in my hands right now. So I'm gonna take a minute to launch my FileMaker Go. And you should be able to see my screen in a second. Okay, perfect. So this is the iPad that I'm currently holding in my hands. And first thing I'm gonna do is tap on to FileMaker Go. All right. And up in the right corner, this icon right here with the magnifying glass, it's gonna search for all of the machine that are currently hosting FileMaker files in the local area network. And as you scroll down to the bottom, we'll see mine, run with MacBook Pro. So I'll tap on that. And there's our database, project tracking. Okay. Now on the bottom left, this button right here, I'm gonna tap on that and choose the iPad layout that we created. Okay. And within a few minutes, we have the start of a solution deployed over to our iOS device. So let's go ahead and add some, add a record. Okay. Add new record. And we'll call this the 2014 annual conference. Okay. Again, we're, we wanna track this event. And say this is plan and track our annual developer conference in December. Okay. Now for the status, let's see what we'll change with our formatting. So I'll tap on this and in progress. All right, perfect. Budget, let's say it's two million. Okay. And we have a nice dollar sign and thousand separator like we specified. The start date, we'll say we started planning for this back in April and we have this nice calendar rule like you would expect on the iOS device, right? And the due date, we'll say is December, so it's just around the corner. And notice down at the bottom, our days remaining calculation picked up how much time we have left. Okay. Well, notice one thing, the status field is a little bit short. It's cutting off for in progress. Let's go ahead and change that in FileMaker Pro. Go back to FileMaker Pro for a second. Jump back into layout mode. And let's drag these fields out for a little bit more real estate. Again, I'm just holding down the shift key and selecting these fields. And then let's drag out our title and description as well. Okay. Let's save those changes. Exit the layout. A little bit short. Let's do that again. All right, let's see what we're working with. I'll save these changes and go back to browse mode. There we go. Now let's jump back into our iOS device. Okay. And you'll notice that those changes are immediately made. So anyone accessing this file, again, all around the world, they're seeing that change. It's all automatic. Okay, let's keep building out. Let me just jump back into FileMaker Pro and I'll go back to layout mode and let's do a few things to really make the title and the days remaining fields pop out. What I'm gonna do is insert a merge field and essentially what this does is it grabs the value of a field and this is great for letters, contracts, things like that. I'm going to increase the font size. It's a little bit larger and I'm gonna add some, a text box to our layout called days remaining. Okay, just put that under here and I'll insert another merge field and I'm gonna grab the value from days remaining. Okay, just put that right underneath here. And since we have this value listed here, I'm gonna go ahead and remove this calculation field down at the bottom, all right? So let's say there's changes and take a look at our solution. Okay, great. Now we have a title, it really pops out when we're scrolling through records and we get a nice indication of how much time is remaining. Back on our iOS device, again, those changes are reflected immediately. So let's add some business logic to this. Let's say that if the time is less than 30 days, I wanna mark this as red, I want this to really pop out. And what we're gonna use is a feature called conditional formatting. So let's jump back into layout mode. I'm going to highlight my merge field. I'm going to control or right click on it and select conditional formatting. And I wanna add calculation that says if the days remaining is less than 30, okay, the value in the days remaining, a field is less than 30, let's make that a bright red and we'll bold as well. So a quick okay, save that layout and let's look at browse mode. And there we go, it really pops out that we have less than 30 days left. So we really have to make sure that we're hitting all of our tasks and milestones. Okay, so let's jump back into layout mode. And speaking of tasks and milestones, there's just two things that you guys really wanted to see tracked in the solution. So I'm going to bring out a tab control object. And this is essentially what it sounds like. It allows you to have tabs on your layout. And I'm gonna call one tab milestones and another tab tasks, okay. Now, we can create a milestone field, text field and enter the information in the milestone text field. But there's probably things about each milestone and each task that we want to really track and modify. So it will be a better practice if we create a separate milestone table on a separate task table and bring them into our solution. So let's go ahead and go to file, manage database back to our, manage database window and we'll add a new table called milestones, okay. And now we'll add some fields. And again, we want to make sure that we have a unique ID for each milestone. So I'll make that a number. And again, I want to make sure that anytime a new record is created, we get a unique value. And then I want to create a project ID field and this will help us associate the proper milestones with the proper projects, okay. And then a few things we want to track. How about again, the due date for a milestone, very important description, turns that to a text field and we want to know if we hit the milestone or not. All right, so let's go okay there. And now let's jump to the relationships tab. And essentially we want to associate a lot of milestones with a project and in order to create a relationship like that, it's really simple. We just need to find the common, the common fields, the common values between the two tables. And the missing there is the project ID. So I'm going to click and hold the project ID field from the projects table and just drag it over to the project ID field in the milestones table. And just like that we've created a relationship. So we're saying file maker, please find me all the records that where the project ID equals a project ID and allow me to share that data. So I'll click okay. Now, back in the lab, in order to share multiple related records, in this case multiple milestones to a singular project, we're going to use what's called a portal, okay. Again, this allows us to show multiple related records. So I'll draw that out to my layout and not asking where do you want to show related records from, where I'm going to show related records from milestones. I'll show a vertical scroll bar, click okay. Now what fields do you want to show them? Let's choose the due date, the description and the completion. We'll click okay. Now we have those fields populating up portal. Excellent. Let's just go ahead and format this a little bit. Okay, we'll move these fields around. Again, I'm just clicking and dragging these handles to resize. And now we'll add some labels. I'm going to use the text tool, save due date. And I can go back to the text tool again if I wanted to, to add another label, call this description. Well, I could hit the command D or control D on Windows and duplicate this object to save a little bit of time. And I'll call this completion. All right. Oh, let's jump back to save these changes and jump back to browse mode. Obviously, we don't have any records right now in our database, so nothing's going to show. So how do we add records from the milestone table into our project? Well, there's a few things we can do. First of all, you'll notice that actually we created a milestones table. If I jump back to my layouts, we have an associated milestone layout. Okay, so what we could do is essentially, one way is use buttons and scripts and variables to grab the appropriate project ID, jump to the milestones layout, create a new record, associate the proper project ID to this field, okay? And then jump back to the project's layout and to the appropriate project that we were working on. That's one way to do it. And it's actually a good, it's a good method, especially when if you have a portal and you want to fill out information, but you don't have enough real estate in the portal. But for this scenario, I want to add our records just directly within the portal, okay? And to do so, well, you can see right now that I click in the portal, I can't really do anything. Let's just jump back to the managed database window. I'm going to go to file, manage, database, okay? And I'm going to double click the relationship. I'm going to tell the file maker, hey, in the milestones table, allow me to create records in this table via this relationship. So click okay, click okay. And now we have active fields that we can enter information in. So let's jump back to layout mode for a second and let's format these fields kind of like we did with the project fields, okay? Stream running a bit for our user. So let's make the due date, a dropdown calendar, and we'll make the completion. If you would, let's also make this a pop-up menu and create a new value list. We'll call this completion and we'll say yes or in progress. Click okay, all right? Now let's save these changes and jump back to browse mode. Let's hop over back to our iOS device and let's enter some information on the milestones table. Okay, so you can see the changes were automatically added. So now I'm going to tap on to the due date field. Again, we get that nice scroll menu and we'll say that in the end of April, okay, one milestone that we want is budget approval for our next milestone. We want to make sure that at least by early May, we have dates approval. And let's add one more, let's say by, we want to make sure that all of the hotel confirmation is completed. We want to make sure that we have the right amount of room books and we know all of the guests who are going to be that we're going to be putting up in the hotel, okay? And in terms of completion field, we can just tap on that. All right, and we get that nice pop-up menu. Yes, all right. All right, let's jump back to SoundMaker Pro and let's keep building this out. I think we can make this a little bit more in terms of user interface, we can make it really stand out what the user has to do for the milestones or adding the milestones. So let's create a button that will automatically add a new record to the portal, okay? So I'm going to jump back into the out mode and first thing I'm going to do is create a script, okay? So go to scripts, manage scripts. Actually, first thing I'm going to do is name our portal and this will come into play in a minute. So I'm going to name the portal object milestone portal, okay? And now we'll go to our scripts, manage scripts and create a new script and I'll call this add milestone. And in the script window, what you're seeing is on the left, these are preset script steps in SoundMaker and what you would do is essentially you can drag a few script steps out into the main screen, okay? And you can use these in conjunction with calculations and essentially what's going to happen is that the scripts will fire off sequentially and they'll perform a task for you. So in this scenario, I actually want to use the go to object script step. I'm going to say go to the milestone portal object, all right, and go to the last portal row, okay? Each portal always has an empty portal row. And then go to the due date field from an out service table, okay? So let's save that script and now let's create a button on our layout so we can trigger that script. So up in the toolbar, I clicked on this button button icon, draw that button on our layout, select perform script, choose add milestone, okay? And now I'll give my button a name, okay? And I'll just add a little bit. All right, perfect. So let's save these changes, go back to browse mode and see if that works, okay? If I click on this in FileMaker Pro, all right, we get this nice drop down calendar, we'll say by, say October or September, early September, we want location confirmation. And yeah, we hit that, okay? Let's see if we get the same type of behavior in FileMaker Go, okay? See again, the add milestone button automatically there. I tap on that and I get this change. Say by November, 10th, we have finalized speaker list and we can say that is in progress. We can start so far. And really all we've done is just drag and drop a few things, edit the look of the fields by again dragging and dropping and clicking and pointing that type of stuff. So let's keep building. Let's add the task to our solution, okay? So let's go back to edit layout and we'll go back to File, Manage, Database and now we wanna add a tasks table. Okay, so click create there and let's add some fields again. We wanna make a unique ID for tasks, all right? And make sure again that each task is unique. We'll add a project ID field so we can associate all the tasks to the proper project, okay? And then a few things that we wanna track, like let's say we want an assets field and we'll make this a container field which allows us to store media like movies, sound files and images. So create that, let's add a description field, okay? Okay, we also wanna know the due date for the task and let's add a cost field, okay? Wanna know how much we're spending for each task and make sure that we're within budget, so create there. And we'll jump back to the relationships tab and again, we're just trying to find those common values between task and project, it's gonna be project ID and all we need to do is again click, hold the field, drag it to the field that you wanna create a relationship to and the next table, all right? And we have that relationship. And double click this relationship again and make sure that we have allow creation of records in this table view this relationship set so that we can add records in that portal. So click okay. Now let's jump to the tasks tab in layout mode and we'll draw a portal, okay? And this time you wanna choose records from tasks. I'll show a vocal scroll bar. I'm just gonna choose to show two rows and I'll use the ultimate background fill for this one. And we don't want the asset, description, the due date and the cost. So click okay. And since we have an image, I'm gonna make this a little bit larger. Let's fill it out here like this. Let's make the description a little bit longer as well, okay? We'll format the date field like we'd expect a dropdown calendar for the iOS. And again, for the cost, we'll make this a currency with a thousand separator. And then again, I'll add some labels. So create a text field or text box and call this assets here. And again, you could go back to the text box or I'm just gonna command D on Mac or control D on Windows to duplicate that object. Save some time. Description, due date and changes to, okay? And like we did with the milestones tab, let's make it easier for our users by creating a add task button. So we're gonna click on the portal and on the position tab, give it a name. We'll call this exportal. Okay, go back to the scripts menu and we'll create a new script called add tasks, okay? And again, we're gonna add some script steps that fire off sequentially to perform a task. And in this scenario, it's gonna jump us to the last row of the portal. So go to the object, task portal, go to the last portal and then go to the due date field from the task table. Okay, so we'll save that script. Again, up at the top in the toolbar and layout mode, we have this button icon. So I'll draw that onto our layout, choose to perform the add task script, click okay. We'll call this add tasks. Edit the size of this by dragging the handles again. Okay, so let's say these changes jump back to our browse mode and see what we're working with, all right? So go to the task tab, all right? We have a portal listed there and click add task, very good. That's working, we have this dropdown calendar and we'll say here in early August, we wanted to meet with the location manager about cost, all right? And we finalize the location. So let's go ahead and take an image from our desktop, okay? This is where we're gonna hold our conference, all right? Maybe the next task is contracts to our vendors, okay? And we'll say that this is due in September, okay? And again, we'll insert contracts just like that, okay? Well, what can you do with this portal on the iOS device? Well, let's jump back into our iOS device, all right? I'm gonna tap the task tab, okay? And let's click the, or tap the add task button and we'll say that October, I'm sorry, let's say October, this is the new task, let's say October, we'll say the end of October, we wanna meet with the awards designer, okay? Now, instead of, we could choose an image that we already have on the device, where we could use the device's camera to take a picture. So I'm gonna tap and hold onto that container field and you see the third option down is, I'm sorry, the first option is a camera. It's gonna choose the camera option, okay? And you can see exactly what we're looking at right now. So this is gonna be the design for the award. We're gonna click on that, or take this picture, all right? And we'll tap on the use button down at the bottom right, picture of that award in our task, pretty cool. Okay, so the final piece of this is the cost, all right? Let's associate some costs here. We wanna say that the cost to rent out this location, including food and things like that would be, I'm still in this record, 1.2 million, okay? If you wanna go with those awards, we're gonna see that'll be say 10 grand, okay? And we wanna essentially a total cost here for how much we're spending so that we can align that with the budget. So what I'm gonna do is let's just go back to the manage database window, file manage database, okay? And we'll make sure that we're looking at the fields on the tasks table. And I'm gonna create a field called total cost. I could create a calculation for this, but I'm gonna use this summary field type that we have. I'm gonna click create, and I'm gonna choose the total of the cost field. So I'll click okay, click okay. And let's jump back to layout mode, okay? And then the toolbar up here at the right, this is the field source, we can drag a field onto our layout. Actually, let's put this right here for a second. I wanna be on the task tab. So you can drag this field to our layout. And I'm gonna pull from the task table and the total cost, okay? Make sure this is properly aligned with the cost field at the top, okay? And let's format this as a currency. Get to the data tab, currency, use thousand separator. All right, so now when I save these changes and go to browse mode, go to the task tab. It looks like we have to make this a little bit larger. There we go. We have the total cost listed down at the bottom, and we can compare that to the budget. This is another may post where you would maybe want to add some conditional formatting. And you can even put it at the top here as a merge field to make it really stand out. So one thing that you saw as I was working through this field is I was getting a few messages saying, hey, someone's already working within this record. So, for example, if I'm in FileMaker Pro and I'm making these changes, let's say I wanna update the description, okay? And now we're going to jump to FileMaker Go. And I'm going to update the budget. We just heard from Finance, and they're giving us another $500,000. So let's tap into that field and make a change. Let's change here. Okay, so we're getting the message now that you cannot modify this record until the admin is finished with it, okay? If I use it, this should just be any user. It's just pulling off the name of my computer. So what you're seeing right now is automatic record locking. So if you're gonna have a lot of people accessing this solution through your iOS device, or through FileMaker Pro or through the web, you have this nice automatic security that's already pre-built in the FileMaker so that you're always gonna have one consolidated version of the truth. So let's click okay. Look at our iOS solution. And I think we'll stop there. I think we built a really good structure. About 40 minutes, we added projects, tasks, milestones. Again, all we really did is just add a few fields, drag and drop, resize a few fields as well. And that's really how easy it is to get started and start building your iOS solutions with FileMaker. So what I like to do now is kind of talk about some resources where you would want it to go next in terms of further developing in FileMaker. I'm gonna jump back into our keynote for a second, all right? One of the best places is the FileMaker Knowledge Base. I'm gonna reference a few Knowledge Base articles in a minute, but I wanna let you know you can access this at help.filemaker.com. And in the search field, you can enter some search terms. But it may be a little easier to just, if you have some Knowledge Base articles that you really like, you can capture the ID and just enter the ID in the search field and it will find the articles for you. Some people that we're kind of over what I went over today, relational database design, Knowledge Base article, 3247, working with portals, 5561, many, many to relationships. This is a really important feature in terms of creating many to many relationships. I highly recommend that you review this and kind of get comfortable with this idea. It's essential in terms of building in FileMaker. What you saw us do today is essential one to many relationships, one project with many milestones, one project to many tasks. If we built this out, many to many relationships, you may see, for example, a personnel table or an employee's table where you would have one employee could be associated with many tasks and a task could be associated with a team of employees. In order to build it out, we have a certain methodology using what we call a join table and this article 9922 goes over that, really important. And then planning scripts with FileMaker Pro 6151, this is really good in terms of how you want to kind of set the table with your scripts. Aside from that, there's a lot of great online material, vtc.com, lindy.com are great resources, they're video based, so you can watch features birthed out and the tutorials there. There's more FileMaker web seminars at www.FileMaker.com support webinars and for a list of other training resources, for the FileMaker.com, for slash support, for slash training, for a list of other things, including instructor-led training and other self-paced materials. Okay, so at this time I'd like to jump to the QA and we'll enter as many as we can time considering. Okay, so start off, when you use the camera, where do you save to? Do you go in the database, else run the computer, or is it only stored on that iOS device? This is a great question. So right now I'm accessing the iOS database that's currently hosted on my FileMaker Pro and FileMaker 12 introduced this great new feature called external storage. So you can sort of the container field where the images, the movies, sound files, they exist in a folder specified on your computer or the FileMaker server is actually a specified location for that, a folder for there. So that's essentially where it's stored when you take that photo. What happens to my layout on iPad when I rotate my device? Will it look the same? What a great question. So what we did is in this scenario we built out a layout for iOS on a landscape view. Really I just did that for a little bit more real estate for this demonstration. But there's two ways of tackling this. And the first way is creating an additional layout in portrait view, okay? And then using the function, I believe it's where I get window content, how you can get window content with and you would capture that. Essentially by having a script run an on-time script run about every second or two. So it's constantly checking to see, okay, what's the width and height of this particular of where the device is. Okay, it'll capture this in landscape or portrait. So for example, if it matches the content and I'm gonna say the height and the width to landscape mode is gonna jump and stay on that landscape layout. If it sees that the device content and width and height matches portrait mode it's gonna jump to the portrait layout. The second way is using anchors and let me jump into a Femmaker Pro database for a second. I'm gonna jump back to layout mode, okay? And let's go to inspector, okay? And these anchors, the way that you break this down and maybe the pathoscope of this webinar but essentially you would have kind of three parts to your layout. You would have kind of like one main section of your layout that would fit in both landscape and portrait mode. Then you have a second section that would only be revealed in landscape mode and the third section that would only be revealed in portrait mode. And depending on which media in landscape or portrait mode this section on the right of the layout, this section at the bottom of the layout is gonna be hidden, it's gonna be hidden underneath of the main layout using this anchoring, okay? There's more information online to kind of suss that out in terms of how to break that down but that's essentially like a high level way of how you would use it, okay? Can I use my database on my iPad when I'm not online? Great question. So with FileMakerGo, let me jump back into my iOS and launch this. Let me close out this database window, all right? On the left-hand side you'll see a file that exists or stored on this device, okay? So if you were in an area where the connection is poor, there's no network at all, what you can do is take a copy of your database, store it on your iOS device and the way you get your iOS devices through iTunes, email it to yourself or through a website, all right? And you can update the information there. Now, getting the information back to the host has varying levels of complexity. If you're gonna be creating new records that no one else is gonna edit, then you know, that's a straightforward, you can just import that information back into the main host file when you're back in the office or if you have an area within network connection. If you're gonna be updating records or creating records that other people need to update, okay? And may have created updates too while you're offline, then there's a level of complexity where there's some business logic required in terms of the import that you'd have to configure, like whose updates are you going to, or modifications are you gonna keep? Is it based on time? Is it based on, you know, administrator rights, that type of thing? There's also a great software program called MirrorSync by 360Works, one of our great developers, and that kind of automates that process for you. During these FoundMaker Pro Advanced to build databases for FoundMaker going, you actually saw me build in FoundMaker Pro Advanced, but if you wanna build databases, it could be either FoundMaker Pro or FoundMaker Pro Advanced. FoundMaker Pro Advanced is really just a super set of FoundMaker Pros. So you get additional tools that developers would use. I would highly recommend that if you are gonna develop it, you would wanna use a copy of FoundMaker Pro Advanced. The script debugger is, you know, it's really great. It allows you to step through your scripts, kind of see where the scripts break or not. Data Viewer makes sure that your calculations are, you know, you're getting the results that you want. And even things like custom menus, we can have a little bit more control for the users or how the users interact with the solution. Let's see. I think that'll be all the questions. You already answered how we get databases on the my iPad, iPhone, and can it be entered? FoundMaker, there's an updated FoundMaker on PC Mac. We answered that in terms of the networking question, networking offline. This has been a lot of fun. Again, FoundMaker, we're holding more idea to iPad webinars. Continue submitting your ideas. I hope you learned some great things here today. You can apply to your solution. On behalf of Ben Cotterall, it's been a pleasure and we'll see you soon.