Assuming means is required, the following 37 results were found.
-
which is NOT in column A. Drag the formula in B2 down all the list as per the following screenshot. A value equal to "#N/A" means the value was NOT found in column A. Method #2 Be careful with this one because if you copy the formula down, it may...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
starting with "File" - eg. "File0001.txt", "File0002.txt") For "Retrieve File Name" I put "Fully Qualified" (hoping this means the full path is used as just putting the file name did not work). Under "Variable Mappings" specify the Variable...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
through. Our transform package will convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could do this: But we...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
article in your browser. Hangar New to the app I thought it would be really cool if I could change the equipment by virtual means. Tap on any equipment, photo or detail to change it. I have pre-loaded it with my own Quadcopter's details but feel free to...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
this on your server) - Warning: Images will reset if you specify a different image type (default is PNG) (eg. PNG to JPG -> means module has to re-download thumbnails into JPG format) - Fixed Bug: Weblink hit counter now works through Joomla! CMS - Date...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
general and prevents the administrator URL showing up at all in the stats (unless you were using it). Leaving this unchecked means that the crackers/hackers will get through ultimately whether it be by brute-force, DoS, Injection, etc. I'm not saying...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
in Zoho, check the domain and specifically the top-level-domain (TLD) part. For example, if it says zoho.com, then this means the US datacenter. If it says zoho.eu, then this is the EU datacenter. If it says zoho.in, then this is the India datacenter....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
that I want to monitor. An eTag for me is simply an MD5 or hash of a bunch of data. If your MD5 value is different, then it means there was a change. If not then it is unlikely that any change was made. Instead, I need to add an additional field called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent would be referring to 2 status fields and not really knowing which one defines the stage the lead...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and then to push that product out to their Shopify store with a pre-built description, tags and inventory details. This means the app needs to be able to sync all of its products, customers, and orders with Shopify as a 2-way integration as the Zoho app...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
bit of this snippet creates a map which for this example would be {"9":1,"10":2,"11":3,"12":4,"13":5,"14":6,"15":7}. This means that if I click on Tuesday10March, this code will match "10" to the map and determine what index or offset this is from the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
have DVI and VGA inputs. The 3 Dell monitors can daisy chain with a combination of DisplayPorts and Mini-DisplayPort, which means that only 1 DisplayPort cable needs to go the PC. They also have 1 HDMI input. The NZXT Z490 Motherboard I have only has 1...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
end user/customer. A custom field against the item record has been added which is a lookup to the Sales Order module. This means that on a purchase order, and per line item, the staff can specify which Sales Order the item relates to. How? At time of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I'm recording the module name and module record ID on the ZohoSign Document record. Doing this at the point of the request means that I can have a generic webhook that handles every ZohoSign completion and attach the signed PDF accordingly. The button...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
time. If you want other categories to display, consider setting categories as vertical, horizontal and square banners. This means that you can have 3 modules each displaying banners from each category and position these as appropriate.
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution below is...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
stop MS Excel simply opening the CSV as if it knew what to do with it. It doesn't. Saving the data source as a text file means that Excel will prompt you what to do with each column: 1. Specify that the data is delimited 2. Specify the data is delimited...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF