FileMaker Scripting Basics

[@butterfliesandbugs4535]

Sad to see you are not still making videos. Your beginner scripting videos are excellent - nowhere else could I find the most basic of beginner scripting tutorials/videos. Wish you had more, but thx for these!

[@waynes517]

It's 2022 - and this is probably the finest example I've come across. Good work man :)

[@spongesy8891]

There are so many FM videos out there that are so so and take a lot of time to go through without getting much out of them. Yours are well defined, explained and beneficial. Hope you continue to teach us.

[@roberthubbell4915]

After watching other tutorials that try to teach the same subject matter as this video, I can say this is the best tutorial-by far. Thank you!

[@davidesoncin2399]

Hi Sunny, great tutorial! It would be interesting to post a message when there are no results that match the search ;). A little exercise in addition to your tutorial. Thanks

[@hiogiso]

Thank you, Sunny! Three springs ago I migrated a database that was running on Microsoft Access to FM. That was the first time for me to get it right. And I realized that FM is far better intuitive, user friendly and developer friendly like me with little knowledge. The database has been running very well and so far only few things to be fixed. But there are still some issues to be solved. Your tutorials on the web are all practical and useful. So far I installed couple of your scripts to automate the processes such as to send email with PDFs by one click. The biggest issue I have now is to resolve "Filemaker cannot share files because another user is already sharing...." thing. Please help me out, Sunny!

[@mathaccount9489]

Really step by step, easy to understand. You are such a great teacher. Thank you.

[@angusdavidson417]

Hey Sunny, this is a fantastic tutorial. I learnt more about scripting as a novice than I ever expected. Especially about making sure your syntax is correct! Thankyou!!!

[@FMBeginner]

Thanks Angus your welcome!

[@bazcleary4411]

At last a scripting tutorial that doesn't assume I already know scripting. Excellent video...as always.

[@markhinze1]

Wow what a great young teacher! Sunny is the Best!

[@cynthiahall2360]

Really great tutorial! So glad I found you!! You're such a good teacher!

[@FMBeginner]

Thanks Cynthia!

[@chris.qzhang1950]

so happy I could find such useful course, though it's 18 version. In China it's teacher's day, Happy Teachers' Day

[@snowily20]

Thank you Sunny. Crystal clear

[@dionilsysoto7595]

Super simple and Easy way.. Great

[@Mega_Casual]

Love your tutorials. So excellent! 👍

[@ideasthatwork]

Excellent class!!!😁

[@tamerel-sakka4769]

How can I use programming for a table with historical data such as a hotel with 14 floors and each floor containing 22 rooms? For example, the room numbers for the first floor are 101-122 and for the second floor 201-222. Create portals for the full rooms and the empty rooms.

[@Mikasalzsky]

Hi Sir, can you make a simple dbase for multiple choice exam, so my student can take their exam on network thru filemaker. Thank you very much

[@svenlidynia8565]

Verry good tutorials. Easy to understand for beginners

[@leventonder5014]

great,, thanks for your tutorial

[@wazwuz205]

You are genius, thank you for teaching

[@josechemist]

Have you done this on an invoice iteam line?

[@tomservo75]

Just wondering, can you write your own scripts, i.e. program your own steps like you would in Access Visual Basic, import 3rd party libraries, or are you limited to the steps listed on the right?

[@robertovestri8626]

Hi Sunny, congratulations on your tutorials which are very comprehensive and understandable. Do you have any suggestions for creating a database for classical music records? Thanks so much.

[@mulletATheart]

Great tutorial. Thank you!

[@andreasglaser1290]

super instructions well and understandable explained outstanding

[@leotorres1536]

Thanks for the tutorial! Very easy to follow!

[@nasir_adam]

Good explanation and excellent examples thank you

[@wfcperrine]

I've watched this video 3 times - you are a GREAT teacher! Please tell me - as I'm tying in search bar I wish the results to narrow in alphabetical order - how do I do that?

