Discussions

Expand all | Collapse all

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

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

    Posted 08-03-2016 11:18

    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.



  • 2.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-03-2016 14:41
    Unfortunately, email notifications can't be triggered by a Formula field, only by adding, modifying, or deleting a record.


  • 3.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-03-2016 19:12
    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


  • 4.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-05-2016 06:47
    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


  • 5.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-05-2016 08:53
    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


  • 6.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-07-2016 21:41
    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.


  • 7.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-08-2016 05:30
    yes, you are right David.
    Please do needful for this.

    Regards,
    Gaurav


  • 8.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-09-2016 12:04
    Hi David,

    Did you get a chance to look into this ?

    Thanks,
    Gaurav Sharma


  • 9.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-09-2016 19:18
    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?


  • 10.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-09-2016 19:34
    Hi David,

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


  • 11.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 08-09-2016 20:14
    Anytime on Friday.


  • 12.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 03-06-2017 05:10
    Hi David,

    Can we schedule a call whenever you free?

    Thanks,
    Gaurav


  • 13.  RE: can we send a notification on basis of user mentioned in comment box ?

    Posted 02-21-2017 07:03
    Hi David,

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

    Regards,
    Gaurav