Google Apps Script Conditional If/Else If Statement

Question

I've got this script below but it keeps returning the incorrect information. For instance, even though the "urgency" may equal "medium", it returns the "critical" result.

var initialcontact;
var row = sheet.getActiveRange().getRowIndex();
var urgency = sheet.getRange(row, getColIndexByName("Urgency")).getValue();
if (urgency = "Critical") {initialcontact = "1 hour";}
else if (urgency = "High") {initialcontact = "4 hours";}
else if (urgency = "Medium") {initialcontact = "1 day";}
else if (urgency = "Low") {initialcontact = "3 days";}

Presumably, the script you're using started out as the Help Desk tutorial. If so, it would be helpful to others for you to include that in the question - it gives background that may help resolve problems, and gives credit to the original authors. — Mogsdad
– Mogsdad, Commented Dec 5, 2013 at 17:19
I didn't begin with the Help Desk tutorial, but when I found it I did take parts from it...didn't think to include that. Sorry for any confusion. — user3070876
– user3070876, Commented Dec 5, 2013 at 18:27

Srik · Accepted Answer · 2013-12-05 16:12:36Z

2

You should use == for comparing , not =

if (urgency == "Critical")

and so on..

answered Dec 5, 2013 at 16:12

Srik

7,9952 gold badges22 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user3070876 Over a year ago

Ok, I made that change but it is now coming back as "undefined"

Srik Over a year ago

Which variable is returning undefined ? Please also post the sample spreadsheet data

user3070876 Over a year ago

The initialcontact variable is returning as undefined in the spreadsheet...almost as if urgency = undefined but it doesn't. The sample is that I have a column with the listed "Urgency", for example "High", and then in the column "Initial Contact" I want it to return a variable accordingly, so if urgency was high, it would return "4 hours".

Fred Over a year ago

Did you change all 4 comparisons to ==?

Srik Over a year ago

In addition to what Fred says, add a Logger.log() to print out the value of urgency . This is a very simple script and there is nothing else that can go wrong.

Collectives™ on Stack Overflow

Google Apps Script Conditional If/Else If Statement

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related