joined by Sabrina UNESCO. Sabrina, first off, appreciate you joining me. How are you feeling? How's the angle? I'm good. Thank you for having me, but everything's going well just here in California and obviously enjoying time with my family and just rehabbing and getting back into things. What's been the toughest part of the rehab process? I mean there's a lot of tough, you know, parts of the rehab process. Definitely not being there with my team. Able to play is probably the hardest part and then of course just staying patient with an injury and kind of taking it day by day has been tough as well, but just been blessed to have great people around me and to start, you know, working out now and kind of getting back into my norm. I know you wanted to salvage as much of your rookie season as possible. What was that process like in terms of getting advice and finding the correct course of action for you? It was hard. I've never really had like a season ending injury and so it was hard and especially with the season that we had being shortened and in a bubble. I think there was a lot of things that we had to consider with trying to rush back to play for a season like that instead of, you know, taking time rehabbing and coming back hopefully next year for a more regular season. So there was a lot of, you know, things that I had to kind of sort through people that I had to talk to that weren't in the bubble and so it definitely took some time, but I'm just happy for kind of the advice that I was given in the steps that I had to take during this process. You know, in a normal year when the players injured, you can rehab, but still be on the bench and sharing on your teammates and observing and learning during games under these unprecedented circumstances. How difficult was it and what was it like trying to stay connected from afar? Yeah, it was different.  I was doing rehab every single day and, you know, trying to stay connected and so obviously was able to watch the games, was able to kind of give my input to the coaches and the players on what I saw. I was still in a lot of the team meetings, you know, they'd call me in over Zoom or whatever it was that they were doing, so I was definitely still able to stay connected, you know, under the circumstances of not being there. We know that it was unfortunately cut short, but what were your takeaways from a couple of games that you were able to play? Yeah, I mean, it was really fun and obviously it was a little bit different just with the preparation beforehand. You know, we were all in quarantine for four months and then had to go into this bubble and play games really fast and so obviously, you know, it wasn't ideal for anyone, but I think just going there and playing and even just getting a taste of what it's like to play in the best league was awesome and I love my team, I love the coaches, I love the ownership and everyone has treated me so great and so I'm just so happy to be returning next year and healthy and starting a new season. What are your plans for this offseason? There's still a little bit up in the air whether or not I'm going to go overseas or not, but as of now I'm kind of just taking it one day at a time and just getting healthy and training and rehabbing and really doing everything that I can control and so that's kind of been where my head's at right now obviously here in the Bay Area spending time with my family and definitely starting to work out again and starting to get into that routine that I normally have. You mentioned spending time with your family. When you're not rehabbing, what else is taking up your day? What is life like off the court for you? You know, I'm usually just at home, I'll watch TV, I'll do stuff, I'll do some business stuff, I'll read. Kind of most of my day is rehab and basketball and I'll see family here and there, but you know not really spending too much time with friends that I haven't spent time with just because I'm still trying to practice social distancing and kind of just abide by the rules that we have just so all of this could end and then we could go back to normal life, but I've definitely seen some friends here and they're gone out to dinner and just kind of laid low. Go back to your team, your New York Liberty teammates and from you watching from afar, you know, it's difficult season for sure. A lot of learning experiences for so many young players on that roster, what were you able to observe? What did you notice from your team? They fought, I mean obviously it was hard, you know, our whole team wasn't necessarily all there. I mean people were hurt, people had COVID, people came in late and there's just so many kind of weird things that had happened during the year and so I mean my hat's off to them for being able to stick it out in a bubble and just kind of fight through all the adversity that we had faced and you know they worked hard and they grew throughout the entire season. Obviously it was a difficult season but we just had, I think, seven ropegeys and a lot of the times they're before five on the court at one time and so I definitely think that's, you know, a testament to our coach for believing in us but also just kind of shows the growth of this team and where it can go. You talk about your perseverance and fighting through adversity, is there something that you learned about yourself over the course of these last handful of months? I think just really appreciating everything. I mean it can get taken away so easily and I think there was just so many expectations and so many goals and dreams, you know, during this first year and then a little injury like that I can take it all away and so I think just being very appreciative of everything that you're given, health, whatever it is and then obviously doing the most with that. I think during this offseason I'm definitely going to focus more on my body, my health, my nutrition and just everything that I can control to make sure that, you know, next season and moving forward through my career I'm in the best shape possible. You watch a lot of basketball, obviously you're entrenched in the game. Are there other sports that you watch and enjoy? Yeah, I watched tennis. I was watching tennis. Naomi Osaka was kind of the goat and so I was able to kind of form a relationship with her a little bit and so definitely watched her play and obviously watching football, kind of watching everything on TV now just because it's exciting that sports are returning and able to watch that. What's something you learned from another fellow fierce competitor like Naomi?  So many are looking forward to watching you compete for the Liberty next season. What are your expectations for the team when the next season does roll around? I mean definitely high expectations, you know, I think it's going to be really fun especially with, you know, having me having, you know, some games under my belt and the team having a season under the belt. I think we're going to come back a little bit more experience and kind of know what to expect. I think a lot of us came in, you know, this first year having no idea what the league was going to be like and straight out of college and then obviously not having a great preparation time during COVID and not knowing exactly, you know, what gyms we could get into if we could lift whatever. So I think this option that season is going to be huge and then I think, you know, whatever expectations we're going to set and goals we're going to set as a team is going to be a lot higher than it was last year. What's the best piece of advice you were, maybe not best, but one piece of advice that you were given in terms of staying patient through your own rehab process? Being where my feet are, I think that's what a lot of people have told me and just kind of take it one day at a time. You know, it's really easy to try and look off, you know, into the future and am I going to be ready? Am I going to get hurt again? You know, whatever the doubts that you might be thinking, but I think just kind of being present in the moment that I'm at and what I can do with today, whether it's rehab, whether it's rest, whether it's play basketball, I think that's really the best piece of advice that I've gotten right now. And something you love that's been taken away from you for a short period of time, but that said, how much hungrier does it make you, you know, as far as wanting to get back out there on the court and compete? I mean, I'm ready. I think a lot of people that know me know that and I'm definitely going to come back better than I was. And so I'm definitely excited, you know, for that. Obviously, misplaying have never missed, you know, that many games ever in my career. And so I'm just excited to come back out there better than I was and kind of try and prove myself in the league. What is your message for the New York fan base of it?  And I know that this is going to, you know, kind of turn around and it's going to be a great season. It's going to be a great team moving forward. So really excited for that, really excited to be a part of that and excited for you guys to be a part of that as well. Sabrina, thank you so much for your time. Yeah, thank you guys.


