Hey everyone, I am appealing to anyone that would be willing to help me in converting an already created excel doc character sheet to be roll 20 usable. I have already done an HTML conversion and can send that info to whomever is willing to help me. Its fully created and usable in excel but I would like to be able to use it in roll20 for my custom game and game system I've written over the last few years. Please coders, you are my only hope.
I forgot to mention I have already included formulas in the excel doc as well, I don't know what additional work would be needed but I am willing to compensate for anyone that is willing to take up this task. I have tried myself but in all honesty coding gives me a migraine and I have given up trying, Thank you in advance to anyone that responds to help in any way.
There's no way to convert from excel to a roll20 sheet. This is mainly because roll20 uses some non-standard html, and the demains of roll20 sheets are different from any other html, but also partly because excel cant generate good html.
So your basically asking someone to design your sheet from the ground up, and they'll both use the html and your excel sheet (and you!) as a guide, but will be essentially working from scratch.
I have managed to extract the html from my excel (using firefox dev tools) and put it in as a custom sheet that populates as a preview thats identical to including the formula pre filled numbers, but I have no idea how to make the fields fillable/editable. Your response confuses me a bit, you say its not possible but I have done part of it successfully from what i can tell just not to the degree the doc is usability wise?
GiGs is saying that if you want the sheet to be interactive and reactive in Roll20, it needs to be hand written from the ground up.
The HTML export from Excel is really just creating something that will display in a browser. There's no connection to Roll20's backend there, and so no 'character sheet', just a disconnected HTML form.
Imagine buying a letterbox, sticking it on an uninhabited island, and putting a letter in it. That letter isn't going anywhere just because it's in a letterbox - you'll need to find or create a postal service, organise a schedule, make sure the collector understands the destination address, double-check the contents so you don't send the wrong thing etc. etc.
That said - if all the math is ready to go, that's actually very helpful.
Edit - all that said, if you have somewhere you can post the HTML you've ended up with and link it, people can have a look at it and see if there's a quick way of making it usable. It won't be pretty or have repeating sections, roll buttons or anything else that makes a sheet easy to use, but there may be a quick way of turning into a very basic starting point.
Gotcha that makes sense, sucks that is the case. I'm using a tweaked 5e sheet ATM for people to roll attacks and track some stats as i have heavily invested in a custom MM on my account. ill see what I can do about the other translations though. Very much appreciate the reply, that definitely made more sense.
Honestly if I could simply sudo (sort of, not linux lol) link the sheet to be retrieved and brought up or just be fillable and do the math like the excel or 5e one does one I could simply give my players the roll equations and have them set as re-rolls through the custom roller already existent. I hate making them use two different sheets so everyone can use the roller in roll20 but having to split their focus if that makes sense at all.