Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshikaul
Creator II
Creator II

How to lock a field value using variable

Hi 

I am interested in locking a field value with the help of a variable. For eg if I want a selected filter has two values 'yes' and 'no ' and I want to give users only  single option (NO) to select the other value I want to lock/disable 
How can we achieve this?

I want to the user can only select 'No' for flag field and other option ie' YEs' should be disabled for selection. How can this be achieved

?

sakshikaul_0-1694695317460.png

 

Labels (6)
11 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

 

You can check "Always one selected value" in properties

 

Aurelien_Martinez_0-1694696352044.png

 

Help users find answers! Don't forget to mark a solution that worked for you!
sakshikaul
Creator II
Creator II
Author

No, but this is allowing me to select the other option as well but I want user can only select 'NO' other option'Yes' should be disabled/locked for the user . The user should not able to select Yes

 

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Ok, you can:

add "hide excluded"

Aurelien_Martinez_0-1694697321489.png

 

or create a new flag with only No option for user and you, you can use the old one.

or add a section acces with a restriction on this flag (no for all user and Yes/No for you)

 

Help users find answers! Don't forget to mark a solution that worked for you!
sakshikaul
Creator II
Creator II
Author

Selecting 'hide excluded' option is working fine but I am not able to see the' YES' option. I want the Yes option should be there but user cannot select it 

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

or you can "Lock" your selection on No. But I think user can unlock

 

Aurelien_Martinez_0-1694698282140.png

 

Help users find answers! Don't forget to mark a solution that worked for you!
sakshikaul
Creator II
Creator II
Author

This user can unlock that is the reason I want to create a variable in which i can call lock trigger and the with the help of variable I can manage selection of field in the list box 
Is that possible?

 

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

You can try with Field event triggers (in Settings>Documents Properties>Triggers)

Aurelien_Martinez_0-1694700671784.png

 

Help users find answers! Don't forget to mark a solution that worked for you!
sakshikaul
Creator II
Creator II
Author

Can you please tell me what am I required to do?

in Settings>Documents Properties>Triggers)

I have selected 'onAnySelect' option -> then I selected selection in field-->'flag' -->search string -> 'No'

sakshikaul_0-1694701593396.png

What are the next steps am i required to do?

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

I have create a "Filed Event Triggers" on Flag field to Lock when user unlock

 

Aurelien_Martinez_0-1694702043539.png

 

Help users find answers! Don't forget to mark a solution that worked for you!