- 1. ZohoCRM: Using Criteria with Module Record Count
- / Zoho /
- ... whose Campaign_Name is "CRM" and not records with "Best CRM" or "Latest CRM" in their Campaign_Name fields. When you use parentheses or comma in the value for a criteria, you must escape them using a backslash. ...
- Created on 14 November 2023
- 2. Zoho Creator: Receive JSON via a Shopify Webhook
- / Zoho /
- ... select JSON Under URL, paste the URL for your CRM REST API function from the steps above. Under Webhook API version I specify the one with the word Latest in the parentheses. Click on Save ...
- Created on 15 July 2021
- 3. Zoho Deluge: Search Records with Special Characters (COQL)
- / Zoho /
- ... name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you ...
- Created on 28 August 2020
- 4. Oracle: order by subquery missing right parenthesis
- / Oracle PL/SQL /
- ... error. So you can see my parentheses are fine. Working Solution: SELECT ps.person_id, ps.person_name, ( select txt from ( select pa.person_text as txt, pa.person_reference ...
- Created on 05 December 2013
- 5. MS Excel - Sort pivottable column headings by date
- / Excel /
- What? This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...
- Created on 12 April 2013