High Level Math

I have been working on an application that will help with engineering problem solving. I need higher level math functions, but I am not able to find any way of integrating those functions. Is there a way to integrate trig and calculus functions?

1 Like

Which functions do you need in particular?

Some Trig functions are supported in Google Sheets. You could do your math there and then have Glide pull in the final result. It would be super convoluted, but you could probably even create your own limited scientific calc add on in Glide with functions like SIN and whatnot using the choice component with inline list, a template column and corresponding rich text component to display the formula as its being built, and then send the final result to sheets for it to interpret your work, do the math, and then send back results. It would be super laggy. And a lot of sheet updating, so not for a free account, Iā€™d say.

Hereā€™s a Calculus add on for Sheets as well:

https://gsuite.google.com/marketplace/app/calculus_functions_addon/803554468276

But yeah, Glide devs, higher level math would be very important for a lot of us to make a complete severing of ties from google sheets. For example, some of my appā€™s math outside of Glide includes LOG, LOG10, POWER, etc.

1 Like

I would need at the very least these functions for simple calculations. ( sin, cos, tan, arcsin, acos, arctan ). I can live without calc functions, but really in the mechanical engineering world you need the trig functions.

Thanks for the suggestion John, I already knew sheets can do all of the functions I need. As you stated earlier it is the lag and the talking back and forth that really prevents me from using sheets too heavily. With how long the delay is, it would be better for me to just log in directly to google sheets and use the cells as inputs. My goal in all of this was to make it more user friendly for phone users, as well as not looking so much like a spreadsheet for those that get intimidated by lots of columns and dense data.

2 Likes

Yeah, I figured. And I agree with you 100%. Just figured Iā€™d throw it out there.

Shipped.

6 Likes

My apologies, I do not know what ā€œshippedā€ means exactly. Is this a good thing?

Yes. Means the feature is now available.

image

To be clear, here are the supported calculations as of now.

1 Like

There are additional ones that arenā€™t listed in the docs. I had tried it when Mark mentioned they were shipped and I tried again now and found the following:

sin, cos, tan, log, asin, acos, atan

Not sure if there are others.

5 Likes

Seems like we need a documenation update :laughing:

And also a lot of cake icons around today, a lot of us joined this forum on its open day one year ago today and is still here.

6 Likes

Almost needs to be a wiki. Too many changes for @JackVaughan to keep up with. I can understand though. Documentation is the worst part of programming.

Definitely going to see a lot of cake now. :slight_smile: Glad we moved away from the Spectrum forum.

4 Likes

Yep i try and prioritize the major features. This is on my list.

5 Likes

And weā€™re shipping mod tomorrow.

6 Likes

This is gonna be big.

2 Likes

thank you

Is anyone aware thereā€™s three users online the old spectrum.chat forum :open_mouth:

Yeah, people seem to keep finding it while ignoring the giant warning that the community has movedā€¦even commenting on the thread that says the community moved. Also a couple scammers out there that I noticed. Might be time for glide to shut it down permanently now that itā€™s been a year. Iā€™ve seen no reason to refer to it anymore.

Oh, ā€˜sheetā€™! If thereā€™s scammers Glide should shut it down completely! +1!!

3 Likes