The cell formatting is not moved around to follow the text in each cell. A specific cell could have turned red text due to a stray keyboard press or perhaps that cell is formatted red in the current sheet.
1 Like
I’ve updated my output formatter with some new features and some minor bug-fixes and improvements. The forums won’t let me update my previous post, so here’s the new link.
Features:
The following special terms can be used in the “Board” or “Actions” columns to create new post sections similar to “In Play:”: Upkeep, Main, Future, In Graveyard, Jailed, On Loan, and Trashed.
Building HP set to 99 will be converted to ∞
2 Likes
It would appear this thread needs to be PINNED again.
@Leontes can you help?
the spreadsheet does not work for me. I have to use the buttons for mobile, otherwise it says there is an error and the script does not work.
The buttons trigger a security message, and certain google account settings can cause it to be automatically rejected, causing it to not work. When I use a new copy of the spreadsheet for the first time, I have to authorize the scripts to run after pressing a button for the first time.
2 Likes
i get the prompt, i do authorize the scripts, and get the error message.
1 Like
In that case, I do not have a good answer, I am not able to replicate the problem you describe using a fresh copy of the sheet.
1 Like
I got the problem. Ffox now disables pop ups, so it blocks the prompt for codex pbp helper. One has either to allow google docs to open pop ups or use chrome
4 Likes
Suggestion: it would look a little better if the patrol zone was formatted as a table. Sometimes unit names are different lengths and it makes the patrol zone hard to read at a glance, for example someone can miss a patroller in elite because they don’t ‘stick out’ far enough. a table would make them aligned more evenly.
output:
| Patrol Zone | |
|---|---|
 Squad Leader: |
Fox Primus |
 Elite: |
Rook |
 Scavenger: |
savior monk |
 Technician: |
sparring partner |
 Lookout: |
source (reference):
| Patrol Zone | |
|:---|---:|
| :psblueshield: Squad Leader: | Fox Primus |
| :psfist: Elite: | Rook |
| :ps_: Scavenger: | savior monk |
| :pschip: Technician: | sparring partner |
| :target: Lookout: | |
1 Like
Easy enought o implement.
I will say that adding the stats (eg 2/4, 3/3+A, 2/1, etc) helps to clue in there’s a patroller.
1 Like
i’m soo lazy though. speaking of which another idea would be adding in an auto-generated ‘command zone’ with hero names and level 1 stats for easier copy/pasting
1 Like
That wouldnt be too hard, just have to decide where in the sheet to put it. Maybe at the bottom of the patrol zone.
Hey, can we get, uh . . . random discard button to facilitate games against the Black starter?
How we have typcialy done that is the imp player picks a number at random and posts it alongside the imp, then the opponent discards that number down from the top of their hand.
If t happens after a tech draw, its still a number down from the top of the hand list.
There’s not really anyway to enforce the fair play with the play by forum format, either the imp player can cheat or the opponent can cheat, but mostly the method i descrbe lets a bystander check that everythings kosher.
All that o say yes I could add a button, but it doesnt solve the problem.
1 Like
I’m thinking about adding a few features to the sheet for myself. Would anyone else want my updates? Any suggestions for what I should add? Does anyone else have updates in their sheet that I could/should combine into mind?
Still considering what the exact updates will be based on how hard they are.
I also modified a few things but didn’t think it worth it to “publish” these. But it anyone is interested, of course I can share:
- Empty line for the turn above the mandatory worker line
- I included a field to insert a game name that is always displayed at the very top
- Added spoiler blur to hide detail elements for hidden information
- Added unit/building stats
- Added brown spec for testing (but can easily be removed)
Please let me know in case anyone is interested.
1 Like
I’ll take what you got!
1 Like
1 Like
I seem to have done something wrong with my copy of the sheet for a game. The right side lists “#REF” for the scavenger. How do I fix it?
(The cause might have been accidentally dragging plasmodium there, and then putting it on the board column, marking it as forecast three.)
Also, is the generated post supposed to contain my notes? It did not, and now they are lost.