Simple Script Trigger Script

[John Chamberlain]

I have been away from FMP for quite awhile, and have forgotten a LOT.
I need a script (using a script trigger) that upon field entry will enter an 1 if the field is empty, or a blank if the field is valid.
Thanks in advance

[comment]

Can you explain the purpose of this? Why is it necessary to trigger this upon entering the field? Will the user be entering more data after the script has run?

And what do you mean by "the field is valid"? The opposite of "empty" is "not empty", not "valid".

 

[John Chamberlain]

I have multiple fields that need to be either empty or have a "Yes" entered. When the field is empty the script should enter the "Yes"...if the filed has "Yes" entered (isvalid) it should delete the field contents.

[comment]

Well, the term "is valid" is taken for another purpose, so you should avoid using it here. I still don't see why you need a script trigger for this, instead of making the field a button. Then the script can do simply:

Set Field [ YourTable::YourField ; Choose ( YourTable::YourField ; 1 )

This will toggle the status between 1 and empty. I assume the field is defined as a Number field, and formatted as Boolean.

 

[John Chamberlain]

Of couse! As I said I have forgotten a lot, even basic stuff like this.

 

Thanks so much

[John Chamberlain]

Just getting back to this and I am having difficulty. To clarify, I need a script that will place an Asterisk "*" in a field (if the filed is empty), or will change the field to empty (if is an Asterisk). II tried your suggestion, but just can't seem to get it to work.

 

Thanks again for your interest.

[comment]

2 minutes ago, John Chamberlain said:

I need a script that will place an Asterisk "*" in a field (if the filed is empty), or will change the field to empty (if is an Asterisk)

In your original question you talked about entering 1 if the field is empty - which IMHO is a much better arrangement than using an asterisk.

If you insist on asterisk, then you will have to do:

Set Field [ YourTable::YourField ; If ( IsEmpty ( YourTable::YourField ) ; "*" ) ]