Hello all,

I thought I would bring something in for everybody to get your teeth
into.

I have a form where people are asked to enter their birthday. Some enter
the date incorrectly and it generates a "error code 500" when the format
does not match the Filemaker database's date format.

I started fiddling around, making the users select a date, a month and
type in a year, in three separate entries and then concatenating the
entries into a variable acceptable by the database, but it created a lot
more challenges than I could cope with, in the suceeding format files.

So my first question is this: Is there a way to validate a date field
for its format? If there is, then all I would have to do is to re-direct
the user to the same page with a little addendum explaining in bolder
letters the format required for the date, until he gets it right and
then proceed to the other pages.

I would be happy with this solution as a temporary one while I learn my
way through something more elegant, which brings me to the second
question. The second question requires that I describe my objectives
with this form in more details.

This is a registration form. At the end of it I need the database to see
a new record created happily. The way I had it originally before the
"error 500's" came up, was an add page followed by an update page and a
success page that sends an email to the database administrator and to
the new registrant.

I want the update page between the success page and the first data entry
page to provide the user with a way to check that he did enter his stuff
correctly.

The way I see it is that for this middle page to be filled in correctly
with the data from the previous page, with data that can be used to
update the database if necessary, I need fields with "Form_Param"'s in
it. It's all nice and easy until I bump into the pop-ups. If the user
realises that he selected the wrong relationship on the "confirm" page,
he needs the pop-up there again for him to select the correct one,
doesn't he? Either that or there could be a button to go back to the
first page and correct his selection there. The problem is that a whole
new record would be added to the database, wouldn't it? And I cannot
have that.

So here is my second question: How do I do it so that I can pre-process
the date entries before I submit data to the database and still have my
pop-up's dynamically filled in with the correct data on an update page
(from the user's selections on the previous pages)?

Sorry for the windy query, but I hope it was clear enough.

--
Kim


-----------------------------------------------------------------------
To Unsubscribe: <mailto:lassostudiogl-off@blueworld.com>
List Archives :
<http:////listsearch.blueworld.com/LassoStudioGLSearch.lasso>