ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 and runs a function which will simultaneously create a task with a reminder both on popup and email which repeats every day until an end date. We then carry out the last bit of the brief with a separate workflow that runs exactly 4 days after the lead...

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

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

15 June 2010 the guideline. When the corners are highlighted in red, this indicates the field is snapped to the guideline. Repeat step 2 until all the fields in the section are snapped to the vertical guideline(s). Set the object’s size and position by...

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

Joes Quicklist Weblinks (JQW)http://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 and use the service. Login to front-end as a user belonging to the group specified in 3c. Keep refreshing the page until all thumbnails have been generated. Switch "STOP Thumbnail Service" to "YES" Logout NB: Thumbnails will first appear blue as the...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Creator: Receive JSON via a Shopify Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 Save the function Return to the functions list and hover your mouse over the function you just created until an ellipsis/3 dot icon appears > Click on it and select REST API. Enable the API Key option and click on the Copy icon to copy the url to...

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

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

30 January 2011 your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder. Avoid installing Sample Data if possible (there will be some but this script...

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

Cranberry flapjackhttp://mail.joellipman.com/articles/_other-misc/cranberry-flapjack.html

07 July 2009 the butter in a thick based non-stick frying pan. Spoon the mixture into small rounds. 3. Fry for 2-3 minutes on each side until golden. 4. For the caramel sauce, in a hot pan, add the butter and sugar and cook for 3-4 minutes. Then add the cream and...

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

Pancakeshttp://mail.joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 added, use a rubber spatula to scrape any elusive bits of flour from around the edge into the centre, then whisk once more until the batter is smooth, with the consistency of thin cream. Now melt the 50g/2oz of butter in a pan. Spoon 2 tbsp of it into...

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

Tagliatelle alla Carbonarahttp://mail.joellipman.com/articles/_other-misc/tagliatelle-alla-carbonara.html

07 July 2009 to taste, with salt and freshly ground black pepper. 4. Cook the tagliatelle according to the packet instructions, or until al dente, then drain, reserving a few tablespoons of the cooking water. 5. Immediately add the pasta to the prosciutto mixture,...

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

Sun-Dried Tomato Basil Couscous Recipehttp://mail.joellipman.com/articles/_other-misc/sun-dried-tomato-basil-couscous-recipe.html

03 September 2009 stir in garlic powder. Place couscous in a large heat-proof bowl. Stir in garlic broth, cover, and let steam for 5 minutes until tender. Fluff with a fork and gently stir in sun-dried tomatoes, onions, basil and some extra virgin olive oil. If I'm...

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

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

28 September 2009 and you get a web installation setup GUI similar to Joomla's. Follow the instructions of the GUI on each page until it confirms you've installed phpBB3. Install RocketTheme Affinity phpBB3 Style The next big step is installing the Affinity phpbb3 style....

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

How To Make Chocolate Chip Cookieshttp://mail.joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

30 September 2009 Leave about 2 inches between cookies - they'll spread out when they bake. Step 4: Bake Bake your cookies about 8-10 minutes, until they're golden brown, but still soft in the centers. Let them cool on the pan for a minute, and then move them to a...

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

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I can't see this panel, there is no advanced parameters...

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

Add Image Mouseover effect in AutoHotkey GUIhttp://mail.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 GUI are: and . These have to be saved in the same folder as the AHK script. It took me a while to get the tooltip to show until I realised you have to specify the tooltip text BEFORE the gui,show command. The above example is used in a search form where...

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

RokDownloads Manager does not list fileshttp://mail.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 I am in the middle of writing a component that will hopefully comprise bug-tracking and download management all in one. Until then, I thought I'd STFW (google) this issue and post a solution considering that even RocketTheme don't want to share this...

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

SQL Queries for Statisticshttp://mail.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 posted from a HTML form in my PHP. Also note: The association to a user can change because anonymous guests count as guests until they login, which is when they are associated to a UserID and identified as staff or student. Number of total hits...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 dataset) Select the Report Type (for just a table with a heading row at the top, select "Tabular") > Next Click on "Details" until everything is added. > Next I'm boring and old-school so my table style will be "Generic". > Next FINISH That's all folks!...

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

SQL Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 any room bookings for that month. This is "Reinventing" because we used to use MS Outlook to store these kind of things until the company implemented a software to deal with room bookings and said we shouldn't use Outlook for this... The DataSet The...

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

Joes FREE Website Thumbnailer (JWT)http://mail.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 program, you'll need to re-run the Help. The Help will tell you what to correct but it doesn't currently refresh its data until you request the Help page again. It only self-analyzes when the Help page loads, it isn't a persistent check. Just re-load...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

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

11 September 2012 }); Known Issues If the end-user clicks too quickly between slides, the slides are not ready or not in the right position until after 1 second --> reduce transition duration? No MooTools Vertical/Horizontal Fx.Slide? couldn't get it to have that smooth...

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

Battery Constantly Drained on iPhonehttp://mail.joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I wouldn't usually take notice but I think this is a brilliant example where...

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