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?
Question
Handling desire for N/A" in type fields"
+7
+6Hi 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:
https://docs.skuid.com/latest/v1/en/skuid/action-framework/action-list/actions-logic.html#logic-actions
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.