Assuming status is required, the following 86 results were found.
-
m_CreateTimeLog = Map(); m_CreateTimeLog.put("date",v_StartTime.toDate().toString("MM-dd-yyyy")); m_CreateTimeLog.put("bill_status",v_Billable); m_CreateTimeLog.put("hours",v_HoursHHmm); m_CreateTimeLog.put("start_time",v_StartTime.toString("hh:mm a"));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
l_HeaderColumns.add({"key":"valid_till","value":"Valid Till"}); l_HeaderColumns.add({"key":"quote_status","value":"Quote Status"}); l_SearchResults = r_SearchResults.get("data").toJSONList(); for each r_Result in l_SearchResults { v_CreatorQuoteID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
with " + v_CustomerName); m_ScheduleCall.put("Call_Start_Time",v_SystemAppointmentDateTimeStart); m_ScheduleCall.put("Call_Status","Scheduled"); m_ScheduleCall.put("Call_Type","Outbound"); // // optional fields...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
script on a server that will validate the Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter than Zoho's. Setup a Zoho CRM Function: Login to Zoho CRM >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to_integer(substring_before(q."Text", '.')) AS "Question Number", q."Text" AS "Question", r."Text" AS "Answer", r2."Status" AS "Status", r3."Variable Value" AS "Respondent Email" FROM "Responses (Zoho Survey)" r LEFT JOIN "Surveys (Zoho Survey)" s ON...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
= 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 20; b_Debug = false; // // Xero Invoice Statuses vs your CRM Invoice Statuses m_TranslateStatuses = Map(); m_TranslateStatuses.put("DRAFT","Draft");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and save it as "Contacts vs Campaigns Pivot": SELECT * FROM ( SELECT "Contact Id", "Contact Name", "Campaign Name", "Member Status" FROM "Campaign Members - Contacts" ) t1 PIVOT ( MAX(t1."Member Status") FOR t1."Campaign Name" IN ( "Campaign...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
this is shortcode, not an invokeURL. { "code":"INVALID_DATA", "details":{ "api_name":"data" }, "message":"invalid data", "status":"error" } How? I recall covering this solution before but it boils simply down to the zoho.crm.getRelatedRecords() not...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for the initial sync to complete (should be quick) Confirm the Location table appears in the workspace Confirm the sync status shows Success Repeat the above for all required tables: See my list below for the core tables and for custom queries. Set...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
y10 gRestart, Reload Gui, Add, ListView, w600 h528 +Hdr +Grid x0 y50, Old Name|New Name Gui, Font, s7, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Successful Response: { "criteria": "ID==1234567890123456789", "newvalues": [ { "FieldToUpdate": "ValueToUpdateWith" } ], "status": "Success" } Method #2: Using API v1 (using JSON not XML) Generate AuthToken: Browser Mode: Open a browser to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
} } // now override fields specific to the newly cloned/duplicated record m_Clone.put("Invoice_Status","Repeated Invoice"); m_Clone.put("Invoice_Date",zoho.currentdate.toString("yyyy-MM-dd"));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products.json?status=active&limit=250&fields=id&order=id+asc&since_id=" + v_LastID; r_GetProducts = invokeurl [ url :v_Endpoint type :GET...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
m_Product.put("published",true); // set to true when comfortable with it publishing correctly m_Product.put("status",ifnull(input.Publish_Status.toLowerCase(),"draft")); // // build up variant list under this product l_Variants = List(); m_Variant =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
" New Template", "id": "aaaa1111bbbb2222cccc3333dddd4444eeee5", "permalink": "https://docs.zoho.com/file/a1b2c3d4", "status": "active" }, { "created_time": "2019-08-28T16:30:33Z", "modified_time_ms": 1567009834477, "owner_id": "34567890",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// with a reminder 5 minutes before (eg. "10 mins", "1 hrs") m_ScheduleMeeting.put("Remind_At","5 Mins"); // // the meeting status m_ScheduleMeeting.put("Status","Not Started"); // // send request and create record r_CreateMeeting =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers when Status is "Paid" Just once or every time is "Everytime" Actions is a custom function called "fn_invoice_updatepaymentmethod" But...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
r_Response = zoho.crm.invokeConnector("crm.getusers",m_UserType); if(!isnull(r_Response.get("status_code"))) { if(r_Response.get("status_code")==200) { l_Users = r_Response.get("response").get("users"); for each v_User in l_Users { v_LoggedInUserID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status to return: All, Active, Cancelled, CancelPending, Completed, Inactive, InProcess v_OrderStatus = "All"; // // calculate from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
back to StaticAlias rather than member Email - Possibly still an issue with delayed payment (check this is not holding status) Date Modified: 2023-03-17 (Joel Lipman) - Enhanced debug messages as function not auto-triggering on receipt of Order -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *