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

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
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.
Photo of Ken Casser

Ken Casser

  • 612 Points 500 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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
Photo of Ken Casser

Ken Casser

  • 612 Points 500 badge 2x thumb
Thank you!  Sorry to take so long getting back to you, but I'm playing with it now.