FileMaker Tips & Tricks

Updated by Kamika Royal on Oct 28, 2024

The Basics: You can use these hotkeys in the search fields in Filemaker to make it easier/quicker to search using your keyboard!

CTRL + N --> Opens up a new note

CTRL + A --> Highlights all text

CTRL + C --> Copies all highlighted text

CTRL + V --> Pastes copies text

CTRL + - (hyphen) --> Inserts date

CTRL + ; (semi-colon) --> Inserts current time

CTRL + S --> Submits entered text (In PS screen this will open up the search panel results. You can save a note just by clicking outside the box)

CTRL + G --> Clears search fields

Performing the search: These shortcuts will make it easier to find exactly what you are looking for when actually performing a search in Filemaker.

... = Date Range

For example, if you’re trying to search for a return placed between 12/15/16 and 12/31/16 you would entire it in the date field as 12/15/16...12/31/16 and BOOM! You get all the returns within that date

// = Today’s Date

For example, if you wanted to type today’s date into a search field, you could instead just type // Aww yeah! Savin’ those keystrokes!

! = All

For example, to find all orders placed within a certain date range, enter your date range and then enter ! for the company name or account number. VOILA! You get all the orders within that date range.

> = Greater Than or After

< = Less Than or Before

For example, you could put >50000 in the Total Value field on the Orders Advance Search screen and find all the orders we’ve had that are over $50,000. And, yes, we’ve had several! Bell Ringer x 100!

For another example, if you put <1/15/10 into the Order Date field of the same screen, it would show you all orders placed Before 1/15/10.

* = Fill It In, FileMaker!

For example, if you enter J*N in the contact field, FileMaker will find every contact that starts with J and ends with N (John, Joan, Jalen, Jen, etc.). This could be SUPER useful if you forget how to spell a Customer’s name but have vague idea and some other info like their order date!

Before you ask, YES, you can put these together to make super ninja-efficient level custom search parameters.

Added tips for using the Advanced Search screens:

- Look at all your fields available. You’d be surprised what you can use!

- Use multiple fields to have narrow your searches.

- Partial information is awesome! Ex: area code and a first name could pull up your Customer!

Please email HDSAnswers@headsets.com if you find any other tips and tricks and this article will be updated!

What is Headset Answers?

This is the internal support database for Headsets.com. We manufacture and sell office headsets in North America. With over 25 years' experience in the business, we know headsets.

Please use our support database for free headset support, whether you’re a Customer of ours (or not). If you have problems, suggestions, or unanswered questions, please email us at hello@headsets.com (compliments also welcomed 😀)

Looking for office headsets in the UK? Check out Headsets.co.uk.

Leitner LH470 Wireless Dongle Headset
Leitner Headsets logo

Ready for a better headset?

What is Headset Answers?

This is the internal support database for Headsets.com. We manufacture and sell office headsets in North America. With over 25 years' experience in the business, we know headsets.

Please use our support database for free headset support, whether you’re a Customer of ours (or not). If you have problems, suggestions, or unanswered questions, please email us at hello@headsets.com (compliments also welcomed 😀)

Looking for office headsets in the UK? Check out Headsets.co.uk.

Questions/comments?