Hi Coda people!
I am building a doc which aggregates a list of time entries using the Toggl Track pack.
The idea here is that we will have all our staff’s time entries in one table, so we can do various kinds of custom reporting and display throughout our doc.
Keep Un-Synced Rows is enabled, so that we can pull entries from Toggl once each day and aggregate them over time.
There are two hurdles to this approach I’m wondering about:
Does Coda have a limit to the number of rows that can be in a sync table?
I see a limit of 10K in the sync table options. Does anyone know if that’s a maximum for rows within the sync window or for total rows in the table (or something else)?
We may have well over 10K total rows in the table eventually with this approach, so we’ll need to make another plan if there’s a limit.
Removing Intentionally Deleted Data
Because we have
Keep Un-Synced Rows enabled, we run into an issue where if someone deletes or changes an entry in Toggl, that won’t be caught by our table. I can’t find a way to remove the deleted data from the table without re-syncing, which could get expensive when we have more rows.
I don’t see a way around this since I guess Coda has no way to differentiate between data that was intentionally deleted and data which just is no longer in the sync window (though let me know if I’m missing something!).
Is there any way to manually delete specific rows from a sync table (such as with a button)?
Obviously a simple right click and delete doesn’t work for sync tables. Creating a simple “Delete Row” button for a sync also doesn’t seem to be possible, since the
thisRow option is disabled for the
Delete Rows action in sync tables.
Any input on these issues, or this approach in general, would be much appreciated. Thanks!