Hello and thank you for the video ! Here another video idea. I group my starting view ("2023 Orders") by months. When the app is started, I want it to go directly to the current month.
I need to build an app for 3 stores to be able to write procurement orders simultaneously, from the same catalog, but divided into different invoices, any ideas ?, I basically need to add the items from the catalog to the total invoice directly from the appsheet, right now I'm using a filter function on googlesheets to filter the values that has input a Qty, but i know there's a "add a new row to another table" in appsheet
The underlying reason as to why this method works is that all automations are run by the server in series. No automation is processed in parallel. As a result if there are concurrent users the server processes max()+1 as it receives the requests. This is why you would never want to use something like max()+1 in just an action itself. Actions are processed on the client (user side). As a result you would get what you described where max()+1 result could be the same value if multiple people are using the app at the same time.
Thanks for the video. I've tried this but The Bot doesn't run the auto increment. If I put a task to send an email to me BEFORE the update row event - I get the email. If I put an event AFTER the update row event, I get no email. So it seems to be hanging on the update row event any thoughts?
Hi So i have 2 colums 1st =date 2nd=duty teacher My question is if a student pick a certain date in 1st column ,how to automatically duty teacher can be showed in the 2nd column?
Thanks for the video!!
Hello and thank you for the video !
Here another video idea.
I group my starting view ("2023 Orders") by months. When the app is started, I want it to go directly to the current month.
I need to build an app for 3 stores to be able to write procurement orders simultaneously, from the same catalog, but divided into different invoices, any ideas ?, I basically need to add the items from the catalog to the total invoice directly from the appsheet, right now I'm using a filter function on googlesheets to filter the values that has input a Qty, but i know there's a "add a new row to another table" in appsheet
how to print receipts to thermal printers using action button
How do you manage if there are 2 or more concurrent users in the app ? expression would return all the users same max() +1 value.
The underlying reason as to why this method works is that all automations are run by the server in series. No automation is processed in parallel. As a result if there are concurrent users the server processes max()+1 as it receives the requests.
This is why you would never want to use something like max()+1 in just an action itself. Actions are processed on the client (user side). As a result you would get what you described where max()+1 result could be the same value if multiple people are using the app at the same time.
Thanks for the video. I've tried this but The Bot doesn't run the auto increment. If I put a task to send an email to me BEFORE the update row event - I get the email. If I put an event AFTER the update row event, I get no email. So it seems to be hanging on the update row event any thoughts?
If you go to the automation monitor under Manage it should tell you the error.
Hii,, how to allow duplicate value in key column ?
Not possible, make the one that is unique in your Row as Key 👍
@@khushalagrawal75 actually i want to make inventory count app for 100 stores so it is possible in app sheet??
@@neverlosehope117 Create a Id Column in data section and make it as key , yours case may work
Hi
So i have 2 colums
1st =date
2nd=duty teacher
My question is if a student pick a certain date in 1st column ,how to automatically duty teacher can be showed in the 2nd column?