DateTime Picker - Setting Time based on value of Field A but Time based on value of Field B - Possible??? - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

DateTime Picker - Setting Time based on value of Field A but Time based on value of Field B - Possible???

Last post 10-18-2012 12:58 PM by csigler. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-18-2012 12:46 PM

    DateTime Picker - Setting Time based on value of Field A but Time based on value of Field B - Possible???

    I have a scheduling form that I created where workflow is triggered and updates a SharePoint calendar. The problem is TIME. It is just too much entry for my users and they really don't need to be percise down to the minute.

    Sooooo  I would like to give them a Date Picker and a dropdown with values of Morning, Afternoon, and All Day.  Then, so the calendar will be updated correctly, have two hidden date/time fields....  Start Time and End Time.  When the user enters the Trip date it sets Start Time (date) and End Time (date) to that value (date). BUT when the user selects "Morning" from the dropdown it sets  Start Time (time) to 7 a.m. and End Time (time) to 12 p.m. 

    Am I over thinking this? Any suggestions would be appreciated.

    Corrie

  • 10-18-2012 12:50 PM In reply to

    Re: DateTime Picker - Setting Time based on value of Field A but Time based on value of Field B - Possible???

    I think you can use some clever string parsing to accomplish this.  You can create a rule on the time field (morning, evening, etc.) when it changes to parse out the date part (use substring) then add on the time piece based on what was selected like 07:00 if its morning.  Hope that makes sense!
    Anson Hidajat
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 10-18-2012 12:58 PM In reply to

    Re: DateTime Picker - Setting Time based on value of Field A but Time based on value of Field B - Possible???

    It does! Will give it a try.

    Many thanks!

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.