How to ignore empty cells
Does anyone know if there is a way to force Quickbase into ignoring empty cells when importing an Excel sheet? I have a sheet that looks like this: ShotID is the key field and the other...
Forum Discussion
The best way I can think to do this natively, and without any code, is to have separate Import fields from your data entry fields, but then how do you decide which value to use in a combine field could be an issue.
I'd say to use something like.
If(IsNull([Import Field]), [Entry Field], [Import Field])
Its tough to say not knowing the whole story behind why, how and when this happens. But I thought I'd give a suggestion.
I'd say to use something like.
If(IsNull([Import Field]), [Entry Field], [Import Field])
Its tough to say not knowing the whole story behind why, how and when this happens. But I thought I'd give a suggestion.