Incrementing Order Numbers

In some situations, it is beneficial to have an auto-incrementing identifier, such as an order number that is unique for each order. This can be an easy way for customers to communicate their order information without letters, which are often misunderstood on a phone call. AppSheet handles most of the calculations client-side, which makes a simple max() + 1 calculation unreliable. The client will not be aware of other orders that are being created at that exact moment, so there is a chance of duplicate numbers. Therefore, in this situation, it is best to use an automation to generate a number. This ensures that the AppSheet server calculates the auto-incrementing value instead of the client, preventing duplicate numbers.
00:00 - Intro
02:32 - Creating the auto incrementing number

[@bernt6500]

Thanks for the video!!

[@hozenex]

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

[@ahmadtamimi141]

how to print receipts to thermal printers using action button

[@ghenitaviorica6666]

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.

[@deqkuanggl]

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?

[@RobHunter-bp7ww]

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?

[@appify]

If you go to the automation monitor under Manage it should tell you the error.

[@neverlosehope117]

Hii,, how to allow duplicate value in key column ?

[@khushalagrawal75]

Not possible, make the one that is unique in your Row as Key 👍

[@neverlosehope117]

@@khushalagrawal75 actually i want to make inventory count app for 100 stores so it is possible in app sheet??

[@khushalagrawal75]

@@neverlosehope117 Create a Id Column in data section and make it as key , yours case may work