Discussions

 View Only
  • 1.  Pipeline changing the last modified by

    Posted 11-08-2022 15:25
    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
    ------------------------------


  • 2.  RE: Pipeline changing the last modified by

    Posted 11-08-2022 15:27
    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
    ------------------------------



  • 3.  RE: Pipeline changing the last modified by

    Posted 11-08-2022 15:35
    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
    ------------------------------



  • 4.  RE: Pipeline changing the last modified by

    Posted 11-08-2022 15:45
    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
    ------------------------------



  • 5.  RE: Pipeline changing the last modified by

    Posted 11-08-2022 15:53
    Mark,

    Thank you for providing the recommendation. I would go ahead and try this. I might rebuild the pipeline.

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



  • 6.  RE: Pipeline changing the last modified by

    Posted 11-08-2022 16:35
    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
    ------------------------------



  • 7.  RE: Pipeline changing the last modified by

    Posted 09-30-2023 08:09

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



  • 8.  RE: Pipeline changing the last modified by

    Posted 09-30-2023 08:28

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