isiprog
asked on
Go to Field name calculated
In Filemaker 7 I can go (i.e. move the focus) to the next field by a script token.
In there a way to go to a well known field name programmatically (without cicling all the fields until the name of the current field is equal to the name that I want)?
A similar functionality is available with the token "Go to record by calculus" (I don't know the exact translation of the token because my version is not in English).
In there a way to go to a well known field name programmatically (without cicling all the fields until the name of the current field is equal to the name that I want)?
A similar functionality is available with the token "Go to record by calculus" (I don't know the exact translation of the token because my version is not in English).
ASKER
Thank you for your reply lesouef, but what I need is to calculate the name of the field where to go.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
got yr zip now, but not the related mail normally sent by server, my antispam refuses *@yahoo.com so I'll put you in my whitelist
So i'll have a look at yr stuff tonight .
Master Bill,
Here it is:
http://extranet.valblor.com/~adispo\GreatEscapes.zip
So i'll have a look at yr stuff tonight .
Master Bill,
Here it is:
http://extranet.valblor.com/~adispo\GreatEscapes.zip
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Lesouef, did you post the link in the wrong topic?
I know I was gonna do it! 10 windows open at the same time...!
and I like yr idea with subscripts arguments
and I like yr idea with subscripts arguments
ASKER
I did not want to use "if then else" because I've a lot of fields simulating a grid. But if you say that this is the only solution, I will accept it, despite my wishes
why don't you use yr idea about looping through all fields and stopping when current field name = required one?
maybe not smart, but only a few lines, and fast if you hide/freeze the window while doing it.
maybe not smart, but only a few lines, and fast if you hide/freeze the window while doing it.
isiprog, in this case, the correct answer to your question is "you can't do that."
Neither Lesouef nor I have any control over the features of FileMaker, so it's not really fair to punish us because the program doesn't have a feature you want. In this case, a grade of C is really not called for.
Please read this:
https://www.experts-exchange.com/help.jsp#hi54
One further suggestion: If you are trying to mimic an array, you might want to take a look at repeating fields. They can be used sort of like a limited form of array, you can return a value by a numeric address, which can be based on a calculation. And with a couple of calculations you can make it act two like a two-dimensional array.
Neither Lesouef nor I have any control over the features of FileMaker, so it's not really fair to punish us because the program doesn't have a feature you want. In this case, a grade of C is really not called for.
Please read this:
https://www.experts-exchange.com/help.jsp#hi54
One further suggestion: If you are trying to mimic an array, you might want to take a look at repeating fields. They can be used sort of like a limited form of array, you can return a value by a numeric address, which can be based on a calculation. And with a couple of calculations you can make it act two like a two-dimensional array.
ASKER
I need to satisfy two needs:
1) go to a well known field name depending on a choice in a list (so the loop thru fields may be acceptable)
2) simulate the behavior of Excel when I press an arrow key
I've a lot of fields placed like an Excel grid.
A lot of row (but not all) are a multiple value fields. Differents rows are different field names. Looping through all fields requires a dictinction if I am in a multiple value field or not.
If I am in a multiple value, I have to go to the next repetition of the field, otherwise I have to go to the next field name
It's a bit complicated and not elegant and not too fast.
P.S. I intercept the arrow key through a keyboard hook plug-in, than I call the script "MoveRight", "MoveDown", etc.
1) go to a well known field name depending on a choice in a list (so the loop thru fields may be acceptable)
2) simulate the behavior of Excel when I press an arrow key
I've a lot of fields placed like an Excel grid.
A lot of row (but not all) are a multiple value fields. Differents rows are different field names. Looping through all fields requires a dictinction if I am in a multiple value field or not.
If I am in a multiple value, I have to go to the next repetition of the field, otherwise I have to go to the next field name
It's a bit complicated and not elegant and not too fast.
P.S. I intercept the arrow key through a keyboard hook plug-in, than I call the script "MoveRight", "MoveDown", etc.
ASKER
Sorry for the grade, it was my first post (by the way i've consumed all my points) and it was not my intentions to punish you. It was my mistake to understand what the grade represent ( a vote to you and not my satisfation in the solution to the problem)
If you would like to change the grade, post a link to this question in the Support area and ask them to reopen the question for you. Or you can request a PAQ/refund and get your points back. I don't have a problem with that, and I don't think Lesouef would either.
"2) simulate the behavior of Excel when I press an arrow key"
As you have no doubt discovered, that's not easy to do. Sounds like you have already put a lot of effort into this, though.
>"Looping through all fields requires a dictinction if I am in a multiple value field or not."
This can be checked using the FieldRepetitions() function. It will return the number of field repetitions that are currently displayed on your layout and the direction (horizontal or vertical)
"2) simulate the behavior of Excel when I press an arrow key"
As you have no doubt discovered, that's not easy to do. Sounds like you have already put a lot of effort into this, though.
>"Looping through all fields requires a dictinction if I am in a multiple value field or not."
This can be checked using the FieldRepetitions() function. It will return the number of field repetitions that are currently displayed on your layout and the direction (horizontal or vertical)
what a hell of a job so simulate excel behaviour? what about using the chart display mode?
you can go to next field for instance (it follows the tab order of the layout)
you can go to the field ny number (in design mode, see it tab number)
or by field name, the simplest (the name cannot be calculated, it is "hardwired" in the script.)
but the given field must be present in the current layout to to this, so don't forget to switch to the relevant layout before asking this in yr script.