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!
Totally get it, and you are their biggest fan, but in how many years QuickBase hasn't found a way to do this?
Qrew LegendThis can be done using a Formula Query. Have you done those before? Do you need help with the syntax?
Scheduling is a challenge. I recommend a tool from KeithJusas
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.
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.
Do you mean overlapping between other records?
RID Mobilized End
2 1 Oct 3 Oct
5 5 Oct
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?
