FileMaker Pro Custom Functions

I'm working with your CF, but I don't know the reason when the parent only has one value selected, always MISS an a paragraph. Per exemple:
Parent1
value1Parent2
value1
value2

When It should be:
Parent1
value1

Parent2
value1
value2

Any ideas would be very appreciated!!!

Serp, Barcelona
September 01, 2009 4:25am

Great CF - thanks, Don!

I ran into the same issue and found that the parentDelimiter is only called in the result of the first argument of the base case statement. It needs to be called in *both* the first result and the default result, as part of the embedded Case statement (and then the childDelimiter removed from the beginning of the first result). I also added another argument in the embedded Case statements to skip the delimiter entirely for the last value, so as not to end with a final delimiter. Here's my modifications:

Case (
GetNthRecord (parent; startValue ) = GetNthRecord (parent; startValue - 1);
childMarker & GetNthRecord ( child; StartValue ) &
Case (
Not IsValid ( GetNthRecord ( child; startValue + 1));
"";
GetNthRecord (parent; startValue ) ≠ GetNthRecord (parent; startValue + 1);
parentDelimiter;
childDelmiter
);

GetNthRecord (parent; startValue ) & childDelimiter & childMarker & GetNthRecord ( child; startValue ) &
Case (
Not IsValid ( GetNthRecord ( child; startValue + 1));
"";
GetNthRecord (parent; startValue ) ≠ GetNthRecord (parent; startValue + 1);
parentDelimiter;
childDelmiter
)

)

&

If(IsValid(GetNthRecord ( child; startValue + 1));
GetValueSet_MultiLevel ( child ; parent ; startValue +1; childMarker; childDelimiter; parentDelimiter))

Katherine Simpson, Valencia, CA
October 17, 2010 3:40pm