Skip to main content

Deleting empty records


Sometimes a base ends up with empty records - records with no values in any fields. Here is a utility to delete them from a table.


A table with several empty records



Using the script



The script asks for confirmation before deleting. Because there is no data in any of the fields, the record ids are shown.



The table with no empty records:



Here is the code:

https://gist.github.com/kuovonne/8837d4c153ee1d1e4214412763b5c58e


deleteBlankRecords.js

/*******************************************************************************

Title: Delete Blank Records for Airtable scripting block

Author: Kuovonne Vorderbruggen

Website: kuovonne.com

Date Created: March 4, 2020

Version: 1.0

Copyright (c) 2020 by Kuovonne Vorderbruggen

Usage License: MIT License



## Description

This file has been truncated. show original











I updated the gist with some enhancements:




  • Sort records by the primary field. Empty records should be at the top of the sort.




  • Retrieve and check only non-computed fields. Should improve performance for tables with lots of computed fields.




  • Stop looking for empty records after reaching batch limit of 50.




  • Improved comments and variable names.



I updated the gist with some enhancements:




  • Sort records by the primary field. Empty records should be at the top of the sort.




  • Retrieve and check only non-computed fields. Should improve performance for tables with lots of computed fields.




  • Stop looking for empty records after reaching batch limit of 50.




  • Improved comments and variable names.




Hello Kuovonne,

I am trying to use your script to alter the following! I would like to combine the first two rows into one by replacing and delteing redundant values, and keeping the valid one under the valid field. How should i do that?


Screen Shot 2021-03-18 at 2.56.25 PM|700x130

@medairtable This script is not designed to combine rows. It is only meant to delete completely empty rows.


If you need to merge multiple records, I recommend looking into the Dedupe app.

@medairtable This script is not designed to combine rows. It is only meant to delete completely empty rows.


If you need to merge multiple records, I recommend looking into the Dedupe app.


I did look into it but ended up filtering and reorganzing my data based on filters and groups. It took some time but i was in control hehe.

@medairtable This script is not designed to combine rows. It is only meant to delete completely empty rows.


If you need to merge multiple records, I recommend looking into the Dedupe app.


I have another problem and looking for a solution, it would be great if you give me ideas.

I have a team generating leads. Every-time a person fills a form, an incremented leads on his row under {Lead}. It shows the total leads this person got.


Goal: I want to know how many leads are in on a week to week basis. I am not sure how should i do that?

Is it through a last modified field and a formula?

I have another problem and looking for a solution, it would be great if you give me ideas.

I have a team generating leads. Every-time a person fills a form, an incremented leads on his row under {Lead}. It shows the total leads this person got.


Goal: I want to know how many leads are in on a week to week basis. I am not sure how should i do that?

Is it through a last modified field and a formula?


In order to calculate statistics for a week, you need a table of weeks, with a row for each week. Then you need to link data records to the proper week. Finally, use rollup (and possibly count) fields to perform the calculations.

Reply


Terms & Conditions