Assuming working is required, the following 120 results were found.
-
site you were trying to access and your usual solution is a reboot, then this tool may be for you. In my environment, I am working with a Visual Studio 2008 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
parameters have no effect. It was initially built for someone as a quick syntax highlighter that recognizes SQL; but I am working on getting it to recognize more programming languages so that I can use it on my own site. Limitations Recognizes SQL only...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing time of the day (working hours). How? The plan is to iterate through a 24-hour clock, enable adding to the picklist when the starting hour is found...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I resized the text...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
in returned JSON (invalid in Zoho): v_MyString = "{"MyKey":"MyValue "}"; // the long way (and cos the regex for this isn't working) v_FormattedString = v_MyString.replaceAll("\r","",false); // carriage returns v_FormattedString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
searches will work for me and sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company name. The issue...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
3: .joellipman.com (used in verification), .joellipman.com and www..joellipman.com (for the subdomain). I have had this working with the 2 CNAME records though. Some providers say this will take between 24-48 hours but I have often found that after a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
"errors": { "code": 7115, "message": { "From": "Sorry, this record cannot be edited." } }, "status": 1 } } [The working solution] I'll cut to the quick solution, which was not to try to update the form at all but instead to prevent the user from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
lists. Why? Because I keep forgetting how to do this and it takes about an hour to go through the documentation and get a working solution. How? So the article below shows how to do this Zoho CRM and how to do it in Zoho Books... The example below is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this end, I have thought of an alternative that I now use frequently in client systems. How? The gist is that we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
which in turn contained commas. Saving this as a CSV and asking Deluge to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ") + "12:00:00"; // // convert...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
looping through all records and creating a distinct list variable... But what if there are 20000+ records? The advantage of working in a team of Zoho developers, is that "two heads are better than one" does apply more than we think. A colleague of mine...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
events to emulate the mouseover and mouseout effects of a button with an image as a background. I couldn't get any of these working and they looked more confusing then anything else. My solution is to set up the default button and the image to respond...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
// returns "Mon" How? Well a few methods. Method #0: Update 2020 Tested in CRM and Creator and this is working: My_Date = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
from 0 to 9) in a Zoho Deluge script: v_PaymentTermsNumber = v_PaymentTerms.replaceAll("[^0-9]",""); // yields 30 And if working with money/currencies, a one liner to maintain the decimal point v_SalesAmount = "Total : £ 5.00"; v_SalesAmount =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
m_Variant.put("inventoryItem",{"cost":ifnull(input.Shopify_Unit_Cost_Price,0).toDecimal().round(2).toString()}); // not working // use inventory_items l_Variants.add(m_Variant); m_Product.put("variants",l_Variants); // // do photos...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the user to be able to set entries in a subform called "Mondays" then to click a button which copies it to the remaining working days. How? So I have a form with 6 subforms which list staff/employee shifts from Monday to Saturday. The form I have looks...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *