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?
Page 1 / 1
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
})
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.