Users who track too many characters, do too many refreshes, or leave their sheet open for long periods risk locking themselves out of their sheet for the day by hitting google's daily 20,000 URLFetch limit. Currently the sheet is limited to 100 characters for this reason.

toonName = myUtils.lowerCaseAllWordsExceptFirstLetters(toonName.toUpperCase());
seems to be doing something very funky with folks with very special names

sargeras Åïmßøt -> ÅÏMssøt

we'll need info from both the progression section and raider.io for this. Apparently some of it is based on your LOWEST mythic+ for the week, so we'll need to obtain/(guess?) at that. Would also need to start tracking pvp stuff to 'fully' do this

Inspection tab should have mythic+ info, at the very least! Maybe we can put in a special pvp api call for folks we inspect?

We would like to have the possibility to change the language of the sheet.

I've seen that in the code, when you call the API it finishes "&locale=en_US". I don't know very much about that but, ¿can this be made for any language? e.g. "es_ES" for Spanish (my case).

For the rest for text in the spreadsheet I recommend to script it in the main sheets (sort off "{chest}") and add a locale sheet with all languages supported. When you update the sheets you substitute the scripted value with the translation.

Need any help with Spanish translation? I will do.

Thank you for your great and very very useful work!

My guild rooster`s highest key done is showing a wrong value for some. Very few are correct.

need to add a bit of logic to deal with gathering and crafting having 2 separate max numbers

When importing my guild in the spreadsheet 1 character does get processed because of the special character in his name.

http://i.imgur.com/y76COea.png

Is there a way I can fix this manually?

Thank you for making this awesome spreadsheet. It has been a great help for our guild!

At this time there is no Torghast info in the API that we're aware of

For the following:

Column G. Row 3

=concat("Healer: ",countif(C:C,"Healing")) - Will not calculate due to "Healing" being incorrect.

Updated below:

=concat("Healer: ",countif(C:C,"Healer"))

Characters showing [empty slot] when the API doesn't indicate the slot was empty. Inspection of these characters api shows there may be something very wrong happening with the way we're assigning soulbinds to slots

Example Character: Isneak Zuljin

Hello, after setting up client and ID following the Wiki's instructions, I get this error when refreshing data:

It would look as though the URL is not being set up correctly? This are my settings:

I even refreshed the Client's secret in case it was outdated, but to no avail. Any ideas? Thanks!

Some people do pvp? what?

need logic to prevent the N/As from causing errors

Hi,
Getting splice error with the newest version of guildcheck.js

issue with google docs not saving settings

enchant audit table will need to have values added/updated. we now have chest armor enchants that give +all stats which will need some special handling

7/8 being marked as All done! in mythics section, possibly pulled.
User who reported it initially: 'I think I see what that 7/8 mythic deal was. It's pulling from the Mythic+, whereas we're only on Mythic, so it's old mythic content'

Currently, the logs shown are the best damage for tanks/dps and best healing for healers.
Being able to change what logs are being checked based on class and spec would improve the clearness of players playing more than one spec (or if a player rerolls spec).

For instance, a restoration druid with boomy offspec (or rerolls boomy) with good damage parses as restoration, will show damage parses as restoration even if the specialization is boomy.

Issue example
Restoration damage
Balance damage
Spreadsheet (balance specced)

Solution example
Class, spec and what to display

issue is on Blizzard's side. soulbind api shows the entire row and doesn't supply us with the selected trait

column header vs outputted data ...we could always just change the header

Some characters are experiencing missing values in their vault output

array formulas need to be adjusted to display all value fetched, and all sheets should be doing the same max number of appcalls. right now there's some mismatching between master vs raw, and likely elsewhere as well.

I dont know what the problem is here.. It all worked yesterday.
When I try to populate.. I get this message.

These are the settings that I've set for the sheet.

This is just a test and can be closed.

I tried to add it myself (basically copying the Nightfallen tracker), however it seems like the reputation id 2165 ( http://www.wowhead.com/faction=2165/army-of-the-light ) is not correct - any non-pandaren Alliance toons report back as hated. Any Pandaren Alliance, or Horde toons properly report back their reputation standing.

Hi,

This is a small function I added:
function numberWithCommas(x) { return x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","); }

I call it at line 1058:
artifactRank = artifactRank + " | AP: " + numberWithCommas(toon.achievements.criteriaQuantity[i]);

I makes the total AP more readable

Rgds

Hello,
I have the above issue. I followed the steps attentively, I think I did not miss a step. Yet, nothing populates.
some details:

1. I am in several guilds;
2. I have 19 characters on the specified server (Magtheridon);
3. I copy-paste all possible to avoid double letters or mistakes in general;

the sheets remain empty
the settings:

the result:

Please help me :)

After API migration in march 2020 the quest API no longer gives us this info

blizz api forum topic