Hi Experts,
I want to build an app with time in and time out fields. I am fine with the date picker but how to implement date and time picker on the same filed.
Please suggest. Attached is the screen shot for reference.
Thanks
Santhosh
Solved! Go to Solution.
hi @Santhosh88
you can use a dropdown for hours, minutes and seconds:
dropdowns:
ddHour Items = ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23"]
DefaultSelectedItems = [Text(Hour(Now()),"")]
ddMinutes Items = = ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59"]
DefaultSelectedItems = [Text(Minute(Now()),"")]
ddSeconds Items = ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59"]
DefaultSelectedItems = [Text(Second(Now()),"")]
Result:
Update or Patch is the datePicker & your hours, minute and seconds as per the comboboxes.
There you go.
Hope it helps,
R
hi @Santhosh88
you can use a dropdown for hours, minutes and seconds:
dropdowns:
ddHour Items = ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23"]
DefaultSelectedItems = [Text(Hour(Now()),"")]
ddMinutes Items = = ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59"]
DefaultSelectedItems = [Text(Minute(Now()),"")]
ddSeconds Items = ["00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59"]
DefaultSelectedItems = [Text(Second(Now()),"")]
Result:
Update or Patch is the datePicker & your hours, minute and seconds as per the comboboxes.
There you go.
Hope it helps,
R
Thanks for your reply. I did your suggestion, but the selected value is not getting stored in the share point list, though its datetime column.
Please suggest.
hi @Santhosh88 just a question, did you select the date or use the default date. the calculation in the update is valid from selecting the date.
I clicked on calender icon and selected the date and hit on 'OK'.
Thanks
Hi @Santhosh88,
Have you solved your problem?
I am confused that if the column is Date and time(including time), why don't you generate the form based on the data source directly, which will get you a date time picker by default.
Try to generate it automatically, do not manually add it.
User | Count |
---|---|
159 | |
97 | |
82 | |
75 | |
59 |
User | Count |
---|---|
195 | |
176 | |
103 | |
94 | |
86 |