Skip to main content

Recording a timestamp when a specific status is met

  • February 16, 2023
  • 1 reply
  • 9 views
S
Forum|alt.badge.img+1

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?

D

1 reply

C
Forum|alt.badge.img+5

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 })
Terms & ConditionsAccessibility statement