Text instead of table/field names

[MoonShadow]

Is there any way I can use a Set Field[ ] and insert:

Get ( ActiveFieldTableName ) & "::" & Get ( ActiveFieldName )

I keep getting errors on it which is unfortunate. Any ideas? Same question about Go To Field [ ] ... any way at all to specify that via global text, script parameter or ?

I guess I want to insert the table/field without having to select it from the Specify Field dialog box. I'm hoping vs. 7 has a hidden miracle somewhere.

[Vaughan]

Just a guess... put it inside an Evaluate() function?

[MoonShadow]

Hi Vaughan,

Nada, already tried it. What goes in the calculation box is the results of the Set Field - not the field in which to set. Set Field [ ] and Go To Field [ ] require choosing a field from Specify Field - or nothing. There appears to be no way of passing this information in from elsewhere; but there are many things in 7 I haven't played with yet, such as GetAsCSS etc.

This is something I've been wanting for over a year. I was hoping vs. 7 had some new tricks up it's sleeves. What would be perfect is if, at the bottom of the Specify Field dialog (to the right of rep#) there was a box in which we could enter a calculation with a new function (maybe called Switch) and FM evaluated it like a Get(field). Syntax could be:

Switch(tablename;fieldname) and could be entered as:

Switch(Get(ActiveTableName); globaltext) or Switch("Contacts"; calculation)

THIS is something I'd like to add to my FM8 wish list.

[Fenton]

The only way so far to do this is to loop through fields on a layout, using Go To Next Field, and stop when get to the specified field (or don't get to it :-). It works OK for things like parsing a text form into fields, where you know what fields are involved. But it's not very convenient, to say the least.

[MoonShadow]

Hi Fenton, Yeah well, I'm still trying to solve Style Assistant. I have captured the table/field name with script parameter. But it looks like I'll have to leave that field. And I don't want to write table/fields into the script - want to keep it generic. So I wanted to pass that parameter to a Set Field [ ] to use later. Can't seem to...

With scripts in 7, passing the table name is also important, not just the field name. And the power of script parameters has again brought to my attention how - the one thing lacking still in FM is the ability to pass to scripts which require table/field names. Possibly your idea will work in this case ... I will give it a go! Thanks much!

[bobearl]

Hi Moonshadow and Fenton, I wanted to see if you solved your problem. I am having a similar issue, which is that I am trying to perform a complex find. I am able to perform an extended find (OR type) but then when I return to the script step that calls the find, I am unable to readily move to the next find field to constrain the first find. Passing a parameter to Go to Field would be tremendously helpful - otherwise I think I'm stuck in setting up a dummy loop. Did you figure out a way to pass the parameter? Thanks very much.

[MoonShadow]

I have been unable to find a way of inserting a variable is Set Field [], Go To Field [] ... or in specifying a variable field.

It is the last step FM needs to hit perfection, in my book! Now watch ... I'll get blasted for this one. But if we could do that, I would be tickled beyond belief!

[bruceR]

You're on Windows. It's been availalbe via applescript on the Mac since 3.0 or so.