Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 14, 2022 03:19 AM
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.
Please help.
Thank you very much in advance!!!
Solved! Go to Solution.
Jun 14, 2022 08:14 PM
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
Jun 14, 2022 06:42 AM
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.
Jun 14, 2022 08:14 PM
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
Jun 14, 2022 11:38 PM
Thank you very much!!! that was what I was looking for.
Jun 14, 2022 11:39 PM
Thank you very much for the suggestion!! That is certainly something I will be looking into.