Solved

FM - Gathering Email Addresses from a Found Set

Posted on 2014-01-23
2
336 Views
Last Modified: 2014-01-23
We are now able to text message our tenants.  However, now my boss wants to be able to send a text message by any Found Set he wants, e.g., all Pizza Places, etc.  So, the usual List() function doesn't seem to apply.  

I'm thinking of a two-step process:  1) Give him a drop down list of the most common found sets, and 2) in case he chooses a found set of his own. have a button called TEXTMSSG that would Loop through and stuff all the text message addresses into a global field and then open up a local Outlook with the global assigned to the TO field.  Is that the most efficient and flexible method?  Thanks.
0
Comment
Question by:rvfowler2
2 Comments
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39804600
The looping option is the most common and in fact prior to the advent of the List() function was pretty much the only option.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 39804754
I like to give credit, even for confirmations, since I like to confirm whether I am using a best practice or not.  Thank you.  P.S. - Personally, I prefer calc fields rather than loops whenever possible because I find the more the moving parts, the more chance for errors.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now