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"),"")))}

[baba_sawane]

you can either : 

use "spreedsheet formulas" when configuring your column, and then add your sheets formulas inside (for the simple way)

Create an google appscriprt, the use "call a script" in automations to call an appscript that will calculate ur value and return it.

https://support.google.com/appsheet/answer/11997142?hl=en

Keep in mind that the more you are using spreedsheat formulas/google sheet formulas, the more it will increase your sync time (not a good idea on the long term).

[rvservicecenter]

I want to do this in the App without using google sheets! Is that possible?

[baba_sawane]

Yes, I added the screenshot because it may be confusing. 

You can configure spreedsheet formula within appsheet, just enter your formula and remove the '='

[AleksiAlkio]

If you are the only user with only one device and you never touch the gSheet directly, then it's possible. But if not, then it's not possible because if two users add the rows at the same time, two records will both have the same value. And if it's a key column, the latest one wins.