I was wondering if there any way which would allow us to apply if statement around all portal rows.
Basically, I have 2 tables orders and goods. An order can consist of many goods.
I have an order layout and also got portal which shows all related goods of that order.
Each of the good will have serial number.
What I would like to do is maybe have an if statement, if all goods of that order (which portal will show) have a serial number, change order status to "ready".
Another way i was thinking was to set order status field as an calculation. Than write an calculation which would determine if all goods of that order have serial number, auto change the status to "ready".
Thank you in advance.