Assuming most is required, the following 77 results were found.
-
a lat/lng). The added feature is that we are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called "States" which stores a default timezone and can be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template snippet for a Zoho Creator page. We set the parameters of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // fetch all payments against this customer in order of payment reference (oldest to most recent) r_SearchResults = zoho.books.getRecords("customerpayments",v_BooksOrgID,m_SearchCriteria,"zbooks"); if(!isnull(r_SearchResults.get("customerpayments")))...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and I'm adding these to a Creator form called "Appointment", my code should be something like the following: // // get 100 most recent appointments where this field hasn't been populated l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null]...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
bear in mind that any image in a prompt can be accessed if people work out the link. "Stealth" mode is only available in the most expensive subscription plan. NSFW will likely be blocked. Installing Stable Diffusion on a local server is the recommended...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
SPF & DKIM setup to improve email deliverability from a ZohoApp and methods to check. Why? Not sure how I came across it as most of our customers don't use ZohoMail, but there is a Zoho Toolkit to run some checks on the email deliverability for a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
but we need these to match if we want to map them in the "Lead Conversion Mapping" page. How? This is a bit of a hack and most likely not recommended... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Field on User Profile Login to ZohoCRM as a system administrator > Go to Setup > Users > Click the pencil icon (top-right most) to edit any profile On the user's dialog/popup in the bottom left, there will be a link saying "Manage Fields" Add a picklist...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below to work, is to add a file upload field on the user profile in ZohoCRM; Login as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not the most essential part of a system but important to some staff... How? In an earlier article, I've shown how to change a radio type...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
info "m) " + v_Rounded; // Yields: 12345.55 So in practice, and for the sake of your finance team's sanity, the most acceptable solution is to deduct the 10th of a cent/penny and as per the documentation for adjustments, we'll run a check after the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
were no help at all. Worse, I hadn't backed up my website for 18 months so even if Joe managed to retrieve it I expected most of my data to have gone. Joe not only fixed it immediately but all the data was still there too! Magic!
- Type: Article
- Author: Webmaster
- Category: Portfolio
- Language: *
-
with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example, the statement: If (ThisCondition = true) ThisVar:=1 Else ThisVar:=2 Converted to Ternary this...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
range. The problem is that there are a few thousand users and Microsoft's SQL Server Reporting Services interface isn't the most fun to scroll endlessly down. Advanced users can type the name really fast for it to auto-scroll down to the desired name....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF