Forum Discussion

PaulTrimor's avatar
PaulTrimor
Qrew Cadet
8 years ago

How to set the FROM clause of an Email Notification to a given user?

I am trying to configure an email notification so that it appears to be coming from an email address of one of our users.  The issue with that when I go under "Advanced Options", the dropdown prese...
Ask about Quickbase functionality
NotificationsEmail
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Can you make that user have access to the app so that it becomes a valid choice?  Or you do not want to pay a license for that email address.  I'm pretty sure that the FROM has to be from a user so that Quick Base knows that you are not generating spam emails from a fake email address.
  • PaulTrimor's avatar
    PaulTrimor
    Qrew Cadet
    8 years ago
    How exactly do I give a user access to that app? The user I want is already listed in the users list in the table I want to send a notification form. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Did you set the Notification to trigger for only single record changes?

    Assuming so, then how about adding a formula user field to the table with a formula

    ToUser("john.smith@mycompany.com")

    That field will then be a choice for the FROM.
  • PaulTrimor's avatar
    PaulTrimor
    Qrew Cadet
    8 years ago
    I've added a field User-Formula with the value 'ToUser("john.smith@mycompany.com")' in the same table with the Email notification. However, it still did not show up in the FROM dropdown. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Can you try one more thing which is quick to test?
    Go to your Users tab and see if that user has a green checkbox to show in user pickers.
  • PaulTrimor's avatar
    PaulTrimor
    Qrew Cadet
    8 years ago
    I figured out what I was doing wrong, I didn't have the "change on single record" enabled. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    When you kept saying that you did not see the user on the drop down list, I thought you were just missing 1 user - you were missing the whole option to select a FROM.  That only can appear if it is a single record change.

    Glad is working for you now.