Hi to all. This is my first question in the f...

(Jorge Santos) #1

Hi to all. This is my first question in the forum, so if this allready been answered my apoligues!

Im creating an app that allows several staff members to schedule events on several diferent rooms (for several diferent days).

Everyone at the event (participants) will signin and schedule a room at almost the same time (lots of peolpe at the same time)

My problem is that two staff menbres can schedule the same room for the same hour and it only becomes aparent AFTER both of them syncs on save…

How can i prevent this from happening? Any workaround? Can the app check the server before save? This is a major problem since it makes the app useless!!!

Thanks in advance Jorge

PS: using goggle sheets…

(Levent KULAÇOĞLU) #2

Chiming in @Aleksi_Alkio :slight_smile: Translate

(Jorge Santos) #3

Hi Levent. Didn’t undestand what you mean…

(Jorge Santos) #4

@Mary_Jane_Pender Thanks for your idea Mary Jane! I´ll try it!

Jorge

(Jorge Santos) #5

@Aleksi_Alkio Thnaks!!! Translate

(Aleksi Alkio) #6

I’m afraid we are not able to generate a totally new row automatically… not yet.

(Jorge Santos) #7

@Aleksi_Alkio I think saw a video where they (appsheet) demonstrates

how to pick data from a table and copied to another table… I’m i wrong?

Any way, if i created a field that is updated with some useless information, wouldn’t that push for an sync?

Thanks Jorge

(Levent KULAÇOĞLU) #8

@Jorge_Santos you can copy and push row data to a form to edit it only. You cannot copy/create row(s) in another table silently.

(Jorge Santos) #9

@Levent_KULACOGLU

Thanks!! i really understood that in a wrong way… Well, better than nothing…

Can i at least delete that row from the original table once i push it to a form? (trought the same action…)

Thanks!!

(Aleksi Alkio) #10

@Jorge_Santos it will copy or update the data into an another table, but it won’t sync that row in a same way if you open and save it. For example… If you have app formulas in that record, it will not trigger that app formula.

(Jorge Santos) #11

@Aleksi_Alkio

Thanks Aleksi… I have to try it and see how it goes… :slight_smile:

Cheers and many thanks!!!

(Mary Jane Pender) #12

Jorge,

This is a problem when two or more people book at the same time.

Here are some process suggestions that might help: 1)

You might be able to manage this by having users first do a Sync to pick up the latest bookings and then create a reservation first, save and sync

  • fill in the minimal fields and do a quick save and synch.

Then they can come back to the bookings table and open the reservation for Edit and thus complete the booking knowing that they have the room and date/time reserved. 2)

Assign each staff member to a set of rooms or a set of times that are their responsibility for booking.

Then they can’t clobber one another’s events.

(Levent KULAÇOĞLU) #13

@Jorge_Santos my business partner @Aleksi_Alkio

(he is a moderator also) is an expert in this kind of booking apps. He can show you some techniques on how to prevent the double bookings.

(Mary Jane Pender) #14

@Levent_KULACOGLU

Hey that’s great Levent – could you get him to post his ideas here.

I am always looking for other methods and maybe better ideas.

thanks,

m.j.

(Aleksi Alkio) #15

Well… actually you can’t be 100% sure about this because you don’t have control for that. Normally I’m adding a validation that if the duration between NOW() and last time synced is more than 1 minute, you can’t do anything with the form. It forces the user to sync the app first.

(Aleksi Alkio) #16

And after that, we normally check the situation from the backend, and if there is a problem, the script sends an alert that there is an duplicate.

(Jorge Santos) #17

Hi Aleksi.

Thanks for your ideia. Great one! Only one question… How do i get i last sync time & date so i can do a Validation?

Thanks! Jorge

(Aleksi Alkio) #18

Create additional dummy table with two rows (header and datarow) and ID column. Generate the table and add a virtual column with the app formula NOW(). Every time you sync the app, it will update this value as well and you can use it for validation.

(Jorge Santos) #19

One more thing.

I´ve been looking into Actions, and discoverd that i can create rows with data (in another tabel).

Is it possible that the app syncs when insert a new row? (it is a change after all, and if i have automatic updates select it should work…)

thanks Jorge