Create a link from my ipushpull pages to an external website

To add a link from your ipushpull page to an external website, insert an ipushExternalLink(...) function in the spreadsheet cell you want to link from.

Here's the syntax:

=ipushExternalLink(URL, displayText)

Examples:

Suppose you want to add a link to a supplier's website to your ipushpull page. Insert this function into the cell you want to link from:

=ipushExternalLink("http://store.apple.com/uk/buy-iphone/iphone6", "Spec")

It should look something like this:

Open

When you push this range to ipushpull (using manual or automatic pushing or the ipush(...) function) the result will look like this:

Open

Clicking on the underlined Spec will now open a new tab and load the external page.

You can add as many links to your page as you like.

Instead of explicitly defining the URL and displayText parameters in the function call you can use cell references:

=ipushExternalLink(A1, B1)

or Excel formulas:

=ipushLink("http://store.apple.com/uk/buy-iphone/iphone6", SUM(E2:E10))

Other link types

The ipushpull Excel add-in lets you add a variety of other kinds of links to enrich your pages:

• ipushpull Page links

  • add links to other ipushpull pages to create live web sites. For example: create a summary page with links from each row to a suitable detail page

• Email

  • add links to your data that launch your email client when you click them

• Telephone Numbers

  • add clickable telephone numbers to your page - great when you're using our mobile site

• SMS

  • launch you mobile phone's messaging app direct from ipushpull