Qrew LegendThis is an interesting question. It's a bit advanced as to how to do this.
My suggestion is to create a child table to your Projects table called perhaps "Project Status History". One Project has many Project Status History records.
Create fields for Current Status and Next Status and a date/time field for the Status End Date / Time.
Now the trick will be how to automatically populate this table using a Pipeline.
The first step of the pipeline would be easy. It would trigger "On New Event" when a Project is added or modified and the status changes. The first step of the pipeline would be to add a child status history record and populating the Current Status field.
Then it would search the status history records filtered for Related Project is equal to the Project [Record ID#] in the Trigger record and also filter where the Record ID is not the Record ID of the Trigger record and and the the Status End Date / Time is empty and in a For Each loop it would populate the current time into the Status End Date / Time and it would populate the Next Status field with the current Status of the project.
If this is just a casual request and you are new to QuickBase then it's probably too many jumps to go through. But if it is a real need that your company has and you have a small budget to work with feel free to contact me directly by the email line in my signature and we could get on a zoom call and get this working.
