I need help with configuring a form that I have created for a tabletop RPG. It will have multiple dropdown menus with races and professions along with skills and such. As well as some auto-fill, totaling, and additional prompted dropdown menu or list capability. I have most of this already in Excel form but it's not really transferable due to the way it is formatted in Excel. I tell you this so you know my issues and goals.
Much of what I am trying to configure here is auto-fill of cells based on selected values from dropdown menus of other cells, along with list selection, totaling, counting, and selected value based on what and how often something is selected.
I will list each issue separately so that any response can be applied to the issue rather than the entire post. If you know of any tutorials or video links that would help me in solving these issues please forward them.
Ok, here we go.
- I want a single selection cell to restrict or allow access to other parts of the form, or allow specific aspects to be selected a number of times. I would like this to happen multiple times or if on this form it is selected multiple times to remember past selections and add on to the rest of the form including what was already selected. Example: (Note See #6 below) I have two fields or dropdown menus that when selected, or filled, several other selections based on the entree will be affected. One is for Level and the other is for Profession. Each profession is allowed some advances at each level while other advances are only allowed once or a set number of times. Still, other options are allowed to be selected multiple times per level but to a limit. If I select the Profession of Thief at level 1 it should auto-fill in that he has a bonus of +10 to all Subterfuge Skills. That should be auto-filled in the appropriate pre-selected Subtefuge skill cells. Also at level 1 all skills should only be allowed to be selected a set number of times for advancement. See #6 below. Note: This should be allowed separately at each level advancement and not affect the prior selections from the prior levels. This can generate additional forms if necessary or multiple pages of the same form. I don't care about that aspect, except how to do it.
- I want my dropdown menus to provide autofill capability depending on what is selected to other cells throughout the form. Example: I have a Race dropdown menu that gives me the options of 5 different races (Human, Elf, Dwarf, Half-ling, Orc). Elsewhere on the form are listed a set of Racial Ability Bonus (Strength, Dexterity, Constitution, Willpower), that I wish to be auto-filled with values based on the selection of race made prior. Also, this should allow the selection of Available languages and Equipment on a separate list, with a total that can be selected at one time, to a maximum number of selections. So that if the Race of Elf is allowed three selections of Languages out of a total of 10 languages they may select 3 and no more. Also, I would like to have the first selection of Race or such to allow access to additional dropdown menus or lists per type selected. Example: Selecting the Elf race provides the option of either Night Vision or Infra-Vision as a selectable dropdown menu, or list, or toggle button. I would like these cells only selectable based on the prior selection of specific other selections made on other parts of the form, such as Race or Profession.
- I want a value fillable cell that the user can fill out. When this is filled I want to automatically generate another value in a different cell based on a list or formula. Example: The number 85 is an Ability Score such as Strength, Dexterity, Constitution, or Willpower, which I entered in the primary cell. This has a value that is auto-generated as a bonus in a separate cell of +12 and a value number 6 for Development Points in another cell. Other cells and values might be affected as well.
- I want to total the value of several cells like an Excel form. These values might be entered manually or as part of an autofill function. Example (see #2 & #3 above): I have entered the Race of Elf, which provides me with a Strength Bonus of +10. I have entered 70 as the value for Strength which generates a value of +10 Strength Bonus. Lastly, there is a miscellaneous bonus of +5 that is entered manually in its own cell. All are auto-filled or entered in their own cells. I now want to total these cells in a final autofill cell to indicate a value of +25. I would prefer it show a + or - to the total value as well.
- I want to have either Check Boxes or buttons that can be selected in succession and when selected will both autofill another part of the form as well as represent a totaling value that will be recorded in another cell. Example: A series of boxes for Skill are set along a line. The skill is Climbing. As each box is selected they each have a cross value of 5 and if three are selected the total will be 15. This 15 will be reported in a separate cell as a total of +15 Climbing Skill.
- Continued from #5 above: I would like the check box to when selected along a line of other checkboxes to do a count of how many are being selected. So if three checkboxes are selected in a row then a total of 3 will be listed in a total box. Additionally, each check box has a value or cost for checking the box that I want to count. So that if the check box costs $1 for each box selected and 3 boxes are selected the total cost would be $3 (note I am not using this for money, but using money to illustrate). Example: The skill is still Climbing. I have selected the skill 3 times and the skill provides a bonus of +5 per selection for a total of +15. The skill has a cost of 3 per box when selected. This indicates that the cost of the skill is 3 and it has been selected 3 times for a total skill cost of 9, which is auto-tabulated and filled in the appropriate cell under Total Cost. Additionally, and it can become a bit complicated so I will try to keep it as simple as I can: This cost selection can have three different options. Single time selection per level. May be selected two or three times at different costs at each level. Or maybe selected an unlimited number of times per level at a single cost. Each skill is different and each skill has separate values.
- Example 1: The skill may only be selected one-time per level. The skill cost is 3 per level. So that each level the skill may be selected one time and the cost is 3
- Example 2: The skill may be selected more than one time per level but the first time cost is 3 but the second or third time is a different number represented like this 3/6/9. This means the skill may be chosen up to three times with the first time costing 3 the second costing 6 and the final third time costing 9.
- Example 3: The skill may be selected multiple times per level without limit. This is represented like this 2/*, with each time it is selected it cost 2 and may be selected as often as the user wishes.
- Can toggle buttons be made as part of a dropdown menu? This is more for space-saving than function. Example: I have three kinds of skills (see examples 1-3 from #6 above) as well as four additional categories of skills. Each skill cost type can be selected as per above. This can be a toggle button and the selection dictates. I would like this in a dropdown menu. The second part of this is regardless of the first button selection, each Skill Catagory is either:
- Regular: No changes.
- Restricted: must be selected twice before a single value is allowed. So the skill costs is 3 per selection (see above #6) and if it is Restricted then it must be selected two times at a total cost of 6 to represent a single selection option.
- Occupational: Each single selection of the skill actually equals two selection values. So using the example from above. If the cost is 3 then every time the skill is selected and 3 points are paid then it equals two skill slots rather than one.
- Professional: As Occupational, except that each single selection equals three skill slots rather than one.
I know there is a lot here, and I do have more, but these questions if answered will go a long way to helping me figure things out.
I can do almost everything on an Excel form, but I want to make it a shareable PDF.
Any help or direction will be greatly appreciated.
Thank you in advance.
4
Replies
AdChoices