Deluge Question: Conditional Statement
Deluge Question: Conditional Statement
Hello, I made a short video showing where I'm stuck. How can I add "For every 5000 over 44,001" execute___?
Video:
CLICK HERE TO VIEW
Thanks for your help!
if(Program == "Lawn Mowing" && Property_Sq_Ft >= 0 && Property_Sq_Ft <= 4500)
{
input.Services.clear();
row1 = Add_Program1.Services();
row1.Inc="true";
row1.Start_Date=zoho.currentdate;
row1.Service=Add_Service[Service = "Lawn Mowing"].ID;
row1.Price="42.40";
row1.B_Hrs="0.50";
row1.Assigned_To=Add_Crew[Crew_Name = "Mow Crew 1"].ID;
varCol = Collection();
varCol.insert(row1);
input.Services.insert(varCol);
}
else if(Program == "Lawn Mowing" && Property_Sq_Ft >= 4501 && Property_Sq_Ft <= 9000)
{
input.Services.clear();
row1 = Add_Program1.Services();
row1.Inc="true";
row1.Start_Date=zoho.currentdate;
row1.Service=Add_Service[Service = "Lawn Mowing"].ID;
row1.Price="47.20";
row1.B_Hrs="0.66";
row1.Assigned_To=Add_Crew[Crew_Name = "Mow Crew 1"].ID;
varCol = Collection();
varCol.insert(row1);
input.Services.insert(varCol);
}
else if(Program == "Lawn Mowing" && Property_Sq_Ft >= 9001 && Property_Sq_Ft <= 13000)
{
input.Services.clear();
row1 = Add_Program1.Services();
row1.Inc="true";
row1.Start_Date=zoho.currentdate;
row1.Service=Add_Service[Service = "Lawn Mowing"].ID;
row1.Price="52.00";
row1.B_Hrs="0.66";
row1.Assigned_To=Add_Crew[Crew_Name = "Mow Crew 1"].ID;
varCol = Collection();
varCol.insert(row1);
input.Services.insert(varCol);
}
else if(Program == "Lawn Mowing" && Property_Sq_Ft >= 13001 && Property_Sq_Ft <= 17000)
{
input.Services.clear();
row1 = Add_Program1.Services();
row1.Inc="true";
row1.Start_Date=zoho.currentdate;
row1.Service=Add_Service[Service = "Lawn Mowing"].ID;
row1.Price="60.00";
row1.B_Hrs="0.80";
row1.Assigned_To=Add_Crew[Crew_Name = "Mow Crew 1"].ID;
varCol = Collection();
varCol.insert(row1);
input.Services.insert(varCol);
}
else if(Program == "Lawn Mowing" && Property_Sq_Ft >= 17001 && Property_Sq_Ft <= 24000)
{
input.Services.clear();
row1 = Add_Program1.Services();
row1.Inc="true";
row1.Start_Date=zoho.currentdate;
row1.Service=Add_Service[Service = "Lawn Mowing"].ID;
row1.Price="65.00";
row1.B_Hrs="0.80";
row1.Assigned_To=Add_Crew[Crew_Name = "Mow Crew 1"].ID;
varCol = Collection();
varCol.insert(row1);
input.Services.insert(varCol);
}
else if(Program == "Lawn Mowing" && Property_Sq_Ft >= 24001 && Property_Sq_Ft <= 36000)
{
input.Services.clear();
row1 = Add_Program1.Services();
row1.Inc="true";
row1.Start_Date=zoho.currentdate;
row1.Service=Add_Service[Service = "Lawn Mowing"].ID;
row1.Price="70.00";
row1.B_Hrs="1.00";
row1.Assigned_To=Add_Crew[Crew_Name = "Mow Crew 1"].ID;
varCol = Collection();
varCol.insert(row1);
input.Services.insert(varCol);
}
else if(Program == "Lawn Mowing" && Property_Sq_Ft >= 36001 && Property_Sq_Ft <= 44000)
{
input.Services.clear();
row1 = Add_Program1.Services();
row1.Inc="true";
row1.Start_Date=zoho.currentdate;
row1.Service=Add_Service[Service = "Lawn Mowing"].ID;
row1.Price="75.00";
row1.B_Hrs="1.00";
row1.Assigned_To=Add_Crew[Crew_Name = "Mow Crew 1"].ID;
varCol = Collection();
varCol.insert(row1);
input.Services.insert(varCol);
}
else if(Program == "Lawn Mowing" && Property_Sq_Ft >= 44001)
{
input.Services.clear();
row1 = Add_Program1.Services();
row1.Inc="true";
row1.Start_Date=zoho.currentdate;
row1.Service=Add_Service[Service = "Lawn Mowing"].ID;
row1.Price="00.00";
row1.B_Hrs="00";
row1.Assigned_To=Add_Crew[Crew_Name = "Mow Crew 1"].ID;
varCol = Collection();
varCol.insert(row1);
input.Services.insert(varCol);
}
Tout forum
France ZUGs
Lille
Paris
Nantes
Lyon
Toulouse
Topic Participants
Chris Korfonta
Ruben [at] aorborc.com
Nouveautés produits
Chaîne YouTube
Résumé des activités
Témoignages client
Gagner en efficacité