Hi filemaker forums,

We have an existing database (fmp12) that contains the fields order numbers, order status (Delivered, current, invoiced) amount of tasks (lists) and delivery dates.

What we want to do is see what orders need to be done and how many tasks are left. I created a field calcData, that concanates the order with the number of tasks to be completed (lists) using this formula.

GetAsText ( Order No ) & " " & "(" & If(IsEmpty ( Lists ); " "; GetAsText ( Lists )) & ")"

This works, but now, we want another field that displays only the orders with the status CURRENT. So i created another field with this formula.

If ( GetAsText ( Order Status ) = "Current";GetAsText(Order No)) (sort of a key for seedcode)

And the display field

If ( Order Status = "Current" ; GetAsText (Order No) & " " & "(" & If(IsEmpty ( Lists ); " "; GetAsText ( Lists )) & ")" ;"")

This works fine on data that has already been entered, but when new data is entered it doesnt refresh. How do i get this to work!?!?!?

I know there are probably rules against making similar fields like this, but we are trying to integrate it with Seedcode calander free, and have done absolutely everything we need to except getting it to display current orders numbers and lists to complete. I cant alter large amounts of the database as it is being used by other people.

bellinat0r.zip

Either use an unstored calculation, or, if you need an indexed version, uncheck the "Do not replace …“ option for the auto-enter calc.

bellinat0r copy.fmp12.zip