Double Fetch in Zoho Creator Deluge

Double Fetch

 fet = Employee_Master[Email == zoho.loginuserid];

fet2 = Time_Sheet[Employee_ID.Employee_ID == fet.Employee_ID] sort by Date_field desc;

//fet2.Date_field.getDate() - Gives the date from the first record/oldest record of the report.

//Sorting in descending order helps in reading the date from the latest record.

//If not sorted in descending order by default it is sorted in descending order and gives the date from the oldest record.

if(fet2.Date_field.getDate() == zoho.currentdate.getDate())

{

input.Work_Location = fet2.Work_Location;

//alert "Yes";

}

else

{

input.Work_Location = "";

//alert "No";

}

--------------------------------------------------------------------------------------------------------------------

Fetch Emp ID

fet = Employee_Master[Email == zoho.loginuserid];

if(fet.Role == "Sourcing Admin" || fet.Role == "PE Admin")

{

enable Employee_ID;

}

else

{

disable Employee_ID;

}