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." error message when I try saving it.
The formula I am using is this:
var text Delete = URLRoot() & "db/" & Dbid() & "?a=API_DeleteRecord&apptoken=*XXXXXXX*=" & [Record ID#];
Does anybody know what I should change? Please let me know.
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)