Just getting started on AppSheet and landed a issue that should have an answer.
I have a simple form where I want to capture the pay period (that has ENUM values for each month - Jan, Feb, … Dec).
Now I want the field to have a default value corresponding to the current month.
So if the form is entered on 5/1/2018, the payPeriod field should default to “May”.
When the entry is made on 4/30/2018, the payPeriod field should default to “Apr”.
I tried using TEXT(MONTH(), “Mmm”) which is the Google Spreadsheet function.
Didnt work in AppSheet.
I tried using SWITCH(MONTH(), “Jan”, “Feb”,… “Dec”) that didnt work