Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Trying to calculate new stock value on button press

Topic Labels: Scripting extentions
Solved
Jump to Solution
309 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello!

I am trying to achieve the following.

I would like to update my stock on button press by adding or removing the value given in the cell.

image

Please help.

Thank you very much in advance!!!

1 Solution

Accepted Solutions

Hi Pim, I’ve put something together here for you that should do what you’re looking for

It would require that the button runs a Scripting App though, which forces the sidebar to appear
script update field

See Solution in Thread

4 Replies 4

Hi Pim,

You could use the button to run a script that makes an API call (using fetch) to a financial API like AlphaVantage and updates your cell with the response.

If you’re happy using a third-party app you could follow this video to use the Data Fetcher app:

Then follow this guide to run the request when a button is pressed.

Hi Pim, I’ve put something together here for you that should do what you’re looking for

It would require that the button runs a Scripting App though, which forces the sidebar to appear
script update field

Thank you very much!!! that was what I was looking for.

Thank you very much for the suggestion!! That is certainly something I will be looking into.