Jump to content

Retrieve position of field to return to the field


michele
 Share

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

Recommended Posts

Concerns: Filemaker 8 for use on pc

What I need is a way to return to a specific field.

If I may compare my question with Excel, I need to store the reference to my cell.

Which would be in this example B9, or G4 or....

So I've used

Get(Activefieldname) and Get(Recordnumber) to retrieve the position of my field.

Now here's the problem. Going to the record number is no problem as the "go to record" script step allows me to specify "by calculation" (where I can refer to the value I stored using Get(recordnumber).

But how do I go to the right field? I've stored the field name retrieved with Get(Activefieldname) but "go to field" doesn't allow me to refer to the stored field name.

What functions or script steps should I use to be able to go to a specific field and then to a specific record number within that field.

The position of the record will vary, so I can't give a 'fix' fieldname.

Thank you for helping me out.

Link to comment
Share on other sites

  • Newbies

I haven't tried this myself, but in theory it should work.

Freeze Window

Loop

  Go to Next Field

  Exit Loop If [Get (ActiveFieldName) = YourField]

End Loop

The reason for freezing the window is so that the user can't see what's going on and to help speed up the script if you have a lot of fields to cycle through.

Hope this helps

Tim

Link to comment
Share on other sites

This topic is 5692 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
 Share

×
×
  • Create New...

Important Information

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