Does Native QB have a localStorage ability the way javascript does?

Question

I want to increment a Quote Number by saving the current number to storage so I can access it later in a subsequent record and add '1' to it.  I can do this is Javascript but after execution I get the Success message and can't automatically redirect to the edit page.  So I'm thinking that if I could write the calculation in native QB instead of js, it might be easier to redirect after it runs.

QuickBaseCoachD · Answer

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.html

You can use an API to get and set the variable.
https://help.quickbase.com/api-guide/index.html#getdbvar.html
https://help.quickbase.com/api-guide/index.html#setdbvar.html

Sign up

Login to the community