Assuming account is required, the following 88 results were found.
-
null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). Most of the remaining datasets use the resulting @StudentReference...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We use a database account with read-only privileges to list all the details. On the last report, the one to execute the stored procedure, we use an...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
money to be returned to them or a third party, for example ‘to pay for shipping’. The cheque will clear into your bank account, only to be refused weeks later. At this point, the bank/building society will take the full cheque amount back out of your...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Thank You!https://www.joellipman.com/component/content/article/thank-you.html?catid=50&Itemid=165
feedback has been successfully submitted and is much appreciated. This filters through to an account which is checked regularly and you should get a quick response.
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
This was as a result after changing the owner of the Creator app to another person and adding our previous Super Admin account as a "Developer". How? I'm going to demo two methods here using the Setup the Connection Link Login to ZohoCRM as the creator...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
// can be any endpoint that does not redirect or reformat the resulting URL // // get Grant Token v_EndPoint = "https://accounts.zoho.com/oauth/v2/auth"; v_Scope = "ZohoBooks.contacts.ALL,ZohoBooks.invoices.ALL,ZohoBooks.purchaseorders.ALL"; v_State =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
2025 A few more years and a few more systems later, we need to parse out the timezone so its reusable, and also need to account for when timezone is not included in the Xero date/time: // REMINDER: Zoho Deluge Tryout needs backslashes to be escaped, CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Note that using this method, you don't have to escape parentheses characters (): // initialize v_MatchedCount = 0; v_MatchedAccountID = 0; v_SearchName = "Father & Sons (Incorporated)"; // // replace apostrophes with double apostrophe for sql...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
"Rejected". We're using the !="Cancelled" and probably !="Rejected" because we want pending ones to also be taken into account (first come first serve basis). Calculate the percentage of people already booked off: A very quick percentage calculation...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Map(); v_RecordID = r_Record.get("id"); v_CountFound = v_CountFound + 1; // // other field update if(!isnull(r_Record.get("Account_Name"))) { // do other stuff v_CountUpdated = v_CountUpdated + 1; } // // update the record irrespectively...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Alongside "Field Type", select "First Name, Last Name" Now your booking form will be similar to the following: And if the account is integrated with Zoho CRM, the contacts will be pushed correctly as first name and last name rather than full name to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to access the Quote Conversion Mapping page... Why? I wanted to map a billing street 2 and shipping street 2 from the Account module to the Quote module, then on convert, to map these to the Sales Order in CRM. As my client's sales team would only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= List(); l_FieldsToMonitor.add(input.Title); l_FieldsToMonitor.add(input.Contact); l_FieldsToMonitor.add(input.Account); l_FieldsToMonitor.add(input.Opportunity); v_eTag = zoho.encryption.md5(l_FieldsToMonitor.toString()); // // now compare to stored...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
on from my article Zoho Creator: Push to eBay Listings. I have a Creator app that needs to receive the orders from an eBay account as soon as the order or transaction is made on a Fixed Price item. How? So first of all, you'll need an access token:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
} info m_Currencies; // // get Books ID for a currency from an CRM account record r_AccountDetails = zoho.crm.getRecordByID("Accounts", 9012345678901234567); v_BooksCurrencyID = m_Currencies.get(ifnull(r_AccountDetails.get("Currency"),"GBP")); info...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
m_Data.put("Issue.Date", zoho.currentdate.toString("MMMM, dd yyyy")); m_Data.put("Organization.Name", r_ContactRecord.get("Account_Name").get("name")); // m_MergedData = Map(); m_MergedData.put("merge_data", {"data":m_Data}); // // to generate and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
form: one called "Customer's TimeZone" and the other called "Agent TimeZone", then our code needs to take these into account and will look more like the following: // defaults v_AppointmentType = "Initial Consultation"; v_AppointmentDuration = 30;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
on the Add Application button Select Creator by clicking the Add button below it Link it if applicable to your super admin account Create an app, a form and publish it in Zoho Creator Create an app by clicking on Create App then go into the app and...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *