How can I set up the "NewUserPassword" in the Properties in the "Manage PDF Password" activity based on a Excel file database?

Help Studio
, ,
1

I’m already able to put a NewUserPassword on the Properties ( “1” in the below example)

image
image1436×709 31.5 KB

Now, I want to protect my file with the Birth date(password) if Lookup filename is found and put this Birth date(password) under the field “NewUserPassword”.

image
image884×198 12.4 KB

How to do that? Do you have an idea? Should I use a lookupdatatable activity?

Thanks in advance for yourhelp
Maic

2

hI @mce

Yes you can use lookup datatable and get the row index and set your target column as Birth date(Password) and create a variable in cell value to get that and use it

Regards
Gokul

1 Like
3

Can you show me an example?

4

Have you used Lookupdatatable in your previous projects?

5

@mce

And how will you differentiate each PDF with the name right

So use like this
image

Look up value : Margrit Hirschi
Column Name or Column Index field anyone should be filled : “Name” or 1

Target Column Name or Column Index must be filled in order t get the cell value: “Birth date (password)” or 2

And create variable in cell value you will get the value as 20211207 and you can use this variable in your manage password

Regards
Gokul

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.