Skip to main content
Question

Pipeline Emails via Outlook

  • August 22, 2023
  • 0 replies
  • 510 views

Hi

I have set up a single pipeline for one user which is working, however, I need to set up multiple users with their own email.  How do I connect a pipeline to a user? There is also one user who had two email addresses, I am assuming two pipelines but need to know how to set up in QB.

Thanks



------------------------------
Jessica Matenga
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+12
    • BrianSeymour
    • Registered
    • August 22, 2023

    It's not clear to me what you are hoping to achieve, but likely you'd want some record to contain a User or email value. Then, you'd include that field in a single Pipeline. The email address would then vary as necessary on the given record and feed dynamically into the Pipeline.

    Or put another way, suppose you had hundreds of Users in your App … you *wouldn't* want hundreds of nearly identical Pipelines (one Pipeline for each User). Instead, just feed a common Pipeline the dynamic data. I'd imagine the triggering event defined in "Step A" of your Pipeline you'd specify a User or email address in the "Fields for Subsequent Steps."

    Oftentimes, we'll create a formula field on a given table to display a given User email for debugging and using in reports. For example, 

    // Formula - Email Field Type
UserToEmail([Your User Field])

    Hopefully that helps or gives you some ideas!



    ------------------------------
    Brian Seymour
    ------------------------------

      Forum|alt.badge.img+12
      • BrianSeymour
      • Registered
      • August 23, 2023

      Hey Jessica, it sounds like you are making progress with Mark! However, to me it just doesn't "feel right" setting up one Pipeline per User. I'm not sure what the equivalent of "code smell" is in a no/low-code platform, haha :) But, maybe this is a fine approach for your project.

      Anyway, I wanted to point out a Pipelines alternative … which may or may not be solution in your case (or maybe you've already considered it). Presumably, a change to some record is triggering your proposed Pipeline, right? As opposed to a scheduled Pipeline?

      If so, in the Settings of a given Quickbase Table (click the gear icon in the top-left), you'll see a "Notifications, subscriptions, & reminders" section (on the right) housing settings to send emails. If you set up a new email "Notification," then scroll to the bottom and fly open the "Advanced options" section you'll see additional info. In the "Operations" section, set the radio to "Only when single thing records change (e.g., Add, Edit)" and yet another option will appear to set the "From Address" to "The user listed in the field:" which is a dropdown. There you can specify a User field from your QB record that triggers the email (instead of notify @ quickbase.com).

      Again, I'm not sure if that's feasible in your use case, but in the past I've used this feature with success. Worth noting, when recipients of this email hit "reply," they'd be replying to the User in the dropdown too.

      See screenshot!



      ------------------------------
      Brian Seymour
      ------------------------------

      Terms & ConditionsAccessibility statement