Kai Schefner, who is a Customer Success Manager at Lean IX. Kai is going to talk about cloud transformation, how to succeed when transforming your IT landscape. He's responsible for making the customer journey of modernization of their IT infrastructure with Lean IX successful. Great title, Customer Success Manager, Kai, I like that a lot. This presentation offers insights into major transformations of IT landscapes like cloud transformations, global ERP transformations, modernizing monoliths, et cetera, and shows how architects can help to drive transformation in budget, time, and quality. A warm virtual welcome from the open group to Kai Stehtner of Lean IX. Welcome, Kai. As you join us, I should say, thank you once again for Lean IX being our premier sponsor for this event. I appreciate it and won't take up any more of your time, Kai, and I'll see you for questions afterwards. I would like to present you now within the next 15 to 20 minutes, something about cloud transformation and how we think you can succeed when transforming your IT landscape. If you have any questions, please feel free to use the Q&A session or just send me an email. You can find my email on the last slide of my presentation. Okay, so let's get started. I would like to begin with some photos, and which shows quite nicely my opinion. Yeah, what's a huge transformation can be, and you can see on the left-hand side, the cockpit of the Apollo in 1970, and you can see on the right-hand side, the cockpit of the SpaceX Dragon Version 2 in 2020. So this might be a nice picture, what a transformation can be within 50 years. You could also apply this to software, and you could see on the left-hand side, some huge transformation in ERP systems. You can see the first version of the SAP software in the console, and you can see on the left-hand side in the bottom, like your proper UI of an ERP system. Same on the right-hand side, you can see like a normal server, and then on the bottom, you can see the cloud. So there's like huge transformations going on, as well in the software industry, but as well in other industries. But like 70% of these transformations fail, and why is that? That's why, because there's like missing preparation, when starting the transformation, there's also a lack of monitoring in the phase from ideation to implementation, and it happens quite often that there's light... You were in there one. There's light identification. ...drains and risks during the transformation. At the moment, there are like many transformations going on, so there's a high need to manage these transformations properly. And here you can see some examples for equations which are going on at the moment. For example, you want to migrate your on-premise world to the cloud, so you want to switch from your own data center to the cloud. As I said regarding ERP systems, you want to roll out global ERP systems. For example, you want to change to the new SAP S for HANA. You want to modernize your monolithic IT landscape, so you want to switch to a cloud-native world to microservices. Your organization is changing, so you want to merge business units or you want to carve out business units, or in terms of COVID, you have to change your entire operating model. So all these transformations are going on, and there's a high need to manage these transformations more right now. I would like to show you now in the next slides how VNIX as a tool can be leveraged to plan and execute your cloud transformation. So I focus on the use case of the cloud transformation. Just a short overview of our LinaX. We are a SaaS company for EA and cloud governance tooling. We have founded 2012 in Germany. At the moment, we do have more than 300 global customers. Approximately 250 employees globally are working for LinaX. We do have 120 million funding, for example, by Goldman Sachs. Gartner reviewed us as a visionary, and we have a really good way to take the Gartner peer insights. And what's really important to us is the usability. So we try to build our software that's really intuitive, and we do, like, every year now, buy 100%. Okay, let me explain to you why we think you need a proper EA tool to manage your complexity. Due to cloud transformation, complexity is really noisy. And this increased complexity and this increased required speed cannot be handled by Excel, Visio, or other modeling tools anymore. So you do have more processes, more applications, more technologies and companies. And there's a need for, like, an EA tool with a transparent overview of your whole IT landscape. And you can see here on the right-hand side our application landscape showing your whole IT infrastructure with a view on the life cycle of your applications. So is it like in plan, is it end of life? Large enterprises are already using LinaX, as for example, Adidas or Vosh, or even high-tech company as Dropbox and Lesson are using LinaX. And they're using it for, yeah, for fast and intuitive analyzers of your applications with regards to your business context and to leverage easy and fast decision-taking. So you don't need to, like, have, like, long plans, but you want to have, like, fast data-driven decisions based on your EA infrastructure. LinaX is also, for us, it's like a GitHub for a G-Rotner planning. As you know, GitHub is, like, one of the leading software versioning applications. And we think you can compare your assets, architecture to the main branch of GitHub, for example. And with LinaX, it's possible to also model and simulate plans of your existing active architecture. So for example, you could have the plan to migrate finance systems to the cloud, which would be, yeah, like, in the future, a different architecture. But there could be also scenarios for the plan. So you want to migrate finance systems to the cloud, but there could be the alternative if you, for example, buy the HR system workday or you just do it on your own. So it's like a make-or-build decision. And all these plans and the scenarios would have some impact on your current architecture. So you would, there's a need to model the impacts on this architecture. And there's a need, if you execute the plan or the alternate scenarios one or two, to execute these impacts. And this is possible using LinaX. So you can model and simulate and plan the scenarios. But then after executing these plans or these scenarios, you can, like in GitHub, you can merge some, you can merge the scenarios to the main branch. It's also possible to lose, to use workflows as a gyro to trigger the execution of the impacts. So it's possible that you can use some external workflow to trigger the execution and, yeah, to trigger the merge to the main branch. To sum this up, it's LinaX using, it's like GitHub and some sort of time machine. So it's a time machine, I mean, you have your SS. As you can see here, like you have your business capabilities and marketing, including Salesforce, your own CRM, Finance with S for HANA, SAP R3, and some HR system. But you can go and then you can go back and forth in the future and in the past. And you could say now, for example, this is the SS. But in Q4 2020, this SS would change. So depending on your scenarios, you can, for example, have now Salesforce marketing, you can have like another billing application within finance, but you can have a workday or HR system in the HR business capability. Okay. Getting back to the use case of cloud transformation. As you know, cloud transformation is happening. So it doesn't depend on the hyperscalers, AWS, Azure, GCP, the migration to the cloud is happening.  And if we talk about the cloud migration, there are, it's called the 6R, so six strategies of how to model your cloud migration. And the 6R would be in the rehosting. So you just lift and shift. So you just, yeah, take your on-premise world and shift the infrastructure to the cloud. You can re-platform as you lift your on-premise, you tinker a little bit, so you change, for example, the infrastructure, and then you shift it to cloud. You just re-purchase. So you move it to some, you move your on-premise world to some star solution. And refactoring, and this is, yeah, the best way for cloud native transformation. So you re-write your application code that is compatible for microservices. Or you can just retire your application or you retain, so you do nothing. So these are like the main migration strategies from on-premise to cloud. And after you have migrated to the cloud, you have to govern your cloud. And if you want to govern your cloud, we have experienced these clusters, which our customers discover at the moment or complain about. They do have like a missing visibility. For example, they're like hundreds of AWS accounts discovered that they didn't know about. Or they do have some uncontrolled cluster whisk. For example, they're using like some VMs or they bought some VMs, which they're not in use. So they have, for example, like 25K every month, which they shouldn't have to pay. Or they have slow response times because they just don't know the owner of the cloud account. So for example, there's like a ticket and they have to fix an issue. And it took them like five days to find the responsible for the specific microservice or the cloud account. And I want to show you now how you can use Linux for your end-to-end cloud transformation and your governance. So you can start to assess your cloud awareness. You can then plan, execute your migration. And then after the migration, you can establish your cloud governance. Now I want to jump now in every of these eight bullets in the following. Okay, so let's start with, let's start in the Lena eggs enterprise architecture suite and how you can prepare your migration. So first of all, you should build your image railway and collect your data, for example, through surveys. So you could conduct a survey for each of your applications. And then get your application owner, get the business criticality and get them equation strategy and considered here. I included in the survey, the business owner, the business criticality and the migration strategy. And you can do this for all of your application infrastructure within Linux. Second step would be to analyze my equation strategy by application. And after the survey, you can see here now, we do have some nice reporting where you can see the migration strategy of every application group by business capabilities, which you can see here. And then in the third step, you could also model your impacts. As I told you beforehand, so you can say, for example, for the migration strategy, we hosting, we do have the application LS law plus, we want to we host them to Azure. And we've, if we do this, that would impact our infrastructure, because we wouldn't need the, the HP application hosting anymore. But we would need Azure VM and Azure function, if we want to migrate them to the cloud. So we can model the or simulate the impact to migrate some some on premise components to the cloud. And we can do this for every application. So we can model for every fact sheet application impacts of a possible migration transformation. And now we want to plan and execute our equation. So we want to see the dependencies to other projects and epics. And then we could use our transformation world map. So we could see, depending on the initiatives on the project phases, how are they dependent on each other, how are they aligned. We can group them by business capability and objectives. You can see here the different work packages or transformation world map. Next step would be, you can now project or simulate the future state of your landscape. So you can select a possible scenario or transformation plan, for example, your scenario be cloud transformation. And then you can jump to a specific time stamp. For example, here's June 21. And you could see the changes in the heat map. You could also jump, for example, now to November 21 or 22. Or you could go back to the past. And then you would see nicely the changes of your heat map based on a specific transformation plan scenario. Okay, now it's step six. We have migrated to the clouds. And now we want to see, yeah, you want to see, you want to gather the clouds. So you want to have some KPIs for the clouds. And we could use our cloud network suite. We could get some nice KPIs on our use on a managed cloud infrastructure. So you could see the ratio of use type of scalars like the ratio of AWS, GCP, Azure. We could use our, we could see our use cloud components based on the business context. As we can see here, security storage. We could see our cloud spend over time. And we could also get warnings. For example, the security warnings for criticality or availability warnings for criticality. And then, so this is like our main dashboard. We could also jump into the details. So for example, we could jump into the AWS Lambda function and then get details on instance level technology life cycle, tax, hosted region, your business context, some classification or violations of this used IT component. So you can have both like a sort of management dashboard, but also jumping to the details of every cloud component. And then the last step would be to mitigate these issues in your architecture. So you can have a connection from the technical view of your cloud to the business view of your applications. In that case, I'm showing the application gain side. Gain side is using some AWS Lambda function. So some infrastructure as a service component. And you can see here by clicking on this icon, this is end of life. So there's a technology risk, which was identified based on automatically based on cloud native suite. And now we should try to set up some mitigation, because otherwise the usage and of the application gain side is at risk, because we're using some Lambda function, which is still using node JS, which is deprecated. Okay, to sum this up. We think that a successful transformation requires pragmatic planning and automatic tracking. So first step is you need a transparency on your assets. So it's, you need, yeah, it's really essential to start the transformation. You need transparency of your assets infrastructure. You should only model brings you added value. So don't model too much just model just enough to take good decisions. You also should apply aggregations and simplifications. So if you want to keep an overview about your use cloud providers, you have tons of details, but you should aggregate them. In for example, as I shown to you the dashboard to apply them and get a clear overview of what is needed to keep control of your cloud infrastructure. And you should focus on automation. So use integrations, use automation to track your technology, but also the impacts of your technology on your business and your coast on your security. Hopefully you're still around for for a quick question where we're sort of out of time, but Yes, I am. I can hear you, but I can't see you. Okay, that's good. That's a good start. So the question came in and talking about trans transitioning to the cloud, the process of transitioning. And I know you had some slides that showed some steps, but for me, the key part of the question is that how have you seen the process that with your customers take? How have you, how do they go about deciding what goes in the cloud and what doesn't? And normally, normally they, they first of all, they, they try to assess their components. So they try to set up a migration strategy. So as I said, like the six hours, so they set up a migration strategy, they assess for some using surveys of the technical fit and the business fit of the application. So first they want to assess like whether or not they want to invest in the application or not. If they want to invest in the clouds, they set up like a migration strategy. If it's like a long trip application. They want to like apply the equation strategy for and they V a ask the application owner about the it components of the application and the application owner says, yes, this this application could be suited to be to get my credit into the clouds or not. And depending on that decision, they can, for example, just lift and shift. They just just put like, they just shift to the cloud using some infrastructure service or they do like a total refactoring to the cloud native world, for example, like changing the application and infrastructure and setting up a micro service. So it's really depending on the in my opinion, depending on the assessment of the of the application owner and the entire migration strategy of the company. Thank you. Well, Kai, we're out of time. I know you've been answering it looks like you've been answering some questions in the. So if anyone else has any questions for Kai, then please do please do go through the channel in the meantime. Thank you once again to you personally for your for your presentation and to be nice for being our premier sponsors for this event. Thank you for your support. Thank you. Thank you.


