danielhonker
commented
6 years ago 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
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.