Re: TRIGONOMETRIC FORMULAS in AppSheet

ME_Webdesign · 01-27-2022 02:33 PM

This is my app:

In minute 11:47 you can see the trigonometric formula that I need to use in appsheet

<iframe width="560" height="315" src="https://www.youtube.com/embed/lSExCsDwJjQ?start=707" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

In order to do the calculs I used spreadsheet, but I would prefer to use appsheet.

¿How can I use coseno seno tangente?

Best regards, 👩‍🔧

graham_howe

Not available in AppSheet, what is the problem in using the spreadsheet?

ME_Webdesign

The delay. As I show in the video it has delay.

I am interested in making an IOT application and I think this will be a problem.

There is any formula that I can use in order to solve this?.

Thanks.

Best! 👩‍🔧

graham_howe

I had a quick look at your video, I can very confidently state there is no way you will be able to include such calculations in an AppSheet expression. However if the data is submitted through AppSheet and stored in the spreadsheet then I think the calculation in the spreadsheet would happen very rapidly. If you're concerned about having to add formulas in each cell alongside the data, then use ArrayFormula at the top of the column and it will automatically align with rows of data coming in from AppSheet.

However you mention IoT, I'm not sure I would consider AppSheet the best platform for that use case. This is typically a platform to present interactive forms to users, rather than to develop apps to be access by devices. If you need to go down that path then you'll have to investigate the API capabilities. If you are really thinking about the typical high volume, small packet type communications normally associated with IoT though, I think you're on the wrong platform.

ME_Webdesign

Okey, it has delay. It is what it is.

Regarding IOT, I can assure you that this type of platform does work.

I recently studied with NODE-RED LOGO M3 SOFT and thingspeak. If appsheet can send the data in time, I can use thingspeak and arduino. I have a channel on youtube that I will demonstrate it this soon.

Best!!

https://www.youtube.com/c/Electricians-PLC%E5%BD%A1CNC/channels

Joseph_Seddik

Trigonometric functions are not calculated, they are just table lookups. Copy these tables and put them in your app.

Nice electrical works by the way, I liked it!