Appsheet Episode 25: How to create Room Booking app with no overlapping reservation.

[@eaindra-jf3zj]

Thanks for your videos , but I am facing an issue - let's assume we have user A and B . If User A is access in the app on 10:00:15 but not key any data , even NOT SAVE yet the app , just keep opening(So not entry yet in the source G-sheet ). On that time User B is access in the appsheet for eg. 10:15:00 and booked BOARD ROOM for 11:00:00 to 12:00:00 and Save , entry also in the data source. After a moment , USER A is continue entry the data BOOKED ROOM FOR "BOARD ROOM" for the same time 11:00:00 to 12:00:00 , he could save the app without pop up any rejection or warning. The issue is, if someone is entry earlier than another use , without saving or close the app , this formula is not working for it. I have try to set NOW() in [Entry Time] but the time is not continueting just shown as the entry time. I have search FORCE SYNC every one minute for every single entry time , but not fournd the solution . Sorry for long test . Could you please help for my problem or guide me or advise me please . Thanks a million.!

[@s2_p_2524]

Thanks for the videos . Very crisp and to the point 👏🏼. Love your channel and content . 🙂👍🏼

[@aris_azhar]

This made my day! Thank you for such kind words! Looks like i have to do more videos for you! I am hyped!!

[@AAKASHRAI1000]

thank you very much for this help, but I am facing an issue, let's assume we have A B and C rooms, if you book room A twice it will not overlap but if you book room A then rooms A & B it will overlap. please help me to solve this issue.

[@aris_azhar]

Hello, are you saying that there's a possibility the rooms are shared? like, A can combine with B as well?

[@FormazioneCiaGrosseto]

Thanks Great Videos I have make app but my resulted ERROR Column Room in expression '[Room].[ID]' does not contain a reference WHY ?

[@FormazioneCiaGrosseto]

Resolved .... the formula in the video notes is wrong NO - [Room].[ID] YES - [Room Selected].[ID]

[@aris_azhar]

Glad that you've found a way out! I will look back into the notes that i've shared, must have mistaken it for something different. Thank you!

[@agarkars]

Hi there, I have watched all the videos and loved the way you have elaborated the entire Appsheet Videos, right from Ep.1... I am struggling to create and a "Sign up", "Sign In" Page then use the user credentials for further action in AppSheet. Can you elaborate on that, please?

[@aris_azhar]

The custom login is possible but it's not recommended since there's already a login provider which is more secured. Regardless for you i will do one tutorial! Since you're awesome by watching all of my videos! Thank you Sir

[@mohdzamreeabdul3935]

@@aris_azhar Salam Tn, mohon maaf. Saya kurang faham ttg login service provider yang Tn maksudkan tsb. Mohon sedikit pencerahan, Tn Aris Tkasih

[@786ashiqmomin]

Great video. Can you do a video on how to use pushbullet api to send and receive messages within the appsheet?

[@aris_azhar]

Thats an interesting mix..pushbullet is cool..alright i will do some experiment on this and will share it soon! Thank you

[@diaahendawy7337]

In episode 25, when we choose the meeting room, we choose the room at the beginning and then check whether it is empty at this time and date or not. I do not want to take this step. I want it to calculate the rooms that are able to receive the meeting, exclude the busy rooms and choose one of the rooms to receive the meeting. Is this possible or not

[@raycharlesdelacruz5362]

Hi can I get a copy of this template please. Thank you

[@subbuunique2823]

Please make a video on dependent drop-downs

[@aris_azhar]

Good suggestion! I will do on the next one..there's a new one coming tomorrow!

[@RubickDota-tk8oo]

how to make link to view into callendar view base on details room

[@Nobody-gz3hh]

Hello are still active? Thank you for the video, i already tried your time valid if, the result once it booked, i can't make a new reservation even at the next day , it says, just like error if formula, already booked. I don't know where is my mistake.

[@moirabahamed2386]

how to make an eamil with pdf created by automation ? Please

[@aris_azhar]

I will do one tutorial for you soon! This is a very good suggestion..adding it to my list

[@kailaspawar3405]

What is row id it is not there in googlesheet

[@aris_azhar]

RowID is a system generated column but it exists in Appsheet not in spreadsheet..just an indicator of the line of data

[@shazzie4eva]

How can i get the row_ID? System generated? Mine not showing in tables. Pls help

[@yasithagayan]

Hello dear, Could you please help me to create Dental Doctor appointment system? It must be apply limitations for treatment types. Please if you have free time reply me.

[@aris_azhar]

hello! kindly email to me the requirements to [e-mail]

[@4ppspwkpn]

thank youuuuu

[@4ppspwkpn]

you just save my lifeeee ♥♥♥♥

[@AyoubBezahe-d2v]

Salam Brother, How can change format date from : mm/DD/YYYY to DD/MM/YYYY

[@FormazioneCiaGrosseto]

Thanks Great Videos How can I change the formula for checking the daily availability if I have to rent bicycles and I have several units for the same bicycle every day. Example of daily availability Red Bike: Nr 3 Green Bike: Nr 5 Yellow Bike: Nr 2 Thank you😏

[@arslanbaig3892]

Nice video. If u find time, kindly make a video on how we can see the reservations already made in a calendar. Rooms booking dashboard 😊

[@masdeyoutube7807]

the calendar can have differents rooms numbers ???

[@natureiseverything6720]

I have make app but my resulted data not automatically updated in app

[@aris_azhar]

Hello, we can discuss further on why that's happening to your app. We can do a 1 to 1 session if you like

[@tabithamyers4236]

😊 𝚙𝚛𝚘𝚖𝚘𝚜𝚖

[@MohdAzham]

Hi can I get a copy of this template please. Thank you

[@AyoubBezahe-d2v]

Salam Brother, How can change format date from : mm/DD/YYYY to DD/MM/YYYY