Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 First-off, let me list the various formats that Zoho Creator says that public link exists. Let's say I have a field called Main_Photo and this is in a form called Portal_Listing with a report/view called Portal_Listing_Report and I have a publish key...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 dynamically and in real-time. To this end, I create a field called "Audit_Change" and then I add to it our workflow with the main bit of code. For any other field that needs to update this preview, I tell it to update the "Audit_Change" field with...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Reminder on SSRS row separatorhttps://joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 details and the staff contact. I want an empty row to appear between each day in the list, so I have: Monday 03/10/2011 Main Office 09:00 17:00 Notes Monday 03/10/2011 Boss' Office 09:00 17:00 Notes Monday 03/10/2011 Stationary Cupboard 09:00 17:00...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 :Parameter3); The Solution To setup the call to the stored procedure for Oracle we had to do the following: We have our main report with a textbox that has the Action property: Go to Report / HouseKeepForm (our confirmation page) / With 2 parameters...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 and hopefully risk-free. How? Here's one method I used based on the services available to my client: Copy all files of your main website to another folder. Setup an FTP account to the new folder created in the previous step. Copy the database of your...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 Panel Go to Extensions » Install/Uninstall » and Install the RokBridge component Make a shortcut to it in your main menu (or whatever menu) Return the RokBridge component in Joomla Admin Panel (Components > RokBridge) Specify the name of the Bridge Path...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

CSS keeping the footer at the bottomhttps://joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 finally got them side by side. But the footer that has a background image was under the left and right columns... The main content layer was overlapping the footer. I tried various z-index's bearing in mind that the footer has to be behind because the...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: en-GB

MessageBox or AlertDialog in Android Javahttps://joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 = (EditText) f.findViewById(R.id.my_input_field); // this is the TextView to store the value in (not the AlertDialog but main xml) TextView newName = (TextView) findViewById(R.id.hangar_aircraft_001_name); // setting header text to returned input...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Android OS: Add GoogleMap as fragmenthttps://joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 you can still build this over the previous example (as I did). Why? The previous article meant that the Google map was your main activity and any other activity would be a sub-activity; returning to the map activity would restart the app as a menu item,...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Frontpage Item Orderinghttps://joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

16 September 2010 the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item called "Home" must be...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Setting up your store to use SSLhttps://joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 "Shared SSL" or the option to buy a "Dedicated SSL" certificate. Shared SSL means that your store will run using two domains your master domain name and shared secure domain which may be used by other customers of your hosting company. Dedicated SSL...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 creating a usable virtual hard disk. When it's done click on the small "Start" button below the "Remove" button (not your main Start menu button) As soon as it loads, press DEL to enter the BIOS setup. Navigate to the "Boot" section with the left &...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 A "Crystal Decisions" documentation. Blank columns appear when exporting to Excel. There are four main causes for extra blank columns to appear in a worksheet. Cause 1: Fields in the same column are not aligned with guidelines or snap-togrid To prevent...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: *

Passwords: Did-you-knowhttps://joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 to connect to your computer and to automatically download all the passwords. (source: NirSoft Recovery Tools 01/2008) 4 main techniques used in getting your password: Steal It (by looking over someone's shoulder), Guess It, Brute Force (=try every...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 (top right) Check your Joomla Admin User Each new Joomla version is trying a different method making this very diffcult to maintain. Check that the "super administrators" for Joomla 1.5 are in your new Joomla site (as "Super Users"). Check that the...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Could not instantiate mail functionhttps://joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 but it has some useful guidelines for these kind of issues: How to setup the Mail System 1) hostname must not match any domain that is being used on the system. Example, if you have a domain called domain.com and you want to recieve mail on...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 data sources in SSRS. A user will specify the student reference in the parameters of the first report (the one with all the main details), as well as a job reference (for audit purposes) and click "View Report". The report will refresh with a link to a...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 is, you can find this info on another site as this article focuses on getting an Oracle stored procedure to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Slideshow div layer through a windowhttps://joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 only appear within the boundary of the parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div layers, I'm going to refer to them as "window_slide" and "inner_window". Slide divs to be added inside the...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 Why? The kCaptcha used by the jComments extension is easily automated and no longer blocks spam comments. How? So the main bulk came from the JoomlaTune website but as it was a forum post that may get moved/deleted, I've copied most of it and put it...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *