Bibhu,
Thanks for your response!
I wrote this in FormCalc as a Calculate Event in the "Number" field:
If (form1.TimeSheet1.Table1.Row1.Day.rawValue=="Friday","7")
It works just fine: when I type "Friday" into the "Day" TextBox, it returns a "7" into the Number field
BUT:
I also wrote these, but no matter what I type ("Friday" or "Wednesday", etc) in the "Day" TextBox, it returns a value of "1" into the Number field in all instances:
If (form1.TimeSheet1.Table1.Row1.Day.rawValue=="Friday","7");
If (form1.TimeSheet1.Table1.Row1.Day.rawValue=="Saturday","1");
If (form1.TimeSheet1.Table1.Row1.Day.rawValue=="Sunday","2");
If (form1.TimeSheet1.Table1.Row1.Day.rawValue=="Monday","3");
If (form1.TimeSheet1.Table1.Row1.Day.rawValue=="Tuesday","4");
If (form1.TimeSheet1.Table1.Row1.Day.rawValue=="Wednesday","5");
If (form1.TimeSheet1.Table1.Row1.Day.rawValue=="Thursday","6");
I need statements that if I type "Friday", it returns "7";
If I type "Saturday", it returns "1";
If I type "Sunday", it returns "2";
If I type "Monday", it returns "3";
If I type "Tuesday", it returns "4";
If I type "Wednesday", it returns "5";
If I type "Thursday", it returns "6"
All of these need to be in one script as a calculate event in the "Number" field.
Thanks!!!
Gene-O