Create Links Between ipushpull Pages

ipushpull lets you create links/hyperlinks between your pages. Click on A INC in the first column of the page embedded below - it takes you to another page. Click BACK on that page to come back to the first one.

To add a link between your ipushpull pages, insert an ipushLink(...) function into the spreadsheet cell you want to link from.

Here's the syntax:

=ipushLink(pageName, folderName, displayText)

Examples:

Suppose you want to add a link to a page called london_sales in your folder called sales_folder. Insert this function into the cell you want to link from:

=ipushLink("london_sales", "sales_folder", "LondonSales")

It should look something like this:

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

Clicking on the underlined Details cell will now take you to the london_sales page.

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

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

=ipushLink(A1, B1, C1)

or Excel formulas:

=ipushLink("london_sales", "sales_folder", SUM(E2:E10))

Note that the ipushpull access control rules are applied to links. If a user has access to the summary page but not the detail page, when they click on the link they will see an 'Access Denied' error.

See the attached demo spreadsheet for more details.

ipushpull Documentation

Create Links Between ipushpull Pages

Other link types