How to prevent empty records?!

[Silvia]

I have a web shop in Filemaker pro 5.5 unlimited. Every time someone enters the shop (even just to browse) it creates a new record - if the visitor leaves without ordering anything the record is left blank. How do I prevent this? Can the empty record be deleted automatically when the visitor leaves the shop?!

[spb]

The way I think I understand what you need to do is to trigger a script on an event (the customer leaving the shop). Trigger-on-event is high on the FM wishlist, but it is not yet available to us.

You might set yourself up a daily housekeeping function, a button you click first thing in the morning that runs a simple script that finds and deletes all empty records.

Or you could take a look at the initial design and see why a record is created by someone logging on, as opposed to being created at the point where the browsing person does something.

Steve Brown

[Silvia]

Thanks for your reply. Could you explain exactly what I need to do to create a button that deletes all empty records? That would be very helpful. I'm a beginner at this, so I need some extra help.

Thanks!!

[Ugo DI LUCA]

It happens that I create a new file and that I don't use it (i.e. order form because the client change his mind).

What I did is the following.

In my button "New Order", I integrate a script that look to the last file and check if the fields are empty. If so, instead of creating a new file, I use the one that is empty.

[Silvia]

Well I need a script like that to go automatically whenever a new record is created in the order.fp5 database.. without having to click a button.. is that possible? How?? And could you be so kind and cut & paste the script you're using?? I tried, but I don't seem to get it right.. Thanks! I'd be very grateful!!

[Ugo DI LUCA]

I have a web shop in Filemaker pro 5.5 unlimited.

Every time someone enters the shop (even just to browse)

it creates a new record ...

How do we enter the shop ? Is there a script like "create new file" ? If so the script shoud be included with the function Enter the shop script (if it exists)

If not...tell me more