SebastianWPB

I've got two fields now in my database: domain_list and Phone_carrier the Phone_carrier field contains the value list of the carriers. I don't know what to do now. I'm thoroughly confused.

I've done what you suggested. There's still the problem with getting the completed text address. So far it's just creating number@ and that's it. Well, I've actually had that part done for a long time. Now I just need it to grab the carrier value and append the appropirately completed domain.

No, I apologize, but I never really understood the calculated email address field response. I was under the assumption that I was to do two different things. If this is not the case, please bring that to my attention. I appreciate all of your insight and expertise!

I don't see how what you just posted answered my question. I need to create addresses from two fields. I understand the emailing script, but it's not going to email the correct address without some doctoring in the scripting department.

ifmcel, I'm sorry, but what you just posted reads like Greek to me. I AM running FileMaker 6, and I need the above values to be appended to the text address. Can you show me an example of what you're talking about?

I read that incorrectly yesterday. That should be the answer to my problem, but one thing I can't seem to do is create a value list. How do I give the selection "sprint" the value of "messaging.sprintpcs.com" ? This is the current breakdown: Cingular: message.mycingular.com AT&T: mobile.att.net Nextel: messaging.nextel.com T-Mobile: tmomail.net Verizon: vtext.com I'm not sure where or how to do this. I already have a pop-up list created, but where do I give them values? Again, I'm using FileMaker 6

Pupiweb, Thank you for your implementation of that script. I think I can work with it. My final issue is the value list that creates the email address from the two fields: Phone 1 and text address. I need the address to pull the value "sprint, at&t, verizon" into the email field appending the respective format. For sprint it's "Phone 1@messaging.sprintpcs.com", for verizon it's "Phone 1@vtext.com" etc. Phone 1 is the number that has been entered. I attempted to create a value list with this data, but I don't think I'm doing it correctly. Can you perhaps give me an example of how to do this?

Pupiweb, Thanks for the file. However, I'm not sure what to do with it. Did you see my database, and do you understand what I'm trying to achieve? I need to grab all the text message addresses and put them in the TO line of my email client with the click on a button or running a script or whatever. thanks in advance

I'm stuck on everything. Here's my database. I don't understand what you people are talking about with all this. It sounds it would only take you two minutes to show me how to do this on my database. It only consists of one file. Please help

The purpose of this list is to send text email addresses. Therefore, the number of people in the TO field is irrelevant. People who receive the text message don't seen anyone else who has also received it. If anyone is willing to take my file and show me what you all are talking about, I would be greatly appreciative. I'm pretty confused at this point, as I'm a business man, and not a FileMaker Developer.

I wish to create the text message address from two fields. Their carrier (spring, at&t, nextel, etc) and their mobile number. I then wish for my email client to pull all those final addresses into the TO area of my email client. Eventually, I want to be able to customize which text messages are sent out by the click of the day of the week or venue selection. I'm using 6.0 of the plain vanilla FileMaker Pro on the PC, although, this will be used on Mac and PC in the end.

ifmcel, I've created the calc field for the above. That's the text_address field. I then created the value list in a field named "domain_field" with all the possibilities and their values. Well, I thought I created the value list, but I'm not sure exactly what I did. I went to define values and told the mobile carrier field to use the value list for its values. Was this incorrect? The third part of your post is where I get lost. I don't new what you mean by design function ValueListItems. Take pity, this is my first time attempting custom scripting using FileMaker.

I posted this in another forum, but NO ONE bothered to even give it a go. I hope that perhaps someone can give me a little more insight in this forum. Here's what I wish to do and here's how I assume it has to be done, but I lack the skills in scripting to make it so. I have a field named phone1. When the data is entered into Phone1, it is also part of the data that results in text_address. Text_address should append the "@" symbol and strip away any formatting of that number for emailing. According to the value that is chosen from a pop-up menu, mobile.att.net, messages.nextel.com, etc is appended to @ in that field value. Like so: 5615772395@mobile.att.net That's part one of the task. Secondly, I wish to have a button which will take all of those addresses and put them into my outlook client from the push of a button. This is already halfway done, because of the email script in FileMaker. So, to review: (A) Script for formatting a field value into an email address based on two fields values. (: Pulling all email address values for text_address into my email client at the click of a button running a script. I've looked into third party solutions, but I know this can't be that hard. I've already got the field adding the "@", now I just need to strip the special formatting and append the appropriate carrier information. I'm including the file as an attachment, because I so desperately need to have this accomplished. Any help at all is sincerely appreciated. You're welcome to email me directly at: sebastian@palmbeachonthego.com or IM me via AIM: KSFCOM - this project should have been done weeks ago. This is the only part holding me up. Copy of the_list.zip

Any direction at all would be greatly appreciated. I really want to get away from having to use an email client with a copy and paste solution for the daily messages we send out. Feel free to email me directly: sebastian@palmbeachonthego.com if you're interested in helping without the world seeing. Thank you

I thought I posted this here, but apparently I was mistaken. Here's what I wish to do and here's how I assume it has to be done, but I lack the skills in scripting to make it so. I have a field named phone1. When the date is entered into Phone1, it is also part of the date that results in text_address. Text_address should append the "@" symbol and strip away any formatting of that number for emailing. According to the value that is chosen from a pop-up menu, mobile.att.net, messages.nextel.com, etc is appended to @ in that field value. That's part one of the task. Secondly, I wish to have a button which will take all of those addresses and put them into my outlook client from the push of a button. This is already halfway done, because of the email script in FileMaker. So, to review: (A) Script for formatting a field value into an email address based on two fields values. (: Pulling all email address values for text_address into my email client at the click of a button running a script. I've looked into third party solutions, but I know this can't be that hard. I've already got the field adding the "@", now I just need to strip the special formatting and append the appropriate carrier information. I have attached this database so you can see what I'm trying to do. I should also mention that I completely took the easy route and used one of the templates. I hope someone can give me direction for the information I seek. Copy of the_list.zip