You can set up a single purpose table called Sequence # with just 1 record in it and just 1 field created, that being Sequence #. The record will be [Record ID#] of 1.
Then, in any other table you can make a formula field which has formula of 1 to calculate to 1 and make a relationship to the Sequence # Table.
So any other record in the app can access that value.
Another approach is to use an Application variable.
https://help.quickbase.com/user-assistance/variables.htmlYou can use an API to get and set the variable.
https://help.quickbase.com/api-guide/index.html#getdbvar.htmlhttps://help.quickbase.com/api-guide/index.html#setdbvar.html
