Best Practices Building FileMaker Solutions with Nick Hunter Day 1 - Claris FileMaker Solutions

the custody job, you know, like a table view and you know you're going to see, oh, I have the record that I need or I have the, you know, they did it, the updates, they did my script. update your IDs, did the reading, the new search worked, did my date change, is my data okay? Go to that layout properly and use that layout for the custodian for controller verification and things like that for debugging, like that for each table. will have in your solution, you need to have those layouts correct and to have those layouts, you need to have those tables correct, but it doesn't change the name, it doesn't because remember how the pharmacist works if I change the name of invoices right, if I change the name of Invoices automatically renamed the documents but it will automatically rename the invoices as well.

Normally you shouldn't have done that because or maybe because I duplicated it. Okay, no, normally you should have. rename, I don't know, okay, it doesn't matter, but you still don't want to break the link because if you name this, you rename this occurrence correctly and you rename the table that goes with the arguments right, you rename it that way it breaks, it won't change the name of this, so now you break it, so those tables also those tables those tables are virgin like sterile, right, they are excellent for importing excellent point Paul because most of the time You don't want things to happen when you import correctly, so you break, you break everything, you break all the links between that table and then you can import into that table without risking anything, so if you don't have any questions, I think. we can go, I will, I'll continue tomorrow because what's next, uh, I need more time, so I don't want to interrupt, oh, we have two more questions, these are good to answer the questions you want to ask, no, no, no, no, Alright. global creation id magic field question mark okay, budgie key, so you know it's simple, for example, I want to create, you know, I'll use it for that, sorry, I want to create from invoice.

United using the magic assassin so you have a global. Okay, so you can here. I'll use it as a link so we can say link, okay and you say uuid, okay, and that's a link, but it's also global, so sometimes a link can be global, sometimes it's No, I don't need that level of information. If I have questions, I go to manage the database and look because all my links and all my IDs are always at the top so they're easy to see. to retrieve, then I say, okay, Global, okay, so you know, I don't need to have or then put the right information, so this is a link or, at some point, you know you can use it like this, let's say Global uuid is if not. matter, either way, it works, you know, I have a habit of saying j u u i g uh, you know, guid, so you can use it, so you have guid in a table and in the receiving table you have uuid creation, but that's not globally, it is not like that. just uuid creation so, you know, this is going to be the key and this is going to be the receiving creation that we, you, are going to use for the creation, right creation, you can get here so you can get this in the creation, yeah, I know why because by definition if you do this it will never update properly so by the definitions you have to replace you have to delete this you have to delete this because when you create and when you create a new new record, I don't know.

If I have a yes, let's say, what is this? You know, yeah, so let's say we go to documents, okay, and we have a new record, so you create a record so that the automatic input calculation has been successful, so you don't have it anymore. when when you drive you have this and what uh that oh that because that file size or something like this yeah so um then you need it because if you don't if it's like that when CR because you create a record first and then insert the insert this right to create a record and then insert with which you cannot create at the same time as the institution's, so you need to make sure you want to delete it.

You already know. Automatic entry. You already know. don't replace otherwise when you drag this boom other questions um but if you forget something to put in those tables question mark when I forget I don't understand the question um yes, but if you forget something to put in those tables question mark I'm not totally sure of what you mean, Wally, yeah, no, but if you forget, go ahead and add it, you can add it, um, you can add whatever you want, like here, I want to please you, you know, I want to write down fields. believe it well and you are not full.

By the way, I don't understand the question. um, yeah, no, me neither, but other than that, I think we're fine, so tomorrow we'll continue the relationship. Okay, so you understand that the name is important, you understand that you know they don't charge you, you know, don't put complex names and things like that, right? We were all with underscores and things like that because it's illegible it's illegible especially in calculations uh it's not cool uh uh it breaks the label right, it doesn't, it's not necessary and you know it every time you need to write something types of underlining you know uh dash under write something underscore write something underscore okay for At the end of the day, the underscore key is going to break on your keyboard, so, um, so you don't want to, you don't want to put symbols and whatever you know, something like just you can understand, uh, no.

I don't use uh you know uh like I I sometimes you know one day I saw I saw a table like this I said okay um you know the table was um you know uh bill item that was the table name right and then you had uh here uh you have a um IDP and then you have a first name you have a last name and you have or uh amounts and you or always like that everything was like that you know address address and city and city and country you know um so so it was all abbreviations, right, and sometimes sometimes they use crazy things like this, you know, like, I don't know, a project would be PGT and, and, and, this will be, you know, an account like this and then we have all.

I know you know, uh e and v e, okay, everything would be like this, I'm doing like this, okay, and then it's so complex that you have something like this and the guy said, okay, you know, he put the captions in, you know, and the equal EnV invoices. So can you imagine? You know, I know you saw that and I know sometimes I know some of you are doing this right, so this is an abomination because we don't need it anymore, that's what I want to prove, we don't need it anymore. why because now we have this now we have we have this we have the finished you know we have the writing like that at the time of uh Final Cut 11 I will understand that I would understand why the advantage but now not absolutely on the contrary, on the contrary, that is killing you because no you can use the beauty of this right, you understand, that said, we can lend boats, we are fine, thank you very much Nick, okay, same time tomorrow, same house, thank you very much.

Same place, same time, same place, thanks Nick, thanks, bye five, all night, foreigner, look at the back of that car, right there it looks like the FileMaker license has expired, sir. I need you to exit the video, sir, exit the vehicle, sir.