Clear field automatically when closing the FMP database

[meteor]

Hi all,

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

[LiveOak]

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

[meteor]

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.

[markpro]

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.

[meteor]

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