Multiple reference Concatenate in single Attribute

weblike

Hi,

Does anyone knows how to implement this?

Multiple reference attributes to populate a single Attribute(html) and every reference to be a new line in html attribute?

For example I have multiple bank accounts for a Customer, but I want only 2 to appear on the invoice template.
So, in invoice I insert those 2 bank accounts which I want to appear on the invoice.

I want to avoid LIST_TABLE_START so i want to have 1 attribute (plain text) which is updated with added/removed references.

Have anyone done this?

Thx,

customaware

Hi Georghe,

I do it by FINDing the Reference records I want and concatenating them into a single html attribute so when placed on a form it
appears like a bulleted list.

Country.ExpenseClaimNotesHTML=UNDEFINED
FIND CountryExpenseClaimNotes WHERE CountryExpenseClaimNotes.ob_Country=Country ORDER BY CountryExpenseClaimNotes.NoteOrder IN BATCHES OF 1
Country.ExpenseClaimNotesHTML=Country.ExpenseClaimNotesHTML+'<li> '+CountryExpenseClaimNotes.Note

BenHayat

eagles9999 wrote
Hi Georghe,

I do it by FINDing the Reference records I want and concatenating them into a single html attribute so when placed on a form it
appears like a bulleted list.

Country.ExpenseClaimNotesHTML=UNDEFINED
FIND CountryExpenseClaimNotes WHERE CountryExpenseClaimNotes.ob_Country=Country ORDER BY CountryExpenseClaimNotes.NoteOrder IN BATCHES OF 1
Country.ExpenseClaimNotesHTML=Country.ExpenseClaimNotesHTML+'<li> '+CountryExpenseClaimNotes.Note

Nice Mark!

UnionSystems

I think you can get the same result with

Country.ExpenseClaimNotesHTML=LIST_LINE('FIND CountryExpenseClaimNotes WHERE CountryExpenseClaimNotes.ob_Country=Country','','<li>','Note')

UnionSystems

UnionSystems wrote

I think you can get the same result with

Country.ExpenseClaimNotesHTML=LIST_LINE('FIND CountryExpenseClaimNotes WHERE CountryExpenseClaimNotes.ob_Country=Country','','<li>','Note')

That was missing a parameter should have been

Country.ExpenseClaimNotesHTML=LIST_LINE('FIND CountryExpenseClaimNotes WHERE CountryExpenseClaimNotes.ob_Country=Country','','','<li>','Note')

Jaymer

---> Country.ExpenseClaimNotesHTML=LIST_LINE('FIND CountryExpenseClaimNotes WHERE CountryExpenseClaimNotes.ob_Country=Country','','','<li>','Note')

Nice !!!
1) I've seen two uses of LIST_LINE
a) email CC,BCC as in the docs
b) on a query (posted in the forum)

People in class     Not in class
bob, sam            sally, mary, tom

So thats a cool use you came up with there - I think there lots of folks who have not played with the LIST_ functions.

2) Using that, I wonder if that can be used on a form and calculated DYNAMICALLY (or on-demand) instead of pre-calc like Mark likes to do it.
He is a fan of pre-building HTML links inside data files - I know 'space is cheap' and all that, but using his plan, the pre-built strings take up more space than the actual data.

jaymer...