What I've learned from 23 years of selling cars is the more you know the less you'll fear Selling cars is the best business in the world Most salespeople have had no training or outdated training at best you go into work like it's survival mode grinding and hustling just hoping to make a washout check Most salespeople walk through this business with their fingers crossed you don't have to do that anymore I can teach you to solve problems and not only solve them but solve them in one breath. I Want you to stop and realize what your future holds if you had the right training? I'm gonna show you the world of selling cars from a whole new perspective. I Want you to ask yourself one question Do you believe that you have the potential to make more money? Yes, or no if the answer is yes Partner with me Let me teach you everything that I know from today forward. You will never struggle financially with money This course will change your life and it will elevate you not only to the top of yourself work But maybe to one of the top-sell people in the country as long as you match it with hard work So what's the next step click on the link below and start training immediately? It's time to focus and think about nothing else But this one


Welcome, everyone. This is Phil Smith, Business Account Manager, a file maker, and I'm your host for today's Starter Solutions on Steroids Web Seminar, where you'll learn how to use and customize the great starter solutions that come with FileMaker. You'll also get to see a great free third party solution customized. Our guest speaker today is Richard Carlton, founder of RC Consulting, who will be doing part of today's demonstration. But first, I'd like to run through some technical information and housekeeping items with you. First, for best experience, we strongly recommend that you participate in the Web Seminar with a broadband connection. Also, you can attend FileMaker Web Seminars using GoToMeeting on iPad or iPhone. Just download the Citrix GoToMeeting client available on the App Store. If you have any problems or require online assistance at any time, please contact Citrix Technical Support at<PHONE_NUMBER>. Well, during today's presentation, you'll have an opportunity to type in questions. I'd like to review how to do that with you right now. Just go to the Control Panel on your GoToMeeting Control Panel, click on the questions section to reveal the area where you'd enter your question. Type it in and hit Send. We'll cover as many questions as time allows at the end of the presentation. Well, now before we get to the demo, I'd like to spend a few minutes reviewing the FileMaker product line with you. For those of you who are new, this is great new information, for those of you who maybe aren't new, it'll give you an opportunity to just review the five products that make up the FileMaker product line. First, on the left is FileMaker Pro. And FileMaker Pro is both the tool that you use to create new databases as you're going to see me doing, or use our great starter solutions. It's also the client to FileMaker Server. Well, FileMaker Pro advanced next to it is a superset of FileMaker Pro. It's everything that FileMaker Pro is, but adds some great utilities for developers. Now, you don't have to be a super developer to take advantage of some of these features. If you're just starting to write scripts and calculations, you'll be able to take advantage of features like the Script Debugger and DataViewer that you'll find quite useful. It also allows you to export database design reports so that you can evaluate and analyze your solutions and even create custom menu sets. Well, in the middle is FileMaker Server. And FileMaker Server is what I like to consider the hub of any good FileMaker deployment. It's where you can host your FileMaker files created with Pro in advanced to up to 250 concurrent users connecting with FileMaker Pro or FileMaker Yo on iOS. Server allows you to host up to 125 of these files. It also allows you to take advantage of FileMaker's external SQL source functionality connecting your FileMaker tables to Oracle, MySQL or Microsoft SQL Server data and even gives you the ability to take advantage of FileMaker's PHP API creating custom web publishing interfaces. FileMaker Server Advanced is a super set of FileMaker Server. It adds some great things like the ability to behave as an ODBC data source to other systems. FileMaker's instant web publishing capabilities and it removes that thousand user or that 250 user, excuse me, limit on the number of clients that you can have at any one time. And finally, on the right is FileMaker Go. We're really excited about FileMaker Go. And for version 12, it's a free download on the iTunes Store. You can go there right now and download it at no cost for your iPhone, iPad or iPod Touch. The cool thing about FileMaker Go is that all your existing FileMaker files including the starter solutions we're gonna experience today just work as they are on the iPad and iPhone. Now you can take those files on the device or you can use FileMaker Go to connect to served files from FileMaker Server or FileMaker Pro as you're gonna see me doing in just a moment. And today we're here to talk a little bit about FileMaker starter solutions. There are 16 of these solutions that come with every license of FileMaker Pro, Pro Advanced and even the trial download so that you can get in there and start being productive immediately. They're professionally designed and have layouts for both desktop and iPhone and iPad. There's a wide range of uses. So whether your business needs inventory tracking or an expense report database or just a way to track meetings and notes better, there's something there for you. They're easy to customize as you're gonna see in just a minute and fully relational. And if you're new to databases and that concept is new to you, you're gonna see some great exposition here of what it means so that you can grip what it means to your business. There's even some great examples of scripts and calculations that we'll get into. So in addition to the FileMaker starter solutions, there are some great third party resources out there. There are solutions built for your business on the FileMaker platform like Productive Computing's Core CRM or 360 Works Document for Document Management. And there's some really great frameworks and starter solutions from companies like Seed Code that makes a calendar that you can download for free and plug into your solutions and Seed Code complete for starting projects. And of course, we're here today to talk about Richard Carlton Consulting's FM starting point, which is a fully functional business solution that's free for you to download, use as is, or customize for your own needs. And now what I'd like to do is leave the slides here and get into FileMaker and start working with some of these starter solutions so that you can see just how quickly you can be productive. So here in the middle of my screen is FileMaker quick start screen. And this allows me to do everything related to creating databases over here. I can create a new blank database. I can convert an existing file, maybe an Excel spreadsheet or a tab delimited file. I can use one of our starter solutions, which we're obviously going to do here in a moment. In the middle of the screen is everything about my existing files. So I can go work with and automatically open and use solutions and files that I use on a regular basis. And on the right is everything about learning. So I've got some great video tutorials by going to the resource center that you see here. You've got access to videos, training, support community and other great things. Or I can start a hands on tutorial. And if I just click on that, you'll notice that I launch a PDF that allows me to start with some very basic exercises on using FileMaker, browsing, finding and sorting information. And then into creating databases and even writing scripts and calculations. It comes with example files. And again, the tutorial is available to you within the trial download that you've executed if you have as well. So let's get back to the starter solutions because that's why we're here. I'm going to click on start with a starter solution. And you see these 16 files. I have everything for tracking assets, which we're going to look at in a moment. Estimates, invoices, project management is a very common one for folks to use and start with. And I'm going to open this event management one because personally I use it myself. And I think it's a great example of what these starter solutions have to offer. So let's just take a quick look at that. You'll notice that I have an event-centric user interface here. So I can create a new event like Phil's demo, for instance. And then a venue, FileMaker Inc. Maybe pick the date, tomorrow, the description. We can type in an address, 5201 Patrick Henry Drive, which is where we're sitting right now. And when I tab out of that field, you'll notice that even without putting in the city and state information, FileMaker knows where I'm at and paints a map for me. That might be the first place for us to start. So let's go ahead and look at layout mode in FileMaker. Now in FileMaker, as you know, you're always working in one of four modes, preview, which we won't talk about right now. Layout, which is where I'm at now. And this is where I design my database. Add fields, create new tab objects, change colors and themes, and add these web viewers. Browse mode, where I'm interacting with my data. Adding new records, deleting records, moving between them, taking advantage of business automation, like running reports and so on. Now if I'm back in layout mode and I double click on that element down there that's a web viewer, you'll notice that all we're doing is creating a view into a Google map, whose URL is being populated by fields in our database, specifically the address, city, state, and postal code and country fields from our events table. Makes sense? That's a pretty nice way of bringing web data into your application. So you can imagine, in addition to maps, you might just use this for things like FedEx tracking numbers, company websites, people's LinkedIn profiles, all kinds of cool stuff that you can do with web viewers interacting with the data in your database. Well I've got this nice tab UI and I've got a couple of other things here. You'll notice that when I come up here to my layout dropdown, I have some options for desktop and iPad to look at events or contacts. Well this is great if it's my own application, but I might wanna share this with my colleagues and I'm gonna show you how easy that is to do right now. So FileMaker allows me to go to sharing, choose FileMaker Network and make this database or any others that I have open available to any or just some users on my network. Once I've done that, I might access this file with another computer outside my network or on my local network or in this case, on my iPad. So if I go search for local hosts, you'll see that I'm seeing a bunch of people hosting files here on our network at FileMaker. And if I, let's make sure I have that file hosted, gonna share it, turn on network sharing, and we'll click all users for that and click okay. I was on my customized version of it. So again, going back to my MacBook Pro now we'll see event management right there and I can click on that and you'll notice that not only is it open on my iPad and now I can see my Phil's demo event there, but I get a different view, one that's custom for the iPad. And if I drill in on that, you'll notice that again, I get a view that's customized for the look and feel and functionality that my iPad has to offer that's different than the layout here. So what's going on there? Well, this is the first point of customization that I think I'd like to talk to you about. All these starter solutions have scripts in them. And this one has some script triggers. Triggers are things that can by user interaction or by some event happening. I leave a field or a type of keystroke or in this case the first window of the database opens. They run a script. You can think of scripts as maybe macros on steroids, automation of any business process in my database. So here all we're doing is saying get the application version. And if it's an iPad go to the iPad layout if it's pro, go to the events layout. Otherwise it's going to be an iPhone. So go to the iPhone layout. So now we with one short script, I easily get a customized user interface for any device, whether it's a computer, an iPhone or an iPad. Now the other thing I want to point out here is if we go to manage database, I can take a look at all of my tables in this file. In this case I have six events, contacts, contributors, tasks, guests and agendas. I have fields within each one of those tables as you see here. And then I have relationships where I've got a one to many or a parent-child relationship going on between events as my main context view. Two contributors, tasks, guests, agendas and contacts. And this doesn't just enable me to see for instance my contributors or tasks associated with an event, but it also might give me the ability to look from contacts and see back through to the events that a given contact has attended, which I think is pretty cool. And it's all built in here and you can start to customize this however you want. Well, let's leave that. And in fact, I'm going to drop out of my events solution right now. You'll notice I can't close it because it wants to disconnect the iPad. Well, let's go ahead and pretend like we're actually in a scenario here where we're working. So I get this message on my iPad that says Phil Smith would like you to close the list of files as soon as possible. We'll click close now so that now a file maker can go ahead and close that file for me. We also manage record locking so that two people can't be trying to change the same record at the same time of course. Now, I'm going to open another starter solution. In this case, it's one that I've got some data in because I want to just point out a couple of other things, right? So I've got this espresso machine and I can see who it was purchased from, the purchase data and service data. I've got some calculations to manage depreciation. So if I have depreciation schedules that I want to run across the assets in my business, file maker can do that for me automatically. And I can even manage check in and check out functionality here. So if I'm a rental business or maybe I just loan things to people, I can track that and manage it easily. I've even got this digital signature here. Now, let's just take a look at that for a second. If I go to sharing again and under file maker network, make that assets data base available. And then back on my iPad, maybe I look for local hosts. Again, find my MacBook, open assets. And you'll notice that I can browse through these things. Maybe we'll pick a different asset like this lobby chair. Actually, you know what? Let's go back to the espresso machine since that's the one we're using. And you'll notice that I have a signature here, but I can click in there and replace it. It's a good point for me to talk a little bit about file maker container fields. You can store any kind of binary data in these container fields. It can be in this case a JPEG or it could be in the case of maybe on a law firm, I want to store contracts or I need to store contracts associated with projects or maybe I want to store signatures. So I can very easily come in and capture digital signatures so that folks can acknowledge that they've maybe signed some agreement or what have you. And we'll go ahead and turn this back. And now if I leave that record, you'll notice when I come back over here that the other signature has been replaced with mine. Well, now let's dig a little deeper into the customization part. I want to show you how you can do things like format this text with a color to show that it's overdue and a few other things. And by the way, we want to be able to get you to leverage your data, right? Because that's what this is all about. So let's close that file. I don't have it open on my iPad so now we should be able to, but you know, it's all right. We'll ask, there it goes, good. Now I want to use starter solution and this time I'm going to click invoices. We'll just save it on my desktop. Now this one's a little more complex. I have really three entities that I have to deal with here. I have customers, products and invoices. And the first thing I need to do is bring in some customer data. So I happen to have some and I'm going to show you how easy it is to bring your data into FileMaker from a spreadsheet in this case. Now this could be a tab or comma separated file. I'm just going to double click on this customer's link. And you'll see that I get this nice dialog box where I can map my fields and make sure that all the information that I have is going into the right place. And if something's not like country, I can just move that up. Maybe fax we want to make sure we have. And I've got website and everything looks pretty good. Excellent. So let's go ahead and not import the first record because I've used that for my field headers and we'll perform auto inter options. This might create unique IDs for me or maybe time and date stamp the records as they get created. And now I have 38, 39 records here for all my different customers that I deal with. You'll notice there's some great stuff here like I can click and go to a web view of that or I can automatically send an email to the contact from there. Watch this. If I click on this button, the FileMaker is going to go out and launch a web browser for that particular area. Great. So now what I want to do, in fact, you know what? Let's do this. Let's host that file so that we can get it on our iPad. I'm gonna say sharing and FileMaker network invoices for all users, click okay. And now on my iPad, let's just go ahead and launch FileMaker Go and get that open so that if we want to, we can use the iPad to create invoices and so on. So again, my MacBook and by the way, this is a good point to mention also, I'm using an iPad and a MacBook Pro here, but FileMaker also works just the same on Windows and it's completely cross-platform compatible. So I don't even know if I connect to a host out there, whether it's a Mac or a Windows machine. It just works, right? Great. So now I've got all these various customers. Now let's go look at, say, Action Auto there for a second. And you'll notice that if I click, the webpage will work there. But check this out. What I really want this to do, let's click there. Okay, just show me the map just like you see. And then I can say done when I'm finished. Now that I've got my customers, the next thing I need to produce an invoice is some products. So let's go look at the product detail view. And again, I have zero records here. So we're just going to go out and import some records again from another spreadsheet. In this case, my products spreadsheet. And I've got item category cost. I need to get the part number in the right place. So let's go ahead and find that. I need product ID up here. Part number goes there. And then I need price, which is right here. So once I have that, I can just verify that these things are all set up the way I want them, that they're all importing. And go ahead and import those records into my database. FileMaker instantly imports 418 records as you see here. And I can click through these and see them going by. All has a price. I have a reorder level here. My stock drops below a certain amount I know to reorder it. So now let's go to the third part of our solution here, which is invoices. You know, I may want to do a different workflow though. For instance, the context from where I get to an invoice might be a customer, right? I'm talking to a customer on the phone. Hey, let's create a new invoice, and there it is. And now you'll notice that when I click on these items, I get all of my products available to me. We'll pick something expensive like transmission, maybe an air filter, a few things like that. So I've started to generate an invoice. Now notice a couple of things here. The first one is that I've got this payment status which is unpaid and that's yellow. I want to show you how you can create these kind of what we call conditional formats. If I go into layout mode, I have this date due since. So if I wanted to, for instance, add a conditional format that said, you know, let's add a condition here where if the value of that field is greater than 30, let's turn the text color red. And in that way, call out that I have overdue invoices. Going back into browse mode, you'll notice it's not red because the invoice isn't due. But if we change the date of the invoice back 60 days, right, now 69 days is past due and my text turns red. So it's that easy to sort of show simple business rules on your screen and give people visual cues that a milestone's coming due or that an invoice needs to be paid or something like that. Now you can also, as I said, edit the calculations in FileMaker and make changes there that still leverage the hard work that's been done for you up front. You'll notice that I have a tax rate here that I can apply. Now this solution is set up right now such that I can type in a tax rate like 5%. You'll notice nothing happens. I'll explain that in a second. But I want to point out that what I would probably do if this were my solution is I would go out and get a tax table that had all the sales tax rates for all the municipalities in all the states and the United States and then maybe link them by zip code so that the tax rate would automatically be applied based upon the zip code my customer's in. Pretty easy to do. This is set up so that my tax will be affected only on my checked line items. Does that make sense? So that's the case where I might have some things that are taxable and some things that aren't. But let's assume that in my case, I'm the business that's selling only to end users only in my state and all the items I sell are taxable. So I want a different business rule. I want this to basically calculate my tax for the subtotal here. So let's go into defined database and take a look at how I might do that. In my invoices table here, I have lots of fields and one of them is tax amount and you'll notice that it's a calculation field that's getting those line items from up above and then multiplying them by the tax rate. But what I wanna do here is change this. Instead of from the invoices data table, I wanna go from the just invoices table, the one that I'm in here. And instead of multiplying the taxable amount by the tax rate, I wanna multiply the subtotal by the tax rate. So you can see that finally for calculations don't require any special programming. There's simple point and click, English language functions that you can use to do just about anything, text or numbers. So now that I've done that, let's go ahead and click okay. And you'll notice that now my tax rate is being applied to my entire subtotal. Maybe we'll get a more realistic tax rate for California like 9%, something like that. And you can start to see how we build this invoice out, do some custom work. Well before I shift it over to Rich, I wanna point out a couple of other things. I have some buttons here that run scripts to send an invoice by email or print the invoice. We'll print the invoice and you'll notice that it looks okay, but it's not customized in any way. Now I can customize any layout any way I want, but FileMakers don't have the trouble of giving you a nice little dashboard view of the company info here. So if I have for instance, a logo that I wanna use like this, I can simply drag it in and apply it to my invoice. I can click my text here and type in the name of my company and I can add anything I want in my header. In this case, I'm gonna make it my address. And once I have that, I might wanna do one more thing, which is add some data to my footer. Just some simple text like thanks for your business. Explanation point. I'll exit there and now watch what happens when I go find one of my invoices, like the one we created and click print invoice, right? Now I have a customized invoice with my logo, my address and down at the bottom, a little text that just says thanks for your business. So what I'd like to leave you with on these starter solutions is just the idea that again, there is a starter solution for just about anything you can imagine doing. And they're great places to start out and create your own business flow. There's also some great training resources to help you learn that we'll talk about it shortly. But now what I'd like to do is switch gears and show you one of the greatest starter solutions that's available for you out there that's not from FileMaker. I'd like to introduce you now to Richard Carlton from RC Consulting. RCC has been around for more than 20 years building great FileMaker solutions for customers of all sizes. They're a platinum level FileMaker business alliance member and they have more than 20 developers on staff, many of them certified. One of the great things about Richard's team and what they've done is to create FileMaker FM starting point, this is a great starter solution that's all ready for you to use. And Richard's gonna show it to you now as well as how it's been customized for a few of his customers. Richard. Hey, thanks Phil, I appreciate it. So welcome everyone. And we've already been getting good questions and I do appreciate that. And Phil, one of the questions I just wanted to, we've been asked a number of times already and I just wanna hit that up front before we even forget about it. As people have been asking about your starter solutions then the maximum number of records that we won't run out of a room in their computer, how many records can FileMaker support before it poops out? There's no practical limit. There's no practical limit. We've had that question a number of times. I just wanted to mention that that FileMaker can literally take millions of records. So before anyone wonders about that, we have databases that store literally millions of records. So it's normally just the limitation of the amount of space on your mobile device or of your hard drive. So Armature Carlton, we built a completely free starter solution that is by far the most popular starter solution on the internet. And the way we know that is we watched the metrics of people downloading it. It's been downloaded over 300,000 times. It is completely free. It's from this website here, FM Starting Point. It's in use by small businesses, medium businesses, even departments within large organizations, educational institutions, even nonprofits. It was originally created back in the day of FileMaker 10 but we rebuilt it specifically for FileMaker 12. And this is a website here where you can download it or end or watch the videos about it. What's neat about Starting Point is that you can use it and only use the pieces of it that you actually need for your business. So I'm gonna come over here and take a look at Starting Point here. This is the basic download that you get with Starting Point. We just actually updated the product and had a major bug release in the last week or so and it's got the latest features in it, all specific to FileMaker 12. So it supports a completely integrated model with the idea that you have a relational database where your contacts are talking to your invoices and you might have projects, some businesses call these jobs. It's an integrated business solution where the modules talk to each other. And so we built a solution that works equally well with Macs and Windows desktop computers but we also built matching screens that are completely supported on the iPad. So I'm gonna click over here and I'm gonna show you how that looks of course. And so this is my iPad screen here that you see in this window here. I'm gonna click over here and of course this works equally well on a regular iPad. I'm using the menu right here but you can use any iPad model that you like. And of course this is the screen here. And you'll notice that the screen magically looks nice. I'm gonna click over here and move this out of the way. And this app is set to be in the foreground. So I'm gonna click here and you can see the screens are set to mimic and match each other. Now you can see what we've done here is that in a desktop environment, the buttons are set to be optimized for a mouse and in the iPad or a touch environment, the buttons are larger to fit your finger, right? So we've optimized things for the mobile environment. So this is the basic download that you get for free obviously with FM Starting Point. Now if you have questions about FM Starting Point, you have questions about Star Solutions in general. What I'm going to recommend that you do is visit the page here where it says about the latest news. And this is our information here. And visit our email at support at rcconsulting.com. Email us your question about Starting Point. We get questions all the time. Can it barcode? Can it do this? Can it do that? Can it go to the moon? No, it doesn't go to the moon but it does a lot because FileMaker does a lot. We built this on the FileMaker platform and that makes it very powerful. Starting Point is a nice solution but what makes it awesome is FileMaker. So let's dive in a little bit more here and take a look at some customer solutions, real customer solutions that use Starting Point that make it work for their business. And it's really made a difference for their business. So the first one is this jewelry company. And they took Starting Point and did a lot of their work themselves and they only consulted with us just a little bit. And they really carved it up. They chopped out most of the solution. They only ended up using mostly the accounts modules, the invoices and the products and which is interesting here because they make custom jewelry. And if you click here, they make very customized pieces of jewelry and this is not fake data. They built these screens themselves. They chopped out the fields they didn't need which was interesting. And what we end up having right here are actually high resolution images that are specific to this customer. And so as you flip through the records here, these are new remote containers or containers with external storage. This is a new capability in FileMaker 12. Phil talked about this brief through a little bit that can store any sort of binary data. And this customer has literally 2,500 records of high resolution data. If I click open right here, you can take a look at this. It's actually on a server in a remote location and actually an Amazon data center. That's a high resolution image right there. There is over six gigs of high resolution images from the server and that's impressive. Some customers would have contracts, right? But this customer actually has photos of all their custom jewelry, which is interesting. That's how they manage it. And so in their invoices, they put photos of their products in invoices, the way they wanted it set up, very simple. So that was their way of creating a cost effective business solution that didn't cost them a bunch of money. In fact, given the fact that starting point was free and FileMaker Go was free, they started off with pretty cheap. Excellent. So anyway, free is always a popular thing with people. Like we find that out every day when we see the downloads, people, you know, 50 to 100 people a day downloading starting point and they're like, what was so popular about it? Oh, it was free. That's always a good answer. You know, the great thing about that is, I think that, you know, I don't know what the number is, but starting point probably represents, you know, in the hundreds of thousands of dollars of development effort, right, Richard? Oh, absolutely. And so, you know, the ability for a customer like that jewelry store to pick up this tool and then do some customization maybe themselves or even hire Richard's team to do it is saving them, you know, what, five figures, yeah? Oh, absolutely. I mean, you can't replace starting point easily for less than 30 or $40,000 on your own because you just can't because it comes automatically with these modules in it. Here's another customer right here. Here's the workflow for this customer. They are basically a past elimination company. When you call to say that you have too many icky spiders around your business and you want the spiders to go away, you call this company.  And so, the whole workflow is you call the company, the truck comes out, they spray, you're gonna sign the paperwork, they go away, you have to pay the bill. And so, this business model is one where there's a back office and in the front and then of course the delivery vehicles are actually going out on the road in the truck with an iPad. And lo and behold, they're also taking a printer with them and they're taking this specific printer here. This is a new model that's on the market that they're using in the trucks to good effect called the Pocket Jet, 73, it's from Brother. And it actually is designed to work with the iPad and FileMaker can print direct to this printer. And so, I figured I'd show this to everyone to know what they're printing. But it gives them a complete solution. So, a back office solution out to a work vehicle that's in the field, it could be a plumber, it could be some sort of medical service provider, it could even be servicing lots of machines in a Starbucks, right? It could be anywhere. It's kind of funny like that.  So, if I look here at the iPad, I'm gonna click on this screen right here and I'm gonna jump out of the basic copy of starting point. I'm gonna flip back over here. This is the actual screen that the pest control person's gonna see.  And then, of course, they have the signature of the person who's going to need to complete the work. Now, this is the same signature capability that those saw earlier, pretty slick. And then, of course, they can make a note of the conditions they found on site. Of course, it's FileMaker, why type everything up, FileMaker Smart. We can just pre-program it to make some notes for us automatically. Hey, that's cool. Let's make some notes. Yeah, okay, the situation's good overall. Excellent. And then, of course, all these notes show up in the database and the backend people who are doing the billing see all these notes. And so we get the service, we print the service report right there with the signature, the person on site gets the printed service report with their own signature. Hey, yes, this is your own signature. You agree to this? Plus, the people in the back office see the service report with the customer signature. There's no denying it, right? And so that helps the billing process because we didn't just manufacture this, we have a spot for their signature. We have a spot for service notes here, once again, the Power FileMaker, right? So all this was set up in starting point. And so it makes a nice interface. We make the buttons larger. It fits the touchscreen. It's all part of building a custom solution that works out in the field. It also works in the backend office. So these mobile devices are using 3G or 4G connections. And I think they have about a dozen vehicles to drive around. So you're talking about 12, 15 people that are accessing this database on a FileMaker server all at the same time, sharing this database. This database is six or seven gigabytes of information signatures to keep copies of contracts that are scanned in the solution. It's actually very powerful. So it makes for a good, robust solution. Hey, Richard, can I ask you just a quick question here? So you reminded me of something I was going to show you and didn't get to, which is when you dropped down into that one field on service notes, I think it was, I noticed you didn't have to type anything, right? There were some pre-populated values there. Can you talk for a minute about how you can edit those value lists in FileMaker Pro? Yeah, that's correct. These are all pre-popular lists. You can set these up in FileMaker pretty easily. In fact, actually we've got an option here turned on where we can edit these lists actually in FileMaker Go. You can allow, now see in some businesses you don't want your staff out in the field editing the list. It depends on how much you trust your field staff to edit these lists. But we can customize these lists right here. We can go in here and edit these, and I could add a new one. I don't want to mess with this right now, but you get the idea that you could pre-build the canned text in there.   I'm not a huge fan of the keyboards on these devices, especially if I'm on a hurry and I have a customer staring at me. You know, it's kind of goofy, right? I prefer sitting on a laptop, but pre-canned text, and you look like a million bucks and away you go, right? And so that's the whole idea with this. So these are what you call a pop-up list or pop-up menus, depending on which way you want to work with it. It's another type of data entry option in FileMaker. So in FileMaker you have text fields, but you can make them radio buttons where you can select a little round dot. You have checkboxes where you can select data that way, pop-up menus, pop-up lists, all sorts of options in FileMaker make it very, very powerful. Yeah, thanks very much. Excellent. So we've had a number of questions about this. So to be clear about this, FileMaker Go works on your iPhone, works on all the iPads from including the original iPad 1. The iPad 1, of course, doesn't have the camera and some of the cool stuff like that, but it does work on that. Of course, all the way through the iPad 2, 3, and I call it the iPad 4, but Apple calls it the new iPad. And that's FileMaker Go, which is completely free, FileMaker 12. And then of course, the solutions for Mac and Windows, desktop or laptop. Hey, Richard, can I, for a second, switch back to FileMaker Pro if you would. Sure. We'll take questions at the end, certainly, but as we go along here, don't move, don't go anywhere. Okay. Go back to that other solution you were just on there. Sure. There you go. So I noticed you have invoice syncing with QuickBooks there, and I'd like to just point out, first of all, in a situation like this, why someone might want to deploy an iPad and FileMaker out there is not just because it's kind of cool or whatever, but to do things like make their texts more efficient, faster, eliminate double data entry, and even decrease the billing cycle for customers, right? So as soon as someone completes a job and checks it off, FileMaker can send that invoice for you. And do you want to talk just briefly about the ability there to sync with QuickBooks? Yeah, absolutely. I mean, FileMaker does have the ability, especially on the Windows side of the things, to actually directly sync with QuickBooks. It's, you know, QuickBooks is a dedicated accounting package that is pre-built in it. Frankly, it's a specialized accounting package. And to rebuild that into FileMaker, it would take a lot of work. It's one of those things that you buy off the shelf and it works well, that's what QuickBooks is. And it's an established standard. So you can get a third-party product, a plugin, that effectively connects FileMaker to QuickBooks. And so that doesn't come standard in starting point and it doesn't really even come standard in FileMaker, but it is an option, it's like barcoding. Barcoding currently, you can print, you can install a font on your computer, for example, and you can print barcodes in FileMaker.  And you can zap barcodes into your laptop or desktop computer, even on a mobile device. You can hack hook up an app that will read barcodes. So there are what we call third-party integration options in FileMaker. So you can talk to QuickBooks. You can talk to barcode applications. You can do these cool types of things. You can actually even print to wireless printers in your mobile vehicle as you're traveling and making service calls. So there's lots of hooks to third-party things in FileMaker. And FileMaker's been really good about supporting these things. Excellent, thanks very much. One of the other things, real quick, I have a good demo here to show you real quick, is we have this one database here. I do show people this once in a while. This is a database that I click on and if it's gonna let me do this, there we go. And it's a database that's hosted on a network, not here, it's not a local database. It has 350,000 records. These are all imaginary, make-believe contact records. But it allows me to do searches and demonstrate the fact that it's a large dataset. It's not millions of records, but it's pretty easy to manipulate and do searches so I can do a search in FileMaker. Someone was also asking how to move in and out of the different modes in FileMaker. And you learn the keyboard shortcuts but I can do it manually. I can show you that we move browse mode, find mode and layout mode. Someone was asking about that earlier. You can do it, of course, from the view menu. From the view menu too, there's several actual ways of doing it and do it right there as well. And so I'm gonna go into find mode and I'm gonna put, say for example, CA. And so I'm doing a search and it was that fast against 350,000 records. It brought back 8,053 records. This is on a local, the database is running, well the database is on a FileMaker server up in the cloud, literally. And we're on a local client here. And so it sent the request up to FileMaker server 12. FileMaker server determined there were 8,053 records that matched CA. It's a wild card search, if you understand what that means. And so it found every record that had CA in the first letter. So CA, all these have a CA leading CA in here. And so FileMaker performs very rapidly. So once again, questions about oh, can it handle this? I mean, it's so gooey, it's so easy. It's not a serious tool. Yes, it's a very serious tool and it can handle tons of data, tons of images, tons of data, it's a very serious application. And so this makes a great tool for showing that as well. So what other questions we have? Well, just do me a favor and see, what if I wanted to find the people that began with CA there but I wanted to constrain it to only the folks that were saying, well let's pick Tennessee since that's where the current records from. Okay, and go ahead and constrain the found set. Yes, so go to Tennessee. We got out of there, there you go. So there's your found set of 853 records. We go into find mode. Okay, find mode, okay. And then just click in the state field. Okay, down to state. I wonder if there are any in Tennessee here. Well, there's at least one, we saw it. Okay. And then go ahead and just hit enter. Okay. Constrain found set. Yeah. And we have 101. So FileMaker allows you to extend or constrain your found set. So you can build your found set. Oh, I found CA's. Oh, I wanna find them in Texas. Oh, I wanna find the Texas ones that need a sales call so we can go and sell them new widgets because well, more sales are good for my business, right? It's very powerful. And then from here, we could print a print list and then we could actually direct mail these people. We could mail them individually right here. I could print a button and mail them. It could generate, so it's already spinning up a mail to send this person a mail if I want. I could do an email blast where it emails each one of them. Of course, you run the risk of being a spam person, so you gotta watch out for that. But there's a lot of power in FileMaker. And Richard, you're sending email from your client there, but FileMaker can also send email direct to an SMTP server, yeah. Yeah, it's a little bit of a geeky conversation, but yeah, FileMaker can actually send mail out of the app direct to a mail server. It's a machine that's on the internet and it can actually directly communicate with that. So in order to do that, you're gonna have to talk to your network administrator or the administrator of that mail server and get the technical login information for that server, which is gonna be a username and password and a couple of things like that. Once you have that, when you do a send mail command, you can send that information out and it's very slick. It skips sending it out through your local mail client. Excellent, thanks so much. So what other questions do we have from folks? Well, are you done with your demo now? Well, I can keep going in demoing, but I'm happy to answer questions as we run along. I mean, a lot of people ask about field sales and they ask, well, can I use this to do, for example, field service calls in the medical business and of course, the difference between a medical business and a pest control business and that type of thing. I understand in your mind that maybe it seems like a big difference between servicing medical devices and spraying bugs, but from FileMaker's perspective, it's not different at all because it's just data and contracts and images and things like that. And I know that's probably upsetting to someone, but the reality is, is that once you put an iPad into a service vehicle and put that on the road, sharing information, bar codes, printing, PDFs, all this kind of stuff, it's the same kinds of things. It's very powerful and starting point is a great starting place to build these solutions. And so once again, customers take the solution, they remove the elements they don't need and in fact, inside the application, I can show you briefly, we've done this, we'd like to do this. People will take and download starting points sometimes just to learn, it's a good learning tool about FileMaker. We try to make sure that it's well organized inside and it's very clean. So as we go into the app, we make sure that the layouts are numbered, they're very clean. We have a numbering sequence and a naming sequence. We have the iPad layouts in one area, we have a subset of iPhone layouts. iPhone's kind of hassle, from my perspective, I don't use the iPhone a lot in FileMaker just because the screens are so small. That is my personal preference. There are some screens in here for the iPhone, but boy, I really love the iPad and I use the iPad a lot. And so we've got good structure in here for that, same with scripts, but if you look at the way the database is designed relationally, we spent a lot of time making sure this was nice and clean. So of course we have the tables in here. If you don't know what table structure is and things like that, there's some great training videos out there from various companies, but in the relational diagram here, you're like, oh, what's this? This is a rather big thing. Well, we've got a lot of moving parts in FM starting point so I can reduce the size here and start to show you what it looks like overall. And what we've done is we've taken each of these modules here, the accounting module, invoices, products, things like that, and we've organized them together so it's kind of coherent. So instead of being a giant spider mess where each of these things would be wired together and if you've taken some solutions apart, you know what I'm talking about. This is actually very cleanly organized so it makes for a good place to get in here. You can zoom in. You can look at these relationships in here and say, oh, I wanna see that relationship right there and you can zoom in and see that and you say, oh, well, this is a relationship between projects and invoices because up here we got a project on one side, we got an invoice on the other side and we can see how we have these flags together. Oh, well, that's how an invoice connects to a project. And that's really what starting point's about is you get into it. Starting point, you'll see that we have a contact record but in the contact record, we can see the related invoices. We can see the related projects. We can see all this type of information and you say, well, you know, I don't really need those modules in our solution. Well, fine, then please get rid of it. I mean, that's the whole point. It's easier to destroy databases than it is to create them so I can go into layout mode, right? Say we don't really need projects. I'm gonna go into projects right here. I can delete the module, right? And then I can go back into browse mode. I'm gonna use a keyboard shortcut, command or control B, whoops. And I can go back into contacts and I say, well, I really don't need this tab right here. And this is called a tab. This is basically a tab object right here. So if I click on this section right here, this whole section right here, see that? Pretty slick stuff. If I double click it, it brings it up. So these are all the tab sections in here, right? And I can actually click in here and delete that tab. Whoop, do I wanna delete the tab? Are you really sure? Boom, it's gone. So we've removed, we're starting to customize and remove things. And then we go up here at the top and we remove that button too. So we start to customize starting point. We can change the name. Some, I meet customers sometimes and they say, well, we don't call them contacts. We only call them customers or people. And they're really insistent. They almost get in my face about it. And I say, you can call it anything you want. So the whole point is you can customize the solution to meet your needs. You can change the colors. If you don't like blue, make it red. FileMaker is super flexible. I highly recommend people who are using older versions of the product to upgrade to the latest version. It's got a lot of new capabilities in the product. If you're not on 12, you're missing out. We're specifically developing for the latest versions of FileMaker. And I highly recommend you that you get on the boat with that. So we get a lot of questions coming in about can FileMaker do X, Y, or Z. We got some more questions about barcode scanning and external device integration. We got some questions about audit trails and things like that. Generally, the answer to a question of can FileMaker X, Y, or Z is yes, it's just more a matter of how you want to go about that. So we'll give you some contact information here at the end of the seminar. In fact, maybe Richard will put that slide up now so that you can contact our Insight Sales team. And that's probably the easiest way to get to me and my team in the field as well if you want to talk about specific things. But I think maybe we'll take a few more questions here. Someone asked the question if the FileMaker files had to be on the device or if it could be connected to server. And I just wanted to be clear there. So we'll run through those options real quick. When you're using an iPad or an iPhone, you can take the FileMaker databases on your device or you can use it as a client to server. So what you saw me doing was connecting to FileMaker Pro serving a file earlier. What you saw Richard doing here was actually both. He showed one that was on the device, I believe, and he connected to a FileMaker server that was, was that in your office or in the Amazon? It was up in the Amazon, in the Amazon data center. So it's on a FileMaker server that's up in the Amazon data center. Right, so it doesn't matter. I guess it can be a Mac or a Windows server really makes no difference. And what you connect to it with can be a Mac or a Windows box or an iOS device from FileMaker Pro. Now, there's another use case which is sync. So if you want to sync your data files, there are techniques to do that. You might want to talk to a consultant about handling full transactional sync. But a lot of times all we're dealing with is data collection, right? I'm a botanist out in the field and I'm looking to track invasive species or something like that. I can get that data pushed up to my FileMaker server and my main file with a simple FileMaker script as you saw there. There are a couple of other questions that I'll go ahead and take here. We talked a little bit about QuickBooks sync and let's see here. I've got a whole list of the ones that have come in. So there was a question about how to get a field to autofill with a script or a calculation without having to click in the field box. And that sort of speaks to something that I touched on at the beginning, but it's worth noting. These scripts in FileMaker allow you to do anything in the database automatically, right? They're like sophisticated macros, but you can also trigger them by different events. So for instance, if I wanted to create an audit log of what people had done in the database, I could have a script run every time someone exited a field that wrote the values of the field previous to them changing it and the values after and then the timestamp of when that change was executed. And there are other ways too. So for instance, you can validate fields, right, Richard, so that you can force people to enter data and maybe only enter specific kinds of data. That's correct. Right here on screen, you can see a spot where you can actually click on a field and set script triggers against that field. So as people enter or exit a field or enter and exit a layout, you can actually cause little scripts or little macros as you were to execute, to check for things. It's very powerful. It's been in the product for a little while, but it's even better now in 12. I can't say enough about script triggers. This kind of carries through to another question we had, which is, can you set up a custom dialogue or message reminder when a task is passed to? And that's exactly how we do it, right? What we would do is have a script trigger run when a value in a field, let's say exceeded 30 days or anything like that. And then it can do anything. It might send an email to the person that the task is assigned to or it might just turn the value red or really whatever you want to do. So it's just a matter of thinking about what your workflows are and your planning. I think it's good to really pay attention to where the place is where you're being least efficient, right? Where are the things where you just feel like you're maybe spending too much time, effort, money? Absolutely. I mean, the whole idea is to find out where your pain points are in your organization, where you're spending nights and weekends working. If you're doing that and then letting FileMaker automate those processes to make your life much, much easier. It will do that. As a consultant, those are the best customer places for me to go to help the smile on their faces. I see when we solve a problem that says, oh, we used to spend 40 hours a week doing that and now it only takes two. And that happens. That happens, I kid you not. Yeah, excellent. So let's see here. A couple of other questions we can get. We addressed that one. One of the issues about audit log, I can address that real quick. There's no, by default, built-in audit log into FileMaker, but there is scriptable, especially with the script triggers. And if you want to get into starting point, we have built an audit log in the system around the product database. So if you see in here, there's an audit log right here. We've actually got one in here we built. So as people, we had issues with people saying, well, someone changed inventory here and they shouldn't change inventory number. We need to know who did that. And so you see one of my staff here, his name is Greg. Gregory Dips, he changed inventory from this to this. So if you want to see how an inventory system is kind of built, audit log is built, then you can see how we built it around an inventory control system here, right? So that's a good place to tear that apart if you'd like, because audit logs become more critical as you get into medical records. And there are doctor's offices and medical locations that do use FileMaker and HIPAA comes into play here. So it's very important for those of you who know what I'm talking about. Medical records are very secure and this DNA is to take that very seriously. So audit logs are important. Yeah, we had a couple of questions about security and we've only got a couple minutes here. So I'm going to take this last question. Can we please get the other slide back up on the screen so we can talk about resources while I'm doing that? So FileMaker has an account and role-based privilege set security model. So you can expose anything you want in the database to any user through their privilege set. It's respected across FileMaker ProGo and even web interfaces. So very granular and you can even integrate with Active Directory if you happen to have that in your infrastructure and want to leverage it. So with that, I'd like to let you know about a couple of resources here we have up on the screen. First of all, I'd encourage you to go download a trial of FileMaker Pro, FileMakerTrial.com if you haven't already. Please check out Richard's FM Starting Point at startingfmstartingpoint.com. You can reach our Insight sales team at<PHONE_NUMBER>. You can just type in your zipper area code and that'll get you to the appropriate representative and that's really the best way to get to me and my peers out in the field as well if you'd like us to have a discussion with you. Plus, know that licensing programs for FileMaker Volume Licensing Program started only five seats and as little as $95 a year for just five seats. So it's not expensive. You automatically get a year of free upgrades with that and I'd encourage you to all check that out. You see Richard's number and contact information there and finally I'd like to remind you that this as well as other FileMaker web seminars are archived at FileMaker.com slash support slash webinars. And with that, I'd like to thank Richard very much for his time today and I'd like to thank all of you for taking an hour out of your day to learn a little bit more about FileMaker and we'll look forward to working with you in the future.


