Default Value

[mleiser]

In FM12, I have a field called City and State. When the user enters the city field I want "Brooklyn" to be a default unless the user changes it. Same with "NY" for state. Is there a way to do this without doing it in view database fileds and making that happen as a default there. Then it will happen all the time. Maybe I only want it to happen in certain layouts.

Mike

[mr_vodka]

You can look into script triggers.

[Fitch]

If he's actually on FM9 then it takes a plugin to do script triggers (not that there's anything wrong with that).

Another option is to use an auto-enter calculation, e.g. Case( Get(LayoutName) = "pizza" ; "Brooklyn" )

[mr_vodka]

Yeah that is what I orig thought too but he started his post with "In FM12". :)

[Fitch]

This happens every time I forget to ignore the user profile.

[mleiser]

I guess it is time to change my user profile. Even though I have tons of stuff on 9, I'm starting with 12 now so I should use those solutions. Thanks folks.