Discussions

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.

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

Thank you!  Sorry to take so long getting back to you, but I'm playing with it now.