Table Not Showing All Records

Question

I have a table sorted in descending order by date. Records are automatically added to it by a Pipeline triggered by events (formerly via automation but it was migrated). I just recently discovered that it doesn't appear to be getting updated. However, when I did an import of the necessary records, it failed for duplicates. When I tried to manually add a record, it failed for the same reason. So, QuickBase thinks the records are in the table but I cannot see them no matter what I do. I have viewed the List All report, List Changes report, tried searching the List All report for a date that I know should exist, and I tried doing a custom report for all recent dates that I cannot see. Nothing shows up. Any input would be greatly appreciated. Thank you in advance to whomever can help.

------------------------------
James Carr
------------------------------

LauraThacker · Answer

Sometimes users accidentally filter List All reports. Create a from-scratch report and see if they show up there. Also, do a data-dump of the entire table. Go to the ImportExport screen for the table; and click the radio button to export the table as a csv. This will allow you to use Excel to search for the data.

If your data is not there, then there is something preventing the import - perhaps a unique field setting or custom Key that would become duplicates. If you have unique-field values in your destination table; perhaps the data you are trying to migrate across has duplicates. See if you can find those, and then exclude those from the process and try to run it.

------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------

Sign up

Login to the community