Jump to content

calculations not working via web


 Share

This topic is 6442 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6442 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.