1. cancel delete;
   

Example

Note:

1. This task is only applicable to Zoho Creator.
2. The same app may be used by different users in different languages. This means the return value of this task may vary in different accounts depending on the language in which the app is accessed.
3. This task can be executed in all workflow events.
   

Syntax

Example

1. <variable> = getFieldNames();
2. // this syntax is not applicable to custom functions

1. <variable> = <collectionVariable>.getFieldNames();

1.  collectionVar = Registrations[Email == "john@zylker.com"];
2.  fieldNames = collectionVar.getFieldNames();

1.  appLinkName = "app1";
2.  formLinkName = "form1";
3.  authtoken = "54927XXXXXXXXXXXXXXXXXXXXXX924e3";
4.  url = "https://creator.zoho.com/api/json/" + appLinkName + "/"+ formLinkName + "/fields?authtoken=" + authtoken;
5.  response = invokeUrl
6.  [
7.  url: url
8.  type: GET
9.  ];

1. <variable> = getFieldValue(<fieldLinkName>);
2. // this syntax will work in workflows except custom functions

1. <variable> = <collectionVariable>.getFieldValue(<fieldLinkName>);

1.  listVar=List();
2.  collectionVar=Registrations[Email=="john@zylker.com"];
3.  for eachrecincollectionVar
4.  {
5.  fieldName=rec.getFieldValue("PhoneNumber");
6.  listVar.add(fieldName);
7.  }

1.  values = Map();
2.  for each field in getFieldNames()
3.  {
4.  values.put(field, getFieldValue(field));
5.  }
6.  info values;

1. <variable> = <expression>;

Example

1. input.<field_link_name> = <expression>;

Example

1. <variable> = thisapp.<function_name>(<parameters>);

1. thisapp.<function_name>(<parameters>);

1. <variable> = <application_link_name>.<function_name>(<parameters>);

1. <application_link_name>.<function_name>(<parameters>);

1. int getAvgSalary(String designation)
2. {
3. avgSalary=Employee[Designation = designation].avg(salary);
4. return avgSalary
5. }

1. Average_Sales_Salary = thisapp.getAvgSalary("Sales");

1. Average_Sales_Salary = Salary.getAvgSalary("Sales");

1. return <expression>;

1. int thisapp.CalculateDays(date sdate, date edate)
2. {
3. days = (((edate-sdate)/86400000)).toLong();
4. return days;
5. }

1. success message <expression>;

1. success message "Thanks for your feedback";

Note:

1. When the "cancel submit" task is triggered, all other deluge tasks except "send mail" task and API calls written in that "On Validate" section will be rolled back and won't get executed.
   
2. The "cancel submit" task also applies when data is being submitted through the Email Data feature or the Import data feature 

Syntax

1. if ( Name.first_name == "Null" )
2. {
3. cancel submit;
4. }