Assuming find is required, the following 168 results were found.
-
v_Message = "To he who shall not be named, Re: " + v_Subject + " Please find attached the CSV export file containing the Data. "; // if(!isBlank(v_PermaLink)) { v_Message = v_Message + " The export file has been uploaded to the workdrive. The direct...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
be sent via the URL as a verification to be checked at the webhook endpoint would be good as well; but I couldn't spend time finding fields that can be 'placeheld', other than what the interface offers, into the template. the CRM webhook API function So...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 additional/repeat action to add tags; the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
issue that took me a fair few hours to resolve. So I'm putting it here as I thought I covered this previously but couldn't find it on my website. This was previously titled something along the lines of truncating to 2 decimals but finance is so much...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Use OpenAI Whisper Install Whisper using PIP: pip3 install -U openai-whisper Determine PATH of Whisper: find ~/.local/bin /usr/local/bin ~/Library/Python/*/bin -name whisper 2>/dev/null Add to PATH Edit your zsh file: nano ~/.zshrc Append the PATH line:...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
to Zoho Click on File Upload and upload the zip file that was just created the Index Page is /widget.html Hit Save then find the one you just created in the list and click on Install Select the profile(s) that will have access to this button and click...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
An article on some Zoho ANSI-SQL (in other words, queries that work in Zoho Analytics) as I couldn't find any examples online on how to do this. Why? I've been tasked with generating a radar/spider/web chart based on the results from a survey....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_WebhookBodyString = v_WebhookBodyDecode.getSuffix("Survey="); m_SurveyBody = v_WebhookBodyString.toMap(); // // find contact by email v_CrmContactID = ""; l_SearchContacts = zoho.crm.searchRecords("Contacts","Email:equals:" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if(b_Debug) { info "Available Taxes: " + l_CrmProductAvailableTaxes; } } } // // couldn't find it so let's create it m_CrmProduct = Map(); // // some companies don't use the product lookup in Xero so you would need a placeholder product from CRM....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// m_CrmProduct.put("Xero_Updated",zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss",v_ZohoTimeZone)); // // couldn't find it so let's create it if(v_CrmProductID == "") { r_CreateCrmProduct = zoho.crm.createRecord("Products",m_CrmProduct); if(b_Debug)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
On Gui Resize Eventhttps://joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html
events... The issue here is if you want to do something when a user resizes your program. If you search and search, you'll find that GuiClose responds to when you close the app, and GuiSize will run when you resize the app. Syntax: GuiSize: GuiControl,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
was asked "... how do you find out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
on http://www.autohotkey.com/forum/topic29752.html) which I'll put in soon. I just needed something on my site now as I find myself looking for this bit of info every now and again.
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
worked? Suggestions by Wikipedia If you are having difficulty understanding a problem, try drawing a picture. If you can't find a solution, try assuming that you have a solution and seeing what you can derive from that ("working backward") If the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
a tiny GUI that displays the link in black and works (somewhat). If you copy the above code into an AutoHotkey file, you'll find this is remarkably temperamental. If the user is too quick with their mouseovers and mouseouts, then the GUI will sometimes...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
--------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
on line 311 How? Copy & backup the file /public_html/.../templates/rt_affinity/rt_sectionrows.php Find the following piece of code around line 311: foreach($this->horizontalCookie[$row] as $block) { $block = str_replace('-', '', $block);...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF