Share
Report
26I have a Sharepoint list with three columns per day of the week (SunOne, SunTwo, SunThree, MonOne, MonTwo, MonThree, and so on). I'm trying to search across specific columns based on a Datepicker result.
I've used Switch and Weekday to translate the datepicker selection into the day of the week, and I also have three other Switch/Weekday combos that translates the datepicker selection into the different column names (when I choose Monday, three text boxes show MonOne, MonTwo, and MonThree). It will also record their name once submitted.
The end user can select an item from a drop-down list, which is fed through another Sharepoint list, in any one of the three options for any day of the week; for example, they can select 12345 in SunOne, TueOne, WedTwo, ThursOne, FriThree, SatThree.
What I'm looking to do is find out which users entered 12345 in any date that I choose from the Datepicker function. Is this possible? Or would be easier to use Concatenate in Sharepoint to add 12345 plus the date they've selected into one field, and search that way?
All responses (
Answers (
