Pipeline changing the last modified by
I have a pipeline which runs based on the trigger and the last modified by default field only shows my name. Is there any way I can change the last modified by or create a new field based on who updat...
Forum Discussion
Hi Mark,
Thanks for answering that. Just to make it clear I make a formula/user field before the pipeline and then add that to the pipeline?
Is that correct
------------------------------
Fanil
------------------------------
Thanks for answering that. Just to make it clear I make a formula/user field before the pipeline and then add that to the pipeline?
Is that correct
------------------------------
Fanil
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendNo, you make a regular user field called
[Last Modified by before Pipeline]
Then have the Pipeline populate it. but I realize now that would need to be the first step of the pipeline or at least a step before the pipeline modifies the record. Also we do not yet have the ability to insert Pipeline steps so you may need to rebuild your Pipeline.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
[Last Modified by before Pipeline]
Then have the Pipeline populate it. but I realize now that would need to be the first step of the pipeline or at least a step before the pipeline modifies the record. Also we do not yet have the ability to insert Pipeline steps so you may need to rebuild your Pipeline.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Mark,
Thank you for providing the recommendation. I would go ahead and try this. I might rebuild the pipeline.
------------------------------
Fanil Dhirajkumar Mehta
Fanil Dhirajkumar
------------------------------- Mark's answer will solve your issue.
I would strongly suggest adding another User to the system that owns all the Pipelines. That way when the Pipeline runs the Last Modified will say something like Pipeline Admin.
Now it is obvious that business logic changed the record and not an actual person. This way when some data issue comes up and management asks "who changed the record last ?" your name is not part of the conversation.
------------------------------
Don Larson
------------------------------
Hey Mark,
I thought this solution would work for a workflow that I am trying to solve for with a PL.
"Last Modified By" shows up as an option to Trigger Step A off of, but not as an option for Subsequent Steps. Thoughts? Is this a bug possibly?
Ashley
------------------------------
Ashley Solomon
------------------------------- MarkShnier__You
My suggested solution was to make a new field of type User, and not try to change the built in field.
if you specify your new field that you created as part of the trigger step in the place for fields to be used in subsequent steps, then it should be offered further down the pipeline as a choice to populate.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
