Jump to content

Finding Email Addresses


This topic is 7472 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi all,

I have a checkbox field named "Registration letter" when the boxed is checked, it means that the registration letter has already been sent to the user. What i'm trying to do is to retrieve the email address of users whose checkbox is unchecked and list them all out. confused.gif

This is only part of the question as there are many more questions to come. So please bear with me.

Thank you in advance!

-Prissy-

Link to comment
Share on other sites

You are looking for a calc which

- gets the position of the first occurence of the character "@" in a text field

->> position(textfield("@",1,1)

- then gets the word left of it

- then gets the word right of it

Unfortunately, some email addresses can have an underscore in it, so you canot use wordsleft() and right functions. So you have to search for the position of a space character to the left and right of the "@".

see attached file

email.fp5.zip

Link to comment
Share on other sites

prissypan said:

Hi all,

I have a checkbox field named "Registration letter" when the boxed is checked, it means that the registration letter has already been sent to the user. What i'm trying to do is to retrieve the email address of users whose checkbox is unchecked and list them all out. confused.gif

-Prissy-

OK, in the simplest terms you need to create a list-view layout that shows the email addresses of all the people whose record have an unchecked checkbox.

Creating the layout is easy enough, so I'm guessing you're just stumped on how to find the records in question.

Enter Find mode just like normal.

Click on the checkbox field.

Click the Omit box on the Status section (over on the far left).

Click Find.

Switch to the list view layout.

Link to comment
Share on other sites

On that topic, is it possible to have users define and 'omit' search if the status area is toggled off and locked? I've never been able to figure out how, and so I'm reluctant to turn off the status area, though this would be a good idea at times.

Dan

Platform: / Version:

FileMaker Version:

Link to comment
Share on other sites

"is it possible to have users define and 'omit' search if the status area is toggled off and locked?"

Bob Weaver has a sample file somewhere or posted instructions to manage this. It even handles multiple find requests with randomly omitted requests.

Basically, the trick is that in find mode the Omit Record step is the equivalent of clicking the omit check box in the status area! All the other interface mucking around is needed to work out whether the user wants the request omitted.

Platform: / Version:

FileMaker Version:

Link to comment
Share on other sites

Status Area is the rectangle on the left side, with the rolodex thing. It's also where the [x] Omit checkbox is, when you're in Find Mode.

The Omit is just Omit Record/Request. Notice the "Request" part (which we normally pay no attention to). When you script it, you just add the step Omit Record/Request.

You can simulate the Omit checkbox by creating your own Boolean checkbox field. Put it only on the Find layout; so it should be a dedicated Find layout.

Have the script Loop through the requests, omitting Requests with the Omit field checked (you can clear the field then, but it's not really necessary). And you have to be Paused, or the script wouldn't run.

Here's a little file that does it. It may be breakable; not seriously tested; but I think it's the basic idea.

Platform: / Version:

FileMaker Version:

Platform: / Version:

FileMaker Version:

Find_Omit.zip

Link to comment
Share on other sites

This topic is 7472 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.