@ ZOHO Creator Team:
This is case-sensitive (only counts records where field Last_Name starts with EXACT value of Client_Last_Name) ...
- matches = count(ClientInfo[LastName.startsWith(input.Client_Last_Name)]);
- alert(matches);
... but this is not (counts records where field Last_Name starts with UPPER/LOWER cased value of Client_Last_Name) ...
- baseURL = (("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname;
- thisURL = baseURL + "/#View:gkMatchingClients?LastName=" + input.Client_Last_Name + "&LastName_op=24";
- openUrl(thisURL, "same window");