Project attribute: Updated At

[mateoclarke]

Right now, Airtable's API doesn't expose for us when a project's data was last updated. There are multiple long threads of users asking for this but there seems to be no progress over the past two years:
https://community.airtable.com/t/created-modified-timestamps/35/60
https://community.airtable.com/t/knowing-when-there-is-a-change-to-the-record/1518
https://community.airtable.com/t/date-field-autoupdate-on-last-change-addition/237/15

In order to implement this feature as @toribr has designed, we'll need to change the service we use to store data. We could think about creating our own API service using something like Wagtail CMS which we have started implementing for austin.gov (see github.com/cityofaustin/joplin).

I did some quick research to see if an alternative service like Google Sheets has an API that exposes this and it seems like they do not. Though I think there are some imperfect workarounds that would involve writing a Googlescript to keep that data in a column and update it automatically. Not ideal.

[danielhonker]

Most relevant date to users: When the project was started or funded.

Ideal intake process:

• Is this a time-bound project, or ongoing effort?
• If time-bound, offer a date picker for start date and end date -- so that users can sort.
• If ongoing, offer a start date and have it indicate an ongoing effort

For now, use open text field:

• Started: [date]
• Funded: [date]
• Ongoing

[danielhonker]

Trying to gauge how relevant this is if we're not going to take on any new dev tasks until Feb probably...