Assuming table is required, the following 117 results were found.
-
The following code snippet will get the Opportunity/Deal/Potential record details, then get the Owner frrom the CRM users table, find the value of the custom field and search for this (if it is a lookup to a module - only returns as string), and updates...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_Day3_Ordinal = ifnull(m_Ordinals.get(v_NextDay.toString("d").toLong()),"th"); Then in my HTML table, I can use the headers: v_Day1_Header = " Today " + v_Today.toString("EEEE") + " " + v_Today.toString("MMMM") + " "; v_Day2_Header = " Tomorrow " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
An attachments section to hold a notes field. A notes field called "Note_Attachments" (this will display a HTML table with click-to-download files) A blank subform callled "Attachments" (links to a form called "Documents") Here's the Creator form to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
or text is possibly a quicker solution and when using a desktop interface, you can parse the multi-line into a nice HTML table. But on a mobile device, it's somewhat better to use the built-in interfaces provided by Zoho Creator. What I really needed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
notes issued in a particular month rather than the one-to-one with an invoice as profits in the past would change. So this table is created so that if a credit note was issued in January for an invoice issued prior to this, and we want to work out...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct prompts you can direct it to focus on the elements you want from a brief. How? A "prompt" is a...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
in the US, where there could be 4 different timezones between customer, agent, HQ, server; we would create a separate table to manage this data. I can't do this for every client, so here's a quick snippet to just check if Daylight Savings are in effect...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- 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
- Language: *
-
which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
and before I added all the layers of complexity, I want to have here an example that demonstrates a basic search on a table of data and returns one record as a result. The use-case here is that we are enhancing a quote builder form in Zoho Creator. The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
back rub, backrub, massages newyear: new year, new year's, new years oilchange: oil change, car service pingpong: ping pong, table tennis, ping-pong, pingpong planmyday: plan week, plan quarter, plan day, plan vacation, week planning, vacation planning...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: *
-
A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows:...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
known to you (create a new joomla user if necessary). The gist: Login to your Joomla database Go to the #__users database table (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
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 selection. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF