-
Similar Content
-
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”.
Register Here:
https://attendee.gotowebinar.com/register/6892433068111504642
We will spend 30 minutes covering a specific topic. Then the last 30 minutes will be an open Q&A on any topic.
Topic List:
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,
Richard Carlton
CEO & Video Trainer
-
By Spoutnik
Hello everyone,
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:
<<contact>>
<<name>>
<<street>> (etc)
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?
contact
name
street
Apologies if this is very simple, I am completely new to File Maker.
Any pointers would be gratefully appreciated!
Cheers
-
By chaversteve
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
Hi.
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?
Appreciated, Karlos.
-
By fantasmamore
Hello all!
I have a database with a number of fields. I have designed a print layout and I used merged fields. Here's an example:
Title1<<field1>>,
Author: <<field2>>
<<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
Author:
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!
-
-
Who Viewed the Topic