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

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered

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.

Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb

Posted 3 years ago

  • 1
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
Unfortunately, email notifications can't be triggered by a Formula field, only by adding, modifying, or deleting a record.
Photo of David Maskasky

David Maskasky

  • 100 Points 100 badge 2x thumb
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
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
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
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
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
Photo of David Maskasky

David Maskasky

  • 100 Points 100 badge 2x thumb
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.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
yes, you are right David.
Please do needful for this.

Regards,
Gaurav
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Hi David,

Did you get a chance to look into this ?

Thanks,
Gaurav Sharma
Photo of David Maskasky

David Maskasky

  • 100 Points 100 badge 2x thumb
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?
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Hi David,

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

David Maskasky

  • 100 Points 100 badge 2x thumb
Anytime on Friday.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Hi David,

Can we schedule a call whenever you free?

Thanks,
Gaurav
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Hi David,

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

Regards,
Gaurav