[SOLVED] Column that autoincrements number from last account created

Moralis General
#1

Hey guys Iā€™m almost done with my dapp only 1 thing I canā€™t seem to figure out is how do I got about making a number column that autoincrements whenever an account is created?

So first user id is 1 then when another user makes an account their id is 2 and so onā€¦

any help will be greatly appreciated thank you!

#2

You can set the new id number based on number of rows in the class.

If your rows count is 10 then you new row id will be 11.

#3

could you give me an examples of how that would look like if the class name is ā€œosidā€? please and thank you

#4

ok for some reason I canā€™t get this to work for the _User table but it worked for a custom table I made for Monsterā€¦ how can I fix this?

                async function dbosid(){
                const query = new Moralis.Query("Monster");
                const Monster = await query.find();
                console.log(Monster)
                }
#5

had to run it as a cloud function got it thanks guys