Want a formula to create a serial number in appsheet

[rvservicecenter]

I have a formula in google sheet to create a serial number order wise like A0001,A0002-A9999 and then B series starts like B0001-B9999 till Z. I want to add this formula in appsheet because the google sheet formula show sync to compute in the app everytime. 

Is that possible?

the google sheet formula is -

={"#";ARRAYFORMULA(IF(C2:C="",,IF(SEQUENCE(26000,1,1,1)<=26000, CHAR(65+INT((SEQUENCE(26000,1,1,1)-1)/9999)) & TEXT(MOD(SEQUENCE(26000,1,1,1)-1,9999)+1,"0000"),"")))}

[WillowMobileSys]

If you have multiple users of your AppSheet app, there is not a way to TRULY generate a sequentially based Order number.  This is because each user is operating on a separate individual version of the app.  The easiest way to describe this is if two users were to enter an Order at the exact same time, the app code would generate the same Order number for each resulting in 2 Orders having the same Order number.  There are other complications as well that have to do with timing of synchronizations across all users.

My best advice is to discontinue the use of a sequential Order numbers altogether - if at all possible. 

[MultiTech]

count(
split(
left(
concatenate(ENTER_LIST_HERE),
find(
"WHAT_TO_FIND",
concatenate(ENTER_LIST_HERE)
) + (LEN(Concatenate("WHAT_TO_FIND")) - 1)
),
" , ")
)

• This will give you the number of the item you're working with
• So if you're looking at "the first item in the list" - this returns 1
  • If you're looking at "the 5th items" - this returns 5

By combining this together with Concatenate() you can create your serial numbering system.

You can find more Resources & Tools here

------------------------------------------------------------------------------------------------------------

An alternative, if you've got a reference between two tables, is to just count the number of related records through the reference + 1.

Count([Record_Parent_Ref].[Related Child_Records]) + 1

•  The method I mentioned first will work retroactively, whereas this formula (the simple count) won't - it's only good for when you're making your record.

[WillowMobileSys]

Hi Matt!

So...I am curious and have to ask now...I have seen several posts over the years with solutions on creating sequential numbers.

But based on my experience, generating sequential numbering has issues.  It works well only if you have a few people in the system creating records and are never really doing so at the same time.  AppSheet documentation also suggests staying away from sequential numbering.  Since my issues years ago, I have never used them.

So based on your "plethera" of experience...

1) How well do these sequential number schemes actually work when there are multiple people making entries into the app potentially simultaneously?

2) If there are issues how do you normally deal with them?