Assuming records is required, the following 60 results were found.
-
t.`myColumn`=REPLACE(t.`myColumn`, 'ź', 'z'); UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'ż', 'z'); Retrieve records with foreign characters: SELECT * FROM `myTable` WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
"error"}: I have had this error with API v2 when I'm using PHP/cURL and not deluge to get a list of contact records. As I'm listing errors encountered, I'm adding it to this list. If submitting the headers as an array, note that it must NOT be an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)];... Lastly, there is a function I find myself...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
related to the API will get executed. Enter the trigger value as [] to not execute the workflows. Source(s): Insert Records API
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
on the record form. The "Save & Close" button would submit the form and then redirect the user to the report view of the records. Sounds simple but you can only set a form to redirect to one link and adding a HTML anchor link () to the page won't help...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= "https://" + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion = "2020-01"; // // loop through 2500 records v_LastID = 0; l_ProductIDs = List(); l_Pages = {1,2,3,4,5,6,7,8,9,10}; for each v_Page in l_Pages { v_Endpoint =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_CreateTask.put("Remind_At", m_ReminderAlarm); Source(s): Zoho CRM Tips: Schedule Calls to records Zoho Community: Zoho CRM: Zoho Api v2 Log a Call to Contact Error - Call_Type Invalid Direction
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// Generate your access token to connect to Xero and query Xero records // See my article: https://www.joellipman.com/articles/crm/zoho/zoho-deluge-sync-to-xero-api.html // v_TenantID = ""; v_AccessToken = ""; r_Response =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
input.Creator_File; // // add it to the public URL field input.Public_URL = v_PublicUrl; } Create a workflow to tidy up the records daily in Zoho Creator Go to Workflow > Schedules > New Workflow Set the Start date and time to tomorrow's date at 2:00am...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= 0; v_CandidateGraduatingCount = 0; v_CandidateGraduatingNextCount = 0; l_CandidateSearch = zoho.recruit.searchRecords("Candidates","School Name|=|" + v_SchoolName,1,200,"ALL","zrecruit"); for each r_Candidate in l_CandidateSearch {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
API.fn_ShopifyQuery_UpdateAllProducts() and it will be added to a nightly schedule. It's aim is to recover all the modified records of a day and ensure that the data in Zoho is the same as on the Shopify website. Included in this is the feature to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
release - Queries OpenAI ChatGPT Date Modified: 2023-03-11 (Joel Lipman) - Stores conversation messages / thread in CRM records - Retrieves and builds up conversation trail to send to OpenAI ChatGPT API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they are the same entity but may have uppercased a letter in their...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
creation or modification. The function to rule-them-all This code was used for testing, then for correcting any historical records, and then when given just one ticket reference; will create or update the images associated in the subform: void...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Shopify_ID == \"" + v_ShopifyID + "\")", page : 1, pageSize : 10 } // find the logged-in user record ZOHO.CREATOR.API.getAllRecords(config) .then(function(response) { // store the search results into an array var recordArr = response.data; // quick loop...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
would intermittently remove our webhooks. This would make the entire synchronization of the system go out of whack and some records would slip through the net while every day, the process to tidy these all up would leave the data more and more...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
adding the lookup to the line item will automatically display a related list on the Sales Order but does not associate any records... not sure why this is. So we have a workaround, by sending all the data including the custom fields per line items to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
help visualize the health of the system. Why? The use-case here is to build a system which monitors a Zoho App for when records were last modified and if a synchronization process starts to fail, there should be images or icons warning or advising of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ "/actions/add_tags" type :POST parameters:m_Params.toString() connection:"zcrm" ]; info r_AddTags; } } Fix to historical records This snippet uses COQL to find me all the deals where the tag is empty but the contact record wasn't. There is an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
2010: Select the data range to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only" box. A few more from Microsoft Office Help /* Count the number of unique number values in cells A2:A10, but do not...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF