It looks like you're new here. If you want to get involved, click one of these buttons!
I have been working on a Character Sheet for an RPG that I designed. I have it in PDF, but I found that the file size was quite large and wanted to slim it down. While I have it in Excel and ODS, it would be cleaner in NBOS. Unfortunately, I am not able to copy and paste into the script area, so it leaves out the crazy var mapping that I did in the PDF. There is too much to retype, so I was hoping to use the Lookup function.
The issue I am having is that I am not able to make the Lookup (DataStore) function work. I have a csv file containing the Skill Point Cost for the Attribute and Skills listed by Rank value. I want to be able to display the total points SP spent on the sheet by looking up the Rank in relation to the correct column on the csv file and return the SP value.
example data from csv:
My ranks go in increments of .1 from -10.0 to 100.0, so there are a lot of values. I was thinking that it could be that it is a number, but when I link the field to the CSV file, a dropdown menu does list the ranks (though in a different order). So I tried creating the example in the help section, but I found that I couldn't make it work either. I was able to make the dropdown menu as before. But I wasn't able to make it pull the data. I then pulled another character sheet with csv files attached, and I noticed that some of their Lookup fields worked and some did not.
Is there a problem with the Lookup function? Is there a work around?
What I would like is to be able to use is a js function that takes selected information to extract the data from the csv through Lookup or some other function, then add extracted values together for a total number.