Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4644 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I am not sure of best way to explain this, and i am feeling a bit overwhelmed with the concept of boolean values, but here goes...

I have an 'orders' databse which contains 'order line items'.

suppliers often deliver only part of an order. I want to conditionally format a parent record (order) for which delivery is incomplete.

So far my thinking is as follows:

in the line items have created a boolean value for 'delivered'. I want a summary field to total the number of items on the order that have been delivered and a summary field to count the order items. So if items delivered - items counted = <0, then the order (parent record) is still PENDING.

I have managed to get the count to work, but not the total of delivered.

Any suggestions?

Posted

I want to conditionally format a parent record (order) for which delivery is incomplete.

Try =

Count ( OrderLineItems::OrderID ) > Count ( OrderLineItems::Delivered )

IMHO, Delivered should be a Date field.

Posted

Thank you! Such a simple and clean solution. I can see I have lots to learn still.

re the date field - i can see the value in your suggestion. I would like to create a button that automatically enters todays date into it when clicked. is there a shortcut for this?

This topic is 4644 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.