I have a load of records that are from a certain date (one fo the fields) and am importing newer records that will duplicate them, is there a way of setting the ones I want deleted to avoid duplication and have a global delete?
E.g. records imported on 1.1 2016 new records imported on 1.6.2016 remove en masse the 1.1.2016 records?
Hi Roger,
Mac or iOS?
In either case, just create a Saved Search that filters the records for the specific date and then just delete the ones that are found from the search.
On iOS one of the new features is the Delete All Records command will delete just the found set of records if a saved search is currently selected.
Thanks,
Brendan
It is the Mac version. Yes I understood that you could create a search and then you would only be presented with the records you wished to delete. However I can then not select en masse bu have to do them one at a time? Am I missing something or will I have to then export the records and do the mass delete in Numbers and then import the cleaned up records back again? Its a bit of a pain… well actually 2589 pains when looking at the records I want to delete.
Roger
You could just press command-a to select all the records once you’ve clicked on one record. That’ll select them all. Then just press command-delete to delete all the selected records.
Duh, indeed I could, and I have just done so. That worked and they are gone. Thank you. So obvious when its said.
However the database is still the same size as it has preserved 2000 plus records as blanks now.
DB prior to action – 5176 records, database now 5176 records. To remove the records I still need to do that either by one at a time selection, or by export to Numbers and then delete there, then reimport…
Roger
I think you were in the multi-column list view and you just pressed the delete key instead of the command-delete key. One clears the fields, the other deletes the records.
To shrink the database size after deleting records, go to the Maintenance tab in the Preferences window and click on the Compact Database button.
Thank you yes that worked fine though it took a little while to delete them all.
I made an optimizing in the most recent version which speeds up deleting of records. Make sure you’ve got the latest version of Tap Forms.
Thanks Brendan, great service as usual
.
