Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Trying to calculate new stock value on button press

Topic Labels: Scripting extentions
Solved
Jump to Solution
2256 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Pim_Wagenmakers
5 - Automation Enthusiast
5 - Automation Enthusiast

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
TheTimeSavingCo
18 - Pluto
18 - Pluto

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
Andy_Cloke
8 - Airtable Astronomer
8 - Airtable Astronomer

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.

TheTimeSavingCo
18 - Pluto
18 - Pluto

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.