... logged in user (who clicked the button)
v_LoggedInUserID = 0;
r_Users = zoho.crm.getRecords("users");
for each m_User in r_Users.get("users")
{
if(m_User.get("email").equalsIgnoreCase(zoho.loginuserid))
{
v_LoggedInUserI ...
What?
This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records...
Why? ...
... retrieve all shipment orders for that day from ZohoInventory
r_YesterdaysShipments = zoho.inventory.getRecords("shipmentorders",v_BooksOrgID,m_Criteria,"ab_inventory");
if(!isnull(r_YesterdaysShipments.get("shipmentorders")))
{
l_YesterdaysShipments ...
... = zoho.recruit.getRecords("Candidates",v_FromIndex,v_ToIndex,"Modified_Time","CANDIDATEID","asc","my_connection");
//info l_Candidates;
//
// sanity check to output that it did something
info "Done ...
... fetch all payments against this customer in order of payment reference (oldest to most recent)
r_SearchResults = zoho.books.getRecords("customerpayments",v_BooksOrgID,m_SearchCriteria,"zbooks");
if(!isnull(r_SearchResults.get("customerpayments")))
{
l_SearchResults ...
... check the form was ticked and there is a package ID specified
if(input.Mark_as_Complete && input.Zoho_Package_ID != "")
{
v_PackageID = input.Zoho_Package_ID;
r_PackageSlip = zoho.inventory.getRecordsByID("packages",v_BooksOrgID.toString(),v_PackageID,"ab_inventory");
if(r_PackageSlip.get("package") ...
... listed here, the standard searchRecords() and then the getRecords() functions:
Set the record ID to your own record ID.
Set the list of pages to the number of pages you want to search. Keep ...
... 32;
//
// set to the Account record of our organization
v_OrgAccountRecord = 123456789012345678;
//
// loop through all users
r_Users = zoho.crm.getRecords("users");
if(!isnull(r_Users.get("users")))
{
for ...
... to assign the sales person.
How?
So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead.
In the next ...
... get 100 records
l_Contacts = zoho.crm.getRecords("Contacts", 1, 100, m_Criteria);
//
// loop through each contact record
for each r_Contact in l_Contacts
{
v_Count = v_Count + 1;
if(!isnull(r_Contact.get("Email")))
...
... the first list layout
Click on "Configure fields for Web"
Add Fields that you want returned
Done
This applies to Zoho Creator 5 when using zoho.creator.getRecords(), zoho.creator.searchRecords(), ...
... someone may want to open this in Google Sheets or Microsoft Excel:
//
// init
l_NewCSVrows = List();
v_ThisEventTime = zoho.currenttime;
//
// loop through dataset
for each r_Event in zoho.crm.getRecords("Events", ...
... a standalone function called "Test".
Type in line 1: r_Record = zoho.crm.getRecords
then press Enter (DO NOT START TYPING FOR A MODULE NAME - LET THE SYSTEM POPUP YOUR OPTIONS AS PER THE FOLLOWING SCREENSHOT ...
... in this department/team:
To determine the total number of employees, we will use zoho.people.getRecords as a search:
// get total "team members" in department
l_SearchCriterias = List();
m_SearchCriteria ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.