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

Question

Question

Lookup rule on a bit field

asked on August 25, 2017

I have a number field in the form and it has value 1 or 0. I have a lookup rule based on this and field in the database that is a bit field. The data is not coming back in lookup rule depending on the field value. Any help please?

 

Thanks

Priya

0 0

Replies

replied on August 25, 2017

Can you post a few screenshots of your fields and how the look up is set up?

0 0
replied on August 25, 2017

Sure, please see attached. Thanks.

 

Priya

CheckorCash1.PNG
CheckorCash2.PNG
CheckorCash1.PNG (24.48 KB)
CheckorCash2.PNG (27.25 KB)
0 0
replied on August 25, 2017

Have to tried showing the auto fill button and clicking it to see if the issue lies with the autofill not happening?  Have you tried using True or False as the values in Forms to match the 1 or 0?

0 0
replied on August 25, 2017

I have tried True or False and it is not working. Let me try auto fill. Thanks.

 

Priya

0 0
replied on August 25, 2017 Show version history

Hi Priya,

Looks as though you're hiding fields. Are you hiding them through field rules? If so, make sure that the data in the hidden field is saved:

0 0
replied on August 25, 2017

Ok, thanks, will check.

 

Priya

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

Sign in to reply to this post.