AnsweredAssumed Answered

Calculated Portal

Question asked by kht on Jun 16, 2016
Latest reply on Jun 16, 2016 by Mike_Mitchell

I haver a table called installations. It has a status Open and Closed. These are manually set. I have a layout called Home and on this is a portal showing all Open Installations. Simple so far. I then have another table, Purchase Orders. I wish to show all open purchase orders within a portal. The problem is that the Status (Open/Closed) is based on a calculation. The calculation is

 

If (Isempty(DeliveryDate),"Open";"Closed")

In other words, if the item has been delivered, the record is marked as closed.

 

Any suggestions on the best way of achieving this? I am aware that calculation fields cannot be used for relationships as they are not indexed.

 

Thanks.

Outcomes