Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Email Field Merge Problem

Featured Replies

  • Newbies

I am a new user and I am sure there is a simple solution. I have a large database of volunteers that I want to personlize emails to so I select the SEND MAIL feature...I specify a field name in the message (Tech Contact::First Name). If I don't put any other text in the box it correctly inserts the first name corresponding to the appropriate email...however I don't know how to insert any other text. When I insert something after that it asks for an OPERATOR and if I insert for example "Hello....then the field name" it puts just that in the email "Hello TECH CONTACT::FIRST NAME" This could be the easiest thing ever but I can't figure it out and it is honking me off....please help.

anything that isn't enclosed in "" filemaker assumes to be a fieldname or a function call. So to do your task we would use the following (i've tried to mix and match a bit so you can get the idea.

"Hello " & TableName::FirstName & ",¶¶How are you today?¶¶Affectionatley Yours,¶¶" & Get(AccountName)

except the ¶¶ needs to be enclosed in "" i.e. "¶¶"

:P

They are enclosed, look carefully... i probably should've used spaces i wasn't sure myself at first

You are correct, I missed them.

Lee

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.