[FX.php List] Approach to update FM data from web input

[Troy Meyers]

Jonathan,

It's not exactly trivial to set up, but there's a trick in FileMaker that we use to track and date-stamp all changes into a logging field for a record, showing original and new values. We've had users do that too, so it's nice to be able to see the old stuff.

It's too hard to explain in a minute, but it takes advantage of field calcution evaluation order.

-Troy


> Hi Folks,
> 
> I'm working on a solution where the user (customer) will be able to 
> log in and update their customer information online.
> 
> While this isn't an issue technically, there's the business issue of 
> how to process the new data without the risk of losing the original 
> data....especially if the new data is invalid.
> 
> In my last experience in this arena, I was astonished at how 
> determined one user was to erase every bit of data presented on the  web
> form.  The customer could just clicked one box to become  inactive. 
> Instead, they felt compelled to eradicate their data.  In  this case,
> there was a second records for each customer that  contained the
> original data...the effort was futile.
> 
> So...what do you folks do?
> 
> Jonathan