Forum Discussion
- ArchiveUserQrew CaptainUnfortunately, email notifications can't be triggered by a Formula field, only by adding, modifying, or deleting a record.
- ArchiveUserQrew CaptainHello 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 - GauravSharma3Qrew CommanderHi 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 - GauravSharma3Qrew CommanderHi 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 - ArchiveUserQrew CaptainWe 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.
- GauravSharma3Qrew Commanderyes, you are right David.
Please do needful for this.
Regards,
Gaurav - GauravSharma3Qrew CommanderHi David,
Did you get a chance to look into this ?
Thanks,
Gaurav Sharma - ArchiveUserQrew CaptainHello 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? - GauravSharma3Qrew CommanderHi David,
I will be travelling to my home this friday.
At which time, you are available ? - ArchiveUserQrew CaptainAnytime on Friday.
- GauravSharma3Qrew CommanderHi David,
Can we schedule a call whenever you free?
Thanks,
Gaurav