The Poms Process a format file before submitting to a database add action
May 17, 2002; 15:25
The Poms
Process a format file before submitting to a database add action
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>
May 21
James Stadnyck Re: Process a format file before submitting to a database add action
May 21, 2002; 18:44
James Stadnyck
Re: Process a format file before submitting to a database add action
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!