Jump to content




Default value on Find within value list



  • Please log in to reply
9 replies to this topic

#1 OFFLINE   itmedex  newbie

itmedex
  • Members
  • PipPipPip
  • 3 posts
  • FM Client:11 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Expert
  • Time Online: 7h 25m 52s

Posted 30 January 2012 - 06:49 PM

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?

#2 OFFLINE   Lee Smith  *$ time

Lee Smith
  • Staff
  • 8,465 posts
  • FM Client:12 Advance
  • FMGo:iPhone / iPod Touch
  • Platform:Mac OS X Lion
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 96d 2h 44m 23s

Posted 31 January 2012 - 11:34 AM

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

#3 OFFLINE   bcooney  consultant

bcooney
  • Moderators
  • 5,207 posts
  • LocationLong Island, NY
  • FM Client:11 Advance
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:9, 10
  • Membership:TechNet
  • Time Online: 14d 15h 41m 11s

Posted 31 January 2012 - 12:55 PM

"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

#4 OFFLINE   itmedex  newbie

itmedex
  • Members
  • PipPipPip
  • 3 posts
  • FM Client:11 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Expert
  • Time Online: 7h 25m 52s

Posted 03 February 2012 - 03:58 PM

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.

#5 OFFLINE   bcooney  consultant

bcooney
  • Moderators
  • 5,207 posts
  • LocationLong Island, NY
  • FM Client:11 Advance
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:9, 10
  • Membership:TechNet
  • Time Online: 14d 15h 41m 11s

Posted 04 February 2012 - 12:55 PM

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

#6 OFFLINE   comment  consultant

comment
  • Members
  • 21,137 posts
  • Time Online: 187d 10h 40m 8s

Posted 04 February 2012 - 01:12 PM

Quote

That is one reason I hate triggers. They hide.

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

#7 OFFLINE   bcooney  consultant

bcooney
  • Moderators
  • 5,207 posts
  • LocationLong Island, NY
  • FM Client:11 Advance
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:9, 10
  • Membership:TechNet
  • Time Online: 14d 15h 41m 11s

Posted 04 February 2012 - 02:00 PM

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

#8 OFFLINE   comment  consultant

comment
  • Members
  • 21,137 posts
  • Time Online: 187d 10h 40m 8s

Posted 04 February 2012 - 04:31 PM

I meant:

Attached Files



#9 OFFLINE   bcooney  consultant

bcooney
  • Moderators
  • 5,207 posts
  • LocationLong Island, NY
  • FM Client:11 Advance
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:9, 10
  • Membership:TechNet
  • Time Online: 14d 15h 41m 11s

Posted 05 February 2012 - 05:23 AM

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.

#10 OFFLINE   comment  consultant

comment
  • Members
  • 21,137 posts
  • Time Online: 187d 10h 40m 8s

Posted 05 February 2012 - 06:56 AM

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


Back to Finding & Searching


1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users

FMForum Advertisers