Ok, so you have a project and it might have 10 possible stages it goes through and you drag Kanban to change the stage.
I suggest a child table of Stage History records. One Project has Many Stage Histories.
You will have a field for the Stage, Stage Start (This will be a for July mirror of the date created field, and the stage end which will be a date time field. Then a duration formula field which will use the end time of now if the stage end is null or Elle's the stage end time.
Make a Pipeline which will triggers on new event and the stage has changed. When that happens the first step will be to search all Stage histories children of the Project where the stage end is not .set and then in a For Each Loop, make them be the current time. You can use a native quickBase field with a formula of Now() to get the current date time, or else use the Jinja expression. {{time.now}}
Then the pipeline will create a new stage history record, by writing out the value of the Stage.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------