Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ActiveDocument.ScrambleField "Field" Macro doesnt work

Hello

i had a requirement to scramble a certain field if the Var XX= 0.

i triggered this macro on the " OnOpen "

IF ActiveDocument.Variables("XX").GetContent.String ="0" Then

  ActiveDocument.ScrambleField "Field",false

End If

i accessed the model with a user that was configured with XX= 0 and the result was that  sometimes it opened up  the model with a scrambled field and sometimes it didn't  ????

any ideas on how i can scramble a field upon a certain condition ????

Thanks a lot

J

3 Replies
fkeuroglian
Partner - Master
Partner - Master

Hi, you test in the acces point or in the desktop?

you can do this not using a macro , using a trigger could be easier and it works ok in the desktop and the acces point

go to

document properties - trigger

Good luck

Fernando

Anonymous
Not applicable
Author

a trigger that does what?

Anonymous
Not applicable
Author

i read some more in the community and i found out that there is a problem with the

OnOpen Document Event Trigger it doesn't work in AJAX

any ideas on how to scramble a field  according to your NT user privileges?