I used FM years ago and loved it but I walked away because it was too difficult to go online. Now I'm back and boy has it changed. your videos are helping refresh my memory and learn new functionality. Thank you!
One clarification that stumped me for a bit, the calculated field (for the first/last name combination) has to be in the same table as the fields that you want to combine and track. As far as I can tell, it also must be a Text type for the search function to work. Great tutorials, by the way. Have saved me multiple times.
I have learned more from Guy's videos than from any book I've read on FileMaker Pro. His videos are definitely worth the time. It usually takes me five times as long to get through the video because I have my database open at the same time and I continually pause and rewind to make additions and changes to my own files. If I could give him 5 stars I would! Thanks for all the help!!
Thank you very much for sharing your knowledge in a digestible way for a beginning scripter. I've used FileMaker for many years but have always been intimidated by scripts - this was super helpful.
Hi Guy, great videos - especially for newbies like me. How do you set up the layout so all the fields show in white against the grey background. When I setup a new layout (even using your template), all the names are intertwined on the same grey background even if I try to set the field color to white? Your layout style looks much more pleasing to the eye. Thanks
Hi Guy thank you very much for your video. I have a question pls. as the field c_Full Name being a calculated field, the replace field under records is greyd out? Thank you in advance.
Hi, Thanks for your find data videos but I am stuck on a find problem. I have a file showing certain payment types which are situated in a drop down choice option. How can a find and list of a specific drop down choice option and list the content? Hope that makes sense.
As usual, in his explanations, a lot of nagging problems are clarified. For example, I understand what a global field is, but have never quite understood how to use one (in this along not just one but various users to perform finds). Incidentally, his presentations are such that I feel in contact with, as we say in Italian, a "simpaticone": a very pleasant "guy" (pun intended).
there are many good Italian filemaker fans but nobody is so unselfish to share experiences on youtube "gratis et amore dei" ... only if you pay..ah..ah..ah..The only Italian book you find ? Filemaker 9!
Actually, I have a fat Filemaker book that refers to FMPro 12. I think it's an official one, and is quite good. I'm also using the FM ebook in English. There can be a problem with function name translations using the English-language ebooks, when the Italian equivalent is not intuitive. In many cases, however, if I have a bit of a problem finding the Italian name for a function, I put the English name in the formula and by some magic, when I return to my handiwork, it has been translated into Italian for me. (I have Filemaker Bonsai files with functions in the Italian version, too).
Hi Guy, I love your videos. i just have a question regarding this example. I find it is habit for most people to just hit the Enter key to search after typing in a search/find box rather than click a "find" button with the mouse. If someone does this in your example, we get a carriage return to another line in your field and no search is performed (as expected). Is there any way to perform the search on the enter key being hit? or at least to disable the carriage return?
Hi Christopher, The easiest method is to make sure that in the tab order your button is followed by the find field. That way you can tab out of the find field and you will arrive on your find button, because it is the next object in the tab order. Then you can use the spacebar or the return key to push the button and run the script. If you want to capture the return key on the layout you could use the script trigger "OnObjectKeystroke" to capture a specific keystroke and run a script if that keystroke is pushed. You could use a script like this: If [ Code ( Get(TriggerKeystroke) ) = 13 ] Perform Script [ Find Script ] End If
Thank you for your videos. I have question. I am creating an invoice form. I need to copy the bill to info to ship to if I select a radio button. Can you help?
Hi Jacinto, I guess you could use different ways to go about doing this. This can be done in complex and in simple ways. I prefer the simplest ways because I'm lazy. :) Look here for a video explanation: ua-cam.com/video/BWafO-Dhahw/v-deo.html Greetings Guy
Performing a find and a sort can be done trough a script. This script needs to be performed. You can do this by clicking a button that starts the script. Or you can place a script trigger on a field. This script trigger will then perform the script. The script trigger can be placed on different events. Like when you enter a field, when you make a change in the field or when you exit a field. In your case you could put the script on the "OnObjectModify" script trigger event of the dropdown. Then when you choose a value in the dropdown the script will be performed. Your script will need to: - Commit record - Enter find mode (Uncheck Pause) - Set Field (With the value from the dropdown) - Perform Find - Sort records It's possible you might need to set your dropdown field to be a global field. Otherwise the value in it might not be visible while in find mode. Because you might be on a different record. This can be done in the script settings. In the tab "Storage". Greetings Guy
@@GuyStevens0 Thank you so much Guy for your quick reply. I'm not sure what I am doing wrong. Perhaps the Set Field - what do you mean (with the value from the dropdown)? I have several different values, so not too sure what you mean. Also, I have tried creating a new global field, maybe this is where I am going wrong?? If I understand correctly, I do not want to change my field to global, as it will modify the data in each record, right?
Thank You Guy! I have spent so much time with you through your excellent training videos. It is slow going but because I can review sections until I can get the examples too work, the time spent is worth it. I have been working on a audit of a rental property that I own. I need to present the payment history in a way that will be easy for my attorney, myself, and a Judge to understand. Using summery fields has the advantage of presenting payments in a way that the math will be quickly looked at and understood. I am not a math person. My presentation must look simple, and easily understandable. I have been working on this project for months and now I am spending several hours daily following your video's. thank you so much. Also I am using FMP 11. I feel it might be easier to follow your videos if I had a newer version. Should I try to buy find a version between 12 & 16 on amazon or ebay?
Thanks for your message. Fmp11 is really outdated. You would be better off upgrading to Filemaker Pro 18. Then it would be easier to follow the instruction videos. Greetings Guy
Hi Bob, I'm not entirely following what you mean. The content of a field, even if the field is a dropdown, is still simply a value. You can perform a find on a field to find any of the values from the dropdown. Greetings Guy
Hi Guy! Very helpful as always. I am trying to count the amount of words in a specific field from all the records in a table, but only one record is being counted even though the Show All Record script step is included in the script. Any suggestions?
Hi Andre, You can use the "WordCount" function to count all the words in a field. This results in a number. Then you can create a summary field that summarizes the number field with the amount. This will give you the total amount for all the records in the found set. Greetings Guy
Should I create a loop that checks every record in the table? Right now, the way the word amount in the field is counted is by me selecting a record from a portal, then let the count script run.
@@AndreasvanHaren Hi Andre, There is no need for a script, no need for a loop. Let's say you have a table called "Table" And in there you have a text field called "Text". You want to count the amount of words in the field "Text". In this table you simply create a new calculation field called "AmountOfWords". The calculation you use in this field is the "WordCount" function. It goes like this: WordCount ( Table::Text ) This calculation field will give you the amount of words in the text field as a number. Every time you change the text in the text field the amount of words will be updated once you exit the field. Then you want to total the amount of words for the records you are browsing. Create a new Summary field that gives you the total of "AmountOfWords". This will add up all of the "AmountOfWords" fields of the records that are in your found set. Like this: www.dropbox.com/s/24rmyem43zspq81/WordCount.fmp12?dl=1 Greetings Guy
Hi Guy, thanks for helping. I still get the same results though, only the single record word amount from the text field is shown. Some more details are maybe helping here: The layout is based on the Story-table. The text field on this layout is from the Chapter-table. There is a portal on this layout that connects a chosen story with a record in the Chapter-table. I think this is probably a little too complicated to discus on UA-cam, I will bring the question to the Filemaker forum where I can also post screenshots. Best wishes André @@GuyStevens0
@@AndreasvanHaren Good luck with the new Filemaker Community Forum. :) They just changed it and it looks pretty funky. :) Did you make your calculation and summary fields in the Chapter table? Do you want to get the total word count of the chapter? Greetings Guy
Hello,i tried to contact you within Udemy no answer , I have a problem with your invoicing database on the LaYInvoice tab to admin the year 2020 does not work docent matter what day you set overdue does not work but if you set the year 2015 thru 2019 the overdue worked I re typed the codes so many times nothing work I tried using one of your finished product and the result is the same Can you help thanks.
Hi Cesar, There are two ways to perform multiple finds. You can have one find request where you enter data in multiple fields. That way you will only find records where only records will be shown where are search values are present in the fields you entered values. This is more like an "AND" find. You can also do multiple find requests and enter one value in one field per request. This will return all records where one of the values is present. This is more of an "OR" find. If you can send me your test file I would be willing to take a look to see what's going wrong. Greetings Guy
@@cesaramaral129 You can simply post a link to a downloadable file here. Or send me a private message on Udemy: www.udemy.com/user/guystevens4/ You can send a link with Dropbox, Google Drive, iCloud or Wetransfer. Greetings Guy
Hi Guy. One more time thanks for your attention. All five search fields are working now. The problem was in the email field. If I try to search blablabla@gmail.com returns no results. When I use any letter or part of the name as bla..blablabla ... g ... gmail everything works. If the @ symbol is present it does not work.What a strange problem
Hi Frank, You could create a field where you enter a random number with the "Random" function. Then you can sort these records based on the random number field and show only the first 10. You could do this by looping through the first 10 records and entering a value into a field and then showing only the fields with a value in it. But if you then redo the random 10 script you will have to make sure to clear all values first so you always start with a clean slate. Greetings Guy
Hi, could you explain why in my FMsolution the number for the ID field (auto-enter serial ) doesn't show up in tableview (nor in the others logically) or what can I do that it appears??
In table view you can click "Modify" on the top right. There you can select the fields that need to be visible. If the field is not in the list you can add it by clicking the green "Plus" sign. Greetings Guy
Hi, thank you so much for making the effort to reply!! The description of the problem seemed to be too unprecise, sorry . My problem is not that the field/the column is not visible the problem is that the number by itself in each record is not visible . Greetings from Germany :) @@GuyStevens0
@@ting-huiherweg2664 That means that either the font color is white. Or the actual auto enter serial number setting has not been made. You should go to the field settings to see it actually has a check next to "Serial Number". Greetings Guy
@@GuyStevens0 Thanks a lot ! Your answer would normally be really helpful! In my case which is too complicate to explain at this point, it seems the problem lies anywhere else. But many, many thanks for replying me! Greetings
I used FM years ago and loved it but I walked away because it was too difficult to go online. Now I'm back and boy has it changed. your videos are helping refresh my memory and learn new functionality. Thank you!
One clarification that stumped me for a bit, the calculated field (for the first/last name combination) has to be in the same table as the fields that you want to combine and track. As far as I can tell, it also must be a Text type for the search function to work.
Great tutorials, by the way. Have saved me multiple times.
I have learned more from Guy's videos than from any book I've read on FileMaker Pro. His videos are definitely worth the time. It usually takes me five times as long to get through the video because I have my database open at the same time and I continually pause and rewind to make additions and changes to my own files. If I could give him 5 stars I would! Thanks for all the help!!
Consider my ego boosted!! :)
Greetings Guy
Thank you very much for sharing your knowledge in a digestible way for a beginning scripter. I've used FileMaker for many years but have always been intimidated by scripts - this was super helpful.
As always from Guy, this is another excellent description, easy to follow. Thank you!
Thanks you for your guides. It makes very easy to us to take advantage of File Maker. !! Great job. !!
Thank you very much! Great teaching and thanks for letting us download the file. Such a big help.
Thanks, Guys - great demo- very clear!
Hi Guy, great videos - especially for newbies like me. How do you set up the layout so all the fields show in white against the grey background. When I setup a new layout (even using your template), all the names are intertwined on the same grey background even if I try to set the field color to white? Your layout style looks much more pleasing to the eye. Thanks
Hi Guy thank you very much for your video. I have a question pls. as the field c_Full Name being a calculated field, the replace field under records is greyd out?
Thank you in advance.
Really helpful tutorial! Makes it easier to use FileMaker.
Hi, Thanks for your find data videos but I am stuck on a find problem. I have a file showing certain payment types which are situated in a drop down choice option. How can a find and list of a specific drop down choice option and list the content? Hope that makes sense.
As usual, in his explanations, a lot of nagging problems are clarified. For example, I understand what a global field is, but have never quite understood how to use one (in this along not just one but various users to perform finds). Incidentally, his presentations are such that I feel in contact with, as we say in Italian, a "simpaticone": a very pleasant "guy" (pun intended).
Haha, Nice one :)
Thanks.
there are many good Italian filemaker fans but nobody is so unselfish to share experiences on youtube "gratis et amore dei" ... only if you pay..ah..ah..ah..The only Italian book you find ? Filemaker 9!
Ouch!
Filemaker 9?
That's a little bit behind :(
Greetings Guy
Actually, I have a fat Filemaker book that refers to FMPro 12. I think it's an official one, and is quite good. I'm also using the FM ebook in English. There can be a problem with function name translations using the English-language ebooks, when the Italian equivalent is not intuitive. In many cases, however, if I have a bit of a problem finding the Italian name for a function, I put the English name in the formula and by some magic, when I return to my handiwork, it has been translated into Italian for me. (I have Filemaker Bonsai files with functions in the Italian version, too).
Hi Guy, I love your videos. i just have a question regarding this example.
I find it is habit for most people to just hit the Enter key to search after typing in a search/find box rather than click a "find" button with the mouse. If someone does this in your example, we get a carriage return to another line in your field and no search is performed (as expected). Is there any way to perform the search on the enter key being hit? or at least to disable the carriage return?
Hi Christopher,
The easiest method is to make sure that in the tab order your button is followed by the find field. That way you can tab out of the find field and you will arrive on your find button, because it is the next object in the tab order. Then you can use the spacebar or the return key to push the button and run the script.
If you want to capture the return key on the layout you could use the script trigger "OnObjectKeystroke" to capture a specific keystroke and run a script if that keystroke is pushed.
You could use a script like this:
If [ Code ( Get(TriggerKeystroke) ) = 13 ]
Perform Script [ Find Script ]
End If
I just made a quick video to explain how you could do this.
ua-cam.com/video/jOUuc4qYs-c/v-deo.html
Greetings Guy
Thanks Guy!
How did you make the detail button?
Very clear and helpful!! Thanks a lot !!
Thank you for your videos. I have question. I am creating an invoice form. I need to copy the bill to info to ship to if I select a radio button. Can you help?
Hi Jacinto,
I guess you could use different ways to go about doing this.
This can be done in complex and in simple ways.
I prefer the simplest ways because I'm lazy. :)
Look here for a video explanation:
ua-cam.com/video/BWafO-Dhahw/v-deo.html
Greetings
Guy
How can I automatically do a find and sort by clicking from a dropdown list? Is it possible? Thanks for all your very clear and informative videos!
Performing a find and a sort can be done trough a script.
This script needs to be performed.
You can do this by clicking a button that starts the script. Or you can place a script trigger on a field.
This script trigger will then perform the script.
The script trigger can be placed on different events. Like when you enter a field, when you make a change in the field or when you exit a field.
In your case you could put the script on the "OnObjectModify" script trigger event of the dropdown.
Then when you choose a value in the dropdown the script will be performed.
Your script will need to:
- Commit record
- Enter find mode (Uncheck Pause)
- Set Field (With the value from the dropdown)
- Perform Find
- Sort records
It's possible you might need to set your dropdown field to be a global field.
Otherwise the value in it might not be visible while in find mode. Because you might be on a different record.
This can be done in the script settings.
In the tab "Storage".
Greetings Guy
@@GuyStevens0 Thank you so much Guy for your quick reply. I'm not sure what I am doing wrong. Perhaps the Set Field - what do you mean (with the value from the dropdown)? I have several different values, so not too sure what you mean. Also, I have tried creating a new global field, maybe this is where I am going wrong?? If I understand correctly, I do not want to change my field to global, as it will modify the data in each record, right?
@@GuyStevens0 I finally figured it out! Thanks very much for your help!
Thank You Guy! I have spent so much time with you through your excellent training videos. It is slow going but because I can review sections until I can get the examples too work, the time spent is worth it. I have been working on a audit of a rental property that I own. I need to present the payment history in a way that will be easy for my attorney, myself, and a Judge to understand. Using summery fields has the advantage of presenting payments in a way that the math will be quickly looked at and understood.
I am not a math person. My presentation must look simple, and easily understandable. I have been working on this project for months and now I am spending several hours daily following your video's.
thank you so much.
Also I am using FMP 11. I feel it might be easier to follow your videos if I had a newer version. Should I try to buy find a version between 12 & 16 on amazon or ebay?
Thanks for your message.
Fmp11 is really outdated.
You would be better off upgrading to Filemaker Pro 18.
Then it would be easier to follow the instruction videos.
Greetings Guy
Sorry Guy with reference to my last post I meant to include the find fields in a button setup
Hi Bob,
I'm not entirely following what you mean.
The content of a field, even if the field is a dropdown, is still simply a value.
You can perform a find on a field to find any of the values from the dropdown.
Greetings
Guy
Thank you ! it was very well explained. It would be nice to include all of those buttons into a popover button to save space.
You could do that if you are limited on space.
But then they might be less visible for your users.
Greetings Guy
Hi Guy! Very helpful as always. I am trying to count the amount of words in a specific field from all the records in a table, but only one record is being counted even though the Show All Record script step is included in the script. Any suggestions?
Hi Andre,
You can use the "WordCount" function to count all the words in a field. This results in a number.
Then you can create a summary field that summarizes the number field with the amount.
This will give you the total amount for all the records in the found set.
Greetings Guy
Should I create a loop that checks every record in the table? Right now, the way the word amount in the field is counted is by me selecting a record from a portal, then let the count script run.
@@AndreasvanHaren Hi Andre,
There is no need for a script, no need for a loop.
Let's say you have a table called "Table" And in there you have a text field called "Text".
You want to count the amount of words in the field "Text".
In this table you simply create a new calculation field called "AmountOfWords".
The calculation you use in this field is the "WordCount" function.
It goes like this:
WordCount ( Table::Text )
This calculation field will give you the amount of words in the text field as a number.
Every time you change the text in the text field the amount of words will be updated once you exit the field.
Then you want to total the amount of words for the records you are browsing.
Create a new Summary field that gives you the total of "AmountOfWords".
This will add up all of the "AmountOfWords" fields of the records that are in your found set.
Like this: www.dropbox.com/s/24rmyem43zspq81/WordCount.fmp12?dl=1
Greetings Guy
Hi Guy, thanks for helping. I still get the same results though, only the single record word amount from the text field is shown.
Some more details are maybe helping here: The layout is based on the Story-table.
The text field on this layout is from the Chapter-table.
There is a portal on this layout that connects a chosen story with a record in the Chapter-table.
I think this is probably a little too complicated to discus on UA-cam, I will bring the question to the Filemaker forum where I can also post screenshots.
Best wishes
André
@@GuyStevens0
@@AndreasvanHaren Good luck with the new Filemaker Community Forum. :)
They just changed it and it looks pretty funky. :)
Did you make your calculation and summary fields in the Chapter table?
Do you want to get the total word count of the chapter?
Greetings Guy
Thanks mate for the info and this is great.
Hello,i tried to contact you within Udemy no answer , I have a problem with your invoicing database on the LaYInvoice tab to admin the year 2020 does not work docent matter
what day you set overdue does not work but if you set the year 2015 thru 2019 the overdue worked I re typed the codes so many times nothing work
I tried using one of your finished product and the result is the same
Can you help thanks.
thanks guy
The problem is when using 2 of the 5 field returns nothing even with valid values. The page returns nothing and shows a withe page
Hi Cesar,
There are two ways to perform multiple finds.
You can have one find request where you enter data in multiple fields. That way you will only find records where only records will be shown where are search values are present in the fields you entered values.
This is more like an "AND" find.
You can also do multiple find requests and enter one value in one field per request.
This will return all records where one of the values is present.
This is more of an "OR" find.
If you can send me your test file I would be willing to take a look to see what's going wrong.
Greetings
Guy
Hi Guy! Thanks for your support. Pls let me know the best way to send you the file. Tks Cesar
@@cesaramaral129 You can simply post a link to a downloadable file here. Or send me a private message on Udemy: www.udemy.com/user/guystevens4/
You can send a link with Dropbox, Google Drive, iCloud or Wetransfer.
Greetings Guy
Hi Guy. One more time thanks for your attention. All five search fields are working now. The problem was in the email field. If I try to search blablabla@gmail.com returns no results. When I use any letter or part of the name as bla..blablabla ... g ... gmail everything works. If the @ symbol is present it does not work.What a strange problem
Hi! How can we Select 10 random result from Find?
Hi Frank,
You could create a field where you enter a random number with the "Random" function.
Then you can sort these records based on the random number field and show only the first 10.
You could do this by looping through the first 10 records and entering a value into a field and then showing only the fields with a value in it.
But if you then redo the random 10 script you will have to make sure to clear all values first so you always start with a clean slate.
Greetings
Guy
Hi, could you explain why in my FMsolution the number for the ID field (auto-enter serial ) doesn't show up in tableview (nor in the others logically) or what can I do that it appears??
In table view you can click "Modify" on the top right.
There you can select the fields that need to be visible.
If the field is not in the list you can add it by clicking the green "Plus" sign.
Greetings
Guy
Hi, thank you so much for making the effort to reply!! The description of the problem seemed to be too unprecise, sorry . My problem is not that the field/the column is not visible the problem is that the number by itself in each record is not visible .
Greetings from Germany :)
@@GuyStevens0
@@ting-huiherweg2664 That means that either the font color is white.
Or the actual auto enter serial number setting has not been made.
You should go to the field settings to see it actually has a check next to "Serial Number".
Greetings
Guy
@@GuyStevens0 Thanks a lot ! Your answer would normally be really helpful! In my case which is too complicate to explain at this point, it seems the problem lies anywhere else. But many, many thanks for replying me! Greetings
@@ting-huiherweg2664 If you send me your file I can have a look.
Greetings
Guy
Hi Guy, do you offer paid work in FileMaker?
thanks you