Library System

Help
, , ,
1

image
image2016×1512 1.57 MB
Hi,

I’m currently working on a library system where the librarian will scan the book/magazine borrowed/returned by the user. By running the RPA the following day, it will send the user an email saying the title, loan date as well as the due date. However, how do i send an email with more than one title when the user borrow more than 1 book/magazine? Sorry if the images are blurry, using an intranet laptop.

image
image2016×1512 1.21 MB
image
image2016×1512 1.72 MB
image
image2016×1512 1.79 MB
image
image2016×1512 1.75 MB

2

Hi @TOBIAS_TOH_TENG_KIAT,
You should either consider sending separate mail per book or build additional step where process will check for duplicates in usernames and if there will be more that 2 records then write email with body consist of these many titles.

3

Hi @TOBIAS_TOH_TENG_KIAT

In addition to what @Pablito said

It would be easy if u send mail in tabular format same as shown as table

For one row of data u can send mail in tabular format Accordingly.

I think it would be an easier approach

Hope it helps you

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

1 Like
4

How do I check for duplicates in usernames

5

You can for example use a method to count how many times particular user exist in your data table. Use assign activity and use expression:
`.DefaultView.ToTable(True, )

This will return you another datatable where each user will be counted by how many times he was in the source datatable.