ipushpull lets you add links to your pages that launch your email, phone and SMS messaging apps with the email addresses or phone numbers you specify. You could use this feature to e.g. create an interactive client directory page for your staff or to let your customers contact you directly from the pages they are viewing.
Here's the syntax:
|=ipushExternalLink("mailto:email@example.com", "ipushpull Support")|
|Phone||=ipushExternalLink("tel:+123456789", "ipushpull Support")|
|SMS||=ipushExternalLink("sms:+123456789", "ipushpull Support")|
It should look something like this (note that we've used some special symbols in the displayText to make the links more attractive):
When you push this range to ipushpull (using manual or automatic pushing or the ipush(...) function) the result will look like this:
Clicking or touching the email link will launch your email program and create an new email with the address pre-populated as firstname.lastname@example.org.
If your device supports telephone calls, clicking or touching the phone link will ask you if you want to call the specified number.
If your device supports SMS messaging, clicking or touching the SMS link will ask you if you want to send an SMS to the specified number.
You can add as many links to your pages as you like.
Instead of explicitly defining the URL and displayText parameters in the function call you can use cell references:
or Excel formulas:
Other link types
The ipushPull Excel add-in lets you add a variety of other kinds of links to enrich your pages: