An email notification should work. There is another thread that would be of interest to you for this, this is a formula from QuickBasePros in that thread.
Case([Cell Provider],
"AT&T",[Cell # (as number)]&"@txt.att.net",
"Verizon",[Cell # (as number)]&"@vtext.com",
"T-Mobile",[Cell # (as number)]&"@tmomail.net",
"Sprint PCS",[Cell # (as number)]&"@messaging.sprintpcs.com",
"Virgin Mobile",[Cell # (as number)]&"@vmobl.com",
"US Cellular",[Cell # (as number)]&"@email.uscc.net",
"Nextel",[Cell # (as number)]&"@messaging.nextel.com",
"Boost",[Cell # (as number)]&"@myboostmobile.com",
"Alltel",[Cell # (as number)]&"@message.alltel.com",
"MetroPCS",[Cell # (as number)]&"@mymetropcs.com"
)
https://community.quickbase.com/quickbase/topics/qb-and-sms