Booking app problem

[Yongki]

Manipulating date time is not straight forward.

Take a look at this

How to calculate with days and minutes

@zeemis52 Here is cloneable app that say greeting based on time in my example, GMT+7, so the fraction need to be substracted with 7*60/1440 to calculate variable related to user, it is better doing it in the collection, then using update operation, we can have option of magic text and custom formula change input value and sometimes visible are still very limited, so we need proxy variable, which is in users’ collection property. I didn’t realize that checking time in app dev need intense …

To do something like this, I also read other’s posts, but old post, like a year ago.

To bring you up to speed, to compare date time with just time such as 8:00am, require focusing on fraction in number, as this is the time, but it should be shifted to your local timezone, in my case, I have to decrease it, we need to play around until we get it.

1. if you get fraction for start-time slot and finish-time slot, you can do validation using input field or temporary variables in users collection that is retrieved using logged in user, basically it compares numbers
2. ok
3. I don’t think you can, because there is no validation process, I use it just for shortcut, for admin purposes, not for user
4. ok
5. Picture #1, I use built-in form, which does not allow me to convert date time into number, so I add another update action to do that
   Picture #2, this is not using form, so I can put in the same action.

If you have come to this point, I believe that this technique works to prevent overlapped date time period.

Maybe you can simplify the switches, because currently I use different, checked and available to do validation.