calculations not working via web

[julesw]

Has anyone else had a problem with calculations not working in the web mode? I have found this several times now. An example is a simple calculation that inserts the date when a particular field is modified... it works perfectly in FM, but via the web the calculation field just returns a '?'.

Any help would be greatly appreciated as most users are accessing the database via the web, and a lot of these functions are really necessary.

Thanks, J

[Vaughan]

It would be really handy if you posted the calculation that you are having trouble with.

[julesw]

ok, there are two fields involved. one, a text field called 'notified' is a checkbox with a single value, "notified".

the other is the calculation field called 'notified date'. the calc is:

if(notified="notified";date;0)

it works perfectly in filemaker, so i think the calc is ok... and this is only one example of calculations that dont work in web mode.

jw

[Vaughan]

What's in the date field -- is it data type date or text?

Is the result of the calculation of type text or date?

[julesw]

it is date

[Vaughan]

If it's a date calculation, then the "0" is a bit of a worry, since it's probably not a valid date. If you want no date to show, use

TextToDate("") for FMP 6 and earlier, or

GetAsDate("") for FMP 7.

[julesw]

okay i gave that a go, but the only difference it made was that the field stays empty, rather than displaying a '?'.

[julesw]

okay i gave that a go, but the only difference it made was that the field stays empty, rather than displaying a '?'.

[Vaughan]

All calculation fields should work in IWP. Some script steps don't work, but all calcs do.

Go through and check that the fields have their appropriate data types set: both the date field and the calculation field should have their data type set to date.

According to your expression "if(notified="notified";date;0)" if the notified field has notified in it, display the date otherwise display 0. What is 0? You've changed it to display null ("") isn't that what you want?

Try this expression instead:

If ( IsEmpty ( Notify ) ; GetAsDate ( "" ) ; Date )

and make sure the result of the calculation is of type date.

[julesw]

brilliant, it works!

thank you!!