Skip to main content
Question

Users are overlapping times on same date

  • October 11, 2024
  • 0 replies
  • 150 views

Forum|alt.badge.img+2

Okay I have a user field a date field, time mobilized field, and a end time field. I need a message to pop up letting the user know  if they put overlapping times in, that they need to adjust their times or have another user take care of the issue. How can I do this? 

Thank you all who take the time to help! 

This topic has been closed for replies.

Forum|alt.badge.img+15
  • Registered
  • October 11, 2024

Do you mean overlapping between other records?

RID    Mobilized    End

2      1 Oct              3 Oct

5     5 Oct               7 Oct

8     6 Oct              9  Oct

 

In this case Records 5 and 8 cover  parts of the same period of time?


Forum|alt.badge.img+15
  • Registered
  • October 11, 2024

Do you mean overlapping between other records?

RID    Mobilized    End

2      1 Oct              3 Oct

5     5 Oct


Forum|alt.badge.img+2
  • Author
  • Registered
  • October 11, 2024

For example: 

Joe schedules a maintenance call on Oct. 1 at 5PM to 7PM

and then schedules another maintenance call on Oct. 1 from 6PM to 7PM

all on the same table, but when filling out his form he does not see two days ago he scheduled that time and reschedules it. 


Forum|alt.badge.img+2
  • Author
  • Registered
  • October 11, 2024

Need to know if there is a way to show him a message that is he is already scheduled for that time and needs to pick a different time or give it to another user. 

 


Forum|alt.badge.img+15
  • Registered
  • October 11, 2024

Scheduling is a challenge.   I recommend a tool from KeithJusas


Forum|alt.badge.img+2
  • Author
  • Registered
  • October 11, 2024

Totally get it, and you are their biggest fan, but in how many years QuickBase hasn't found a way to do this?