I want to add Java confirm to the beginning of this formula, but I am not sure how

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
I have this formula:

If(Contains([Payment Status],"Not Paid")=false,"https://qb.com/db/bnjabvum6?a=dbpage&pageID=20";,
If([Payment Approved?]=true,"https://.qb.com/db/bnjabvum6?a=dbpage&pageID=15";,
If([PO#]="","https://qbp.com/db/bnjabvum6?a=dbpage&pageID=11";,

var text URL = URLRoot() & "db/"
& "bnjabvupd"
& "?act=API_EditRecord&usertoken=b3h8mh_k_c9j3i6gcvnzat8caff9m2quiq2m&rid=" & ToText([Record ID#])& "&_fid_364=1&_fid_365=" & URLEncode(User()) & "&_fid_483=" & URLEncode(Now());

"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);")))


I want to prepend this:

"javascript:confirm ('Are you sure you want to receive this line? ')"


Any ideas?

Thanks!
Photo of Mark Winter

Mark Winter

  • 252 Points 250 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
I'm not an expert on this, but I don't think you can have the Get and the Confirm together.

You might just have to determine the redirect ahead of time and then use the confirm option.  

Just an idea