We are an engineering company and I am looking for a way to do some calculations, that are currently done and stored in excel, within Quickbase.
An example would be
=ATAN((1.452D2)/1.666)*180/3.1416
Where D2 would be a field in Quickbase.
Is this possible?
 0 Points
Posted 4 years ago
Jack, Champion
 50 Points
I'm not aware of a formula function called ATAN existing in Quickbase. However there is nothing to say that you couldn't perhaps write a formula to perform the function, then apply it to your formula.
To help you here is how Quickbase formulas work.
((1.452[Quickbase numeric field name])/1.666)*180/3.1416
To help you here is how Quickbase formulas work.
((1.452[Quickbase numeric field name])/1.666)*180/3.1416
 0 Points
thank you. In looking into that, would anyone know if/how to use the math function in jscript to pull the parts of the formua from fields, do the arctan and then populate a numeric field with the answer?
for jscript:
Return the arctangent of a specified number:
Math.atan(2)
for jscript:
Return the arctangent of a specified number:
Math.atan(2)
Ⲇanom the ultimate (Dan Diebolt), Champion
 30,074 Points
Add a new record and then view the List All report:
Advanced Math  List All
https://haversineconsulting.quickbase.com/db/bkgihsdq6?a=q&qid=1
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=461
I only implemented the ATAN calculation on the report page but it could easily be added to the add, edit or view pages.
If you have any other questions about using "Advanced Math" with QuickBase let me know. Right now I am working on applying QuickBase to a Singular Value Decomposition of sales data using Numerijs:
http://www.numericjs.com/documentation.html
I once solved the threedimensional unsteady form of the NavierStokes Equation with QuickBase but I had to use a lot of fields and records to discretize all the points.
https://www.grc.nasa.gov/www/k12/airplane/nseqs.html
Advanced Math  List All
https://haversineconsulting.quickbase.com/db/bkgihsdq6?a=q&qid=1
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=461
I only implemented the ATAN calculation on the report page but it could easily be added to the add, edit or view pages.
If you have any other questions about using "Advanced Math" with QuickBase let me know. Right now I am working on applying QuickBase to a Singular Value Decomposition of sales data using Numerijs:
http://www.numericjs.com/documentation.html
I once solved the threedimensional unsteady form of the NavierStokes Equation with QuickBase but I had to use a lot of fields and records to discretize all the points.
https://www.grc.nasa.gov/www/k12/airplane/nseqs.html
 0 Points
Thank you Dan! Sorry missed your reply until now.
I will be getting back to this very soon. Thank you again for your effort and help on this
I will be getting back to this very soon. Thank you again for your effort and help on this
Ⲇanom the ultimate (Dan Diebolt), Champion
 30,074 Points
Eleven months without Advanced Math Equations in QuickBase! How did you ever survive this travail?
Related Categories

Data import & export
 731 Conversations
 18 Followers

Formulas & functions
 2975 Conversations
 79 Followers

Tables & fields
 7257 Conversations
 187 Followers