Hi there,
I am creating an app for my burger shop and set up a google sheet with a list of items along with their current stock levels.
I want to create a way to update the stock for each item using buttons, as shown below.
However, when i create text to display the item, i am only able to display the first item in the row. Same goes with the button, it only changes the stock in first row. In this case it is the burger buns and their stock.
I cant seem to find a way to choose which row in the google sheet I want to display in the text and change stock levels with the buttons.
Is it possible to achieve this? or is there another way to do this?
Thank you much appreciated !!!