Hi, My database is set up with session entries having the fields “start time” (a date/time) and “duration” (a number, representing minutes).
How do I either prevent overlapping minutes or inform the user that the new session they added overlaps with another session?
Thanks!
In the workflow that creates a thing you could add a conditional to only create the thing if Do a search for thing where the Users match and then filter that list, choose Advanced. Then say this thing’s start time start time plus minutes (thing’s minutes) contains point new start time. The add first item is empty., If that condition passes then create the new thing. If it does not then alert the user.
You could also use the same logic to try and filter the input where the date is originally selected to exclude unavailable times.
Hi William, I am trying to do this, but I am just getting errors.
I was hoping that I could filter the sessions I am searching through, so the if my date/time picker start time is greater than each item’s start and less than each item’s start plus minutes duration, then that would be one constraint.
However, as you see, I can’t seem to add the minutes, and the thing is throwing an error.
What do I need to do differently?
Thanks!
There it is as if you are saying “Start’s Value (which is one value) is greater than A List of start time’s: filtered” It can’t work because you need to say greater than one thing but not greater than a list of things.
This topic was automatically closed after 70 days. New replies are no longer allowed.
