How to do advanced Math Equations

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

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.452-D2)/1.666)*180/3.1416

Where D2 would be a field in Quickbase.


Is this possible?

Photo of Richard

Richard

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Jack

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
Photo of Richard

Richard

  • 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)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb
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 three-dimensional unsteady form of the Navier-Stokes 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/k-12/airplane/nseqs.html
Photo of Richard

Richard

  • 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
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb
Eleven months without Advanced Math Equations in QuickBase! How did you ever survive this travail?