AnsweredAssumed Answered

creating a packing list for shipments

Question asked by krberb on Feb 10, 2010
Latest reply on Feb 10, 2010 by Marx

Title

creating a packing list for shipments

Post

Hi all,

I just started with Filemaker and have been able to find answers to most of my questions, but I can't seem to find one that quite fits this one.

I'm creating a packing list for order shipments -- I have several fields that may or may not contain data.  I want to put these fields on the packing list as just a line of data with a "," in between each piece of data.  I can list all the fields on the packing list but if there are fields that are empty, then I have a bunch of spaces and carriage returns.  I want to remove any empty spaces and put the "," in betwen each field that does have data - hope that makes sense.

 

example:

field1 = " labor "

field2 = empty

field3 = " shipping "

field4 = " Antenna "

field5 = empty

so forth and so on......I have 22 fields, so if there is only 2 with data, I could have a bunch of spaces on this list.

 

I am able to make it show:

 

labor  shippingAntenna

 

I would like my packing list to show:

 

labor, shipping, Antenna

 

Thanks in advance.

Kevin

 

Outcomes