Assuming work is required, the following 174 results were found.
-
noted earlier: Click on OK and close the respective dialogs (note that setting the variable via the command prompt will NOT work!) To get the Test SHA1 code: Creating a Google Maps project in Android Studio (v0.8.6 beta) "creates" a SHA1 along with the...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
A quick article to get an Apple Trackpad working with an MS Windows 11 Pro (Intel 64) workstation. Why? I forgot my work Macbook at home and rather than drive the commute back and forth again, I took my previous biscuit box out (a Dell MFF Optiplex...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
function: "json_encode". How? So here's what I tried and ended up with: If your XML is UTF-8 This is the basic code and will work to fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file //...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
the Microsoft website is as helpful as the Microsoft paperclip, in other words, not worth the time or effort to try (didn't work anyway). The TRIM() function will not work for you either, nor with the VALUE() function.... The culprit was a suspicious...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
You can change this but remember to put two double-quotes if you are searching on it, eg: FIND(""",B1) // will NOT work! FIND("""",B1) // will work FIND("″",B1) // will work You could merge all the statements into one but for simplicity's sake I'm...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Windows 7 SCREENSHOTS: LICENSE: These scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
adding it to this list. If submitting the headers as an array, note that it must NOT be an associative array: // this won't work $a_Header['Authorization'] = "Zoho-oauthtoken " . $v_AccessToken; $a_Header['Content-Type'] =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
a first example, there is a problem here, you asked for Books and this next bit shows how to attach it to a CRM record. This works in the scenario where you have disabled the transaction modules in CRM (so Sales Orders, Invoices, Purchase Orders) and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at time of print (2020-10-24), Zoho Creator does not allow you to use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Another red herring ahead] We tried various other options such as adding a tickbox that would be used in an approval workflow but ran into issues when trying to update the record: { "response": { "message": "Error occurred", "uri":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
and I have a publish key held in v_ListingPublishKey and lastly, my datacenter is .COM: URL Syntax #1 // works in eBay v_ImageSrc = "https://creator.zoho.com/file" + zoho.appuri + "Portal_Listing_Report/" + input.ID + "/Main_Photo/image-download/" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
If you don't get an OK message then check your CRM code matches as above (with different v_Webhook_Key). If it still doesn't work then try solution #2: using a third-party server detailed further in this article. Solution #2: Using Third-Party Server If...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
An article on something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and the Payment Date. Why? This was requested by a customer...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= "com"; // // enter client ID, secret and refresh token as noted from above steps (the below are sample ones and will not work) v_ClientID = "1000.ABCDEFGHIJKLMNOPQRSTUVWXYZ1234"; v_ClientSecret = "aaaabbbbccccddddeeeeffff111122223333444455";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
two months to find a solution. How? Disclaimer! There may be many ways of doing this, this is just one way that we used that worked for 90% of the invoices. There are invoices that may be associated to sales orders changed after being confirmed or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
filters or criteria. Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working examples I use in production...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
ZohoDesk is sync'ing with your ZohoAnalytics: Login to ZohoAnalytics as an Admin with access to ZohoDesk Make a note of the workspace name that your ZohoDesk will sync with. Select Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
Zoho Creator: Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want a solution which sits on an external website and which talks to Zoho, then setup an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *