I am not skilled with php but I am learning. Thank you in advance for your patience.
I'm interested in a formula that will display only dates that are the first day of the week in the date field. E.g. rather than letting the user choose from January 1, 2014, January 2, 2014, January 3, 2014, etc. I would like them to have only choices like, January 5, 2014, January 12, 2014 (Sunday is our first day of the week),...February 2, 2014 and so on.
I tried FirstDayOfWeek but apparently I am not using it properly. I want them to be able to choose from dates so they can enter previous weeks if necessary.
Thanks for any tips you may have.
Then make a relationship back to your data entry table and the users will see a drop down list of only Sundays. if you like you can create a report to be used on your FORM properties to limit the dates the user will be able to choose from - for example perhaps only Sundays going back or forward 6 months.
One more reason for using code--
I thought using PHP would allow me to relate the dates available to the year the user was in--so for example, in 2014, the user would see all FirstDayOfWeek[(Date)] or something. But that code gives me only the first day of the week for the week the user enters data. We travel so there's a fair chance of back-entry.
I don't have a problem limiting them to a list that I enter personally.
My robot picked up this reference to my name so you got my attention.
Why involve PHP? This is a simple thing to accomplish. The jQuery datepicker UI (which QuickBase uses) is highly configurable. All you have to do is inject a little script into the page using the image onload technique and use this tiny bit of code to allow only Sundays to be selectable:
Note that QuickBase has already initialized the datepicker so you have to use the option parameter to reconfigure it to your Sunday only needs.
See the screenshot attached.