[@FMBeginner]

Thank you Mark! You can try adding a "sort record" script step at the end

[@wfcperrine]

@@FMBeginner Thank you! It worked.

[@carlatalamantes5883]

This is amazing!!

[@arturoramirez4467]

Nicely accomplished. Thank you very much!

[@SnowHu2019]

its best I have seen

[@sarwathamdy]

Hi, Sir How can I input different ranges in file maker database , such as 1101:1126 And From 2101: 2100 By making script.

[@chellebe4640]

Hi I'm new to FileMaker and am not a developer in any way. I am trying to build a database to use for my small business. I was following the tutorials, but for some reason I cannot select "Input" under Find Request - Find Records When - Primary Key - Input. It is greyed out. I researched and saw a Q&A that said you cannot do a find if the field is a global field. But it worked on the video. Am I doing something wrong? I have FileMaker Pro 19. Like I said, it doesn't allow me to click Input. I tried deleting it several times and even changed the Name. Any help would be greatly appreciated! Thank you!

[@baskethood]

Works flawlessly!! Thanks for sharing! Quick question, is it possible to add search symbol inside the search bar? And maybe an X symbol to clear out the things I typed?

[@FMBeginner]

You will have to manually create an image to do that. One way I do it is to create a button (with no function) with the magnifying glass icon.

[@shabulal3308]

how to connect api using script. can u explain in video?

[@Hawk95969]

Thank you, My first FileMaker Pro 4.0. It had a record feature that aloud you record your step and it would save your scripts. I jumped to Pro 11 and the record feature is't there anymore. Any chance that the newer Pro's have that feature?

[@jean-pauljaggard4042]

Thanks Sunny. I just have one issue - the search only works if the string starts the same. ie if I have a record 123-456, the search must begin with "1", Any solution?

[@frankalesci8039]

Thank you so much! You are helping tremendously

[@FMBeginner]

You're welcome Frank!

[@mitziperdue2820]

Thank you! I’m amazed by how clear your explanations are.

[@mariogunner2641]

pro tip: you can watch movies on Flixzone. Me and my gf have been using them for watching loads of movies recently.

[@aidenavi5976]

@Mario Gunner Definitely, have been using Flixzone for months myself :)

[@graysonkade5326]

@Mario Gunner yea, I've been using flixzone for since november myself :)

[@reimono]

why couldn't you be my university teacher? you are absolutely great man

[@renderdreality]

@FileMaker_Beginner Hello Sunny, could you explain why you had to create a variable with set variable even though you had the input field set to global variable? I did hear you mention that it needed to be created for the find , but you made it seem as if it would not work if you didn't create the variable. A clear explanation about that would be really good to hear. #Update I think I realize why. Is it because the field search script step doe not accept fields?

[@FMBeginner]

Yes thats correct, the "Perform Find" script step does not take in field values, only variable or a flat value. So we need to convert the global field value to a variable first before submitting it into the finding script.

[@piorosellmigone7012]

NIce Explanations Dude!

[@udayanbhanot2509]

Brilliant.

[@polarstaribiza]

Super helpfull buddy!!!! thx!!

[@pedayakarreddy6283]

Very clear explanation, thank you very much!

[@FMBeginner]

Thanks Reddy!

[@dendisnear]

Thank you very much. Excellent tutorial...

[@magicmanj32]

great video, easy to follow

[@richhyer1789]

Sunny, I am very interested in taking your course but I would like to ask a few questions first but there is no way to ask a question on your website. How can I contact you to ask those questions?

[@FMBeginner]

Hey Rich, I can't post publicly here but my email is in my channel about page.

[@ahtfilemaker]

Excellent, go on sunny

[@pralhadshetye8863]

Hi Sunny, That's a great video. Continuing with it.. I was wondering, if you want to print the filtered (searched) records. How would we do it? I tried GTRR script but it doesn't print the filtered records but it prints all. Kindly advise. It would be of great help. Thanks.

