Been diving into FM for a few months now and this is a great video. Curious if there is anywhere to get a more recent Help documentation pdf. The link you have in the video description leads to the right page, but the "Claris FileMaker Pro 19 Help (Download)" link leads to a 404 page now. Would love to have an offline version of the Docs.
@siegfriedbarfuss937914 күн бұрын
So this requires a plug in? Please always flag if non native FM!
@andreizhitkov501214 күн бұрын
Thank you, Matt, for your unique attention to design. A typical programmer will pay no mind to the design or even UI/UX in general, and a typical designer will know very little about tying UI to the functionality. Your perspective becomes valuable for those who what to enhance functionality with functional design.
@4CardsManАй бұрын
I do a lot of FM scripting. How do you make the script text larger?
@meistertocaАй бұрын
3 Years into my FileMaker development and watching this again; I finally understand everything you are talking about. Thank for providing this video. 🙏
@DaveHenningАй бұрын
Is it possible to use the custom function on borders/backgrounds etc? Example: I have a title that's at the top of each 'section' that should have a background color dependent on the layout table, the box has a 2px border at the top that is a darker variant of the color.
@filemakermagazineАй бұрын
Unfortunately, the degree of programatic control over UI coloring is not quite there for lines and backgrounds. There are some tricks ("hacks") you can do to vary background color (e.g. using a container field set to fill with a raster image to show the fill color - or - using a colored block char set to massive text size) - but, really, if you need maximum color control, then you may not be able to get exactly what you want. Short of using a Web Viewer, where you do get full control, but with unfortunate load flashing, you don't get the same things you get with other development environments in FileMaker.
@DaveHenningАй бұрын
@@filemakermagazine Thanks. That's a shame. I was hoping for full context templates. That would have been slick.
@gjermundificationАй бұрын
There used to be an iOS app that picked a number of colors from an image; 5 was it? Perhaps it was called Adobe KULR?
@filemakermagazineАй бұрын
There's a wide variety of tools I've used over the years. Unfortunately, as Apple has locked down the OS, even things like this cool Photoshop-like picker is harder to enable. github.com/viktorstrate/color-picker-plus
@MrTheophile69Ай бұрын
Thanks Matt!!!
@jffortier1294Ай бұрын
The hide condition only works in a master-detail portal !? In a regular portal with releated records it doesn't... unless I missed something ?!
@Lamarre27182 ай бұрын
35:37 Why are you concerned about character length? Is it because of having to transfer data from and to the cloud where the solution is hosted??
@FM-Security2 ай бұрын
Just noticed this channel already has 256 videos out! That's a round number, 0x100 hex :-) Congratulations!
@phillbaska2 ай бұрын
I'm glad Alexey is getting some credit and reward for this
@JordanKahn-d9b2 ай бұрын
Very eye opening and informative video. Thank you, Matt.
@MonkeybreadSoftware2 ай бұрын
Great video! Thanks Matt and Alexis MBS Plugin allows you to limit the number of available functions using Plugin.SetFunctions function. You may just need 20 of our over 7500 functions. See also Plugin.LimitFunction and Plugin.LockFunction functions. And please don't just call Evaluate() anywhere directly with text input from the user. At least check for brackets, double colons and backslashes for the case the user likes to hack your database.
@dyhrsgarage2 ай бұрын
Great video, thanks a lot //Greetings from Sweden
@FM-Security2 ай бұрын
Thanks Matt, great video, all true and to the point. Indeed, the vulnerabilities are quite serious. I was happy to help find and close them. Maybe Claris can patch older versions too ? In the meantime really everyone should upgrade.
@andreizhitkov50122 ай бұрын
Those Russians again... Apple may not have been able to pay any money because of the sanctions. I know they did stop all the payments for any Russian-sourced apps in the App store.
@FM-Security2 ай бұрын
Im not Russian, Im Ukrainian! :)
@andreizhitkov50122 ай бұрын
@@FM-Security Oops, sorry. You used the Russian spelling of your name. So why no dineros from Apple then?
@FM-Security2 ай бұрын
@@andreizhitkov5012 I've updated the article. Apple did find the right category for this vulnerability and paid the reward. This happened just the other day.
@siegfriedbarfuss93792 ай бұрын
That should be all built in FileMaker Pro !
@walternoia86392 ай бұрын
Great Video Matt it would be great if we could get a better understanding off how to set the Environment correctly Apple Script vs Typinator and inline vs disc storage and if possible could we get some samples of Typinator Filemaker extension
@filemakermagazine2 ай бұрын
I am working on a new product which is a series of videos on how to optimize your development environment for FileMaker Pro. Stay tuned.
@FlyByNightBBQ3 ай бұрын
The line number thing is a known issue with Monkey Bread and increasing the font size. I've asked Christian about it, and he said that he can control the font of the script steps, but he can't change the UI of the line numbers.
@filemakermagazine3 ай бұрын
Makes sense in that he can only swizzle so many things exposed when the UI renders.
@djc7283 ай бұрын
As always Matt »» great video. Every time I hear "Node-Red" I think of the movie "A Few Good Men" with Tom Cruise and Jack Nicholson where Tom Cruise asks Jack "Did you order the 'Code-Red?" Well we can easily change that line to "Did you program in Node-Red?" ( lol ). All kidding aside, this looks like a fun technology »» thank you for the introduction. I could easily see a series on this and I for one would enjoy watching that if you decide to do one. Great work Matt !!!
@illia42283 ай бұрын
This is really nice, but I'm having a problem trying to filter out duplicate records from a portal based solely on the Filter calculation. Is there a good method? My status quo: Portal based on child table shows related records. There are two fields (let's call them CODE and WEIGHT) that can constitute a duplicate if they both are identical to another record, so duplicate by a combination of fields. My goal: Show only one occurrence of every record, making it unique by combination of CODE and WEIGHT, and hide all subsequent duplicates. I can't modify the data or the schema of the table in question. I'm reading the values from the portal to later use them in scripts, so I can only rely on the filter calculation.
@djc7283 ай бұрын
Great video Matt and 2 fabulous guests with Robert and Josh. Cool stuff. I may go to the "Single-pass loop for error handling" thanks to Josh. ;). Please do more of these type of videos as it's always great to learn about other tools a developer can use with FileMaker to make the overall development experience less stressful and more productive.
@filemakermagazine3 ай бұрын
I will be publishing a video shortly about using Single Pass Loops and explain why/how they are useful.
@stevienichol10083 ай бұрын
Hi Matt, have been trying to find a way to open a web-page in another browser, not the default. By passing a variable, can't seem to get it to work at all. Have you done anything on this problem? Thanks
@dyhrsgarage4 ай бұрын
Thank's a lot Matt!
@jaybogartsupport4 ай бұрын
Still waiting for Filemaker feature that can make a Video Clip a background in the Layout. And also, make the slides "auto-slide".
@jaybogartsupport4 ай бұрын
So many years had passed Still can't make a video a Background on Layout. Also, Can't make a search bar capable of handling a quick search on 200,000 records. The program lags on search.
@djc7284 ай бұрын
As a person who doesn't use the table view all that often » this was very helpful and I love the tip regarding making timestamp fields custom with leading zeros and having year first. The font change to a 'mono' style font is another I will use. AND I really will take advantage of adding a TEMP field to do replace field contents. Good stuff.
@MrTheophile694 ай бұрын
Thank you
@gjermundification4 ай бұрын
1:17:17 ^^Gem!
@desingbyulrik5 ай бұрын
Matt. You are a very talented educator. However, you run way too fast to follow along. Slow down and provide context as you click around and zoom in and out (making viewers seasick)
@karomac5 ай бұрын
Hi, why do you use Get( RecordNumber ) for the array for $render? I would also use Get( RecordID ). Because if any user is deleting a record while your printing script is running, you have the have the chance to have the wrong qrcode...
@dansonamission5 ай бұрын
What is triggering the OnObjectSave event on the search field? The only time you are committing is with backspace or escape via OnObjectKeystroke
@KubieQ5 ай бұрын
I dont have the luxury of combining my tables before..so how do I do with multiple tables without merging tables?
@MrTheophile695 ай бұрын
Thanks a lot
@kaffeburk1006 ай бұрын
2:41 Why do we have two defaults?
@MrTheophile696 ай бұрын
Hi Matt. Thanks for your high quality video. Based upon what you've said about tabe occurence (only aliases) I wanted to do a big cleaning around to go back to a blank relationship graph but then all my layouts show "<Unrelated table>" in the fields. Impossible to reconnect my numerous records to any layout. What can we do if that happens? Why did this happen as you were saying it was only aliases. I don't find any answer on FM Forum. If ever you had an advice? Thanks.
@MrOktony6 ай бұрын
Can you use application with local LLM?
@lnebw996 ай бұрын
I do something similiar using Execute SQL (much simpler) and a table with all button labels). Adding a button, however needs manual copy paste (except I would include placeholders)....I will take a look at your solution. Learnt so much from you over the last two decades!!!
@filemakermagazine6 ай бұрын
One thing you should always consider with using ExecuteSQL is that if there is an open record on the client, then the performance can degrade significantly. It's always suggested to use a Commit Records just prior to any ExecuteSQL call. Plus, for some, they don't like having to learn SQL. But, I love using it myself. You can also use AI now to compose your SQL statements for you!
@MrTheophile697 ай бұрын
You're a marvellous pedagogue beside your real abilities in mastering this software. My mum just told me today that looking backward in her own times, approaching filemaker, there was only this huge paper documentation whereas nowadays tutorials are so practical : thanks to people teaching like Matt Petrowsky. Best rgds
@Vistouf7 ай бұрын
At around 6:00, you talk about how mobile is slower than desktop. Is this still a concern in 2024?
@christianschmitz74887 ай бұрын
You can just rename FileMaker Pro and have 10 different versions installed on a Mac. I love to have 18 versions installed here for testing.
@filemakermagazine7 ай бұрын
Thanks for the info Christian! One of the benefits of using folders is that you can keep that ClarisConfig.json file within one of the copies of FileMaker you're running. Simply closing one version and then opening another means you've got your network testing turned on. Just name the folder something like FileMaker 21.0.1.53 debug and include the ClarisConfig.json file with desired settings.
@gjermundification7 ай бұрын
53:18 Would element type be JSON or ION?
@filemakermagazine7 ай бұрын
JSONGetElementType just returns one of JSONString, JSONNumber, JSONObject, JSONArray etc... Which all correspond to just a number. You can see their values with this function. List ( JSONRaw; JSONString; JSONNumber; JSONObject; JSONArray; JSONBoolean; JSONNull; ) // equals "0¶1¶2¶3¶4¶5¶6"
@gjermundification7 ай бұрын
@@filemakermagazine Did you move to neovim? I did after the passing of Bram Moolenaar. I have some basic LSP set up for Swift in nvim.
@andreizhitkov50127 ай бұрын
Apple stopped distributing Python 2.7 starting with macOS 12.3.
@filemakermagazine7 ай бұрын
I knew it wasn't that far back as it felt like it was just there a release ago as you mention. I've been avoiding the upgrade to Sonoma to wait out all the bugs with FileMaker.
@vincentcestmois75297 ай бұрын
Is the thumbnail a ship about to sink ? :-)
@filemakermagazine7 ай бұрын
I thought about that while I was making it with AI (midjourney). Good catch! Nah, it's fact that explorers of days yonder had to weather the uncharted waters in order to find new lands. You, know, discover AI functionality, play with new features... all that cool stuff. ;)
@zerobatsu7 ай бұрын
RIP RezEdit
@filemakermagazine7 ай бұрын
Yep. The closest my curiosity took me was finding some decades old nib decompilers. github.com/akahan/Nib-Decompiler I've gotten too old to take the time to rearrange the Calc dialog. So, I just live with what they give me now.
@GarthBrown-uc2qc8 ай бұрын
Did I miss something? You began by introducing the "Launcher" app. As far as I can tell, we never got back to making that app operational. While I found your introduction to FileMaker development extremely useful--for which I'm very appreciative--I'm left unsatisfied with that "hanging chad." Tangential side-barring is common human behavior and certainly can be useful when creating on the fly. I would characterize this presentation as something of a Mandelbrot set fractal having intricate details and self-similar patterns, but not closing on expectations. In any case, thank you for advancing my understanding of this amazing product.
@mykhaelhernandez63888 ай бұрын
Video marker 19:32 you mentioned a key expansion tool to time stamp a script comment. Please explain in detail, I think quickly/easily time stamping script comments is very useful and important. Thank you for the how to videos, they are very helpful and educational... keep up the amazing work.
@faworkstation30798 ай бұрын
I have problem with my Filemaker Pro Invoice. I have upgrade my Filemaker pro 14 when I change my new computer and cannot be use anymore. So I purchase the single user Filemaker pro 2024. Completed installation, all goes well, I can open my old files for couple of day. But yesterday, when I open the Filemaker all the file become ??????????. HOw can I solve this isuue?