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?!

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

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!!

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.

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!!

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