Only want to show up one day

Hi! 

ive been stuck since 3 days ago. I made an app with column type date, but I want the calendar to only have Thursdays, other days cannot be selected.

Screenshot 2023-09-14 at 09.17.00.png

 

Thank you in advance!

0 1 62
1 REPLY 1

AFIK you cannot control what days are shown in the date picker.

A few things you could do that I can think of

  1. set the valid_if setting of the field to WEEKDAY([_THIS]) = 5 . 
  2. in the suggested values, set a list of thursdays close to today (i.e.
    LIST(
     ...
     today() - (weekday(TODAY()) - 5) - 7,
     today() - (weekday(TODAY()) - 5),
     today() - (weekday(TODAY()) - 5) + 7
     ...
    )
    
    add as many as you want... 
    you can tweak it to show only future dates if that is what you needโ€‹
Top Labels in this Space