Hi everyone,

i have a database and all the fields are set to uppercase. in my html file i have this for every field:

[FMP-Field: name, raw]

i am tring to get the text from the records to be in titlecase like the database.

thanks peter

Try using Format instead of Raw. This was introduced in either FMP 5 or 5.5.

Failing that, you can try this:

<script>

var FMPField = [FMP-Field: FieldName]

FMPField = FMPField.toUpperCase()

document.write(FMPField)

</script>

ok i tried the Format and it didn't work.

the script didn't as well. it shows in the source file that it is there but it's not writing on the screen.

not sure what is happening

Peter

Try this:

<script>

var FMPField = "[FMP-Field: FieldName]";

FMPField = FMPField.toUpperCase();

document.write(FMPField);

</script>

Garry

Nice catch, Garry... I keep forgetting about quotation marks around literals.

Gets me occasionally too!

Garry

Works great. Thanks everyone.

Peter