Concatenate -unknown number of instances


i'm sure extremely basic issue (stupid scripting question) -and appologize in advance.
i've got form in there 2 fields names of relevant parties ('mortgagee' , 'mortgagor'). in cases there 1 or 2 names per field -but in there may 3, 4, 10 or more. in each field multiple names should show either comma or "and" in between them ("allison j. williams, jeffrey simmons , megan nelson")
i've got fields (mortgagor , mortgagee) tied repeatable subform (sfmortgagor , sf mortgagee) containing unparsed name field (and parsed name elements). subform , parsed/unparsed fields bound schema.
i've been using formcalc concat script limited success.

concat(sfparties.sfmortgagor[0]._unparsedname, space(1), sfparties.sfmortgagor[1]._unparsedname)

so far i've gotten work 2 names when call each instance specifically.
when try use sfparties.sfmortgagor[*]._unparsedname grab names can't figure out how make put comma or "and" in between -or space matter!
i'm sure i'm mis-using [*] in accessor (or i'm clueless , have mucked up) -but can't figure out. i've been through of javascripting references , through of examples can find, no luck.
if out there take pity on me , steer me in right direction i'll forever grateful.
jennifer

i've discovered need script checks see if instances there before concatenating.
i've tried number of variations on if/else script no avail.
currently data imported via button on have script set trigger yet button if/then script (i've learned designer doesn't on 1 object).
i guess need know how check see if exists or not? found brief reference exists(myfield) script in ref docs can't make work.
any ideas?????
thanks!!
jennifer


More discussions in LiveCycle pre-ES (6.x and 7.x) discussions


adobe

Comments