Formula calculations | Zoho Creator Help

Formula calculations

This API service lets you manage the different functionalities in a form.

Formula calculation

Methods
executeFormula(forFieldLinkName:withDelegate:form:)This should be called to calculate the result of a formula field which is a part of the form field. It should be called after the user has completed giving the input for the participating field.
Use "FieldProtocol.formulaExists" to find out if the field is participated in a formula field.
 
executeFormula(forRecordID:reportLinkName:and:withDelegate:form:)This should be called to calculate the result of a formula field which is a part of the form field. It should be called after the user has completed giving the input for the participating field. This method is applicable while editing a record in a report.
Use "FieldProtocol.formulaExists" to find out if the field is participated in a formula field.
 
executeFormula(forFieldLinkName:withDelegate:form:)

Parameters

fieldAccessPathThe access path of the participating field.
delegateA delegate to get the Form object of the formula calculation.
formA Form object in which the actions are to be executed.
 
executeFormula(forRecordID:reportLinkName:and:withDelegate:form:)

Parameters

recordIDThe ID of the record that needs to be updated.
reportLinkNameThe report link name.
fieldAccessPathThe access path of the participating field.
delegateA delegate to get the Form object of the formula calculation.
formA Form object in which the actions are to be executed.
  1. Adding a record from a report
  2. Adding a record in a form
  3. Adding an entry in a Lookup field
  4. Editing a record in a report
  5. Bulking editing records
  6. Fetch choices
  7. Upload media
  8. Deluge script executions
  9. Field actions