Discussions

Expand all | Collapse all

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

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

    Posted 05-04-2018 00:12
    I have this formula:

    If(Contains([Payment Status],"Not Paid")=false,"https://qb.com/db/bnjabvum6?a=dbpage&pageID=20"">https://intuitcorp.quickbase.com/db/bnjabvum6?a=dbpage&pageID=20"">https://qb.com/db/bnjabvum6?a=dbpage&pageID=20";,
    If([Payment Approved?]=true,"https://.qb.com/db/bnjabvum6?a=dbpage&pageID=15"">https://intuitcorp.quickbase.com/db/bnjabvum6?a=dbpage&pageID=15"">https://.qb.com/db/bnjabvum6?a=dbpage&pageID=15";,
    If([PO#]="","https://qbp.com/db/bnjabvum6?a=dbpage&pageID=11"">https://intuitcorp.quickbase.com/db/bnjabvum6?a=dbpage&pageID=11"">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!


  • 2.  RE: I want to add Java confirm to the beginning of this formula, but I am not sure how

    Posted 05-08-2018 03:30
    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