Jump to content

Recommended Posts

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

Link to post
Share on other sites

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

 

Link to post
Share on other sites

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.

Link to post
Share on other sites

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.

 

Link to post
Share on other sites

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.

Link to post
Share on other sites
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 ) ; "*" ) ]

 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.