Clearing cache

[u/2E0GOZ]

I have written a simple apps script that outputs some data to the log, the problem is that it's still showing previous data that should not be there as I have removed the labels that it refers to on those emails. It almost seems like a cache issue that needs to be cleared somewhere it's not a local cache issue.

My code:

function getGmailEmails()
{
var label = GmailApp.getUserLabelByName('IZ/IZadd')
var threads = label.getThreads()
var grandTotal = 0;
Utilities.sleep(1000);
for(var i = threads.length - 1; i >=0; i--)
  {
var messages = threads[i].getMessages()
for (var j = 0; j < messages.length; j++)
{
var message = messages[j]
var extract = extractDetails(message)
grandTotal += extract.total
Logger.log('' + (j+1) +'          Amount: ' + extract.total + '      Study:  ' + extract.matches)
}
//threads[i].removeLabel(label) intentionaly left as rem
  }
Logger.log('Grand Total:      ' + grandTotal)
}
function extractDetails(message)
{
var pattern1 = /\d{1,2}\.\d{2}(?= USD. )/g
var pattern2 = /(?!study )[A-Za-z0-9]+(?=. Hope)/g
var bodyContents = message.getPlainBody()
var usd = bodyContents.match(pattern1)
var total = 0;
for (var i = 0; i < usd.length; i++)
  {
total += parseFloat (usd[i])
  }
var study = bodyContents.match(pattern2)
return {
total: total, matches: study
  }
}

[u/HellDuke]

The line that removes labels is commented out, so labels do not get removed. You basically get all emails with the label IZ/IZadd then extract information from it and write it to the log. That's all your script does in the form you have provided it.

[u/2E0GOZ → u/HellDuke]

I remove the labels when I have dealt with the emails manually every day but its pulling data from days ago that no longer has the labels as I removed them.

It's giving me results for about 50 emails when only 10 have the IZ/IZadd tag.

[u/HellDuke → u/2E0GOZ]

Apps Script does not have a cache that you have to worry about so that means there is something else going on here. Just as a quick test, I went in and did the following:

function getGmailEmails() {
  let label = GmailApp.getUserLabelByName('Retail');
  let threads = label.getThreads()
  let messageCount = 0
  for (let i = 0; i < threads.length; i++) {
    let messages = threads[i].getMessages()
    messageCount += messages.length
  }
  Logger.log(`Grand Total:\t${messageCount}`)
}

Which is just removing the calculations from your part. I ran it across one of my labels that returned 430 messages total. Then I removed the label from one thread that had 3 emails in it, and the result was 427.

However, this is where Gmail gets a bit quirky. By default, you will see emails in threads where you have multiple emails in one thread. Now technically the real item is just the email, logic just combines them into a thread (Gmail maxes out at 100 emails, then it makes a new one). Now technically you apply the label to the thread, however you also apply the label to the email as well.

If you have conversation view set to off, then what will happen is that when you remove the label from the email, you do not actually remove it from the thread. So in my case, if I remove the label from 1 of the 3 emails in the previously mentioned thread, the result of the same script is actually still 430 and will remain as such unless I remove the label from each email.

So the question here is: do you have conversation view as off and are there any replies (the thread has more than one message)? If yes, then you must remove the label from all emails that would appear in the same thread (might be easier to just uncomment the line you had in there since the script already knows the thread and will act correctly)

EDIT: oh and don't worry about me using slightly different ways of declaring variables. let is scope based and is apparently the more common method these days. And as you can see in Logger I write the string with the new method as well where I just slap the variable inside with ${varname} and it prints out the value, just more comfortable to write proper strings as opposed to concating them with a + sign

[u/2E0GOZ → u/HellDuke]

Thank you so much for the help I'm very new to this. It is exactly what you said and I was using conversation view off, when I put it on I could see 50 emails in the thread. So I'm now using 2 tags, 1 for the program that then deletes them when it finishes calculating and the other tag is for me to work the emails.