毎年変わる学年と年齢を自動更新する（カスタム関数（Deluge Script）とワークフロー）

学年/年齢項目を用意

誕生日起算で実行するワークフローを設定

引数を設定

//年齢更新
//今日日付をYYYYMMDDに変換
tm = toString(zoho.currentdate.getMonth());
if(len(tm) == 1)
{
tma = "0" + tm;
}
else
{
tma = tm;
}
td = toString(zoho.currentdate.getDay());
if(len(td) == 1)
{
tda = "0" + td;
}
else
{
tda = td;
}
nowd = toString(zoho.currentdate.getYear()) + tma + tda;
//誕生日付をYYYYMMDDに変換
bm = toString(birthDay.getMonth());
if(len(bm) == 1)
{
bma = "0" + bm;
}
else
{
bma = bm;
}
bd = toString(birthDay.getDay());
if(len(bd) == 1)
{
bda = "0" + bd;
}
else
{
bda = bd;
}
//
nowb = toString(birthDay.getYear()) + bma + bda;
//年齢算出式
agedeci = (toDecimal(nowd) - toDecimal(nowb)) / 10000;
age = floor(agedeci);
//年齢算出したものを更新
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"年齢":age}));
//学年の算出
//日付算出
birthd = birthDay.getMonth() + "-" + birthDay.getDay() + "-" + zoho.currentdate.getYear();
ap = "4" + "-" + "1" + "-" + zoho.currentdate.getYear();
//誕生日が4月以降だった場合は0、4月1日より前の場合は1を+させる
if(birthd.toDate() > ap.toDate())
{
i = 0;
}
else
{
i = 1;
}
//年齢による学年算出式
gakunen = zoho.currentdate.getYear() - birthDay.getYear() + i;
if(gakunen == 7)
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"小学１年生"}));
}
else if(gakunen == 8)
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"小学2年生"}));
}
else if(gakunen == 9)
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"小学3年生"}));
}
else if(gakunen == 10)
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"小学4年生"}));
}
else if(gakunen == 11)
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"小学5年生"}));
}
else if(gakunen == 12)
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"小学6年生"}));
}
else if(gakunen == 13)
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"中学1年生"}));
}
else if(gakunen == 14)
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"中学2年生"}));
}
else if(gakunen == 15)
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"中学3年生"}));
}
else
{
res = zoho.crm.updateRecord("contacts",leadID.toString(),Map:String({"学年":"不明"}));
}