I have a calc field for my recipients and I want it to ignore empty
fields. There are 5 repetitions. and it looks like this:

database::resource[1] & "@xxxx.com" &
database::resource[2] & "@xxxx.com" &
database::resource[3] & "@xxxx.com" &
database::resource[4] & "@xxxx.com" &
database::resource[5] & "@xxxx.com" &


How do I get this script to ignore the lines if it is empty? As it
stands I get "@xxxx.com" in my recipient line for each empty
repetition.

"dvfx" <damienvfx (AT) gmail (DOT) com> schreef in bericht
news:b4d41097-9070-4cff-bbfa-3e81bc638858 (AT) k25g2000prh (DOT) googlegroups.com...
You really should chuck out those repeating fields. They are a paint in the
but to work with. Only use them for GUI graphics. Then as and when you
really understand their limitations you might reconsidder using them.



--
Keep well / Hou je goed

Ursus

On Jun 17, 5:35*am, "Ursus" <ursus.k... (AT) ziggo (DOT) nl> wrote:
I know. Not my ideal plan, but until I can create a new resource
table on my next iteration of this DB I was looking for a temp fix.

On 6/17/2010 8:54 PM, dvfx wrote:

case( not isempty(database::resource[1]), database::resource[1] &
"@xxxx.com") & ¶ &
case( not isempty(database::resource[2]), database::resource[2] &
"@xxxx.com") & ¶ &
case( not isempty(database::resource[3]), database::resource[3] &
"@xxxx.com") & ¶ &
case( not isempty(database::resource[4]), database::resource[4] &
"@xxxx.com") & ¶ &
case( not isempty(database::resource[5]), database::resource[5] &
"@xxxx.com")


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker Certified Developer
Associate Member, FileMaker Business Alliance

On Jun 18, 1:57*pm, Howard Schlossberg
<how... (AT) nospam (DOT) fmprosolutions.com> wrote:
Great, that worked well!

On Jun 18, 3:37*pm, dvfx <damien... (AT) gmail (DOT) com> wrote:
Just in case anyone is following this thread, it turned out that I
needed to create a separate table after all. It took a little more
time to set up, but increased the amount of information that I was
able to track ten fold. All of my related calc fields were much
happier.