FileMaker For You
FileMaker For You
  • 45
  • 95 312
FileMaker global fields - how and when to use them | Beginner Tutorial | FileMaker For You
FileMaker global fields are incredibly useful -- but only if you know how and when to use them. Global fields can be used to store a logo, tax rate, commission percentage, department account code or username, to name a few of the many possibilities.
In this FileMaker tutorial, I show you two ways you can think about global fields so that you have a stronger understanding of how you can put them to good use. You'll also learn about one case when it is not a good idea to use a global field.
You'll also be shown several examples of FileMaker global fields in action including: improving your user interface, creating an Excel report for accounting and building a user login screen.
Are you too busy to do the work yourself? Contact me ➜ bit.ly/2GHicbJ
~~~~~
FileMaker Cheat Sheet - 9 pro tips for finding powerful insights and analysis fast [ Infographic ] ➜ bit.ly/2q9VEcG
Get More Great Tips - Subscribe ➜ bit.ly/2uPxJFf
Newsletter registration (early announcements for free live webinar workshops -- limited seats) ➜ bit.ly/2q82teI
~~~~~
MORE VIDEOS:
Easy Excel summary reports with Filemaker's export group option
ua-cam.com/video/9MPDybD4nUs/v-deo.html
Quick way to find duplicates:
ua-cam.com/video/BpprRYpMjD8/v-deo.html
Create personalized emails with FileMaker email merge tip!
ua-cam.com/video/wYdgO5Py-Sk/v-deo.html
Date stamp your notes with this easy trick!:
ua-cam.com/video/JLtE91aA8Jk/v-deo.html
Sort by a FileMaker Summary Field (What categories perform well and which don't?)
ua-cam.com/video/dSebkZaXoqc/v-deo.html
FileMaker Web Viewer in action
ua-cam.com/video/mWSshj1wS-Q/v-deo.html
~~~~~
Newsletter registration (early announcements for free live webinar workshops -- limited seats) ➜ bit.ly/2q82teI
#filemaker #filemakerforyou #fm4u
Переглядів: 3 163

Відео

FileMaker naming conventions - choose the right one for you! | Beginner Tutorial | FileMaker For You
Переглядів 7516 років тому
FileMaker naming conventions can be confusing camel case, title case, underscore what are they and more importantly can't you just name fields the way you want? Choosing the right naming convention is about people and computers. Satisfying the needs of both the people using the FileMaker database *and* the computers that you may need to integrate with for things like SQL databases, Salesforce, ...
FileMaker popover - protect data from accidental edits! | Beginner Tutorial | FileMaker For You
Переглядів 2 тис.6 років тому
A FileMaker popover is a smart way to protect your data from being accidentally changed. The convenience of viewing and editing data in the same layout is easy and awesome. It can also be dangerous! Even careful people can inadvertently make a change to a FileMaker record and not realize it. By adding a FileMaker popover to your layout and not allowing fields to be edited in FileMaker's browse ...
FileMaker text formatting: all in one place with one click! | User Tutorial | FileMaker For You
Переглядів 1,3 тис.6 років тому
FileMaker text formatting is really useful for making information stand out, but the tools are spread out in three different places: 1) under the Format menu, 2) in the inspector and 3) in the right click menu. Wouldn't it be great if you could access all of FileMaker's text formatting functions in one place with a single click? In this FileMaker tutorial I show you how in just one click you ca...
FileMaker conditional formatting for high quality work days! | Beginner Tutorial | FileMaker For You
Переглядів 1,4 тис.6 років тому
Use FileMaker conditional formatting to prevent data processing mistakes, increase productivity and bolster high quality products and services. Lists lacking FileMaker's conditional formatting act like a run on sentence. Without visual highlights, it is easy to miss key information that is critical for high product and service standards. In this FileMaker tutorial, I show you how introducing co...
Make your FileMaker layout responsive! | Beginner Tutorial | FileMaker For You
Переглядів 4,4 тис.6 років тому
FileMaker responsive layouts aren't just great for tablets and mobile devices - they're awesome for making the best use of space on your desktop! With the ability to auto-size objects on a layout including FileMaker fields, tabs, field labels and even web viewers, you have a great tool for making good looking layouts that are highly functional and more useful than their non-responsive alternati...
FileMaker save record automatically - avoid the gotchya! | Beginner Tutorial | FileMaker For You
Переглядів 1,1 тис.6 років тому
FileMaker's save record automatically has a hidden gothya there is no edit undo! When you accidentally make a change to a FileMaker record and want to undo the save, you find yourself stuck. There is no close the window and don't save changes, or alert that pops up to let you know you've edited the record and it's about to get committed. Having a save changes alert on layouts where someone coul...
Filemaker container fields: manage files and digital media! | Beginner Tutorial | FileMaker For You
Переглядів 4,7 тис.6 років тому
FileMaker container fields are an amazingly easy way to add document and digital media management to your database. A FileMaker container field can hold an image, pdf, movie, sound or document file. With this one field type you get a full range of possibilities for tracking your digital assets. In this FileMaker tutorial, I show you how to add files using the drag and drop, as well as the inser...
Create personalized emails with FileMaker email merge tip! | Beginner Tutorial | FileMaker For You
Переглядів 2,1 тис.6 років тому
Use this FileMaker email merge technique to easily and instantly create personalized email messages for everyone you contact. Including merge fields in your email is a time saving way to be a better communicator with your colleagues and customers. It's a marketeer's dream and essential to clear communication and you are only a few clicks away from having this magical tool - the FileMaker email ...
Are you missing out on this essential FileMaker find technique? | User Tutorial | FileMaker For You
Переглядів 4926 років тому
A FileMaker find is essential to creating lists and building reports that win grants and grow your business. But what do you do when you can't create the right FileMaker find request to get the results you need? In this FileMaker tutorial I show you how the order of your find requests has a huge impact on the results you get and how to order your FileMaker find requests so you get the right res...
FileMaker charts by month | Beginner Tutorial | FileMaker for You
Переглядів 6 тис.6 років тому
FileMaker charts are an amazing communication tool. You know right where you stand at a glance. But creating a FileMaker chart can be tricky. There are lots of boxes and options. It's hard to know which of FileMaker's chart options to pay attention to. Related blog post: ➜ bit.ly/2HaIhkx In this FileMaker tutorial, I show you the basics of building a chart including how to assign data and forma...
FileMaker duplicate alert - prevent duplicate entries! | Beginner Tutorial | FileMaker For You
Переглядів 3,8 тис.6 років тому
Creating a FileMaker duplicate alert is an awesome way to prevent duplicate entries from polluting your database. Duplicate records in your FileMaker database are a problem waiting to happen. They cause misunderstandings with important customers, shipments arriving at the wrong address and reporting errors that can cause embarrassment or revenue loss or both. Related Blog Post ➜ bit.ly/2GBfV5X ...
Learn faster with your favorite YouTube tutorial and how to videos! | FileMaker For You
Переглядів 1046 років тому
It's awesome to learn and even awesomer when you know how to learn faster with your favorite UA-cam inspirational, tutorial and how to videos. In this tutorial I show you a trick that allows you to watch UA-cam videos faster - up to 2x faster. That means you can learn from all the best educational videos in half the time! It's like speed reading, except it's speed watching. And once you know an...
FileMaker Web Viewer in action | Beginner Tutorial | FileMaker For You
Переглядів 4,5 тис.6 років тому
Filemaker's web viewer is a great way to gather intelligence automatically and in one place. Finding out as much up to the minute information as you can about a contact or a subject is vital. With FileMaker web viewer you can display information about your contact from their blog, Twitter, UA-cam and LinkedIn pages right inside the contact's record. You don't ever have to leave FileMaker! Relat...
FileMaker group report by month & year with a single field! | Beginner Tutorial | FileMaker For You
Переглядів 5 тис.6 років тому
Grouping sales by month and year is a common FileMaker reporting request. What do you do when there is no single field that will do the trick? If you use a FileMaker sub-summary part and sort by the order date, then all orders for that day will be grouped together. Not what you want. If you sort by month and then by year, you need two sub-summary parts and it is still not what you want. In this...
FileMaker Lookup vs Related Fields - Use Caution! | Beginner Tutorial | FileMaker For You
Переглядів 5 тис.6 років тому
FileMaker Lookup vs Related Fields - Use Caution! | Beginner Tutorial | FileMaker For You
How to add a FileMaker background image | Beginner Tutorial | FileMaker For You
Переглядів 1,8 тис.6 років тому
How to add a FileMaker background image | Beginner Tutorial | FileMaker For You
Use FileMaker new layout to create a safe data entry form | Beginner Tutorial | FileMaker For You
Переглядів 4,3 тис.6 років тому
Use FileMaker new layout to create a safe data entry form | Beginner Tutorial | FileMaker For You
Easy Excel summary reports with Filemaker's export group option | User Tutorial | FileMaker For You
Переглядів 2,7 тис.6 років тому
Easy Excel summary reports with Filemaker's export group option | User Tutorial | FileMaker For You
FileMaker's View menu - 14 cool tools to make work easier! | User Tutorial | FileMaker For You
Переглядів 8836 років тому
FileMaker's View menu - 14 cool tools to make work easier! | User Tutorial | FileMaker For You
Fast sales call lists in FileMaker - Get the phones ringing! | User Tutorial | FileMaker For You
Переглядів 2936 років тому
Fast sales call lists in FileMaker - Get the phones ringing! | User Tutorial | FileMaker For You
Easy Top 10 in any FileMaker list using omit multiple option! | User Tutorial | FileMaker For You
Переглядів 9436 років тому
Easy Top 10 in any FileMaker list using omit multiple option! | User Tutorial | FileMaker For You
Go paperless! Save / Send to PDF in FileMaker | User Tutorial | FileMaker For You
Переглядів 7606 років тому
Go paperless! Save / Send to PDF in FileMaker | User Tutorial | FileMaker For You
Use FileMaker's Extend Found Set to build great lists fast | User Tutorial | FileMaker For You
Переглядів 7286 років тому
Use FileMaker's Extend Found Set to build great lists fast | User Tutorial | FileMaker For You
Create an Excel report from FileMaker - no export required! | User Tutorial | FileMaker For You
Переглядів 9 тис.6 років тому
Create an Excel report from FileMaker - no export required! | User Tutorial | FileMaker For You
FileMaker's Snapshot Link - Share + quickly save your place! | User Tutorial | FileMaker For You
Переглядів 4736 років тому
FileMaker's Snapshot Link - Share quickly save your place! | User Tutorial | FileMaker For You
Filter your found set in FileMaker using Constrain Found Set | User Tutorial | FileMaker For You
Переглядів 1,8 тис.6 років тому
Filter your found set in FileMaker using Constrain Found Set | User Tutorial | FileMaker For You
How to save finds in FileMaker - automate your find routine! | User Tutorial | FileMaker For You
Переглядів 5516 років тому
How to save finds in FileMaker - automate your find routine! | User Tutorial | FileMaker For You
Sort by a FileMaker Summary Field (Who's performing? Who's not?) | User Tutorial | FileMaker For You
Переглядів 6466 років тому
Sort by a FileMaker Summary Field (Who's performing? Who's not?) | User Tutorial | FileMaker For You
Keep FileMaker records sorted - make this feature behave! | User Tutorial | FileMaker For You
Переглядів 5296 років тому
Keep FileMaker records sorted - make this feature behave! | User Tutorial | FileMaker For You

