Ok, got an interesting issue. I have a list of dates, which allow people to book an appointment by selecting "Edit" next to the time they want, and populating the name field. The name field is a person lookup field.
To help keep things manageable, the public view filters out any non-blank emails - i.e., once someone books a slot, it no longer appears in the list.
This was working fine in testing, with me adding dates directly into the list. However, when I went to make it live, I used excel to generate a long list of dates and times and then pasted them into a datasheet view. Whats odd is that any dates added this way are filtered out. It seems that for whatever reason, sharepoint sees the email field as non-blank, even though there is nothing visible in there. I've checked for errant spaces etc and there isn't anything - plus, its a lookup field, so if I was adding anything in there, it should have given me an error that it was an invalid entry.
So, SharePoint Gurus of Overclockers, the question - is there a foolproof way of blanking out a field in SharePoint? Or even just seeing what data is actually in said field?
To help keep things manageable, the public view filters out any non-blank emails - i.e., once someone books a slot, it no longer appears in the list.
This was working fine in testing, with me adding dates directly into the list. However, when I went to make it live, I used excel to generate a long list of dates and times and then pasted them into a datasheet view. Whats odd is that any dates added this way are filtered out. It seems that for whatever reason, sharepoint sees the email field as non-blank, even though there is nothing visible in there. I've checked for errant spaces etc and there isn't anything - plus, its a lookup field, so if I was adding anything in there, it should have given me an error that it was an invalid entry.
So, SharePoint Gurus of Overclockers, the question - is there a foolproof way of blanking out a field in SharePoint? Or even just seeing what data is actually in said field?