as long as the sheet is set to anyone with link can edit it should work
Can you show an example of it working?
i would love to but i would prefer not to expose my personal email
you can try it for yourself. if you would feel more comfortable i can send you the code
I totally get it, and I'm fine if you don't want to do that. I'm just not sure what should go in the sheet input. Is it a link to the sheet or some id?
an interesting thing i noticed is that formulas run even if the sheet is not open
got it to work?
I created a sheet that is shared/ however I cannot figure out what format "cell" expects, and it doesn't help that there's no error messages.
what does it do
A1 will be cell A1.
the set block will set the data in the cell to whatever you write in it and the read will return the cell data
I tried that, and it's not working. Plus, it's reporting nothing.
(I changed it to a reporter so I can have it report the return the confirmation variable)
Just saying, that sheet is a link to a sheet I made on my public email (that uses my username)
incorrect link
you have to make it so anyone with the link is an editor
Well that didn't change anything.
https://docs.google.com/spreadsheets/d/19z9YcggFhvYmifaIF2Rm6lDV7CKr0mJQHw8k9YxIFyA/edit?usp=sharing
use this exact url
Alright, so you have to have /edit at the end of the url.
This kind of information is important to share when sharing a block, rather than just assuming people will understand.
Alright, now I'm gonna unshare my sheet so people don't start using it as an unmoderated chat
i did. you didnt look at the picture i sent