You are viewing limited content. For full access, please sign in.

Question

Question

Remove lookup values from textbox

Forms Laserfiche Ideas How To
Updated May 31, 2024
asked on May 31, 2024

Hello ,

We are using lookup query to auto populate textbox.

While we select Agenda RIN = "NO" we need to call lookup and auto fill RIN textbox.

When we select Agenda RIN = "yes" we need to hide the auto fill that we got from above step but its shows that selection. How we will clear that auto fill ?

 

Thanks,

Pratik

 

 

Remove autofill while select yes.png
Remove autofill while select yes.png (8.39 KB)
Download
0 0

Replies

replied on May 31, 2024

A lookup rule will always apply to a field. If you only want to use the lookup under specific conditions, then I'd suggest using separate fields or something along those lines.

You could have two separate fields, one with the lookup and one without that show/hide based on your dropdown selection. Then, you could add a third hidden field to store the final value with a calculation to determine which of the two fields to use.

=IF(Agenda_RIN="No", Lookup_RIN, Manual_RIN)

Just make sure the if condition matches the actual value coming from the dropdown.

1 0
replied on May 31, 2024
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...