Hi Roezmv! I love the spreadsheet. However, I'm having an issue in V21 where if my player tries to roll using the in-sheet dice roller, they get an error message saying they're trying to change a protected sheet, and the roll doesn't go through. How do I fix this?
Howdy Adam! Thank you for the kind words and the bug report. Someone else spotted it a week or so ago :(. I fixed it and the latest version does not have the error (v21.2). Depending on your comfort with google scripts, you can fix the problem one of 3 ways:
1. If you are super comfortable - Go to the new version (v21.2) , open the App Scipt editor, select all, copy, go to your version, open the app script editor, select all, and past.
2. If you are somewhat comfortable - go to your file, open the app script editor, go to line 98 and change it
FROM:
var diceCount = sourceSheet.getRange("BT2").getValue();
TO:
var diceCount = sourceSheet.getRange("BT3").getValue();
3. If any of that sounds scary, clone the new google sheet (v21.2) and migrate over the info from your player, crew, and faction tabs. Your players can help :).
Hi Roezmv!
No worries at all. I'm a bit confused that you say the error was fixed in v21.2, as that's the version I'm using. I just double-checked and it still has the error. It's interesting - it only crops up when other players given access to the sheet try to roll dice. I can roll them fine, but if I share a 'can edit' link with a player and they use that to access, they get the roll error.
Thank you for sending the app script editor edit. I can make use of that if there's no easy fix.
Best wishes,
Adam