Calculation odditiies in IWP

[cubistDave]

Hi,

I am new here, but am having some trouble so I thought maybe I'd ask for help.

I have a database that I am sharing through IWP. I have a fields that returns a "1" or a "0" that is calculated based on whether other checkboxes in the record are checked or not.

my calculation looks like this:

If (VideoEncoded ≠ "" and VideoMaster="Yes" ; 1 ; 0 )

Now in FM7, everything works fine. As I click my VideoEncoded and VideoMaster checkboxes, my calculated value changes from 1 to 0 and back.

In IWP however, when I click on a checkbox, my value changes... but when I click "Submit" it changes back.

Has anyone experienced this? What am I doing wrong?

Many thanks!