I have built a project management app using softr and airtable. My project record has a field called “status” which was really meant to be a top level status indicator to tell if a project was “planning”, “in-progress”, “completed”. This is a manually populated field which I have been setting for each project.
My project load has grown and I need a way to look at the project list and know where each project stands once it is “in progress”. So I need to get more specific about where each project is in it’s lifecycle, which is likely a new field. Something like:
- Information Gathering
- Draft 1 Published / Awaiting Review
- Draft 1 Reviewed / Commented
- Draft 2 Published / Awaiting Review
- Draft 2 Reviewed / Commented
- etc, etc, etc
Preferably in a way that is automated, since I am not looking to created extra steps. So when a new draft gets published it updates and if/when a comment is added it updates etc.
I am having a hard time visualizing this since the suggested field will be on the project record and the draft records and feedback record are different tables.
- Drafts are related to Projects
- Feedback are related to drafts and projects.