What I’m trying to do:
Writing to a specific cell in sheet 2, Google Sheets writes it on sheet 1!
when click
Google Sheets writes True on sheet 1 instead of sheet 2
What I’ve tried and what’s not working:
here is the image before:
and here is the image after (it writes always in sheet 1):
Code Sample:
client:
def primary_color_1_click(self, **event_args):
anvil.server.call('update',2,2,"True")
server:
@anvil.server.callable
def update(rid,cid,v):
# print(rid,cid)
lib = app_files.untitled_spreadsheet
worksheet2 = lib[1]
cell = worksheet2.get_cell(rid,cid)
print(cell)
cell.value = v
#cell.input_value = v
# this is a formatted code snippet.
# paste your code between ```
Clone link:
you need to create google sheet and use google API
https://anvil.works/build#clone:FQUEDQRCYW5NNZ3U=XNJSRYBVMZMQAIV2PJPNPVI3
share a copy of your app