Jump to content

Recommended Posts

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

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
  • Who Viewed the Topic

    1 member has viewed this topic:
    Sparknet 
×
×
  • Create New...

Important Information

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