Calculations on the web

[ldelappe]

Hello all,

I need some help getting my web database to calculate and show the total. I have detailed the setup below in hopes that may help you help me.

First calculation field is a text field with a value list and no additional text:

$345

$395

$695

$0

Second fields are identical in text format, no text:

$45

$45

The calculation field needs to show the total. This is the calculation that worked the last time:

"TextToNum(Early Registration Fee) + TextToNum(East Additional Tickets) + TextToNum(West Additional Tickets)", with the fields respective to the above order.

This field is then used in an encryption code to be sent via a secure secondary server to a credit card site.

If anyone knows how to make this field show the calculation on the web, I would be forever grateful! At least until the next problem pops up

ldelappe

[Keith M. Davie]

I'm not sure I'm following your needs, but I would suggest you look at Langer's "Database Publishing with FileMaker Pro", pages 316-319. The answer in those pages may be pertinent to what you are attempting.

Peace

Keith M. Davie

[Vaughan]

The problem is that the text fields all contain the "$" character. You'll need to remove the "$" before the TextToNum function will work properly. Try this...

TextToNum(Subs(Early Registration Fee; "$"; "") + ...

I have used the Subs() function here, but Left() could have also been used, but would neeed to assume that the "$" is always typed.