Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

SMSaddress( Carrier ; CellPhone )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 4.3  (30 votes)
  Discuss this Custom Function

Roger Biel, 2Geckos Consulting, LLC
www.2geckos.com

Converts cell phone to e-mail address

Sample Input:
SMSaddress( "Verizon" ; "(520)708-9834" )
Sample Output:
5207089834@vtext.com


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

To find the mobile carrier, I use http://mobilecarrierlookup.com/

Below is the Provider ValueList:
Carrier Names
3 River Wireless
Advantage Communications
Airtouch Pagers
AirVoice
AllTel
Alltel PCS
Ameritech Paging
Arch Pagers (PageNet)
Bell South
Bell South (Blackberry)
Bell South Mobility;
Bluegrass Cellular
Boost
Boost Mobile
CallPlus
Carolina Mobile Communications
Cellular One
Cellular One East Coast
Cellular One PCS
Cellular One South West
Cellular One West
Cellular South
Central Vermont Communications
CenturyTel
Cingular
Cingular (GSM)
Cingular (TDMA)
Cingular Wireless
Communication Specialists
Cook Paging
Corr Wireless Communications
Dobson-Cellular One
Dobson Communications Corporation
Edge Wireless
Galaxy Corporation
GCS Paging
GrayLink
GTE
Houston Cellular
Inland Cellular Telephone
JSM Tele-Page
Lauttamus Communication
MCI
MCI Phone
Metro PCS
Metrocall
Metrocall 2-way
MetroPCS
Midwest Wireless
Mobilecom PA
Mobilfone
Morris Wireless
Nextel
NPI Wireless
Ntelos
Omnipoint
OnlineBeep
Pacific Bell
PageMart
PageOne NorthWest
PCS One
Enid Cellular
Price Communications
ProPage
Public Service Cellular
Qualcomm
Qwest
RAM Page
Safaricom
Satelindo GSM
Satellink
Simple Freedom
Skytel Pagers
Smart Telecom
Southern LINC
Southwestern Bell
Sprint
Sprint PCS
ST Paging
SunCom
Surewest Communications
T-Mobile
Teletouch
Telus
The Indiana Paging Co
TIM
Triton
TSR Wireless
Unicel
US Cellular
USA Mobility
Verizon
Verizon Pagers
Verizon PCS
Virgin Mobile
WebLink Wireless
West Central Wireless
Western Wireless
Wyndtell
*/

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 2 + 4 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions