I have been working on my website for a few years now, which provides a suite of tools to help manage your Table Tope RPG between players and the game master. One of the core pieces of functionality that I have been working on is the character sheets (D&D 5e to start). I am very (very) new to coding and am having difficulty understanding how to complete some mathematical and logic based calculations on the character sheets. But where I really get lost in the sauce is how to do these mathematical/logic operations with inputs from multiple datasets at once
For Example:
Acrobatics Score: (Game Mechanic) Dexterity Modifier + Proficiency Bonus if Proficient in Skill
How I want this field to calculate on the page:
Acrobatics = Dexterity Modifier (Number from Modifier Dataset filtered based on overall Dexterity Score) + Proficiency Bonus (From Proficiency Bonus Dataset which filters based on character level) IF Acrobatics Proficiency (From Character Dataset) = True
I appreciate any assistance that can be given to help me figure this out.