[@FMBeginner]

Hey pradlhad, check the post on the facebook group I posted a reply to your question!

[@jeffreysmith5970]

Excellent Video!

[@MrZegadil]

very helpful thanks for the knowledge share.

[@charlessanderson2635]

This was really helpful and succinct :-)

[@fabiolachouha985]

Hi Sunny thank you very much for this excellent tutorial. Just a question please as I have applied the same to my database but still when I type the cursor erases my previous entry and I have to click every time with the mouse to continue typing the word. I dont know where the problem lies. .Thank you very much.

[@FMBeginner]

Hi Fabiola, you probably forget to go back to the object on your script trigger

[@fabiolachouha985]

Hi Sunny, on my script trigger, I just had it on "object modify", should I have changed that to something else? Thank you very much for your kind assistance.

[@fabiolachouha985]

Hi again Sunny, or did you mean in the script itself to add the step go to object. If yes, should this step be place after "perform find" and "sort records"?

[@fabiolachouha985]

Hi again Sunny any suggestion please to my questions of last week? Your help is very appreciated!!!

[@abortot1958]

good day I need to understand how to make a script to automatically insert photos on image fields the photos are saved with unique codes and are resident on the desk of my mac. unfortunately I'm in trouble. thanks

[@RidleyS79]

Thanks for the awesome vid. I tried to enroll the 12 week course but it says: An error occurred while submitting your data. Please try again

[@uveysiya]

man, what a great tutorial!

[@FMBeginner]

Thanks uveysiya!

[@PedroMartinez-nl1gr]

Hey Sunny excellent course, well explain. I downloaded the file from the link above but I only see two sets of fmp12 files one named After the other Before. This belong to zip file number YT1805_File. Maybe I made a mistake, can you direct me to the right place? No sure if still available since this is almost a 2 year old course. Thank you

[@FMBeginner]

1805_File is indeed the exercise files for this video. Just open the before file and you will be able to follow along.

[@PedroMartinez-nl1gr]

@@FMBeginner Thank you very much.

[@rogerthat9306]

Nice video. I have some experience in Filemaker, but I'm trying to do something that's beyond my scope - wondering if you can help... here is my problem: I have an invoicing dbase with a sales tax option field - "tax" or "exempt". When I choose "tax" it automatically taxes 6% on the subtotal. "Exempt" taxes 0. That works fine. But now I want to enhance that option because the tax rate has changed. So I want to add another qualifier - If record number is less than 1570 - charge 6%. If record number is more than 1571 - charge 7%. I know it can be done, but everytime I write a script it gives me an error. I'm missing something and have exhausted my personal knowledge. Can you help?

[@FMBeginner]

I think you can try using calculation and check out how to use the If( ) or Case( ) function. Sou you can do something like "if( number < 1570 ; 0.06 )" something like that to get your tax thing going

[@RM1-o2y]

Can you show how to perform a find and then omit records that match a certain criteria??

[@FMBeginner]

Well it's also within the "Perform Find" script, but inside the place where we set up our query criteria, on top there is a drop down option to select if you want to Find or Omit record.

[@SportLhord_TV]

Please do tutorials on church database 🙏🙏🙏

[@prof.dr.med.carstenbunger3931]

Ottimo, großartig, greater than great; molte grazie, herzlichen Dank, thank you so much. I'm looking forward for your next tutorials.

[@nasserahmad578]

Hello Sunny, what is up...if I wanna search more than one word say BMW 2004 at the samme time..how can we do it...thanks

[@FMBeginner]

Create another query in the first dialogue after you double clikced Perform Find

[@nasserahmad578]

i did insert the year field inside ( Perform Find ) but when typing say BMW it began to showthat but when typing (BMW 2xxx) so nothing happened and i tried the And function also not working

[@hassankadhum4127]

More more more plz plz