Skip to main content

Hello,

What is the best way to insert multiple records into a workflow email using a single smart object? 

I have a table that holds records for multiple transactions based on a single main transaction. When I insert the smartobject reference into the email it just inserts the records for each entry together 

e.g. 

TransactionNameVariable appears as 'Test1Test2Test3' in the email (3 records found for the main transaction)

 

Any suggestions on a method to use to display them separately?

 

Thankyou

 

Hi


See similar post below:


https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Insert-a-List-view-multiple-records-in-an-email/td-p/103163


 


Regards


Elvis


Hi  @bbn2 ,


 


Would you be using a Loop step to loop through a list of records? You can make use of a loop index that uniquely identifies the current record in the reference and returns a single item.


This will require a table column with a sequential number that starts from 1 to match the Loop Index (which starts from 1). To display the fields in your email step, you need to call the properties directly from the SmartObject.


https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#How-Tos/LoopSQLMethod/How-To-Loop-through-SQLmethod.htm


 


 


Regards,


Kimberly 


 


K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.


Reply