Hi TB Community,
We are importing CSV data to a table containing a field marked MUST BE UNIQUE, but duplicate values are still being imported to the field.
This would not be such a problem except that we can’t devise a method internally or externally to delete the duplicate records. I’ve already written a Google app script to mark duplicates as YES, but I can’t figure out how to automate the deletion of these records in TB.
Thanks in advance,
—S
Hi Sean,
You could set up a scheduled task using the Tadabase rest API to delete the records based on your conditions. You can set it to run daily/weekly/monthly/quarterly (depending on your plan) or on demand.
But to get at your initial issue of “Must be unique” not working - I’m not sure that works for importing, it might only be for user submitted records in a form.
@partners can anyone show Sean how to set up a scheduled task with the API pipe?
1 Like
Hey Sean,
Here’s how you can delete records with the scheduled tasks based on your conditions:
2 Likes
Thanks all, will attempt and get back to you.
—S