Hey guys, another kind of interesting little shoutout here. Jade, Wei, and I are teaming up once again. A few people have requested something similar to this. Jade and I are going to do a team up and we are going to do a discussion video, but the discussion will be from you guys. She's putting out a video just like this as well. As well, we're also going to be putting comments, so I question polls in our community tabs about this. What do you guys want us to talk about about Supernatural, about the seasons, about the show, favorite episodes, the state of the show right now as is, our kind of thoughts on the actors and whatnot. Give us your questions. We're going to go through them, choose the best ones, and we're probably going to have a really, really damn long video to talk about it, which is why we will be splitting it. Most likely, if it runs as long as we think it will, I'm going to have one half. She's going to have the other half and we're just going to make the best of this. We're going to do a cool little community thing with this and we're interested to see what you guys have to say. So make sure to give us the questions or the discussion topics you would like us to talk about in the comment section below and we will be sure to look at the best ones and we'll see what goes from there. We're really excited about this. It's going to be a fun time. I've been looking forward to doing this for a little while. So make sure to leave your questions, our discussion topics below. Check out Jade's video because you might see some people who have a question that might bring up a question in your mind and then we will see where goes from there. Really looking forward to doing this. The editing will probably not be the funnest. This camera is going to have to go through a bit of a struggle. I'm going to have to sit.  Anyways guys, I hope you were looking forward to that video because we are as well and we look forward to seeing what you guys have to ask. Anyways, that's all from me guys. See you guys next time.


