Hi,
I am rebuilding a spreadsheet into Skuid, and the users like to enter “N/A” into date and currency fields.  We want to properly evaluate the fields when they are entered (like sum or filter by quarter, etc…) but ignore them when they are N/A.

Obviously we could have a proxy field that is text or UI only and then copy values into type field or an N/A checkbox, but I’m hoping to not triplicate all the fields with this pattern. 

Has anyone done something clever related to this that might lead down a different path than having a field for the UI and a field for the DB logic?