I have a Lookup control that is pointing to a list where the field is set as a Yes/No checkbox. Can someone help me with a jvscript to convert this to Yes or No on my form? Thank you!
can you post details on your configuration?
if I try to connect lookup to Y/N field I do get regular yes/no texts
I've found a work-around to this but let me share what I discovered in case it may be of use to others.
Ok. So, if the lookup is to a field type that is a Yes/No (check box) instead of Choice Drop-Down menu option with Yes and No, then the data for that field will be displayed as "true" or "False" on the form depending on whether it was a Yes or No. I couldn't get it to convert to display "yes" or "No" so that was what prompted me to post the question.
However, I went back into the list setting and changed the field type to Choice but selected it to be a Drop-Down Menu instead of Checkboxes, then it displayed correctly.
Thank you. I will mark this post as answered......unless someone has a solution for when the column type is a Yes/No check box.
Retrieving data ...