КОМЕНТАРІ

  • @KnitSwag
    @KnitSwag 11 місяців тому

    Perfect, just what I needed!

  • @sukhanjotsingh9281
    @sukhanjotsingh9281 Рік тому

    Can you also show what type of data is in field Month year

  • @zalman7208
    @zalman7208 Рік тому

    Wasted half hour trying to find the relatively simple answer before I got to your video. Took another 2:16 to solve my problem. Thank you.

  • @zoeanne5282
    @zoeanne5282 Рік тому

    Thankkkk youuuuuuu

  • @naisha9969
    @naisha9969 Рік тому

    How to export tables into separate worksheets under same file.

  • @CabaretDCT
    @CabaretDCT Рік тому

    Very helpfull however it took me a while to figure out that you have to 'click out' in order for FM to run the script in the Hide Object. Is there a way to run that Hide Object script when tabbing to the next field?

  • @robertleb800
    @robertleb800 Рік тому

    Could you show how to enter the data from the contract entry table to the actual database. Maybe show multiple tables which are related. Showing some data verification along the way would be supper helpful.

  • @robertleb800
    @robertleb800 Рік тому

    Could you make a vid showing how to move the records from the entry screen to the proper tables in the database?

  • @sarwathamdy
    @sarwathamdy 2 роки тому

    Thank you too much

  • @albertoreyes1137
    @albertoreyes1137 2 роки тому

    nice, short and clear

  • @therealjetlag
    @therealjetlag 2 роки тому

    How did you get column names on the File -> Export version, please?

  • @FeliceFarina
    @FeliceFarina 2 роки тому

    great video, you saved me! Is there a way to have a different background image for each record?

  • @jansaluba5227
    @jansaluba5227 2 роки тому

    excellent just what i wanted.

  • @osks
    @osks 2 роки тому

    Very nicely done!

  • @karlhedberg1566
    @karlhedberg1566 2 роки тому

    Very clear to understand :) Yea!!

  • @drmagnus1970
    @drmagnus1970 2 роки тому

    wonderfully clear, thanks

  • @akid803
    @akid803 2 роки тому

    Quick video but useful. Thanks

  • @dugontube
    @dugontube 2 роки тому

    Thank you - very helpful.

  • @nehaalone4848
    @nehaalone4848 3 роки тому

    I like your videos..keep posting please

  • @hamienator4707
    @hamienator4707 3 роки тому

    Hi, I need help :) I have a simple filmmaker budget database for the whole year with incomes fields, week, days, expenses and some other fields....my question is: is there a way to find the data only for specific week (lets say week 3 )? from Quick find I tried but I get no results and it shows all the data from beginning of the year! Am I clear enough? I need just to get the information for specific week P.S. I have also created a field for week number in the main layout and also in preview layout. Thank you :)

  • @muhammadshahzeb7061
    @muhammadshahzeb7061 3 роки тому

    you are the best.... thankyou

  • @michaelhuskey3225
    @michaelhuskey3225 3 роки тому

    Excellent video that is tremendously helpful. Thanks for taking the time to make the world a better place!

  • @harisdurrani8422
    @harisdurrani8422 3 роки тому

    Thanks...watching this video gave me idea how to omit top 10 records and award them position in my school database...really would like to say...English people when learn some thing they share it with others...and our people when learn some thing they dont share cause they think we will steal their knowledge.....sorry if my statement offends anyone...but truth is bitter

  • @davidford1094
    @davidford1094 3 роки тому

    Is it possible to implement a top ten list using a subsummary with subsummary inside that. ie top 10 producing products in a category showing total sales

  • @albertoreyes1137
    @albertoreyes1137 3 роки тому

    THANKS

  • @vanirayan5805
    @vanirayan5805 3 роки тому

    Thank you for the useful info. Also can you please explain how to create a related fields?

  • @josemanueljuanatey2994
    @josemanueljuanatey2994 3 роки тому

    Excelent, waht a teacher!!

  • @jonathancreamer2585
    @jonathancreamer2585 3 роки тому

    Anyway to do this on a 30 , 60 , 90 day range?

  • @scotty562
    @scotty562 3 роки тому

    One addition note is that the calculation field needs to be have it's calculation result set as date.

  • @michaelhuskey3225
    @michaelhuskey3225 3 роки тому

    Thank you for the great idea. I added a checkbox field next to the duplicate flag, called "HideDuplicate". I use a different field name than you, but I essentially hide the checkbox field using the following Calc, "Count ( Patients NameLast::NameFirst) ≤ 1". I then hide the Red duplicate warning with "Count ( Patients NameLast::NameFirst) ≤ 1 or Patients::HideDuplicate = 1" The "HideDuplicate" field is set to be a checkbox with a value of 1. I do this, because I would imagine that you may want to hide the warning occasionally for a common name like Robert Smith or José Garcia, that is actually not a duplicate.

  • @MoRabie-sn7qf
    @MoRabie-sn7qf 4 роки тому

    how to save the find in a variable and use it later?

  • @theeducationstation391
    @theeducationstation391 4 роки тому

    This helped, but how did you create a related field?!! I was kinda hoping you'd show how to do that too.

  • @albertoreyes1137
    @albertoreyes1137 4 роки тому

    thanks for the explanation. for me was not very clear how to allow or block related field

  • @Angelo1969s
    @Angelo1969s 4 роки тому

    very useful!!! Grazie ;)

  • @loganhayden8383
    @loganhayden8383 4 роки тому

    Nice simple explanation between Lookup and Related! Any tips if I actually want the field to be related?

  • @vanillasf
    @vanillasf 4 роки тому

    Thank you!

  • @patricktheberge1144
    @patricktheberge1144 4 роки тому

    How do set up a script to do this?

    • @akid803
      @akid803 2 роки тому

      I think you need Global fields to capture what you want to search and use them in the script.

  • @labautoman
    @labautoman 5 років тому

    update: it does work but not for finding records that do not have a related record in another table

  • @labautoman
    @labautoman 5 років тому

    does not work

  • @mostirreverent
    @mostirreverent 5 років тому

    Great! Concisely answered my question after watching videos about each type, where authors neglected to mention the differences. It is a very fine point, especially since there are connections made on the tables tab in both types of situations (Lookup and Related Fields)

  • @PurplesinnerW
    @PurplesinnerW 5 років тому

    bless you this saved me

  • @taylorralston4702
    @taylorralston4702 5 років тому

    This isn't responsive design. It just makes the elements stretch as your window expands/contracts. Responsive design means this and so much more. It means reflowing of objects based on screen dimensions. For example, viewing your layouts on a phone in portrait mode would either shrink your elements so small to see, or require a lot of scrolling across. A truly responsive design (which Filemaker and Web Direct does not support yet), would mean that you could render specific objects in different positions on your layout (such as a table reading across for a row, to a row reading vertically).

    • @taylorralston4702
      @taylorralston4702 5 років тому

      Here's a starting point: www.smashingmagazine.com/2011/01/guidelines-for-responsive-web-design/

  • @robmonkriedlinger
    @robmonkriedlinger 5 років тому

    Thanks for this

  • @mamunurrashid5652
    @mamunurrashid5652 5 років тому

    Thank you...

  • @developerdeveloper8048
    @developerdeveloper8048 5 років тому

    Great info ... Thanks!

  • @meganh.3829
    @meganh.3829 5 років тому

    Thank you! This was super helpful - I really appreciate you taking the time to make this video!

  • @johnmurphy3951
    @johnmurphy3951 5 років тому

    Fantastic hack, thank you

  • @robmonkriedlinger
    @robmonkriedlinger 5 років тому

    Thank you for this - it was a quick and easy implementation which really helped me on a project!

  • @timmullins3463
    @timmullins3463 5 років тому

    Oh forgot to say that I found your video very informative. :-)

  • @timmullins3463
    @timmullins3463 5 років тому

    How do you set the container field so that you can open a image file with mspaint or other image viewer program?