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.

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-

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

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.

-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.

Hi thanks John.

Is it possible to make the method you've mentioned above into a script so that it will be easier for the end user?

Platform: / Version:

FileMaker Version:

Another thing is how do i link the checkboxes to the email address, so that Filemaker will know that when i check the box, its the email that i want to retrieve. Do i do it by defining the relations?

Platform: / Version:

FileMaker Version:

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:

Status area? Can you explain to me what is a status area?

Platform: / Version:

FileMaker Version:

"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:

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

Hi guys.. Thank you for your fast response.

Thanks to Fenton too, i'll try out the file..

Platform: / Version:

FileMaker Version:

Thanks!

Platform: / Version:

FileMaker Version: