Managing dates - My user desperately needs to...

(Marlene Williamson) #1

Managing dates - My user desperately needs to see what day of the week it is when he chooses a date on the entry screen. I can show a field that gives him Monday, Tuesday, Wednesday etc after he has chose the date, but he wants it AS he is choosing the date, as they most often work only a week or so ahead. Can anyone suggest a workaround?

(Suvrutt Gurjar) #2

Hi @Marlene_Williamson1

May be you are looking for different solution, but just in case you are looking for calender view that shows day of the date while setting the date field, it is available by clicking on the tiny direction

icon at the right in the date field entry.

(Marlene Williamson) #3

Have asked the user to try it. He has an iPhone.7. It always soars as calendar picker on my android@Suvrutt_Gurjar

(Marlene Williamson) #4

I have discovered that it is

IOS date picker. It’s there any way to

change the style of date picker?

(Thomas Chandra (THOMZZ)) #5

No. Date picker is OS dependent.

(Suvrutt Gurjar) #6

Hi @Marlene_Williamson1, Not sure if this helps you. However I request you to explore. You have mentioned that the user needs to select dates only week or so ahead. In that case, there is a


to create

an Enum type field with valid_if constraint consisting of

a bit crudely created list such as

LIST((SWITCH(WEEKDAY(Today()), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, “Saturday”))&"-"&(Today()),(SWITCH(WEEKDAY(Today()+1), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, “Saturday”))&"-"&(Today()+1),(SWITCH(WEEKDAY(Today()+2), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, “Saturday”))&"-"&(Today()+2),(SWITCH(WEEKDAY(Today()+3), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, “Saturday”))&"-"&(Today()+3),(SWITCH(WEEKDAY(Today()+4), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, “Saturday”))&"-"&(Today()+5),(SWITCH(WEEKDAY(Today()+2), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, “Saturday”))&"-"&(Today()+5),(SWITCH(WEEKDAY(Today()+6), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, “Saturday”))&"-"&(Today()+6))

The above list is for 7 days including today and produces Enum result as given in picture attached below. Every day on date change, it will advance by one day for next 7 days

Hope this approach helps you in some way. Of course , you may further refine, this approach as

per your needs.

(Marlene Williamson) #7

@Suvrutt_Gurjar thank you for your detailed reply. That might indeed help and I will see what I can do. this app needs to show the day, sort and group and it has been very tricky with no easy answers. Thank you for your help

(Suvrutt Gurjar) #8

Thank you @Marlene_Williamson1, good to know the approach may be useful to you.