Calculate time in stage
Hi All, I am creating an app to track performance by a team and need to be able to say how long an activity has been with them and how long they are waiting on another team. To do this I am looking...
Forum Discussion
In our PM system, the status is a formula field. It changes based on the passage of time, entries into a number of other fields, and context within a child table. Grid edit is used to update a number of these other fields, which then affect the status.
- That is another good way to do status changes.
If you are automating the status changes, like that they you wont need this set up.
But if you want to log the changes in the stats, you will need to set up a logs table, and use either webhooks, or QB actions to create new "status logs - Thanks, that makes sense. Can QB Actions handle the time-related status changes for logging?
- No, Actions can only work during manual edits.
If its automatic changes (over night), then you will need a cron job that runs externally to compare record details, and watch for changes. - Thanks for clarifying that. Bummer. This seems like an area that is needlessly complex, and as a result diminishes QB as a platform. So now I have to go hire a programmer/consultant to write some php code and then rent an external server to run it on, just to do something pretty straightforward from a business logic perspective. Kind of knocks the wind out of a "Citizen Developer".
