Forum Discussion

CBH_Service_Acc's avatar
CBH_Service_Acc
Qrew Member
18 hours ago
Solved

Delete Formula Button Error

Hello, I have a URL Formula field I created that I'm trying to use as a Delete button on one of my tables, but I keep getting this "A formula cannot end with an assignment to a variable declaration....
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    17 hours ago

    Sure, I can help.  Where do you want to redirect the user to after the delete?  Perhaps that table home page?

     

    If so, try this

     

    var text Delete = URLRoot() & "db/" & Dbid() & "?a=API_DeleteRecord&apptoken=*XXXXXXX*=" & [Record ID#];

    var text TableHomePage = URLRoot() & "db/" & dbid() & "?a=td";

    $Delete

    & "&rdr=" & URLEncode($TableHomePage)

     

     

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
17 hours ago

Sure, I can help.  Where do you want to redirect the user to after the delete?  Perhaps that table home page?

 

If so, try this

 

var text Delete = URLRoot() & "db/" & Dbid() & "?a=API_DeleteRecord&apptoken=*XXXXXXX*=" & [Record ID#];

var text TableHomePage = URLRoot() & "db/" & dbid() & "?a=td";

$Delete

& "&rdr=" & URLEncode($TableHomePage)

 

 

  • CBH_Service_Acc's avatar
    CBH_Service_Acc
    Qrew Member
    16 hours ago

    Mark,

    Yuup, that's perfect. That's what I was looking for. It works on my end now. Thank you!