Meet with Me: A Booking App that Prevents Conflicts

Not currently. I had to remove it from the template store because if the issue I mentioned previously (any updates @Mark?).

If you want to purchase what I have as is, let me know and I’ll make my app copiable for you. Otherwise, I’ll make an announcement once it’s been readded to the store.

1 Like

@Robert_Petitto Do you mean that is only useful for American date setting? Or is it another issue that I’m missing?

1 Like

Correct. Currently, despite my sound logic on the front end of glide, the locale is affecting my logic on the backend (unseen to me). So, at the moment my app only works if the date is formatted mmddyyyy on the users device.

1 Like

@Robert_Petitto that sounds good to me. I’d like it as is.

1 Like

Awesome. I’ll DM you with instructions!

1 Like

Sounds goo!

1 Like

Hi @Robert_Petitto,

With regards to your “date calculation” need in the dataeditor, I might (?) have found a workaround.

At this stage, it works in my app, so if it can be useful for you I would be happy to make my 1st contribution to this so helpful forum :slight_smile:

  • nb 1: the ignition of the idea came from an exchange with @ThinhDinh @Jeff_Hager
  • nb 2: I give you the procedure below, and I’m sure that you will be able to make it simpler (as a newbie, I built something quite complicated).

My Use case:
I have a list of standard recurring challenges among which kids will select some (ie. User Specific) >> define a frequency to perform each challenge >> and a starting date.
Then, each day, the appropriate challenge has to be displayed according to this initial setup and Today() 's date.

My need:
GSheet formula would be with a ‘mod’ function on: (“Today” DayNb of the year - “StartDate” DayNb of the year) / (frequency) >>> if it’s an integer multiple (no ‘mod’), challenge is displayed.

My constraint:
Must be User Specific, hence in DataEditor, but no Date calculations were possible… and here started the nightmare!

Implemented 8 steps solution:
(1) In DataEditor: ‘Starting Date’ and ‘Frequency’ User Specific columns,
(2) In DataEditor: template column on ‘Starting Date’ to reset the date format,
(3) In GSheet [datalist] 's sheet: creating all 2020 dates and associated DayNbs of the year; idem with ‘Today()’ formula,
(4) In DataEditor: Relation to link the ‘Starting Date’ of the [challengeSelect] tab with the [datalist] tab,
(5) In DataEditor: LookUp to bring back the DayNbs of the related dates (‘StartDate’ & ‘Today’),
(6) In DataEditor: Maths to do the calculation (Today - startDate / frequency)
(7) In DataEditor: If-then-else displaying TRUE if the ‘mod’ of the division is 0 [calculation to be checked],
(8) In Glide layout: Filter on TRUE in the inline list component … !

https://bac2bazik.glideapp.io/
[Edit: modification in-progress on the on-boarding of the app, so you may experience difficulties to test the above explanation]

Hope this could be a temporary lead, until Glide enables date calculations.

4 Likes

Step 3 is the solution for sure. Thanks for for taking the time to write this up!

2 Likes

A suggestion to consider: hide out the booked slots.

2 Likes

@Robert_Petitto That was my thought as well.

Regardless of whether you are a psychiatrist, a herpes clinic, or even a hair salon, you still don’t want to expose the names or other personal details of your other clients to the public.

Show them at the admin or staff level, but otherwise find a way to mask out names.

1 Like

Hey! Could you please reshare the copy I would greatly appreciate it!? The link is coming up as “Not Found”
Trying to figure out how to make a scheduling system for my hairstylist booking app and this may help tremendously :smiley:

1 Like

I’ve had to temporarily abandon this project because dates were not matching when users were booking from a device that wasn’t set to English. Still want to attempt it?

I would love that! I’m currently spinning my wheels trying to find a scheduling API of some sort

There is a simplified booking example in https://concepts.glideapp.io/. @Robert_Petitto’s is a little more polished though.

1 Like

Direct link to vote for dedicated, native Date Formatting

1 Like

Hi, In my application, the User clicks on a button and, by adding his email, gets access to edit the line. But if two users simultaneously press the button, then I get two lines with two different emails and a difference of one, two seconds. I have to hide the button after writing a certain field, but when pressed at the same time, it does not work. How can I solve this problem? I would be grateful for ideas.

Love it!!! Just sent you a request through your app. Great work!

1 Like