Hello what hang on maverick hello everyone richard carlton here welcome to another day where my camera at the moment is not working but that's okay we are going to show you my nice pretty screen today it's kind of a different broadcast today we are broadcasting from santa clara i will fix my screen momentarily meanwhile we are going to welcome nick uh or from base elements it's very exciting to have nick here uh nick is an awesome guy he is basically the ceo and creator of goya and goya does all sorts of really cool tools they have a diagnostic application for the filemaker platform that works very very well with uh well basically all versions of filemaker and what it allows you to do is do some really amazing things like find references things like this uh rcc my team we buy this product we use it uh we desperately uh i desperately need products like this and so we invited him here today nick if
you want to meet yourself are you there hello hey nick is here yeah nick is here so what we've arranged for everyone to do today is we're gonna look at the base elements uh diagnostic tool or whatever he nick calls it because nick has two products that conveniently use the word base elements in the product name and so it always confuses it confuses everyone nick just so you understand we have a wide variety of people here today some of the people are very beginners and some of them are very advanced so it makes it always a challenge to try to include everyone but but why don't you take a swing at this today is going to be on the diagnostic tool the base elements the paid tool that i buy tomorrow is on the base almost plug-in which is another free thing so you guys i know how many people love free you know free free free free so yes all right well go ahead and start off what
is this tool and why do we care about it right so the the idea for base elements started with a solution i was working on once i wanted to find something in my filemaker database and as you know there's no nice little neat search within filemaker you can't search within a script or within a table or you know you can't find a place that you're using something in a calculation somewhere spread out over a thousand different layouts so filemaker at that point um and this is going back quite a while now you know version six and seven um so that old and filemaker has had since then and still has the ddr the database design report so you can run that yourself tools database design report and that generates xml and html if you've ever run that it's useful the html version pops up in a little browser and thing it can be really quite nice but it has a whole bunch of limitations one is
is again it's html and it's it's tricky but it also has things where it doesn't link between files so there's stuff that's just missing in it so it i wouldn't recommend you use that html report for anything other than sort of just quick glances of things so base elements was the end result of that and what i wanted was something that was a filemaker solution that i can search so this is an analysis i've done in in base elements so i've generated that uh database design report in xml and i've imported it into base elements and now i've got lists of everything that's in my solution there's 750 custom functions in this solution 108 uses of a plug-in there's 88 tables and that gives us 17 000 fields this is a really cool uh solution to demo based elements with because this is actually what happens when you give 100 staff all complete full access to do whatever they want in the database you know you say
that with a straight face right but that was a giant joke for anyone who waited a joke it's actually not a joke it's one of those like it's like a joke but it's not a joke because it's real life it's perfect oh yeah i i got invited to this client because they said oh look we've got some troubles with our filemaker database it's crashing a lot and i went oh jeans yeah yeah of course right so yeah so nick did you show them how they could i was behind my computer plugging stuff in the camera works now did you show them under tools how you kick out the that ddr did you show that at all or well i didn't step yeah just show them because some people have never heard of this so so if you so let me let me back up just a second so if you're open filemaker pro um and then you'll never see this tools menu unless you open filemaker and on
the mac you have to go to preferences right yep and he already knows where i'm going and you got to turn this on and then you have to quit and reopen filemaker then you get the tools menu which is like really it's worth its weight in gold it's really quite good and what happens is is that you uh you get this report that it can kick out and it kicks out this report and then base elements the product that you're gonna buy reads that report right makes sense and so the idea is that you read the report so you read it reads a report which is really great and then it kicks out this information and really you're looking for areas where there's problems or if you you're on a layout you don't know if it's used anymore a lot of times i just try to find abandoned stuff that no one's using and then i delete it right so so but yeah i didn't mean to intervene but
i got we got some bunny we call it bunny right so bunny is one of our watchers it's literally his name right there you're processing it right there and so what happens is we got some brand new people so the idea of bunny is that as you become more of a established filemaker developer you're going to run into situations where you're building and building and building and what nick is saying is that not only are you building but you've got a hundred other people building on this one file and building their own reports doing this and doing that and it creates a giant mess and so base elements is useful to clean up your own mess or if a hundred of your best friends or co-workers create a mess you can help clean it up there too so that's why this is so cool because otherwise you would never know this so go ahead nick yeah so this is this is what it generates when you do that save
step as xml you get these files obviously you're not generating base elements as a solution this would be all you all the different files in your solution so these would be the if you've got four files if you've only got one there'd only just be one and the summary is the thing that we import so when we click on import that asks you to select the file and you go away and input that and that brings it in and then once it's finished processing you end up on this screen and the idea behind both elements you can write a really simple solution that you can keep track of in your head you know one layout a couple of fields and a few calculations in a script but the moment it gets sort of beyond you know one or two layouts or you know a couple of different scripts you think okay well i've got to change something somewhere how do i go about doing that um and that's
when base elements really comes in so first of all you can think you know if this is the thing about base elements is i said at the start you want this to be a file making solution so for example i'm going to click here and this is going to take me to all 17 000 fields so this is a list of every field in my solution so when i've worked with massive data sets in filemaker i do lots of things where i take advantage of things like putting up new windows or keeping list views and then switching to a different layout things like that so if i want to search for different fields that are a different type i've got my list here i can just do command f for find and i can put in the text of what i want a thing this field has the word text in the name so i hit search oh yeah okay no worries there was one of these free text
ones so then i have a look at that costings 2006 and that's the field i'm after what is it it's just a standard number field normal it's not global where's it being used it's okay okay yeah you're you're you're going about 5 000 miles an hour this is the piece that i use right all the time this is the part i don't do a lot with it but i want to know if i'm on a layout if there's a button on the layout a field that's defined a relationship somewhere i want to know what calls that so if i delete it or i have to change it or something what might i break is the question right and so when you check out the reference by that's what's going on here it's a very very powerful it and a lot of times you get a little warning it says uh you have a warning for that if it's not being used it's like on the list somewhere nick
don't you have like a warning it says warning this isn't being used yeah yep let's see yeah it's also in the list view so yeah um when we switch to listview here this u box which you'll you'll learn as well unreferenced there's a has a check there to say this one is unused so this field here is text box three it's not used anywhere in this solution at all and um that can be that field can probably be deleted um that means it's not on any layouts it's not used in any scripts it doesn't appear in other calculations it's not in the you know privileged sets none of that sort of thing so none of these boxes where you took a talk about um i picked the wrong one there but none of these places here that things can be used that one exists so i'll jump back to the start because as well as being a filemaker file you probably i showed you this screen at
the start and i didn't really explain what it is so what's going on here is that we have once it figures out what's in your solution and we have all these counts and we can go and look within our solution and do what we want to do it also picks up places where there's errors such things that are broken in your solution so you created this layout with a whole bunch of fields on it and then you deleted one of the fields and now we've got errors in our layout objects so you can see exactly what these are again you click on these and we've got a script step that's doing set field but the field is missing tables missing it's gone yeah i've got another one here where we've got a calculation in a field in a table and the table's still there so the trust ledger from airbox copy is still there but the field that it's referencing is missing so we can see straight away
where there's things that are broken in my solution it's one of the things i love if i'm working on a solution that i really care about that i want to make sure it's it's good quality that everything works exactly as it should i make sure these numbers go down to zero yeah i look at what i'm doing what's going on here and i check to make sure things aren't uh are correct in them and they aren't making mistakes somewhere else so again have here this field has an error it's in the auto enter i can have a look at that and there's a lookup and there's a field missing in the lookup so i can go straight in and i can go hang on does that need to have a lookup and the lookup's a really quirky one that um and i don't know i think it might have changed recently but in previous versions of filemaker the the auto enter lookup uh dialog that pops up
when you set it if the field was missing it didn't use to display it so there were certain criteria you could get where you could have this error and you can't see it but it's actually missing a field there so either you've set something either you've intended it to be a lookup or perhaps it doesn't need to be a lookup obviously it's not doing the lookup now so it's not working so if you need it to do something then you need to actually go through and fix that and have a look at it so that there is can i uh can i uh inject here so real quick so so the strategy with this tool is like when we do the starting point we will periodically although i don't think we've done the last month or two but we'll periodically go through and do an errors analysis to find all the errors and what happens is that you are working in this file on screen and here and
then over here you'll be actually are on another computer with another monitor if you've seen me i have got computers left and right so i might have bass elements running on this computer and then on this computer i'm doing my development and this this that the other thing but you're you're going to make some edits you're going to make these changes then you're going to run your ddr again and you create another round and you re-import it again so if you go here back to the first screen somewhere you have like the versions of the of the solution nick where is that at when you look at that this one that i was looking at is is travel code okay i know exactly what you're saying there's a great example in here um so this is you know everything that i've imported there's different versions of different solutions so i do a lot of different imports to try and change things now if you have a look at
this one for example this e-strength player so i started with this version of the solution it has 10 000 items in it and 114 hours and i was doing a clean up on this solution yeah so i'm getting rid of things it was built by someone else it has a whole bunch of stuff in it that doesn't need to be there so that this is a uh it was a combined administrator and you end user file and what i wanted to do was turn it into just an end user file so i'm doing iterations of this and just stripping out all of that administration stuff because it doesn't need to be there so you can see over time this is from oldest here to newest here as i work through this count of elements i'm getting rid of stuff this countdown of elements goes down the count of errors goes down um these other ones which i didn't quite get to yet but these this green one is unreferenced
so things that aren't being used oh deleted okay green is unreferenced and what is what is orange what is that orange is uh warnings and and the purple ones are performance issues so i'll get to those as well but yeah you can see that history over time of this one evolving as i do things to it um other ones have different approaches so i i looked at this one this was a different version of that same file and what i did at the start was go through and clean up a bunch of things here and at some point between this one and this one i've broken another nine things so i'll give you an example here of how we can look at what that is so what i'm going to do i'm going to click on this one but i'm going to hold down the option key because when i click on on it and hold down option key that pops it up in a new window for me
so i can keep my background space we do that starting point two we do that too we do that too holding the option key it's a great thing we we check and modify or we pop a new window so these are my three errors before three errors in objects and you can see straight away just from the count i've set of something i've done in getting rid of one of these layouts i've gone from 62 to 46 has got rid of one of those errors but i've added 10 script step errors so i can look at those and go what have i done here aha go to layout unknown so i can say hang on i've deleted a layout that i shouldn't have perhaps so i can then have a look in this one and say well where is this this is a go to layout script step what's the script it's called script set flag position 94. okay so let's go into my old version remember this
is my old version still has all that in it so i can go into scripts and i can do a find and i can type set flag now this is going to find across all my solutions because of what i've got set up um if i jumped into this one for example i could look at step 94 i think i'll pick the right one if i pick if i could pick the right one out of that massive list of scripts uh his friends trainer pro trainer no i don't know which one it is i've got too many versions and there's a there's a quirk here in what i'm doing here so i'm doing this demo in the dev version um in the active user one it limits you to a single um solution at a time so if i'm in this e-strength chrono and i go and do a find it will show me just e-strength pro trainer when i do the fine so it doesn't use those privilege sets
to limit me to one solution at a time you can turn that off but it makes it really handy i need to focus just on this one solution so i could go in and find that step 94 and i could figure out which layout that is um i've deleted you know one of these probably what it is either go to layout phone summary i'll go to layout ipad something it'll be one of those and the issue with it you know which one is it i've deleted actually i was getting rid of these um ipad ones so the ipad ones are the admin ones that are going and so i've got this script step in here where i haven't cleaned it up which would be what that issue is so that's why i've added a couple errors no worries i can go in delete these particular script steps that i don't need and that error those ten areas will go out go away so i can use that to
find out exactly where the issues are that i've added in these extra 10 things i can now go find in my solution these are in our easter egg pro csc file these are the they're all script steps this is the name of the parent and this is the position and it prefixes these with script because you can have steps that are from menu items and you can have steps that are from what's the other one i don't even think where choose menu items and triggers and buttons sorry of course buttons on layouts so go back to our solution that we were looking at our test one travel code so i said before red is errors so those are things that you can go on uh fix clean up but green is things that are unreferent so for example out of those 17 000 fields there's nearly 3 000 of them that just aren't being used at all in this solution so some of these things
will be you know automatically created things you know every table gets one of those some globals here that aren't being used various bits and pieces so these almost certainly can be deleted michael gravel from montreal says you get all this information from the filemaker ddr question mark yes yep and we do it we do a lot of like post-processing as well so i'll show you a few more things and that we do in terms of post-processing as well at the end but essentially yep all of this comes from the ddr um and there's another question too and i'll i'll speak to that a bit later about the exit the new xml that filemaker's got so the other things these are warnings their warnings are things that are not necessarily errors but maybe things that you've done unintentionally so for example relationships is a great one so a warning on a relationship is something where you've got a mismatch in the field types so relationship joint
fields don't have the same field type now quite often that's intentional i don't know if everyone knows in filemaker you can put text on one side and any type of other field on layout could be a date field or a number field anything like that and then on this side of the relationship you can have a list of dates for example and then you can do a go to relationship and it will pick up all the related values that match the any one of those dates in the list so it can be something that's intentional but in this case something may be that you've got this set up that you're looking at this in a portal you just added the portal and all of a sudden you go to browse mode and there's no records showing you why is that what the hell is going on why aren't you know that the fields are right i've got my data right i'm not doing any filtering and it turns
out you've got a mismatch in the types so when the filemaker treats these two different types it treats them differently and things may not go quite right because you've got that mismatch in relationships in privileged sets for example here for warnings our alert here one or more fields are set to modifiable in the field acts restrictions but the privilege set does not allow create or edit so the field can't be modified so there's probably a reason there why you set that to be modifiable in other words you wanted the user to be able to modify it but the privilege set as a total doesn't actually let you do it so do you need to change the privilege set do you need to reconsider what's going on so those are these types of things that warnings are they're things that hey do you need to know about this is there's something going on in this solution here are you sure do you want to just double check that
you've got everything right and finally performance things so performance comes up a lot more lately it does come up in in themes and stuff but this solution being version 8. 5 that was another thing i didn't mention before this ddr was run out of filemaker 8. 5 and base elements 19 will import it just fine so even though this is 19 you don't need to be working in filemaker 19 to use base elements 19 as long as you can run uh filemaker 17 or later which is what baselines 19 requires you can run this and any ddr all the way back to v7 you can import but but but but but but nick there's a new xml import right and it's so shiny and pretty can't we use that so that's a great question yes the new xml so we know if you've seen this again this comes up save a copy as xml and this is what filemaker is internally using for some of their
new whiz-bang functionality in the latest versions of filemaker where you can have these add-ons and the add-ons are written in xml and there's this cool thing where they just take that xml and they basically slurp it into filemaker and it creates a whole bunch of things automatically for you script steps layout objects all sorts of bits and pieces and this new format xml which is different from the database design report is what they use for that however there's new format xml doesn't have everything we need to do the database design report and doesn't have anything everything we need so in a calculation for example if i jump into any particular one of these let's find one uh yeah okay so this uses two different items the two items are a custom function called mac and a custom function called win there's others if i could find one that was complicated i can't but this detail that comes out for example here variables custom function set
property the set property custom function variable there that detail isn't in the x in the new xml so this would be empty i could tell what the calculation is but i could not tell what's used in it so the idea and i've spoken to people at filemaker about this when they talk about this new xml format what they say is this is is new it's not yet a replacement for the ddr and they've got all these plans and obviously these plans are around these add-ons in the short term but at the moment it's not a replacement for ddr however i can see some really cool stuff that we could be doing with this as as this new xml format evolves because the new xml does a few things in terms of layouts it doesn't have any more detail it just gives every layout object its own unique uuid so that means that you can look at two different versions and just say this object move from here to
here at the moment i can't because i don't know whether you deleted an object and recreated one so in the future i could do things like hey take these two versions of your solution and do a diff on them which i can do now and i'll show you that as well but then i could take that gif produce an xml patch file and you could patch the old version and bring it up to the new version using the new xml structures so it doesn't actually matter what base element uses whether it's the ddr or the new xml or even a combination of the both what filemaker is doing with this new xml structure gives us a few opportunities but the new xml structure isn't quite there yet they've given us examples of the patch tool but it works for ads and deletes and not for modifications yet and there's no documentation about how to write your own xml so yeah that sort of stuff will come
yeah so so just to re-emphasize here so filemaker pro for a long time has been able to export this ddr report in an xml format so claris engineering has this new format of xml so there's really two kinds of xml that come out the new one is still i want to say very alpha e it's not even a really officially a shipping product they call it pre pre-release some pre-release products are pretty baked and good to go other pre-release products are undocumented and kind of sketchy this falls into the undocumented sketchy side of things um i'm glad claris is doing it i do receive emails from people going richard where's the training on this and i'm like here's the rule once again reminder on the training if it's not been documented by claris like officially like where they wrote instructions down we're not gonna put we're not gonna produce training on it because it's not official it's not final and and what nick is
saying is that they're gonna have to modify it to make it really awesome and nick nick kind of slid through this really fast if you're a very seasoned developer you caught what he was saying but like let me bunny eyes the conversation for you the idea with base elements and with this new xml coming out not available yet but maybe six months or a year whenever this happens is that you take an old version of your file you take a new version of your file and you do a comparison nick says really rapidly he talks he says diff really fast he's doing a comparison he's finding the difference between the two and it generates a a very specific list an xml list of the differences between the two if you knew the difference between the new one that you had you new application that you were shipping and the old one and you could compare the two and get the diff really quick you could build a
patch application right and then run that okay i'll yeah i'll bump in there and show you because um base elements does do reports one of the reports it does is a change report so let me see if i can find nothing so you call a change report here that's a diff a difference yeah okay yep so this is a change report um so these are for example before and afters um so this is and i've been you'll have to excuse me i've been fiddling and working with reports and changing a few bits and pieces here but this is old and new versions and i need to sort on this so i don't i don't have the right details showing but essentially these are changes green is new items um there's a summary option here it's not showing up in my dev version as i work on these things and these are things that have changed between two oh okay stop so so we're gonna we're gonna give you
a pass on that uh the current shipping product everyone is base elements 18. what is this up here it's a new super duper version so if you do buy his product and you get the annual release you're going to get this one for free as part of your annual subscription right remember we have that third off coupon right so i'm just helping he so he's over here actually testing and fixing things on the new version we're gonna get which is awesome so that's why this is happening so yeah these are these are things that are deleted in the solution and these are things that have changed so you can look at these and say okay what happened before this was the old value this is the new value and it's actually picking out different things that have altered between the different solutions so this base table for example changed for this particular field it changed from patient to telehealth booking so imagine you could take
all of these changes into your old version you know things that have been deleted things that have changed the relationship has changed on these particular things imagine you can change and you could create an automatic patch so you know solution where you work offline so my client has their solution it's up on their filemaker server they're working they're putting their data in it doing all their work you can you can be doing development offline and then you can say okay i need to know exactly what's different between my version where i've been developing in the clients version and then you could create your patch and say okay all my changes that i've been working on yep no right now push them to the new file so that's that's the potential of it the diff here is already the starting point so things were deleted things were changed all that sort of thing and this patch is the the hopeful future of what what they're doing with the
xml the beauty of this comes in also other situations like for example where you've got a client that's got their got full access to their solution and they come in and say to you you know this thing's broken you need to fix it why you know why is this thing breaking and then you've got you run the ddr and then you do a diff and then you say well actually someone else has gone in and changed this and deleted a field or modified a calculation and you can say this is why this is broken because you know this is what happened to it you know someone went and deleted something that they shouldn't have so in that sense here can be really really valuable there so that's that's the diff that's one of the reports that's in there so i said right at the start that this is a filemaker file so you can do things in it that you do in filemaker so a great example i was
doing a demo live at that point one time and asked if anyone had any questions and this i think was around the filemaker nine days because they'd introduce at that stage a new feature the quick find so all of a sudden people who just all they did was upgrade their filemaker pro from eight to nine suddenly had this quick find option in their toolbar and i'll demo that as well for you in a sec but they had that there and then all of a sudden they needed to know which fields on their layout had quick find turned on so how do you find that out they said if if i've got any unstored calculations on the layout that have got quick crime turned on they're going to be really slow so if i do if the user is searching across all these unfind fields unstored fields how do i that will be slow i don't want them to do that so how do i find all of those and
when you think about a filemaker file you can also think in terms of hierarchies you have a solution that has files files have tables the tables have fields and then the fields are used in places so you can follow that hierarchy so i can click here are 17 000 fields so this is my list of everything that's a field in this solution i can right click in this particular field and go constrain found set so now i've gone from seventeen thousand to five thousand so there are five thousand calculated fields in this layout now the storage isn't on the list view but it's in here store calculation results true so again i can go command f to find and pick false and then go request constrain found set so that is all the 3000 unstored calculation fields across this entire solution so then i can look at where they're used some of these aren't used in any layouts at all i can pick one that's used you know
on sorry referenced by i can pick one that's used on a on some lamp so this one for example is on four different layouts now my issue though is that i've got three thousand fields i can't click through all of these but i can go view as list for these and that will take me to if i hold that option a key option key that will take me to the list of just the four places that these exist on layouts but i have this other option if you know in uh let go to related records script step there's two up there's a couple of extra check boxes in there one is using this current record or one is go to related record using found set so there is the option as well as holding down option to do a new window you can hold down shift to do go to related record using found set so in other words what's that what that will do will take me
to all of the layout objects for all of the 3000 fields so i'm going to do that and click on it hit slow because there's a few but it'll only take a couple of seconds so in other words those 3 000 fields exist on 8 000 layout objects and again i want to see i don't want to see that i want to know which particular layouts they are so here's a here's the link that takes me back to this layout for that layout object and again i hold down shift and click on that and there's my list 844 layouts that have unstored calculations so it's both using that thing of hierarchy in filemaker knowing you know well fields have certain types fields exist on la on as layout objects and then the layout objects exist on layouts and as well as that using things that we know in filemaker you know putting up new windows you know controllers for fine constraining found set all those sorts
of things but i can then go okay these are all the layouts that i need to go through and adjust my constraint found adjust my quick find i wouldn't like to do that job 844 layouts but i could keep this list here i can work my way through i can i can mark things if i want i've got the ability to add notes so i can put details on these sorts of things um and this is a you know check box i can keep track of things and mark them as fixed if i like as well okay really handy we have a couple questions here and then we and the people are thanking you for getting uh getting up early in the morning they want to thank you scott on discord is asking does base elements have to be used on the local machine only no so it's just filemaker files so you can put that up on filemaker server and the advantage of running it on filemaker
server obviously you can have it shared and lots of people can access it but it also has an option to do the import server side so this one isn't so i can't show it to you but um the server side input means it just does a sort of basic processing of the xml xml and then stores them in container fields and then just goes away and starts working so you can be back in here and looking at things obviously not in a solution that's still importing but in your other solutions that you've got while the server using perform script on servers doing your data import for you yeah we've done training classes here on psaw so his uh his solution is is server aware and psas happy so it offloads because when you first do the the dump out of your system it's got to do the ddr export which is one thing but then it has to read it in the base almost has to read
in and then really chew it apart to make it useful and that chewing out i never wait more than five or ten minutes but i guess some people could have a really ugly solution it takes hours i guess how how how how long does it really take this is a yeah this is a really ugly solution that took 21 minutes um but if we have a look at some of these other ones that one i was uh talking about that i was sort of evolving different versions of that so in the most recent one of that is 11 seconds yeah yeah i think starting point takes that's a reasonable responsibility yeah starting point on a local machine takes maybe two or three four minutes whatever it's you know to get up and get a new refresh your diet coke or something and then you come back it's ready if um there's anything that you have in your solution that you want to ask it essentially you know find
all the container fields that are using uh open storage so um this particular one won't be useful because open storage didn't exist in in that version um but yeah so i could go into fields i could find let's have a look um let's have a look on the list and go data type is i think it's called a binary yep so there's binary fields here um if i can go jump towards the end here so purchase order and this is secure encryption so this is a secure thing so i could go constrain found set and so there's 42 fields here using secure secure external encryption on those container fields so you can do anything that you think about asking you know find all the script steps that are using a particular plugin anything that you can ask it it can tell you so details here that where it's using plugins for example um there's some troy file there's some um older ones
here fms auc it's i don't know what that is to a dialogue there's some mbs and some smtp so you can tell exactly which places those are being used these particular ones it's used on a layout object and in a script step so anything like that you know particular buttons that are using additional formatting places using tooltips for example and then you can find links to things so you can find all the button objects that are calling your particular scripts that are calling your particular script so if you're looking at that script you can then find all the button objects that do that find all the script steps that use a certain field all of those sorts of things and then beyond that as well just telling you about your solution based elements also sort of introduces a whole bunch of different things that are sort of even more like metadata so as well as these things like unreferenced and errors we have some other things in
here in terms of statistics for example this solution has these different functionalities turned on so shared clients so there are 523 accounts with shared clients but there's 82 accounts that have xml sharing turned on i don't reckon that client even knew they had xml sharing turned on or that they needed those 82 users to have that privilege enabled because i didn't think that i was surprised when i saw that because i don't think they knew that that was the thing that was happening so for example you know being able to jump in here and say um do we how many people have access to this in different ways the data api the php urls or web direct that can be really handy to be able to figure out what's going on in your solution there's some other stuff in here which files are my biggest which files are my biggest files so these costing files are the largest ones if i want to look at you
know some issues there um i can i could look at those particular files and see you know is there anything i can do there these are the tables that have the most records these are the script steps i use the most um and these are the most common areas that i'm picking up so i've got scripts missing all over the place that i need to then go in and look at so that's sort of almost a bit like meter data things about the solution so here as well you've got compatibility so this tells you everything that this particular script is compatible with because obviously a select windows step isn't compatible with server or custom web publishing for example as well as that here i'm looking at this script and i want to know what this perform script step does i hit my little plus button and it expands for me and shows me what's going on here so i can then look at and see the detail of this
within the one script i got a question is that is is that is that plus button in 18 or is that a 19 thing i missed okay i missed it i just haven't seen it sorry my bad yep and then finally i'm looking at this script and i go oh hang on i need some of this detail this is the script that i accidentally deleted out of my solution i can hit copy and now i've got a copy of this script on the clipboard and i can go into scriptmaker here and pick a script and then hit paste and paste this exact script back into my solution so anything in filemaker that you can copy and paste which is custom functions tables so an entire table with a list of fields and everything and all the calculations fields by themselves scripts individual script steps and i think every value list these days so they can be copied out of one filemaker solution and into another but
they can also be copied out of base elements and so i can take for example a bunch of a bunch of custom functions an individual custom function i can copy but if i wanted to copy those 754 custom functions i hit copy here i'm not going to do that because i don't need 754 of them on my clipboard but i could copy them and then paste them back into my solution so that's really handy you've got over time you build up this history of the things that you're doing in different versions of this solution i can then go back to an old one at some point here and go hang on oh i deleted something i really needed back here in this one so i can go to my previous version into that find the thing that i accidentally deleted copy it and paste it back in again so as well as being a really cool little you know process to do my day-to-day this is also a
really cool archive to be able to know what happened in my solution a long time ago so there's three little things i hope i distracted you there richard no it's absolutely great i love the feature there uh there's a various conversations going on scott says the copy script is a great feature of a way of borrow from another solution yeah absolutely okay nathan schneider says do you is there anything you can talk about the clip server explain about the clip server i'm not sure what he's talking about do you know what a clip server is so in here um we can keep you can keep track of of clips in your solution so if i copy um uh if i copy something i can paste so say i'm saying i'm in my solution it's a solution i haven't even put into base elements but i'm working in something and i copy something uh to the clipboard so it's a script for example um i can go
into base elements doesn't matter where i am and i can do paste xml to clips so as you can see i copied that script before so now i've got this clip here as xml that i can keep so i can and this this list of clips these local clips are things that i can keep so uh you know it might be a collection of custom functions that i use a lot or my starter template for a script you know i i lay out my scripts with certain script steps at the start so i can keep these here and this doesn't this is separate this clip manager is separate from all my solutions and it exists over time so even if i get a new version of base elements this clips server detail this clip history detail is kept in a preferences file so i've always got access to this no matter what i'm doing so this is a great way to store things that you use on a regular basis
or store things that you use for other things to be click server and there's a file you can download off the website that essentially says i want to be able to share these clips amongst myself and other people or keep a server-side copy of them so you can then put that clip server file up on filemaker server set an account and password and then that will keep these in sync whenever you come into the clip server part here so i can look at the i can for example across a large group of people have a shared access of click snippets whatever it happens to be that we share and use and these can be you can even pick out layout objects for example so um it will do a little um can you search clips someone asked if can you search clips search in clips can you search in clips yeah this is just a filemaker table so yeah command f for fine yeah you can search whatever
yeah tk says command f goofball he's one of the ones that's been triggering me so yeah no it's actually as when you get base elements i think i stumbled on this the other day it's actually unlocked is that a true statement kind of unlocked or really unlocked because you can like edit the layout or something yeah it's certainly you can edit the layout you can add your own scripts um this data file here has so everything that you get in in terms of the data it ends up in this data file and this is not i'm not doing special things here this is what you've got access these are all the things in here these are all the tables that we're using you can link to this data file from another file so you can reference the tables in this data file from outside of base elements if you want um and you can modify in the in the ue file you can modify layouts and do
whatever you want to do so yeah so i'll just i was just going to show there that when i copied that object which is a portal object from base elements and i paste it into my clip server it has a little jpeg preview as well because when you set the clipboard um it actually sets two different types one is all the xml so this is all the xml to generate that portal but also it does a little mini jpeg preview version of it so objects as well people love this so yeah they're saying they love the clip server the beauty of all that is that that tracks over time and we're using um people if i observe it may have noticed there's this fourth file here based on its press 19 which actually goes into your preferences folder um so we're using there's a feature that came about i think it was 16-ish where you can use a variable for a external data source so it doesn't have
to have in a fixed path so we're using that feature to put a little filemaker file in your prefs folder and that stores those clips um and also stores things like your um recents and and favorites as well so even if you keep different copies of base elements so what lots of people do is they have like one copy of base elements for each client or for each project that they're working on which is absolutely fine um or a new version comes out and you you know start from scratch you you know archive your history um it will remember the things that you've done recently so yeah there's lots of different things there you can track and it will know exactly what you're working in final comments for us nick orr no that's so good thank you very much for tuning in really appreciate it um you know i there's these developer tools you you do realize once you start using them you know you you
realize and not just mine there's other developer tools around but i like mine obviously um you realize how much that filemaker doesn't you know things that filemaker doesn't let you do just by the nature of the product and these developer tools make you a better developer i think so you should be using one you should go and find one that you like and use it it's about being able to in my opinion visually navigate to logical parts so you go to the file you find the layout and then you look for the references and how many other reference how many is that file layout being used anywhere oh no i can delete it so it's out of here that's what i use it for all the time yeah yeah absolutely yeah yeah so i use it in a very limited way there's obviously a nick is a much more established code coder than i am but i want to say thank you to him for coming and showing this
all right we're going to catch nick tomorrow appreciate everyone we'll catch you tomorrow thanks thanks bye so bye and the guys just stepped up the whole way calm cool collected the quarterback great read good patience more importantly great job up front protecting this quarterback to give you a chance and that's all you can ask for trying to rally down 10. 9 25 to go here in the fourth short motion by amendola from the left brady takes the shotgun step stands in throws it left ramadan reaches up and snaps a high throw and lands inside the tent with an eye slightly again he makes the ground
Daily Open Q&A with FileMaker Experts. Questions about Installation, Upgrading, Purchasing or How to make FileMaker work for you in your company to increase ROI.
Get up to speed with the FileMaker Video Training Course!
Top Rated Course by FileMaker Expert, Richard Carlton.
http://fmtraining.tv/fmpro19.php
Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 30 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions.
The course is 60 hours of video content! Transform your business with the FileMaker Platform
Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide.
Richard works closely with RCC's staff: a team of 30 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas.
Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration.
Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.
Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
2122 9th St., Suite 102
Los Osos, CA 93402
(805) 946-6552
FileMaker Pro is a simply powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
FileMaker 19 Video Training Course Introduction-FileMaker 19 News-Learn FileMaker From The Experts
FileMaker 19 New Release - Top 10 Need To Know Items in FileMaker 19 - FileMaker Top Ten News
https://youtube.com/watch?v=kRDXfpMrjvM
FileMaker Purchasing Options-FileMaker Training-Best Way To Purchase FileMaker 19-FileMaker 19 Video
https://www.youtube.com/watch?v=LlZqf_8N1Ho
https://www.youtube.com/watch?v=LlZqf_8N1Hou0026list=PLjTvUZtwtgBTCbN3Sr7yn6weIyIofDoMLu0026index=3
A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data
Video introduction to iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw
Free FileMaker videos check out ...http://www.filemakervideos.com
Download the FileMaker Pro and FileMaker GO for mobile devices training videos at http://www.fmtraining.tv
Download FileMaker Go video training at https://fmtraining.tv/fmgo19.php
Download FileMaker Full Video Training Bundle at https://fmtraining.tv/subscription.php
Learn how to use FileMaker to create an app with the FileMaker Training Series
Comment, Like and Share All of Our Videos.
Feel Free to Embed any of Our Videos on Your Blog or Website.
Follow Us on Your Favorite Social Media
https://www.facebook.com/FileMakerVideos
https://twitter.com/filemakervideos
Join us for live training on Twitch daily at 1pm Pacific
https://www.twitch.tv/fmtraining
https://www.youtube.com/user/FileMakerVideos
https://www.filemakervideos.com/
https://fmstartingpoint.com/downloadform3.php
Download FM Starting Point
https://filemakerfree.com/signup.html
FileMaker 17 manual For Novises kindle
https://rcconsulting.com/courses.html
https://www.guidetofilemaker.com/
Blogger sites
https://fmtrainingtv.blogspot.com/
WordPress sites
https://fmtrainingtv.wordpress.com/