WHAT: Right now the only date option "effect" or "then" for the conditional logic in automations is "if this happens then fill said date field with [specific date]" but there is no fill with [today's date]... so of course that is useless because we would never want to fill a specific pre-determined date but rather the date something has occurred.

WHY: Since the way Coperniq is designed now, we need separate work orders for each workflow if we want to add attached automations that vary per workflow or different auto-assignees for different workflows, etc., so when we need to export reports for multiple workflows, or multiple duplicated WOs' completed dates, we would have to have different columns for each one, this could be many columns for basically the same date. (ex. when the "electrical construction" WO has been completed for Oahu, BI, Maui, etc. as each one needs a different WO since there is no conditional logic for WOs or forms based on workflows, or if we base it on phases, each WO has its own phase even if it's the same stage.)

HOW: We can get around this by adding conditional logic to automations with a "mark as today" date for any specific action, such as "when Electrical Construction WO is marked complete, fill Electrical Completed On field with today's date" (meaning obviously that day's date). Or "when Construction phase is marked complete, fill Construction Complete date field with today's date."

Since we can resue the fields for all projects, we could then use this date field that would be auto filled at various times for every WO/workflow, we only need to have one column, not many, to indicate the same date across all projects/workflows.