Hi all,

How to write a script that can clear a field in all records when users close the FMP5?

The obvious question is "why do you want to do this?". Kind of sounds like a "how do I drive in a screw with a hammer?" question . The answer is to use a shutdown script and a replace statement, but there is probably another way to structure the whole process. -bd

Hi LiveOak,

I forgot to mention that the FMP5 database was located in our server and all users are accessing it from LAN as a guest. So, does the shutdown script can do what i want? Because the host will never be closed.

Quick thought, Not if any of the fields are global fields, as only the host entries are saved. I'll ponder on any other consequences.

OH ~

I have done a test in a text field and it work fine as what i want.

I have used the following shutdown script:

Enter Find Mode

Set Field [ fieldA "testing"]

Perform Find

Go to RecordiRequestiPage[First]

Loop

Clear [ fieldA ][select entire contents]

Go to RecordiRequestiPage[Next, Exit after last]

End Loop

-------------------------------------

However, the actual field i need to perform Find is a radio button but not text field. How to do the step "set field" ??