Help with Lasso and Repeating Fields?

[misa]

Hi everyone,

I ended up having a database job assigned to me at the last minute. Someone else had already built the database (in FMPro 6), relying on repeating fields. I am using Lasso to pull the information out of FMPro fields, and I'm having a lot of problems with the repeating fields.

For example, there can be a maximum of 20 records per repeating field. I want Lasso to only list the fields that actually have something IN it, instead it's currently listing fields that have something in it AND fields that don't have anything in it.

So, I get something like this:

UNIT COST:

$3,480.00

$35.00

$8,400.00

$900.00

$900.00

$900.00

$900.00

$2,100.00

$5,200.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

I've tried a few things to get it to stop doing this, such as:

[if: ('UnitCost') !=''][Repeating: 'UnitCost'][Currency: Repeating_ValueItem]<BR> [/Repeating][/if]

And:

[Repeating: 'UnitCost'][if: ('UnitCost') !=''][Currency: Repeating_ValueItem]<BR>[/if][/Repeating]

Neither work, I keep getting the same thing. The same is true on non-Currency fields except I get a blank line with a <BR> instead of $0.00.

I also tried a couple of WHILE statements but that just killed the Lasso file completely.

Does anyone know how to fix this problem? I'm on a due-tomorrow-deadline and I barely know Lasso at all (I'm a PHP person) so I'm ready to go beat my head against a wall.

Many thanks for any help and happy computing to you all,

Misa

[misa]

Hi all,

I figured this out on my own...

UnitCost is the name of my field, so just insert your field name there. The rest should be the same.

[Repeating: 'UnitCost'][if: (Repeating_ValueItem) !=''][Currency: Repeating_ValueItem]<BR>[/if] [/Repeating]

If you are doing a regular repeating field (not currency) it would be (my field is EstDelDate -- replace that with your field):

[Repeating:'EstDelDate'][if: (Repeating_ValueItem)!=''][Repeating_ValueItem]<br>

[/if] [/Repeating]

I hope this helps someone else,

Marisa