How to Create Delivery Days/Due Date Calculated Columns in Loocey

Overview

In this video, we’ll learn how to create calculated columns in Loocey to keep track of our Delivery Schedule and Due dates.

“Backend Calculation” code for Delivery Due Date Column: {{ if award_date }} {{ deliveryDate = award_date | date.add_days delivery_days }} {{ deliveryDate | date.to_string '%m/%d/%Y' }} {{ end }}

“Backend Calculation” code for Delivery Due In (Days) Column: {{ if award_date != null && delivery_days != null current_date = date.now target_date = date.parse award_date days_difference = (target_date - current_date).days * -1 remaining_days = delivery_days - days_difference remaining_days end }}

Step by step

The walkthrough covered in the video, written out so you can follow along inside Loocey.

1. Go to the Bidding Board and create a new view, call it Won, and add a filter where Bid Status is Won, so you only see awarded items.
2. Click on Columns, hide all, then select only the columns you want: Bid Status, NSN, Award Date, and Delivery Days. Save the view.
3. Optionally rename the Delivery Days label to Delivery Days Quoted so it’s clearer.
4. In the Award Date column, set the dates you received the awards, for this example, a few dates in March.
5. In Delivery Days, enter the delivery days you quoted in DIBBS, for example 80, 120, and 180.
6. Now create the Delivery Due Date column: click the plus sign, then More Options. Set the display name to Delivery Due Date, choose the Calculated Number column type, and paste the calculation from the video description into the backend calculation field. Click Add.
7. The system creates the column and calculates the actual due date from your Award Date and Delivery Days Quoted columns.
8. Add another column, Delivery Due In Days, the same way: plus sign, More Options, display name Delivery Due In Days, type Calculated Number, and paste the second calculation from the video description.
9. Click Add. Delivery Due In Days now shows the number of days remaining until each due date.
10. Test the calculations by changing an Award Date or Delivery Days value and watching the columns update.

Where this fits

This tutorial covers the Platform, Team & Admin part of Loocey DLA. Loocey Core features underneath the DLA module: columns, views, assignments, exports and permissions.

• Loocey DLA Getting Started guide — account setup and the full bidding workflow
• Saved-search recipes — the exact column, condition and value for 20 common DLA searches
• DLA / DIBBS glossary — what every field on a solicitation means
• All Loocey DLA video tutorials