Assuming list is required, the following 200 results were found.
-
was a way to display the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report. How? We would think it similar to a picklist/dropdown where you simply add an option to the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
O', D', I' l_ExceptionPrefixes = {"Mc", "O'", "D'", "I'"}; // // deal with double barrelled surnames l_FormattedLastName = List(); l_LastNameParts = v_LastName.toList("-"); for each v_LastNamePart in l_LastNameParts { // // default to proper...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Instead, when building the invoice, this had to be added (don't ever remember having to do this) as contact_ids (array/list). Instead the below script will show you how to use this API having a few email addresses as the recipients: A sample code...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:GET headers:m_Header connection:"my_workdrive_connection" ]; //info r_TeamFolderInfo; // // ====================== // get list of subfolders by name (creates a timestamped duplicate if exists so need to check if it exists first) //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
pushing an invoice, there's a strong chance of being a cent/penny off. Let's take the following example of an item with a list price of 12345.545: ZohoCRM Line Item ZohoBooks Line Item How? Here's the immediate solution I have applied now until Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
is flaky so I thought I'd make a note here just in case I need to refer to it again. 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
all related sales orders l_RelatedSOs = zoho.crm.getRelatedRecords("SalesOrders", "Deals", m_Deal.get("id")); l_UpdateSOs = List(); for each m_SO in l_RelatedSOs { m_UpdateSO = {"id":m_SO.get("id"), "Status":"Cancelled"}; l_UpdateSOs.add(m_UpdateSO); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
you make a copy of the file before making the change just in case you need to revert the change: // We need to get a list of all weblinks in the given category $query = 'SELECT *' . ' FROM #__weblinks' . ' WHERE catid = '. (int) $this->_id. ' AND...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
see that the option “ Let windows choose what’s best for my computer “ is by default checked. Below it you should see a list of visual effects, some of which will be unchecked if you are not experiencing the full range of Aero features. Select the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
have a portable media player that needs to convert media files before they can be transferred to the device, then this will list all the originals you no longer need and send them to the "Recycle Bin". Say you've got 100 media files, you sat there...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for transactions...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
SSLCA specifies the path to a file with a list of trust SSL CAs. SSLCERT specifies the name of the SSL certificate file to use for establishing a secure connection. SSLKEY specifies the name of the SSL key file to use for establishing a secure...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
user and not by one of your users who coincidentally has the same identifier. Check that your OddUser (will be last user listed in users table) can login and their respective articles are still attributed to them. Prepare for Go Live This migration...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
expressions function search_escape_rlike($string){ return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string); } # function to list terms into list of regular expressions # eg. search for 'foo' matches 'a foo a' but not 'a food a'. function...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
T-SQL DateTimestampshttps://www.joellipman.com/articles/database/t-sql/t-sql-datetimestamps.html
130) 14 ?? ?????? 1432 06:00:00:000AM CONVERT(CHAR(25), CURRENT_TIMESTAMP, 131) 14/11/1432 06:00:00:000AM I originally got a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html
that licensees may convey the work under this License, and how to view a copy of this License. If the interface presents a list of user commands or options, such as a menu, a prominent item in the list meets this criterion. 1. Source Code. The “source...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the 3 following columns...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below you want to set as restricted, and click on OK. -- Restrict multiple drives by adding the values together -- For Example:...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF