Pipeline changing the last modified by

Question

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 updates that records, it will record that name.

Thanks,
Fanil

------------------------------
Fanil Dhirajkumar Mehta
------------------------------

markshnier__you · Answer

np,Make a new field of type user called maybe [Last Modified by before Pipeline].Have the Pipeline also populate that field with [Last Modified by].------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

rameshsingh · Answer

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 ------------------------------

markshnier__you · Answer

No, 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
------------------------------

rameshsingh · Answer

Mark,Thank you for providing the recommendation. I would go ahead and try this. I might rebuild the pipeline.------------------------------Fanil Dhirajkumar MehtaFanil Dhirajkumar------------------------------

donlarson · Answer

Mark's answer will solve your issue.I would strongly suggest adding another User to the system that owns all the Pipelines.&nbsp; &nbsp;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.&nbsp; &nbsp;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------------------------------

Forum Discussion

Pipeline changing the last modified by