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 }}

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