I have a field that gets its data from a field in another SharePoint list. That field either has ONE value or is blank.
I took the easy way and made it a combo box with a tooltip that says "If the drop-down is blank (does not display a value) manually enter a 1," but the testers are putting in stupid numbers like 100 trillion.
Is there a way to automate human action out of this field? In other words, have to look at the field based on the filter values, and if something there put it into the field in question. If nothing there, just put in a "1"? This way I could make it a read only field and leave human interaction out of it.
I don't know if this can be done using InfoPath rules...