So i have a google sheet with two worksheets, one worksheet that has a list all approved records and a sheet that has records waiting for approval, each record waiting for approval is shown inside its own expander that’s created dynamically as the waiting for approval is iterated through, when a user clicks the expander they will see all the relevant details that can either be approved or denied, there’s buttons for approval and denying, now if someone clicks approve, the data is sent to a dataframe and concatenated with the approved data frame, so I can approve the data, now the problem is, for both the deny and the approval, I want that particular record gone, so its deleted from the waiting for approval list, how can this be done?
Hi @websterl
You could use the gspread library in your Streamlit app and can update/delete a particular cell, column or row:
https://docs.gspread.org/en/v6.0.0/user-guide.html#updating-cells
1 Like
this worked, gspread seems to have more functions than gsheets connection
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.