Tintin, need back up now! He may be outside of his jurisdiction, but that ain't gonna stop old Robo from being tough on crime. You are under arrest, dirtbag. I mean this dude is legend. Part man, part machine, all cop. You have the right to remain silent. And you have the right to bugger off. This is one police officer who doesn't need a partner. There hasn't been a crook yet who could outrun the arm of his law.  You are coming with me.


This is the real face of the US empire Someone uploaded one of those viral help identify this racist jerk clips featuring a man accosting a street vendor with awful Islamophobic vitriol and it turned out he was the former deputy director in the office of Israel and Palestinian affairs at the US State Department It sounds made up, but that's exactly what happened. Vice has a whole article out about it The video was uploaded today and within hours the man was identified as Stuart Seldowitz Who helped direct US diplomacy on Israel Palestine from 1999 to 2003 and then served on the Obama administration's National Security Council Stuart's identity was confirmed by his former employer Gotham government relations who released a statement Announcing him and saying they've ended all affiliation with him Seldowitz is seen hounding the New York City vendors in multiple different videos wearing multiple different outfits Showing a sustained campaign of harassment and abuse He told them while fully aware he was being filmed that Israel killing thousands of Palestinian kids wasn't enough Insulted their religion threatened them mocked their intelligence and their English called them terrorists and asked did you rape your daughter like? Mohammed did From the videos he appears to be harassing them for no reason other than because they are Muslims selling halal food That such a horrible person could climb his way to the highest echelons of the world's most powerful government Working on Palestinian affairs. No less illustrates an important point about the US Empire and what it is There are no barriers stopping such creatures from rising to the top of that power structure just the opposite in fact They get an express lane to the top That's why bloodthirsty swamp monsters like John Bolton Lindsey Graham Victoria Newland and Elliot Abrams find themselves so intimately involved with US policymaking That's the true face of the US Empire right there. That's the Empire at its most honest Not dressed up in affable charm and slick PR work But sneering and hurling racist invective at immigrants who are just trying to do their jobs in peace Not performing carefully rehearsed faces of compassion for the Palestinians who are being tragically unintentionally killed as collateral damage in Israel's war of defense against Hamas But staring straight into the camera and saying if we killed 4,000 Palestinian kids, you know what it wasn't enough Too many people look at Israel as something separate from the US Empire Seeing it as a small nation run by a historically mistreated ethnic group that everyone singles out and picks on unfairly If you look at Israel separately from the US centralized global power structure It feels off to have any forceful animosity toward Israel and its government because it feels like you're picking on the little guy It's only when you see clearly that Israel is just an arm of the same empire That's been murdering people by the millions around the world with non-stop invasions bombing campaigns proxy conflicts starvation sanctions and CIA coups that you begin to understand that yes Israel really is exactly as evil as it appears to be and its behavior in Gaza is exactly what it looks like The US Empire backs Israel for the same reason it backs most of the world's Dictatorships because a globe-spanning empire can only be held together by non-stop violence and tyranny Israel and other US aligned states in the Middle East are like the chair and the whip of a lion tamer weapons used to violently abuse the populations of a crucial geostrategic region into compliance it suits the empire Perfectly to having nuclear armed government which exists in a constant state of war in the Middle East governed by officials who speak English with American accents and interests which are reliably in alignment with those of the United States Stuart Seldowitz is not an aberration, but a perfect manifestation of all this This is the sort of mind which keeps the empire marching along from administration to administration no matter who Americans elect This is the sort of mind which keeps the weapons flowing the blood pouring the fossil fuels burning and The terrified screams which power the imperial machine continually erupting into the night sky