Coffee cups indicate the complexity of a file, tip or article. One coffee cup is the easiest and three is the most advanced.
To download a file, click on the green arrow icon next to the listing. If there are no coffee cups
or platform icons, the listing may be an article, Quick Tip, Knowledgebase or bonus file.
Indexes make finds fast! But, indexes also support a bevy of other features such as relationships, value lists and validation. This blog entry will explore the definition of an index from a FileMaker point of view as well how it is used throughout the application.
Interactive PDF WoesQuick Tip
Common Issues with Interactive PDFs
A lot of people wonder why the Insert PDF option is dimmed or greyed out under the Insert menu even when they have a container field selected. The two most common reasons, other than installation issues, are the interactive option is not checked and the container field is in a portal. Start by going to layout mode, click on the container field and display the Inspector. Navigate to the Data tab and scroll to the bottom to see if “Interactive Content” is selected. If the Insert PDF option is still not available, it is likely your container field is in a portal and interactive PDFs are not available for size and performance reasons. Consider inserting the PDF as a file. It can still be opened with your favorite PDF reader using the Export Field Contents step but won’t be interactive inside FileMaker.
Professional developers pay attention to the number of files in their FileMaker solutions because it’s a crucial factor in good database design. Most developers utilize the standard single file structure because it makes development easier. On larger multifaceted projects, a developer might use several files for separate areas of the company. A smaller set of developers like to use the separation model to avoid issues with updates to their solutions and other benefits that will be explored. It’s very important to choose the file structure the best suits your style as well as the project at hand.
Script Triggers are one of the most fascinating features in FileMaker. Triggers augment existing features like auto-enter and validation as well as introduce completely new functionality not available through button driven scripting alone. The ability to define a script to execute based on a defined event fills so many gaps, their power can never be underestimated.
Send Text Messages via Twilio
Twilio allows you to send SMS text messages using an http call. This is great since FileMaker doesn’t have a send text feature. This tip file discusses how to use Insert from URL to communicate to Twilio.
Reminders with the Install OnTimer step
How to create a reminder system, as found in a calendar solution, using the Install OnTimer Script step. Complete video set at Thinkific.