Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 16, 2023 08:08 AM
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?
Reply
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 16, 2023 09:27 AM
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
})
