What plan are you on at the moment? Maybe you can help a mirrored table that stores only the added IDs and check against them?
im still in free plan, and will use the maker plan for this app after im done developing it. If im making a mirrored table isnt it will takes up the row count?
Yes, it would count towards your row quota.
is the maximum row count (25k) is applied to row from googlesheet to?
im planning to use mirrored table from googlesheet, where i store all the unduplicated ID from a 3 days data collection. my question is, if my relation action triggered (to check my ID stored in googleshet) do it count as update or the update count just when i sync the stored ID every 3 days?
Yes, that’s correct.
A “relation” won’t trigger an update, but any changes on the Sheet side will trigger an update (as a sync).
if the row from googlesheets still count, theres no meaning for using it for my stored ID. i think with my target surveyed around 20k citizen and the mirrored from googlesheets just will eat my row count. So theres no solutions for me to have a individual data with general column for ID checking.
My only thoughts would be to create a separate admin row owner so you can access all rows. Maybe add a collection somewhere in your app that only shows duplicates and add an action to your collection to delete one of the rows. You could do the same thing with a second app that only you have access to, which would have any row owners applied.
1 Like