By Richard Carlton
Summer is over and our weekly FileMaker webinars are back!
Our first one is this Thursday at 11am PDT, on “Relationships for Beginners”.
We will spend 30 minutes covering a specific topic. Then the last 30 minutes will be an open Q&A on any topic.
Sept 13th: Relationships for Beginners
Sept 20th: Find Records, Date Ranges, and Special Operators
Sept 27th: Conditional Formatting (Can I making something Red?)
Oct 4th: Automation (Repetitive Tasks can become Scripts)
Oct 11th: Reporting & SubSummaries
Oct 18th: Merge Fields and Hiding Objects (Harry Potter Invisibility Cloak)
Oct 25th: Sharing your FileMaker App with Co-Workers
Nov 1st: Basic Concepts for Building Mobile Apps
All the best,
CEO & Video Trainer
My company uses File Maker to keep a record of customers' addresses. When looking at a given customer, I would like to be able to copy the whole address block (as displayed on screen) to be able to paste it somewhere else (for instance, in an email, or on a Word document).
You can't do this from the layout for data entry, but we have another layout showing the address block as a succession of merge fields (see screen shot). I added a copy button, all it does is copy what's on screen to the clipboard.
The problem is that, even though the layout is separated by carriage returns like this:
When I copy and paste I get a succession of data separated by empty spaces (tabs), like this:
contact name street
Is there a way to add a line break between the merge fields so when I copy and paste to Word or else, I get this instead?
Apologies if this is very simple, I am completely new to File Maker.
Any pointers would be gratefully appreciated!
How can I set and change the font of a merge field that will appear in a mail merge letter? Especially when it is a different font from the font as used in other layouts?
I am having special difficulties with merge field numbers that are dollar amounts. I cannot get Filemaker tout commas in the right places of the merged 5 or 6 figure number.
By Karlos Fandango
I have a text field for entering the description of work being quoted for, almost every description will vary in size on each quote, all other fields aren't a problem, only this one because it needs user input on every quote, input that varies in text length.
My problem is this, that when I add this text field as a 'merge field' to a letter, it doesn't automatically resize to fit the description for work to be done. In the inspector>Position>Autoresizing I have the top and left anchors locked, which I thought would have allowed the field to expand to the right [though I don't want it to overshoot the page] and down. However the field isn't expanding at all, but clipping the text.
I think I understand 'sliding', but I don't believe that reflects in anyway on this issue.
Should or can a 'merge field' autoresize to adjust to differing text lengths entered on another layout, or am I expecting too much?
I have a database with a number of fields. I have designed a print layout and I used merged fields. Here's an example:
<<field3>>, is happy with <<field4>>... and so on.
Which is great, I can format the fields as I like, I don't care if a field contains 3 words or 3 paragraphs, because everything is so flexible. But there are times that a field like field2 is empty. Then the output becomes
Jason makes a new friend
Jason, is happy with his new friend...
Yeah, I know, stupid example, but you see where I am going... If field 2 is blanc, then the print output turns out a bit strange. Is there any way to tell the db that **if <<field2>> is blanc then don't display it**? Could I write something like <<Author: field2>> so that I make everything disappear if the specific field is empty?
And another question.
Can I use a background colour for my merge fields that covers all the width? I want it to be dynamic, so if I have only a couple of words, the background will be one line, but if I have two lines of content, then the background for the specific field will automatically become two lines. Just as the example in the attached image. I don't want to "highlight" the content, I want to use a background...
I am not sure if any of the above is possible. However thank you for reading this and for your help!