Recording a timestamp when a specific status is met

474 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Is there a way to set up an automation so that the current date is recorded when a specific status is met. For example, When a project's "status" is changed from incomplete to complete, a date column would automatically fill with that day's date?

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

You could run a script

const now = new Date();
let inputConfig=input.config();
let CellId=inputConfig.StatusChanged;
let table = base.getTable("All Projects");
await table.updateRecordAsync(CellId, {
    "Completion Date": now