Excel import -- do not import ""
Would like to set up validation where FM will import an Excel range, but will not import records within that range where, say, Price is equal to nothing ... "" [double quotations] are in the cell.
Have tried a few different things but to no avail.
Assuming that field truly imports as empty, you can set a validation rule
No IsEmpty ( ThatField ) with "validate always" enabled. This can even be on a different field as long as you have it somewhere on one of the fields.
Then those fields should be omitted during import.
The other options is to find and delete those records immediately after import--which is simple to do.