Any way to clear all records or delete a table through script?
This don't work:
do
{
let table = base.tables.pop();
console.log(`Goodbye, ${table.name}!`);
}
while(base.tables.length>0)
Solved
Script to clear all records or table
+4Best answer by Mike_AutomaticN
Hey @renewNiko!
I just sent you my own version of the script via PM, in case @kuovonne did not send that over yet :D.
Best,
Mike, Consultant @ Automatic Nation
+29Yes, it is possible to delete all records in a table through a script. The script is actually a very simple one; however, because it is so destructive, I don't feel comfortable posting a version.
It is not possible to delete the table itself via scripting.
Where did you get the code you posted? It looks like code for removing items from an array one at a time, which is very different from deleting an actual table.
Would you care to share why you want to delete all the records in a table or delete the table itself via code? Usually these things are done very infrequently and thus can be done via human interaction.
+4Yes, it is possible to delete all records in a table through a script. The script is actually a very simple one; however, because it is so destructive, I don't feel comfortable posting a version.
It is not possible to delete the table itself via scripting.
Where did you get the code you posted? It looks like code for removing items from an array one at a time, which is very different from deleting an actual table.
Would you care to share why you want to delete all the records in a table or delete the table itself via code? Usually these things are done very infrequently and thus can be done via human interaction.
Thank you for the reply. There is a third-party integrations that feeds data and they can't keep track of changes/new rows in the data so they send everything. Therefore, I would like to empty the table every day.
I would be grateful if you posted that simple script. PM me if you like, the risk is on me 🙂
ps
the script I posted was something I just came up with just using IntelliSense...
+28Hey @renewNiko!
I just sent you my own version of the script via PM, in case @kuovonne did not send that over yet :D.
Best,
Mike, Consultant @ Automatic Nation
+29Thank you for the reply. There is a third-party integrations that feeds data and they can't keep track of changes/new rows in the data so they send everything. Therefore, I would like to empty the table every day.
I would be grateful if you posted that simple script. PM me if you like, the risk is on me 🙂
ps
the script I posted was something I just came up with just using IntelliSense...
@renewNiko wrote:the script I posted was something I just came up with just using IntelliSense...
Thank you for saying how you got the code. Looks like IntelliSense doesn't know anything about the Airtable scripting environment. I would not trust it to come up with an Airtable script.
+4Hey @renewNiko!
I just sent you my own version of the script via PM, in case @kuovonne did not send that over yet :D.
Best,
Mike, Consultant @ Automatic Nation
Thanks Mike! 👍
+2Hey @renewNiko!
I just sent you my own version of the script via PM, in case @kuovonne did not send that over yet :D.
Best,
Mike, Consultant @ Automatic Nation
Hello Mike, can you send me the script too? 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.