I've set up a database, and users are now importing their data into the database using an Excel template, as it's easier for them to add a lot of data in Excel and then import than to add records one by one in Filemaker.
In the Excel template, there are some fields of data that are generated by a calculation, and the calculation will show a zero if the calculation was not needed for that record. When imported into Filemaker, rather than showing a zero, I want that field to be empty as if there is no data there, since the the record does not have data for that field. Is this possible? If so, which settings do I need to tweak?
Note: I've tried hiding the zero value in the Excel template, but it still carries over when imported into Filemaker despite not being visible in Excel. I'd rather not tell the users to delete all the fields that have the unneeded calculation before they import, which would be a straightforward solution but cumbersome for users.