Forum Discussion

JENNIFERPASCHAL's avatar
JENNIFERPASCHAL
Qrew Trainee
2 years ago

Last Modified By Criteria in Automation Trigger

Hello -

I have an automation that triggers on modification of a record. I would like to add criteria to that will not run the automation if I am the person that modifies the record. I know how to do this via notifications because you can select the user from a dropdown when adding Last Modified By as a criteria. In the automation however, it gives you an empty text box. I have tried typing my full name as shown in QB, the way my name exports "FULL NAME <QB ID#>.

Anyone have any guidance on this? I can turn off the automation to do the bulk uploads I need to do but I do them regularly so I would prefer to build it in to the automation if possible.

If this would be easier with a pipeline I am open to that as well, but I would have the same question as to proper syntax for entry of my name/userid for the criteria to read correctly.
ā€‹

------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
  • Try entering your email address into the box.

    Or Plan B can be to make a formula checkbox helper field called [Last Modified by was Jennifer?] and use that as a hook for your Automation or Pipeline

    [Last Modified by] = ToUser ("JPaschal@Mycompany.com")

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • JENNIFERPASCHAL's avatar
      JENNIFERPASCHAL
      Qrew Trainee
      Thank you this worked perfectly, appreciate the help!

      ------------------------------
      Thanks in advance,
      Jennifer Paschal
      ------------------------------