Must Be Unique not working for CSV import?

App Development
1

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

2

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
3

Hey Sean,

Here’s how you can delete records with the scheduled tasks based on your conditions:

image
image1053×440 17 KB

image
image1018×900 48.1 KB

2 Likes
4

Thanks all, will attempt and get back to you.

—S