Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Suggested answer

Display format of Time Window Start / Time Window End in columns

Posted on by 1,784

Any reasonable easy and supported way to display only the Time part of the Time Window Start and Time Window End fields in columns

- all standard views, i.e. Work Order view

- in Schedule Board's Requirement Views

  • Fannie30 Profile Picture
    Fannie30 2,990 on at
    RE: Display format of Time Window Start / Time Window End in columns

    I agree with Alexander. Please bring these ideas up. Also understand that items are typically implemented (and I'm speaking on my own behalf, not Microsoft) if they benefit the entire platform, not just a few customers.

  • Al Iggs Profile Picture
    Al Iggs on at
    RE: Display format of Time Window Start / Time Window End in columns

    It's always helpful to bring these suggestions to the attention of the program managers. I didn't find any idea related to that topic, so I filed a new one, feel free to vote: experience.dynamics.com/.../

    I am however pretty sure that this is a platform topic, not just a FS one, which means much more dependencies and complexity.

  • moko33 Profile Picture
    moko33 1,784 on at
    RE: Display format of Time Window Start / Time Window End in columns

    @Scott & Shilpi: "Time Window Start" is a datetime field, only the control displaying it ON THE FORM is a "Time Only" control. This means this is no solution for all the VIEWS, which was what I was asking about.

    @ba365guy: you'll have a problem if somebody from a different time zone than the dispatcher is creating the work order. If you have a script/plugin/workflow writing the time in "new time window start", you loose the User Local context of the original field.
    So you might have a "time window start" of 9am but a "new time window start" of 10am in Schedule Board than.

    => not really best solution, only if everybody works in the same time zone.

    Even if you would think about also taking the time zone into consideration separately and create a custom calculation you would always have to determine the current Users Time zone as well. And how would you go ahead and display this calculation result in a column on the Schedule Board's Requirement panel? Maybe there's a trick with using calculated fields for it?

    Oh man... especially in Schedule Board this is really disturbing that after years of Field Service Microsoft is still not able to provide a solution here and still have this column by default in their "Unscheduled Work Orders" view.

  • Suggested answer
    Shilpi Profile Picture
    Shilpi 145 on at
    RE: Display format of Time Window Start / Time Window End in columns

    Hi moko33

    There is a way to show only time part of Time window start and Time window End.

    1. go to your entity

    2. select the field (Time Window Start/Time Window End) which you are using

    3. go  to change properties

    4. go to controls(last tab in field properties)

    5. add control Time without Date

    6. save and then publish your form

    then you will be able to see the Time only format.

    Please see the below screenshot for your reference.

    pastedimage1577162647925v1.png

  • ba365guy Profile Picture
    ba365guy 2,946 on at
    RE: Display format of Time Window Start / Time Window End in columns

    Hi Fannie30

    It appears "Time Window Start" and "Time Window End" are date time fields.

    pastedimage1576504613618v1.png

    Am i missing something? Please help to understand. 

    Thanks in advance.

  • Suggested answer
    Fannie30 Profile Picture
    Fannie30 2,990 on at
    RE: Display format of Time Window Start / Time Window End in columns

    This is incorrect.  There are two sets of fields:  Date Window Start / End:  These show Date only.  Then there are Time Window Start / End - they show Time Only.  There is no need to create new fields because these already exist.  Since you want to display time only, why not show Time Window Start and Time Window End?

  • ba365guy Profile Picture
    ba365guy 2,946 on at
    RE: Display format of Time Window Start / Time Window End in columns

    Hi moko33

    Did you find the solution for this? If yes, please close the thread by marking an answer as verified. 

  • Suggested answer
    ba365guy Profile Picture
    ba365guy 2,946 on at
    RE: Display format of Time Window Start / Time Window End in columns

    Time Window Start & Time Window End both are DateTIme fields. Displaying time only in view is not possible in a supported way. (to my knowledge)

    There is a work around to display time only for your requirement.

    Please add another field called "new time window start". Copy time value from "Time Window Start" to the new field. (via script / plugin). Use the new field only for views.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans