UID has been generated | Google Developer Community | Page 1

somber vault Sep 22, 2024, 5:47 PM

#

email sent or nah?

#

#workspace message oh

#

that is tragic

lean sluice Sep 22, 2024, 5:47 PM

#

yup

#

however if I fire that bad boy manually

somber vault Sep 22, 2024, 5:48 PM

#

perm issue then unfortunately

lean sluice Sep 22, 2024, 5:48 PM

#

it spawns in normally

#

lean sluice Sep 22, 2024, 5:48 PM

#

lean sluice

that was on manual fire

lean sluice Sep 22, 2024, 5:48 PM

#

somber vault perm issue then unfortunately

huh

somber vault Sep 22, 2024, 5:48 PM

#

actually sec

#

gimme a spoonful of time

lean sluice Sep 22, 2024, 5:48 PM

#

any bypass or do I have to create a vercel server less script again

somber vault Sep 22, 2024, 5:49 PM

#

lean sluice any bypass or do I have to create a vercel server less script again

vercel serverless always comes in clutch but lets use that as a last resort

lean sluice Sep 22, 2024, 5:49 PM

#

oh I have to deal with sheets API again that sucks

somber vault Sep 22, 2024, 5:49 PM

#

https://developers.google.com/apps-script/reference/mail/mail-app#authorization_1 you sure this is there as a scope?

Google for Developers

Class MailApp | Apps Script | Google for Developers

lean sluice Sep 22, 2024, 5:50 PM

#

valid point need to check it out

somber vault Sep 22, 2024, 5:51 PM

#

sec trying to reproduce this while you do that

lean sluice Sep 22, 2024, 5:54 PM

#

summin like this?

somber vault Sep 22, 2024, 5:55 PM

#

yah

lean sluice Sep 22, 2024, 5:55 PM

#

yeah thats there

#

Still aint going

somber vault Sep 22, 2024, 5:56 PM

#

yeah your thing is tweaking

#

mines an editor add on

#

works fine

#

and your handler seems to fire

#

so wtf

lean sluice Sep 22, 2024, 5:57 PM

#

somber vault yeah your thing is tweaking

did you have it on trigger?

somber vault Sep 22, 2024, 5:57 PM

#

i have it happen when a dialog shows up

lean sluice Sep 22, 2024, 5:58 PM

#

hmm

somber vault Sep 22, 2024, 5:58 PM

#

sec, go to your overview

#

when you scroll, what scopes does it show there?

lean sluice Sep 22, 2024, 5:58 PM

#

somber vault Sep 22, 2024, 5:58 PM

#

** b r u h **

lean sluice Sep 22, 2024, 5:58 PM

#

fr

somber vault Sep 22, 2024, 5:59 PM

#

whats ur email quota

#

chances are its maybe ignored for manual runs

lean sluice Sep 22, 2024, 6:00 PM

#

I need to check that im trying the Gmail library for now

#

even that does not work

proper elk Sep 22, 2024, 6:04 PM

#

just writing a message to get the notificatons on this thread xD

somber vault Sep 22, 2024, 6:04 PM

#

vro

proper elk Sep 22, 2024, 6:05 PM

#

I was looking for it 💀

lean sluice Sep 22, 2024, 6:05 PM

#

lmao

proper elk Sep 22, 2024, 6:06 PM

#

Didn't see it and expected it to be in a more obvious place like 😭

lean sluice Sep 22, 2024, 6:06 PM

#

im currently tweaking as to how he got it so fast and mines tweaking

proper elk Sep 22, 2024, 6:06 PM

#

Anyways, I'm a bit busy today, but if you guys don't figure it out i'll try to look into this tomorrow

lean sluice Sep 22, 2024, 6:06 PM

#

ok

#

thanks

proper elk Sep 22, 2024, 6:07 PM

#

gl(hf?)

somber vault Sep 22, 2024, 6:07 PM

#

lean sluice im currently tweaking as to how he got it so fast and mines tweaking

hm

lean sluice Sep 22, 2024, 6:07 PM

#

proper elk gl(hf?)

thanks

somber vault Sep 22, 2024, 6:07 PM

#

sending code here again for reference

#

function onFormSubmit(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  // Get the header row (assuming it's the first row)
  var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
  
  // Find the column numbers
  var phoneNumberCol = headers.indexOf("Your Phone Number") + 1;
  var nameCol = headers.indexOf("Your Name") + 1;
  var emailCol = headers.indexOf("Your Email Address ") + 1;
  var datesCol = headers.indexOf("Days You will Be Attending") + 1;
  var uidCol = headers.indexOf("UID") + 1;

  // Check if all required columns are found
  if (phoneNumberCol > 0 && nameCol > 0 && uidCol > 0 && emailCol > 0) {
    // Get the last row
    var lastRow = sheet.getLastRow();
    
    // Get the values from the last form response
    var phoneNumber = sheet.getRange(lastRow, phoneNumberCol).getValue();
    var name = sheet.getRange(lastRow, nameCol).getValue();
    var email = sheet.getRange(lastRow, emailCol).getValue();
    var dateAttend = sheet.getRange(lastRow, datesCol).getValue();
    
    // Take the first 3 letters of the name and email
    //.... logic for UID
    var uid = "MBS-D2024-" + (total % 256);
    
    // Write the UID back to the sheet in the "UID" column
    sheet.getRange(lastRow, uidCol).setValue(uid);
    var htmlTemplate = HtmlService.createHtmlOutputFromFile('Style').getContent()
    .replace(/{{259106725__COL\$D}}/g, name)
    .replace(/{{259106725__COL\$A}}/g, uid)
    .replace(/{{259106725__COL\$I}}/g, dateAttend)
    .replace(/{{259106725__COL\$G}}/g, phoneNumber);  
    MailApp.sendEmail({
      to: email,
      subject: "Mallapur Bangiya Sangha Durgotsav 2024 - Dandiya Nights Registration Confirmation",
      htmlBody: htmlTemplate,
      name: "Mallapur Bangiya Sangha", // Optional: Set the sender name
      bcc: "", // Optional: Add BCC recipients if needed
      replyTo: "",
    });
  } else {
    Logger.log("Phone Number, Name, or UID column not found.");
  }
}```

lean sluice Sep 22, 2024, 6:07 PM

#

yup np

somber vault Sep 22, 2024, 6:08 PM

#

theres NO WAY this solves your issue but try it off superstition anyways lol https://stackoverflow.com/questions/64221977/email-not-sending-or-probably-not-being-triggered-on-form-submit-google-apps-scr

Stack Overflow

Email not sending or probably not being triggered on form submit Go...

Well we have this google form and the details are being added to google sheet with custom g apps scripts. When the details have been appended to the google sheet log, it should send email. If I run...

lean sluice Sep 22, 2024, 6:11 PM

#

Theirs is much more simpler than mine honestly

#

cause what I see is their code does not run at all

#

mine does. but its some selective ahh running

somber vault Sep 22, 2024, 6:17 PM

#

lean sluice cause what I see is their code does not run at all

yeah thats what i thought but the answer said [Edit] Since the trigger is created properly, change the first the line of the trigger code from:

#

that's probably not the issue

#

more likely is your code has an error somewhere

#

move send email to the first linje of the handler (with hardcoded stuff)

lean sluice Sep 22, 2024, 6:18 PM

#

I plead to differ, it should not have worked when run manually then no?

somber vault Sep 22, 2024, 6:18 PM

#

lean sluice I plead to differ, it should not have worked when run manually then no?

yeah, but there can always be inconsistencies between environments

lean sluice Sep 22, 2024, 6:18 PM

#

true

#

5 mins

#

ok

#

so

#

I was nerding about

#

This is what i find when its triggered:

#

and if I run it manually those values exist

#

so my code is tweaking when run on triggers

#

what the hell

#

scammers I tell you

#

I GOT IT TO WORK 🗣️🗣️🗣️🗣️🗣️

#

I REMOVED VARIABLES AND BASICALLY GOT IT TO GET VALUES THEN AND THERE AGAIN

#

I COOKED 🗣️🗣️🗣️🗣️🗣️

#

HEHAW

#

I must thank you for spending a part of your day in helping me with this problem!

#

Could not have done it without the nudges

somber vault Sep 22, 2024, 6:42 PM

#

lean sluice and if I run it manually those values exist

ahhh

#

🔥

somber vault Sep 22, 2024, 6:42 PM

#

lean sluice I REMOVED VARIABLES AND BASICALLY GOT IT TO GET VALUES THEN AND THERE AGAIN

😭

#

so it was an env difference wtf

lean sluice Sep 22, 2024, 6:43 PM

#

not only that

#

its tick rate

#

the varaibles were not allocated the memory by the time the email was sent

#

pretty sure thats why they return me a blank value

#

they are declared but never initialized

#

makes sense as to why manual runs works

#

honestly stupid but sure who cares if it works it works

somber vault Sep 22, 2024, 6:44 PM

#

lean sluice and if I run it manually those values exist

lean sluice Sep 22, 2024, 6:44 PM

#

???

somber vault Sep 22, 2024, 6:44 PM

#

the whole script runs when manually executing it

lean sluice Sep 22, 2024, 6:44 PM

#

Oh lmao

somber vault Sep 22, 2024, 6:44 PM

#

but the handler uses the function as an entry point

#

so nothing ever happens

lean sluice Sep 22, 2024, 6:45 PM

#

yeah its so goofy

somber vault Sep 22, 2024, 6:46 PM

#

Damn

#

So now we know

#

Whenever you send the code yeah

#

Send the whole thing 💯

#

Censor out some values but keep the code structure intact 🗣️

lean sluice Sep 22, 2024, 6:46 PM

#

f

#

r

somber vault Sep 22, 2024, 6:47 PM

#

Tragic fix I was lowkey hoping for a bug to be there on Googles end

lean sluice Sep 22, 2024, 6:47 PM

#

bug bounties are nice

#

😔

somber vault Sep 22, 2024, 6:47 PM

#

Only rewarded for security bugs afaik laugh

#UID has been generated