I have a DB which can be used to record student test results, as well as to display bar graphs of the class results in different areas.

On the recording layouts, I have some demographic info to be entered. (e.g. gender, English is Second Language?, etc.)

I have a layout with scripted buttons which allow you to filter the info according to the demographic info before proceeding to the graphs layout. (eg. graph the achievement of only girls) There are scripts such as GETGIRLS

I wanted the title which appears at the top of the graph layout to be specific to the search results. ie. if I'm only viewing the test achievement of girls, I want the title to read "Girls' Achievement", so I included a title field, and in the GETGIRLS script I included the instruction Go to Field--->TitleField, Insert Text--->"Girls' Achievement".

It works, but it is still highlighted with a flashing cursor, which screws up the appearance of the title.

How do I get rid of that?

Thanks. Paul

PS. That's really long winded isn't it?!

Instead of "go to field" and "insert text", use

"Set Field" [TitleField, "Girls' Achievement"]

ps: I could use a "GETGIRLS" script myself

someone with some spare time want to figure out the syntax?

Yeah man I hear yah. That beetle has to be a magnet though at waterloo. Where do you do paragliding?

Thanks for the help. I'm trying to learn as I go here. Do you know some good FMP books?

Hey Jason,

I couldn't seem to select the text that I want to put into the field.

I can do:

SetField ["TitleSelectedGroup"]

but I can't get:

SetField ["TitleSelectedGroup", Girls' Achievement"

What am I doing wrong?

Paul

I thought you were putting the title in a field called "TitleField"... not sure if you changed that intentionally in your followup or if this could be the problem...

The other potential problem is that you have to put Quotation marks around both sides of the text, if you're just inserting a simple text string.

Are you getting an error message when you try to set up this script step?

Actually, sorry about the name change, it is actually called TitleSelectedGroup, shoulda used that originally.

I can't see where you get to enter text. When I double click the SetField choice from the left side of the scriptmaker window, it moves into the list of script instructions on the right. Then I click SPECIFYFIELD and choose the TitleSelectedGroup from the list of fields that pops up. But once that's done, I can't modify that line in the script...I don't know where to type it....

under the "Specify Field" button there is a "Specify..." button (these buttons are under the list of script steps).

Maybe you were clicking the script step in order to specify the field... in which case you could have missed the specify button at the bottom of the screen. I didn't even know you could specify the field right from the line!

So do I have to enter a calculation?

Hah cool. so I used

Case(TitleSelectedGroup!=0, "Girls' Achievement", "Girls' Achievement)

Seems awkward to me, but what the heck it works!

What about the gliding?

Paul

[email protected]

nope, just put the result you want in quotes if it's as simple as that.

You could make things more sophisticated by using If or Case statements to decide WHICH title goes in the field (eg: "Girls' Achievement" vs "Boys' Achievement"... sounds like you might be using separate scripts to get that effect.

Great! Thanks!