How do you format a API_PurgeRecords button?
I'm sorry but I'm not very experienced in coding. I'm trying to just create a button on a table or home page that will allow me to use the API_PurgeRecords to delete some records on a table based off ...
Forum Discussion
There is a low tech solution
The API_PurgeRecords API as descibed here https://help.quickbase.com/api-guide/index.html#purgerecords.html can have a parameter to filter which records get purged.
URL Alternative
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
The API_PurgeRecords API as descibed here https://help.quickbase.com/api-guide/index.html#purgerecords.html can have a parameter to filter which records get purged.
URL Alternative
https://<em>target_domain</em>/db/<em>target_dbid</em>?a=API_PurgeRecords&qid=10<br>&ticket=<em>auth_ticket</em>&apptoken=<em>app_token</em><br>
where target_domain is the domain against which you are invoking this call, for example, intuit.quickbase.com.
So you can make a report where the filter is that checkbox being true and hide the report form all role so no one is likely to mess with it. i would also put in the description of the report to not delete or alter the report.
so the URL formula would look like this below. The javascript code will simply run the formula variable called URL to do the purge and refresh the page.
var text URL = urlroot() & "db/" & [_DBID_TABLE name goes here] & "?act=API_PurgeRecord&qid=99";
"javascript:" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
You can put that into a URL formula field. If you want to have a dashboard button, make the URL formula on a field somewhere in the app and expose the code by by suppressing the link text. Then copy and paste the code into a URL dashboard button element.
I would test this first on a Copy of your app, as when you purge records they are "gone baby gone".
There is also another way to alter the URL to not depend on a report qid, but rather just use query parameters. That would actually be a bit safer as that way you would not have a risk of someone removing the filers on your report and then the purge might purge everything.
My solution is very low tech. Just make a report and filter it like any report is filtered. Then save the report and observe the qid# in the URL when you run it.
Or are you in fact asking how to use query parameters to filter the report which involves more syntax. My method is no code at all, just make a report with the correct filters, and then use that report qid in the API call.
Or are you in fact asking how to use query parameters to filter the report which involves more syntax. My method is no code at all, just make a report with the correct filters, and then use that report qid in the API call.