This is a beginner tutorial for people who are just getting started with Filemaker and have no idea where to begin. In this lesson we create a simple contacts solution from scratch so you end up with a file you can actually use. During the lesson we cover all the basics you need to learn to get started with Filemaker.
Get the Filemaker file here: https://dl.dropboxusercontent.com/u/18099008/Demo_Files_FMP12/25%20-%20Filemaker%20Basics/Basics.fmp12
My Udemy page:
https://www.udemy.com/user/guystevens4/
Greetings
Guy
I have to say though – I am not very good at giving compliments , If a person can do something and he knows it then he needs no compliments
BUT i have to say after looking at your video's and teaching methods – I personally think they are brilliant and deserve the compliment – Looking forward to seeing more from you on YouTube or even Udemy
Thank you for the hard work !
David Erika
I use FileMaker since a long time. I started with a pre-made solution I received with the program. It worked well but I had no feeling with that program and made mistakes. Guy is explaining this now step by step and finally I understand the program, how to use it and how to adapt it to my whishes. Thank you Guy!
Hello Guy. Your videos are great and I have learned a lot from them. But there is one thing I am having trouble with and would appreciate some help with. I am creating an invoicing system which looks up prices from another table. The problem is that when I issue an invoice and then change the price of an item, for example, I want that new price to be used for future invoices, but not change the price in an old invoice what I already created a while back. Thanks!!!
I built my whole companies customer service database based on your channel! Thank you so much… been following for some time now
Hi Guy, I must say, that your video are an inspiration for me. I have learnt so much in such a short period. Now that I have purchased filemaker and have my databank started. I have a question for you. I have a tiny business (it's just me), in which I use inventory for repairs. Sometimes I would add an items to the repair report and then delete it, because it wasn't used. How do I make the inventory count list, back track this inventory so that the stock count is again correct. It wasn't used, but booked out. I also have problems with the automatic data filling for such a report. I want to choose from a list of existing parts or another table which fills out the PN, description, customer, contact, quoted repair, po received. Any new video in this direction would be a pleasure to watch and learn. I have already many tables, organised in your manner. So now, I just want to start automatically filling in forms or layouts, using the relationship and your methods. To have multiple suppliers of one part, would like to show a different price for each and the last order. I have many questions. Thank you for everything you have shown me. I normally watch your video and then spend hours doing the same on my database and having to watch each step again and again . I get it in the end and I love it.
hoi Guy ,ik vind je video's top.maar ik heb moeite met de Nederlandse stappen on een script maken ( ik heb filemaker windows )jou "Set Capture is het Nedelands "foutafvanging instellen". dus niet makkelijk te vinden.als ik jou script stappen volgt is dat niet makkelijk.als je een steps(rechts van het scriptveld) daar opzoekt is het nog wel te volgen welke je bedoeld.maar als je in script veld schrijft komen jou Engelse stap te voorschijn ,bij de Nederlandse versie is dat niet.zijn alle steps in het Engels ergens in het Nederlands te vinden?
sorry Guy ,ik bedoelde Set error capture is in het nederlands foutafvanging instellen.nu kan ik niet scroll windows [home] vinden rechts in de stappenlijst. help
gevonden , "scroll windows [home] " is in het Nederlands "venster schuiven [home]"
bedankt Guy voor je antwoord.
zal het overwegen ,het helpt mij wel als je rechts uit de stappenlijst en stap een stap kiest ;-).
nogmaals, top video's en een rustige uitleg. topppp
Hi Guy, this Bob from the UK on Filemaker Pro advanced 11. Have a problem printing stock label details where some stock items require more of the same labels than others. I have set up a print page for the labels but I cant seem to find a way of printing several of the same stock details along side other stock details of lesser item in stock. What I need is to be able to print the labels that correspond to the stock quantity of each item along side items of less stock.I have considered duplicating the stock items by the amount in stock but that throws my stock and ID numbers out of sequence. Is there a solution. If anyone knows you do. Great videos by the way, I have seen most all of your videos which have helped me greatly. Regards Bob Cole
Hi Guy, Hoe kun je best je database aanmaken als je verschillende leveringsadressen hebt,
voor één klant?
Hey Guy,
Super bedankt voor je reactie, en goede uitleg.
Ik ga hiermee aan de slag.
Ik ben bezig met het maken van een Fm14 database. Met als basis hetgeen ik leer via jou film op YouTube. Ik maak het wel voor een Layout voor een Ipad.
Bij de Basic button 4 (geel) voor mail zie ik op mijn Imac het icoontje postbus, maar op het scherm van mijn Ipad enkel een geel veld. Weet jij hoe dat komt?
Groetjes
Philippe
Thank you so much for this useful video!!!
Hi Guy! THANK YOU SO MUCH for putting this video! I'm very new to FM and had been searching for basic introduction to this software. I was hoping to find a video that shows intro and dives a little more deeper to relationships and some of the "macros" I need to design my database. You nailed it! Super happy to watch your video! I've learned a lot! Looking forward to other videos you posted or will post :). THANK YOU!!!
Thank you so much for this video! I just got Filemaker and needed some basics, which your video provides perfectly. 🙂
Excellent video and very well explained. Thank you, Guy!!
Hello Guy,
I'm creating a POS system.
In your script, you defined the script to find two product names (status).
How would you write the script if there many product or service names?
Basically, I want to enter the designated database, and search for ServiceA, ServiceB, ServiceC, with their service prices and save the results as variable.
outstanding! thank you
You are freaking awesome. You made it all very approachable and opened up a great deal of possibilities for me. Thank you!!!
Hello Guy,
The video is very good, simple & important…
Thnks !
Hi Guy, your toturial es very interesting.
You can give me an idea how to include the User and Password fields in a form, something like this:
(https://mir-s3-cdn-cf.behance.net/project_modules/max_1200/38335d43888305.58002216b1ab6.jpg)
Thanks for yout help.
I am new to Filemaker pro. I watched your video… and was able to create exactly what I needed. Great Job! Thank you. I do have a follow up question…. I have Filemaker Pro Advanced… Now that I have my solution… I would like to "publish" it so that I can access it from different computers that I may be on. I don't need to change the layouts on those devices… just enter data… I do want the data entered on one device to change the data on all other devices… do you have a video on this or is there a place to go get help on this? I am working for a tiny school district and can't afford to buy additional licenses or subscribe to expensive cloud services. Thank you for your time.
Bedankt voor deze tutorial, Guy. Na mijn vorige experimenten was het tijd om even terug naar basic te gaan 🙂
Dear Steven, Am new to FMaker Pro and appreciate your approach so I have a request. I'm trying to create database for a friend
whom owns a farm. Th task he has set for me is to try and come up with a database that takes care of Seed inventory. Problem is it's all s a MSFT Excel xlse file which has data entries that have northing to do with field tables I have laid out so when I try o iFile/Import Records/ File there is nothing listed on my side of the ledger to match the Excel list. I have
Plant Category/Seed Name/Company Name/Date of Sale/ Price/ Expiration Date ( on seeds he already has ) Website/Re-Order form /Email to which there re no corresponding titles in the Excel tables. How can I import all on the stored info instead of trying to manually enter each of the 154 entires in their respective fields. Make Identical host fields that FileMaker pro will successfully transfer over to and then manually change the fields the corresponding fields as I designated them or what? T.I.A.
Hey Guy,
I'm going to try an experiment. I'm going to create in Layout only the field headers I named that match the headers in the Excel Xlsx file. Namely: Plant/Variety/ skip*Style* which is left empty/Company/Date/ skip shelf life/Expiration date and see if that transferal works for me and thanks for leading me in the correct direction.
If need be I can correct the import header designations after the fact and place the Expired Seeds on a separate Tab in order to allow the designation to be clearly differentiated from the still active seed packets.
How would I create something similar to this with the colors and subsections?
https://vignette3.wikia.nocookie.net/starwars/images/a/a0/Holocron-screenshot.jpg/revision/latest?cb=20130206172000
Sorry for the poor quality.
Excellent ! Please do not move cursor so quickly
You know your stuff! Wow!
I'm not a coder, not a developer but I would say this is a very useful tutorial for Filemaker. Thanks
Watching your video for 2nd time and it gets better each time. It is much better than the Webinar from Filemaker. Thanks
You are amazing! I love your videos – you are a great teacher!
all your video is great. love it say thanks many time still not enought
I am designing an inventory system for a helicopter company. Within this, I need to have a part, such as an engine, and then I would need to show sub-components within that engine with corresponding data. How would I be able to create a hierarchy of items like that? Great tutorial, by the way!
Thank you so much Guy, trying to decide if this will work for a "relationship database" needed for my business. Been working with excel but time to get real. The CRMs on the market are just too conflated. You sure make it look easy!
You are AWESOME! Thank you!
Very good
does anyone know how to place a text discription in a field when a field has no entry in it
Hi, thanks so much for the tutorial,
but I don't understand what happens at 1:10:49.
or 1:13:18