Delete record from synced CSV email data table

[Gabrielle_Guill]

I have a table that syncs from emailed data from CSV attachments. I need to be able to delete some individual records. (The data is not valid, and it's messing with roll-up calculations.) When I try to delete a record in the main record UI it's grayed out and says "To delete this new record, update this table's sync configuration so that records are deleted when deleted or hidden in the source." But I don't know how to get to the source since it's an emailed CSV? Can anyone advise on how I can get some records deleted from the synced table? Either through accessing the source data (how?) or through a script or API override of sorts? Open to any suggestions. TIA!

[ScottWorld]

I could be wrong, but I don't believe that there is any way to delete data from an emailed CSV sync, which is why I think that this feature was poorly implemented by Airtable!

You may want to email support@airtable.com to see if they can delete the record for you.

In the meantime, my best recommendation for you would be to create your own CSV sync by using Make's CSV integrations and Make's Airtable integrations.

I should exactly how to do this step-by-step on this Airtable podcast episode.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

[Dan_Montoya · Accepted solution]

@ScottWorld is correct.  The CSV import will recreate missing records if you have that checked on the sync configs.  

I would suggest your rollups only rollup records that meet the criteria to make it valid.  This will protect your rollups from other data that doesn’t meet the criteria. 

[ScottWorld]

Yes, great idea. In essence, just have your base "ignore" the records you don't want.