AnsweredAssumed Answered

Number field needed to behave more like a Calculation field

Question asked by shae1725 on Oct 22, 2013
Latest reply on Oct 22, 2013 by shae1725

Title

Number field needed to behave more like a Calculation field

Post

     I need help understand how I can make  number fields behave like a calculation field.

     These fields need to update immediately  the  fields data is inputed or modified!

     I have these calculations below  but because updates aren't immediate it makes my application useless!

     I am new to FM so open to all ideas

     Any help would be appreciated

      

     Table1::Width     Case (Table::Size = "Yes" ; Table2::Width - (Table3:A + Table3:B);
                                           Table::Size = "No";Self)

     Table1::Height    Case (Table::Size = "No" ; Table2::Height - (Table3:C + Table3:D);
                                           Table::Size = "Yes";Self)

      

      

     Table2:Width     Case (Table::Size = "No" ; Table1::Width + Table3:A + Table3:B;
                                          Table::Size = "Yes";Self)
      

     Table2:Height    Case (Table::Size = "No" ; Table1::Width + Table3:C + Table3:D;
                                         Table::Size = "Yes";Self)

      

      

     Table3:A             Case (Table::Size = "Yes"; Self; Table2::Width - Table1::Width /2;
                                          Table::Size =   "No";  Self

     Table3::B             Case (Table::Size = "Yes"; Self; Table2::Width - Table1::Width /2;
                                           Table::Size = "No"; Self

     Table3::C            Case (Table::Size = "Yes"; Self; Table2::Height - Table1::Height /2;
                                           Table::Size = "No"; Self

     Table3::D            Case (Table::Size = "Yes"; Self; Table2::Height - Table1::Height /2;
                                           Table::Size = "No"; Self

      

      

Outcomes