It seems as though a Formula URL field type can handle JavaScript. Is this correct?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

 I'd like to add a button to a form that would pop up a window that would allow an anonymous user to simultaneously send an email to the user in the field [Assigned To] and post the anonymous person's message into a field called [Updates] in the record, updating the record.  Perhaps this is doable with QB's native scripting but I'm not cottoning how I can get it to fire the email and edit the record at the same time, so I was thinking a little JavaScript might do the trick.  Thanks! I'm a newbie at both QB and JavaScript, so I'm trying to learn as I go.

Photo of Mark

Mark

  • 10 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
I'm not understanding the issue. Can you just have the anonymous user edit the record, perhaps on a mini form, and upon Save, trigger a native email Notification to the [Assigned To]
Photo of Mark

Mark

  • 10 Points
Thanks. My question is related to another post I made here.  https://quickbase-community.intuit.com/questions/1419603-is-it-possible-to-pass-the-value-in-a-dashboard-search-field-to-use-as-a-custom-permission-in-a-role-setting?event=new_question  Your suggestion won't work because I'd need to open up editing to all anonymous (EOTI) users and that's not something I'm comfortable doing.  If I could do what I want in the other forum question (linked above) then perhaps I could use the native QB email notification trigger.  If I need to explain the use case in more detail I'm happy to.  Thanks again!
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
I can cotton how to do this but it involves using several techniques First git yourself in an appropriate cotton mood:

https://www.youtube.com/watch?v=K0ZlI3fCCgY


The first technique is to create a button that will throw up a modal dialog and solicit user input for the user and/or message. The two buttons on this page show how to run a script with and without aditional user input beyond the fields on the record being clicked on:

https://haversineconsulting.quickbase.com/db/bkw2ff3e3?a=q&qid=1


Details here: https://quickbase-community.intuit.com/questions/1383163

The second technique is to create hijack QuickBase's method QBI_ValidateEmailView to send email using JavaScript and user supplied to, subject and message fields:


Details here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=429


If you are new to JavaScript there may be a bit too much detail to digest at first but feel free to ask a questions or contact me privately.