Validation

[boller]

Probably quite an easy solution, but i cannot figure it out, without using several million ifs.

hmmm

just wondering how i can get an email validation

in the form

[email protected]

where as yyy has to be part of a value list

with all the million .net .tk .com .co.uk. .il .de

etc etc

thanks

mike

[comment]

No, it's not easy at all. Read here .

[boller]

ok i sort of understand

but mostly don't

can i just that php in a validation calculation!?!?!!?!?!?

[comment]

Alas, no. But the article gives a good overview of the issues involved. Some parts of the method are easy to convert into Filemakerese, others difficult, if not impossible.

The question is what do you need and how much resources are you willing to put into it. For example, you could isolate the last top-level domain and check for a valid field in a related table of top level domains. That's only about 250 records.

Or you could split it into two: first, check if the last part is a country code. If so, isolate the part before last and check if it is a valid generic TLD (only 15 of those). If not, check if the last part is a generic TLD.