Skip to main content
Question

Delete a record without going into grid edit or going into the selected record

  • May 16, 2017
  • 0 replies
  • 62 views

Hi, is it possible to delete a record from the table view with quickbases native features?

No problem,
You can make a URL formula button to delete a record and refresh the page. But there is no "are you sure" step on this so be careful.

var text URL= URLRoot() & "db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#]
& "&apptoken= xxxxxxx";


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


if you have application tokens enabled on the app properties tab for the application, then you will need to supply that long code number.  or else just disable them as not being needed.

  • Registered
  • May 16, 2017
If you want to take is a step further... what happens to all the child records of the parent you delete?  
They become lost in space, and really reek havoc on your reporting.
.
.
In comes "Clean Delete" to save the day.  We have a tool that will delete, in one click, the parent, the children, and grandchildren records.


QuickBase is about data, but if your data becomes 'dirty' over time, its hard to trust the reports.

  • Author
  • Registered
  • May 16, 2017
This did the trick, thank you!

Tying to  QuickBaseCoach App Dev./Training, Champion answer, You can do something like this for confirmation:

var text URL= URLRoot() & "db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#]
& "&apptoken= xxxxxxx";

"javascript: " &
"if ( confirm('Are you sure you want to permanently delete this record ? ') == true ){ "&
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);"&
"}

Thx for that post!  Good addition to the Community base of knowledge.

Forum|alt.badge.img+6
  • Registered
  • July 31, 2017
Trying to figure out how to use this to delete a child record in a embedded report.  It is a line item on an order form, and I want to have the option to delete the line item.  The record ID# does not appear on the embedded report used to enter line items.

Just use my post which begins with "no problem ....