Assuming where is required, the following 228 results were found.
-
is a redirect to the actual thumbnail stored by Google Drive: https://drive.google.com/thumbnail?authuser=0&sz=w320&id= // where is the file id The shareable link to the file will be something like: https://drive.google.com/file/d//view?usp=sharing //...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc )...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article'...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
2. Setup your Domain/Subdomain The process here is dependent on your service provider or domain registrar (website where you registered your domain). I've listed some third-party providers' instructions on how to set up a CNAME record at the bottom of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= Map(); // // enter webhook key featured in the "settings > notifications > webhooks" section beneath the webhooks where it says // "All your webhooks will be signed with.... so you can verify their integrity" (obtained further below in this article)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
mark it so that the process doesn't repeat on records that have already been checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Again this example doesn't include the publish key but can be used across apps in Creator [note this is just for quick ref]. Where my form is called "My_Form" and the image field is "My_Photo" [also note: instead of zoho.appuri, we are hardcoding the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has to go to the CRM record, click on Mail Merge, which opens...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? By default / out-of-the-box / vanilla, in a Zoho CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
check for the decimal point, check each digit thereafter to see if there are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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 picklist and then specify which of the options are selected. In this case, simply giving it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
on creation to allow 32000 characters. Keep the email field called "Email" Return to the Context Handler Function IDE (page where you enter the deluge code): Click on "Manage Connections" Click on Create Connection Select Service "Zoho OAuth" Give it a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section here where I demonstrate how to upload photos to be hosted by the Zoho Analytics app. Uploading the images to be hosted by Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
function invokeURL rather than the usual shortcode of zoho.crm.updateRecord() or zoho.crm.createRecord(). How? This is somewhere in the official documentation but here's the bits that I need: Updating a record with PUT (note that id needs passed for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
up to 200, v6 up to 10k, v7 up to 100k) m_Params = {"select_query":"select Product_Name, COUNT(id) 'Frequency' from Products where Product_Name is not null group by Product_Name limit " + v_PerPage + " offset " + v_Offset}; r_CoqlUniqueProducts =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it will load the first few images and as the user scrolls down the dropdown, more are loaded. This still gets buggy on...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
which took me a few years to notice in Joomla. If you've ever installed a template for Joomla and spent hours working out where or how you are going to put what where, try adding ?tp=1 after your index.php url (ie. http://www.yourdomain.com/?tp=1) If...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
cache" so click on the "Run Now" button which I found myself doing at lots of stages in this installation process. So note where it is and come back to it when things aren't responding properly....so in summary: General → Server configuration → Load...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *