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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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 presented does not contain the email address of the user I would like to use. 

I read this article: http://help.quickbase.com/user-assistance/company_email_domain.html
I think the problem is that the email address of the user I want to add in the "FROM Address" is not registered. 

Is there anyway I can get around this?  
Photo of Paul Trimor

Paul Trimor

  • 488 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.
Photo of Paul Trimor

Paul Trimor

  • 488 Points 250 badge 2x thumb
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. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.
Photo of Paul Trimor

Paul Trimor

  • 488 Points 250 badge 2x thumb
I figured out what I was doing wrong, I didn't have the "change on single record" enabled. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.