- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 06:59 AM
Good Morning everyone,
so i have a tricky request here.....
I have this list collector that is looking up information from the sys_user table on a record producer.
Once the request form is submitted what i would like is to have the users listed in the list collector to be collected and formatted into a table like form on a HTML variable for the fullfiller to see but also i want one column of the table structures be like this
| Name | Department |
| John Smith | Accounting |
| Jack Wilson | HR |
but i also want to have the information organized via department meaning everyone from the same department be groups together like this
| Name | Department |
| John Smith, Jacky Ya, Peter Tyer | Accounting |
| Jance Yi, Aaron Nunes | HR |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 07:39 AM
i was able to figure it out via Business Rule
Created the BR on the Record Producer
Setting is After -> Insert and Update
Script is
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 07:17 AM
You want to send that format in the email? Did you try any approach?
Similar questions on adding table in email are answered below, Give a try and let us know the updated code so that we can help you out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 07:23 AM
No Basically take the list collector information here and format it into a table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 07:26 AM
You can use the same approach to build the table using html tags
write a BR to update the description field when your list field changes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 07:39 AM
i was able to figure it out via Business Rule
Created the BR on the Record Producer
Setting is After -> Insert and Update
Script is