GC GYM Posted July 13, 2011 Posted July 13, 2011 Hi All, I have tried both a self-join relationship and conditional formatting to make a touchscreen keypad disappear/reappear. I want the keypad to appear when someone enters any field, and disappear when they exit the field. I'm using Get(ActiveFieldName) as the condition (or to populate the join key for the relationship) Data viewer shows that Get(ActiveFieldName) is either empty or contains a value as expected. However, the condition is not triggered and the the key field is not populated. Conditional format: (Get ( ActiveFieldName ) Key field calc: Show Keypad = If(Get ( ActiveFieldName );1;0) I even tried putting a script trigger on the fields to refresh on entry and exit, but no change. Any ideas? Thanks Phil
Vaughan Posted July 13, 2011 Posted July 13, 2011 I'd create 2 layouts -- one with the keypad one without. The one without the keypad has buttons where the fields are that switches to the keypad layout.
GC GYM Posted July 14, 2011 Author Posted July 14, 2011 I'd create 2 layouts -- one with the keypad one without. The one without the keypad has buttons where the fields are that switches to the keypad layout. Sounds like a good idea, thanks Vaughan. Any idea why my own attempt isn't working? I'm thinking that I'm about to learn something new about Filemaker, or just that I can be a bit of a dill sometimes? I'd prefer the former of course.
Vaughan Posted July 14, 2011 Posted July 14, 2011 Any idea why my own attempt isn't working? Your calculation doesn't make sense to me ,and I have no idea why you need a self-join relationship. If the aim is to make conditionally formatted text appear when a field is active the calculation probably needs to be not isempty( get( activefieldname ) ) But all that seems too complicated to me, too hard to build and too difficult to maintain. It might also be easier to have the keypad appear in the scripted "modal" window, with entry into a global field.
GC GYM Posted July 14, 2011 Author Posted July 14, 2011 I got the concept of using a self-join relationship from http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000743 When the relationship is true, the buttons on the first row of the 1 row portal appear. Anyway I couldn't get it to work so I'm using the conditional format method. I thought that for a boolean result, Get ( ActiveFieldName ) would give the same result as not isempty( get( activefieldname ) ) Anyway yours works so I'm using it. The problem though, is that it works on entering the field, i.e. the keypad appears, but when exiting the field and there is no active field, the conditional format doesn't change back unless I refresh the window. I put a refresh window script trigger on entering, saving and exiting the field, but it still doesn't work when the user goes out of the field.
Vaughan Posted July 14, 2011 Posted July 14, 2011 The problem though, is that it works on entering the field, i.e. the keypad appears, but when exiting the field and there is no active field, the conditional format doesn't change back unless I refresh the window. Part of the reason I think doing this with conditional formatting is not a good idea. Also the conditional formatting does not really "hide" the buttons so it's possible they could be clicked on at any time.
Recommended Posts
This topic is 4898 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now