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

Discussion

Discussion

Clear a dropdown lookup and a few text fields once a checkbox has been checked

Forms
Updated April 1, 2022
posted on March 31, 2022

The idea is I provide a lookup of principals and directors.  Unfortunately, there are people that are not classified as such in AD and need to be in that list (designee).  IF they select a checkbox, I give a textfield that they enter NetworkID in and do a lookup for that person's networkID.

Issue is I am trying to use 1 field to use for the routing because I can't clear values.  

Is there a way to refresh the lookup and those text fields?

 

 

Thanks,

Sue

0 0
replied on March 31, 2022

How about having both lookups go to separate hidden fields, and then use a calculation on the visible field to populate from the appropriate hidden field based on whether the checkbox is set?

1 0
replied on April 1, 2022

Thank for responding James :)  I'm new to if statements in forms.  I was playing around with it and this is what I have:  

Field: Principal/Director/Designee Username: 

=IF(checkbox_principal_dir_desig_.My_Principal_Director_Designee__is_not_listed=TRUE, hide_designee_EmpLoginID)  

Error: Field contains a calculation error.

Not sure what I'm missing...

Thanks!

 

0 0
replied on April 1, 2022

I see I forgot a value now :)

=IF(checkbox_principal_dir_desig_.My_Principal_Director_Designee__is_not_listed=TRUE, hide_designee_EmpLoginID,Principal_Director_Designee_Username_)

Learn something new everyday!!  Love it!!

Thanks again :)

0 0
replied on April 1, 2022

:)

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...