Hi Roezmv! I appreciate your continued work on this project. My crew and I found 1 small bug that persists on 22.0.3, On the GM sheet, PC1's Special Abilities are displayed for PC2 too. I fixed it pretty easily for myself, but if you could fix it the next time you update, I'm sure someone will appreciate it.
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 :).
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.
Thanks! Turns out there were TWO bugs, and I only squashed one of them last week. I just pushed out v21.3 and I believe that should squash the bug. Love if you can give it a try and let me know. Thank you for your help!
This looks amazing - I just discovered Deep Cuts and was stressing about how to cannibalise the Roll20 BITD sheet to work with it (all my games are online) so this will be a godsend.
Is there any way to access & change the lookup databases? I plan to use a homebrew world rather than Doskvol so if there is a way to prepopulate with my own factions etc that would be an added bonus
EDIT: Ignore the question, I just figured out how. Leaving the thanks!
← Return to VTT
Comments
Log in with itch.io to leave a comment.
Hi Roezmv! I appreciate your continued work on this project. My crew and I found 1 small bug that persists on 22.0.3, On the GM sheet, PC1's Special Abilities are displayed for PC2 too. I fixed it pretty easily for myself, but if you could fix it the next time you update, I'm sure someone will appreciate it.
Thank you and good catch! Fixed in the latest version
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
Thanks! Turns out there were TWO bugs, and I only squashed one of them last week. I just pushed out v21.3 and I believe that should squash the bug. Love if you can give it a try and let me know. Thank you for your help!
This looks amazing - I just discovered Deep Cuts and was stressing about how to cannibalise the Roll20 BITD sheet to work with it (all my games are online) so this will be a godsend.
Is there any way to access & change the lookup databases? I plan to use a homebrew world rather than Doskvol so if there is a way to prepopulate with my own factions etc that would be an added bonus
EDIT: Ignore the question, I just figured out how. Leaving the thanks!
Wahoo! So glad you found what you needed. Did you see the video on how to hack the google sheet? It is on the Readme First tab.