Do you need them in a separate table or can you just use filtered views?
Do you need them in a separate table or can you just use filtered views?
Ideally, we want to keep an achieve of them.
If we hide them with filtered views, will they still show in any live sync’s like Google Sheets/Website API for example?
Ideally, we want to keep an achieve of them.
If we hide them with filtered views, will they still show in any live sync’s like Google Sheets/Website API for example?
No clue. If your syncs permit you to limit to a particular view, then they shouldn’t show up. If you can only specify a table then they’ll show up.
You could use an automation to create an identical record in another table. There’s no “delete record” action step, but you can delete the “live” record using a script action in the Automation after the “create record” step runs to make the archive record.