Skip to main content
Question

can we send a notification on basis of user mentioned in comment box ?

  • August 3, 2016
  • 0 replies
  • 263 views

Hi Team,

I have a comment box (i.e formula-text field) in which if anyone mention any name/email id/username then, a notification would be send to that person.
As like we do in facebook ( i know we can't built here).

can we select/mention a name with @sign then, we can send a notification.

  • Registered
  • August 3, 2016
Unfortunately, email notifications can't be triggered by a Formula field, only by adding, modifying, or deleting a record.

  • Registered
  • August 3, 2016
Hello Gaurav,

Despite Quickbase formula language not being all that helpful compared to modern formula languages, there is another approach.  You can add some javascript to this page using Dan Dieboldt's image onload technique.  This Javascript would be able to read and parse the text entered and submit new child records for those emails.  Notifications would therefore be driven in this solution from this child table.

Alternatively, you can populate user-list fields to accomplish the same thing.

Alternatively once more, you can have javascript send these emails instead.

There are a lot of options, none of them rely on native Quickbase.  I hope this has been helpful.  Please let me know if you need help with any of this.

Best regards,

David Maskasky

  • Author
  • Registered
  • August 5, 2016
Hi David,

Thanks for your reply.

Are you saying to populate user list into the comment box or place a separate field on form ?
Because i created a separate user-list field to pick a user for notification and its works perfect for me.

I figureout that if we can pick or parse username like if we use @gaurav.sharma in comment box and we pick this username through the help of some functions and use it in formula User-list.

What do you think ?

Thanks,
Gaurav Sharma

  • Author
  • Registered
  • August 5, 2016
Hi Blake,

Notification is a separate part, can we extract username,email address so, we can easily send a mail/notification to those usernames/email.

Regards,
Gaurav Sharma

  • Registered
  • August 8, 2016
We can use javascript to read all emails mentioned and use it to populate a user list.  The prereq of this is that these email address are already users, otherwise I believe it will create placeholder users in your application.  Please let me know if you want some help building this.  I am happy to help.

  • Author
  • Registered
  • August 8, 2016
yes, you are right David.
Please do needful for this.

Regards,
Gaurav

  • Author
  • Registered
  • August 9, 2016
Hi David,

Did you get a chance to look into this ?

Thanks,
Gaurav Sharma

  • Registered
  • August 9, 2016
Hello Gaurav,
Unfortunately, other priorities have kept me from writing anything.  I am happy to assist you with this, but I would first like to have a quick call on this.  Would you be available on Friday for a quick conference call?

  • Author
  • Registered
  • August 9, 2016
Hi David,

I will be travelling to my home this friday.
At which time, you are available ?

  • Registered
  • August 10, 2016
Anytime on Friday.

  • Author
  • Registered
  • February 21, 2017
Hi David,

I emailed you but did not get any response.
Can we set up a call whenever you free?

Regards,
Gaurav