Conditional Time Field on Notes Form?

UPRRDevelopers used Ask the Experts™
I'm creating a form that will hold several fields, but I'm not sure how to handle one of the requirements.  They're asking for two from and to time fields, essentially an event start time and event end time.  Simple enough, but there will be some cases in which the end time will not be provided, because the issue is ongoing.  So normally, the field(s) will read like this:

Event:  10:15  to  13:35
Which will be simple, as my plan was to create a table row with "Event:" then the start time, then a text field with "to", then the end time.  But they want to optionally select a checkbox to indicate that the event is still ongoing, so when it is selected, this is what the field(s) will display:

Event:  10:15  to  (Ongoing)

Obviously I can't store a text string in a Date/Time field.  I'm thinking that I would need to say that if they check the "Ongoing" checkbox, instead of an end time field, I would substitute a text field with the word "(Ongoing)" as its value and conditionally hide the end time field?

Am I on the right track, or is there an easier way to do this?  Any help would be appreciated!
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2007

I would substitute a date 100 years or so in the future, and convert it to whatever you want to show.

May need to hide the actual date field and just show the view only field normally, except if needs editing by an authorized person ( perhaps by role )

I hope this helps !
Groupware Consultant
Don't do yucky thing that your colleagues after you don't understand. I'd say you're on the right track: add the Ongoing field as you say, and based on the ongoing show or hide the plain-text paragraph "Ongoing", so not a text-field, no need for that. Hide-when formula for this word: Ongoing!="1" (assuming you use a 1 to indicate that the job is ongoing).


I like it ... thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial