Just getting started on AppSheet and landed a...

[Padman_Kondur]

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

Any suggestions?