You’re offline. This is a read only version of the page.
Hello Gurus 😃
I have a Sharepoint List with StartTime and EndTime as Single Line of Text columns.
I have a EditForm where users can edit existing records, with a toggle - The 'New Start Time' and 'New End Time' are hidden until Edit is enabled.
What I would like to do is have the Hour and Minute dropdowns equal the Existing data. At present they have the same default values as the New Form. This means that if Edit is enabled, and some other section changed, but the times left as they are, the times will be edited to the default values when the form is submitted. I obviously need to avoid this.
I've tried 'ThisItem.StartTime' and 'Parent.Default' without success as both return "00" unsurprisingly.
When creating a new form The Start and End times are created using: Time(Value(HourDropdown_3.Selected.Value), Value(MinutesDropdown_3.Selected.Value), 0) so I think I need a formula that will extract the first 2 numbers (text) from the string for Hours, and the last 2 for Minutes?
Something like: First(Split(ThisItem.TimeStart, ":")).Result ??
Kev
Sorry, found it eventually:
Left( StartTime, 2 ) etc.
Simple really 😜
Share
Report
All responses (
Answers (
610
