Forum Discussion
QuickBaseCoachD
Qrew Captain
You cannot add or delete records manually on a connected table.
So your choices are to either change the source table (if that is possible) and delete them there or to adjust the filter. For example, if you change the filter to match the source records exactly, and filter the old records out, then the old records should delete. In the next refresh.
So your choices are to either change the source table (if that is possible) and delete them there or to adjust the filter. For example, if you change the filter to match the source records exactly, and filter the old records out, then the old records should delete. In the next refresh.
BobJordan
7 years agoQrew Cadet
Well I noticed some special conditions discussed for 25MB files here: http://www.quickbase.com/downloads/sync/QuickBase_Sync_for_Cloud_Apps.pdf
Additionally in my own use of it, I noticed that I kept getting substantially more errors in the sync operation as the file size was closer to 25MB (operation time out errors and spools failing).
For the file split, my thought of changing the settings is so that the table in QB retains all the data. Meaning that the first half of the import would basically wipe the DB and make it match that first half of the CSV while the second half would simply append to it on the table without removing anything (essentially re-combining the file prior to the split).
If you believe the split may not even be necessary though, then that might save some work.
Additionally in my own use of it, I noticed that I kept getting substantially more errors in the sync operation as the file size was closer to 25MB (operation time out errors and spools failing).
For the file split, my thought of changing the settings is so that the table in QB retains all the data. Meaning that the first half of the import would basically wipe the DB and make it match that first half of the CSV while the second half would simply append to it on the table without removing anything (essentially re-combining the file prior to the split).
If you believe the split may not even be necessary though, then that might save some work.