Is it possible to use searchRecords to search a subform on a module?
I am trying to use .searchRecords to access a field in a subform on a module.
The name of the custom module I'm searching is "Residual_Purchases" and the subform APi name is "Affected_Accounts". I've tried using both the API name of the subform, and the API name of the field in the subform I am trying to match up as well, both return the same error (attached screenshot.)
Has anyone had success using .searchRecords to search a field on a subform within a module?
Here's the code I've tried, as well as a screenshot of the API names of the subform and subform fields.
- // Get Residual (custom module) record
resid = zoho.crm.getRecordById("Residuals",residId);
// Get Account Name from Related Account field
accountName = resid.get("Related_Account");
// Search Residual Purchase (custom module) records for accountName under Affected Accounts subform
ser = zoho.crm.searchRecords("Residual_Purchases", "name" = accountName);
// Return search results
info "Search Results: " + ser;
- // Get Residual (custom module) record
resid = zoho.crm.getRecordById("Residuals",residId);
// Get Account Name from Related Account field
accountName = resid.get("Related_Account");
// Search Residual Purchase (custom module) records for accountName under Affected Accounts subform
ser = zoho.crm.searchRecords("Residual_Purchases", "Affected_Accounts" = accountName);
// Return search results
info "Search Results: " + ser;