Handling desire for "N/A" in type fields

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?

Hi Paul, sounds like the Branch action could be useful for you, depending on the setup of your page. You can find more information about the Branch action in our online documentation: