Creator Help

Sample Code

Calculate Days

Function to calculate the number of days between two given dates. The function returns an integer value.

Function Definition:

int Calculations.CalculateDays(date sdate, date edate)
{
days = (((input.edate - input.sdate) / 86400000)).toLong();
return days;
}

where,

int - type of data returned by this function is of type int.
Calculations - is the namespace under which the Function is created.
CalculateDays - is the function name.
sdate - argument of type date.
edate - argument of type date.

Function Call:

The function CalculateDays is called in the on add -> on success script, which updates a numeric form field Number_of_days with the value returned by the function.

on add
{
on success
{
input.Number_of_days = thisapp.Calculations.CalculateDays(input.Start_Date, input.End_Date);
}
}

Date Format

Function to get the month, year and date of a given date. The function returns the input date as a string in the format "day/month/year", for example 12/2/2008

Function Definition

string dateformat.getAustralian(date inputdate)
{
month = inputdate.getMonth();
day = inputdate.getDay();
year = inputdate.getYear();
outputstr = day + "/" + month + "/" + year;
return outputstr;
}

isLeapYear()

Function to check if the given year is a leap year. The function returns a boolean value 'true', if the given year is a leap year.

Function Definition

bool isLeapYear(int year)
{
leapyear = false;
if ((input.year % 400) == 0)
{
leapyear = true;

}
else if ((input.year % 100) == 0)
{
leapyear = false;

}
else if ((input.year % 4) == 0)
{
leapyear = true;

}
return leapyear;
}

nextLeapYear()

Function to return the next leap year based on a given year. Here, the function calls another function isLeapYear().

Function Definition

int nextLeapYear(int year)
{
input.year = (input.year + 1);
if (thisapp.isLeapYear(input.year))
{
return input.year;
}
else
{
return thisapp.nextLeapYear(input.year);
}
}

Email Notification

Function to send mail to selected records in a view.

Function Definition

void Email.EmailNotification(string toaddress)
{
sendmail
(
To : input.toaddress
From : zoho.adminuserid
Subject : "Subject of the email"
Message : "Your message"
)
}

Custom Action

The function Email Notification is configured as Custom Action in the View definition. The value of the EmailId field in the form is passed as the argument value.

custom actions
(
"Send Mail" : Email.EmailNotification(toaddress = EmailId)
)

Update Field Value

Function to update the value of Travel_Status field in the SampleForm to "Confirmed", for selected records in the view.

Function Definition

void test.ConfirmTrip(int id)
{
rec = SampleForm [ID == input.id];
rec.Travel_Status = "Confirmed";
}

Custom Action

The function ConfirmTrip is configured as Custom Action in the View definition. The value of the ID field of the selected records will be passed as the argument value.

custom actions
(
"Confirm" : test.ConfirmTrip(id = ID)
)

Note:

  • Change the form and field names based on your requirement.

Top