Solved

FM - Gathering Email Addresses from a Found Set

Posted on 2014-01-23
2
343 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 25

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

820 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