Sign in to follow this  
Followers 0

Default value on Find within value list

10 posts in this topic

Posted

We have a field that builds its value list off of itself. When a user enters find mode, the list will display the same value, in this case 2011. How does one change the value to display 2012?

Share this post


Link to post
Share on other sites

Posted

Hi itmedex,

There are a couple places you can check, the 1st one I mentioned is probably where you are going to need to change it. Go into your Manage Databases, click on the current field, click on the Option for that field, & see if there os an Auto Enter of 2011. If not, you will need to edit the value lists to include 2012.

HTH

Lee

Share this post


Link to post
Share on other sites

Posted

"When a user enters find mode, the list will display the same value, in this case 2011. How does one change the value to display 2012?"

What do you mean? It displays the same value as what? The last record viewed?

To set a default in FIND, you'll need to script it.

Enter Find Mode

Set Field (myField, "2012")

Pause

Perform Find

Share this post


Link to post
Share on other sites

Posted

I solved this mystery. Somebody went and setup a OnViewChange script trigger that was setting the year to 2011 when the user entered find mode. Once I found it and changed it, everything worked fine. Thanks for your help.

Share this post


Link to post
Share on other sites

Posted

That is one reason I hate triggers. They hide. Good for you that you found it.

Share this post


Link to post
Share on other sites

Posted

That is one reason I hate triggers. They hide.

If you'll pardon the allusion: Triggers don't hide - developers hide.

1 person likes this

Share this post


Link to post
Share on other sites

Posted

Huh? To me, they're right up there with auto-enter calcs.

Share this post


Link to post
Share on other sites

Posted

That is definitely a best practice, and we've done similar for "hidden" tab panels, etc. However, I contend that it would be much nicer if FM natively could call your attention to such triggers.

Share this post


Link to post
Share on other sites

Posted

I agree. But since that's not likely to happen...

Share this post


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
Sign in to follow this  
Followers 0