Assuming number is required, the following 160 results were found.
-
Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
2023-03-20 (Joel Lipman) - Check if payment has already been recorded before creating a new one. - Fixed reference_number being included on customer payment. Date Modified: 2023-03-21 (Joel Lipman) - Added if conditions to not adjust stock level if item...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
happening in the background: File is generated FIle is attached to the last record of the source data File identifying number is returned from being attached File is opened in a new tab/window to trigger downloading. File is deleted from attachments...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Org ID: Login to ZohoDesk > Setup > Developer Space > API Scroll to the bottom of the page and you should see the 11-digit number "OrgId" there Note this down for later use Get the ZohoAnalytics Org ID: Login to ZohoAnalytics and ensure you are at the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
p_TicketRef) { v_TicketRef = ifnull(p_TicketRef,""); c_TicketRecords = QC_Report_Table[Ticket_Number == v_TicketRef]; for each c_TicketRecord in c_TicketRecords { info "Ticket Ref: " + c_TicketRecord.Ticket_Number; v_CountImages = 0; v_CountNew = 0; for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
v_BaseURL = "https://analyticsapi.zoho.com"; // // to get workspace ID, look at the URL in ZohoAnalytics and take the number straight after the word "workspace/" v_WorkspaceID = "12345000001234567"; // // to get the Analytics Org ID, login to Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
are upcoming events; status=closed are events in the past; status is a mandatory field // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index (not the ID of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
authenticate the contact on a Wordpress portal. OTP or 2FA or MFA or OTC is in effect however; so a contact email OR phone number is required. Both aren't required but at least one should be. How? We can do this without code and only using ZohoCRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
by the contact Zoho ID if(v_QuoteRef != "-") { r_SearchResults = zoho.books.getRecords("estimates",v_OrgId,"estimate_number=" + v_QuoteRef,"my_books_connection"); if(r_SearchResults.get("code") == 0) { l_SearchResults = r_SearchResults.get("estimates");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
{ m_CreateAccount = Map(); m_CreateAccount.put("Account_Name", m_SurveyBody.get("Company")); m_CreateAccount.put("Number_of_Employees", m_SurveyBody.get("Number_of_Employees")); m_CreateAccount.put("Turnover", m_SurveyBody.get("Last_Years_Turnover"));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
site (created on installation) is still a "Super User" (e-mail address, receives sys emails) and note their ID (identifier number). See if elements created on install show as created by the admin user and not by one of your users who coincidentally has...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
COUNT(*) FROM #__assets WHERE parent_id=0 -- where #_ is the Database Tables Prefix value There can be only one: If the number returned is 1 then this article is not addressing your issue. This is a red herring. If the number returned is greater than 1...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Calculating Percentagehttps://joellipman.com/articles/else/e-commerce/calculating-percentage.html
calculate a percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress So Far / Total Progress Units) * 100 = % or (Net Amount / Gross Amount) * 100 = % eg. (12...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
they see the error they programmed in. Apparently this problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst the data. The easy fix is by dealing...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
enough for our customers. The Workaround we actually went with Our Stored Procedure would check if the unique identifying number (in our case StudentID) matches a record in the database table and that the request number was alphanumeric. In addition,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
red censoring but this allows the images to be used in further demonstrations): Note that a footer exists (contains page number) because if printed, the page would end on a dataset row and continue the next page with the rest of the dataset. This footer...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
-- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS v_char_at NUMBER := 0; -- v_char_at : internal variable for string indexing v_rand_param1 VARCHAR2(50) := ''; -- v_rand_param1 : parameter 1...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
how to do this with a UNION ALL clause. Scenario: I have a Joomla module which should take the keywords from a specified number of different but similar tables. I'm looking to query the Title and the Introductions of any valid articles from BOTH tables...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB