Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4898 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

Posted

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.

Posted

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.

Posted

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.

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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