ArGiEs wrote:Brian or Dave,
Last April someone asked for a way to text from a phone number in a text field instead of dialing it. Brian responded with a .zip file containing an example set-up to create that in a DB. I d/l it, and today just got around to trying to build it in my customer DB. I didn't quite get there. All I got was a copy of the targeted phone number with the numeral 1 added onto the end of it.
I believe I have the general idea what it's doing: combines the intended phone number with what I guess is the iOS internal address for iMessage,
sms://, which when launched opens iMessage and inserts the phone number nice & neatly into the recipient field. Like I said, I got the phone number with an extra digit tacked onto the end, and, when the weblink field is tapped Safari launches to tell me the page can't be displayed:-/
If you would, please, explain to this non-programmer how to set the fields up correctly. The name of the fields that contain the phone numbers are Phone 1 and Phone 2 (both are text fields). I don't know if it's significant, but each of the phone number text fields are tied in to a Dial Number field as well. Just for clarity, I also want to be able to do that to each phone number independently.
Thanks,
Bob
Sent from my iPhone using Tapatalk
You are so close to what you want, you can taste it, but you are missing two fields from the sample that Brian provided. The fields that you are missing are the sms prefix, and the combine text fields which appends the sms prefix to the phone numbers.
Let me back up a second and ask a question. Your dialing field that you have to phone the customers, I am assuming that you are using a field that appends a 1 to the front of the phone number so you can dial long distance or maybe your phone provider makes you put a 1 in front of the number to dial out?
I downloaded the example from Brian (had to search for it), and loaded it up on my device. I then wanted to see how to recreate what you are seeing, and I was able to recreate it by using an external field to send the phone number to a web link which opened up Safari. I then added an external field to dial the phone number and I was successful in being able to do both SMS and Dial the Phone Number from the same database. So the thought of you already dialing the phone with the phone number is not preventing the SMS External Field from working.
The reason why you are seeing Safari open up, is because your external field does not have the "sms://" in front of the phone number.
To get to where you want to be, follow this. I tried to make it easy to read, but put some explanations in it, so if I confused you at any point, just let me know.
- You need a field that is hidden (or you can make it visable, but that would clutter up the screen), and that it has the static value of "sms://". Call it SMS Prefix (that is what Brian called it). If you already have this field, then proceed to the next point.
- Create a text field called SMS Phone Number, or something that has SMS in the name so you can differentiate it from your dial phone number field.
- You need an external field to combine the SMS Prefix field to your phone number field, and use the SMS Phone Number field for the combined text.
- Set your external external field that you are using for SMS property "Field Containing Web Address" to the SMS Phone Number Field.
- You should be all set to rock and roll.
P.S. - The SMS sample that Brian provided also works on iOS 9 on my iPad. The dial feature doesn't work because the iPad does not have phone capabilities
