- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 02:11 PM
Is there a foolproof way to do this? I use CTRL-X and CTRL-V, but sometimes it works and sometimes it doesn't...and it may depend on whether the columns and views are arranged the same way between the source and target tables.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 08:37 PM
I usually set up views specifically for this where the columns are arranged the same like you mentioned. You could try to make an automation to do this for you, but it probably isn't worth the effort as the view thing works fine, really
I'm curious as to what your workflow is too; is it that you need to keep the original data static as a form of revision control or something?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 08:37 PM
I usually set up views specifically for this where the columns are arranged the same like you mentioned. You could try to make an automation to do this for you, but it probably isn't worth the effort as the view thing works fine, really
I'm curious as to what your workflow is too; is it that you need to keep the original data static as a form of revision control or something?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 06:51 AM
Thanks. Setting up Views will clearly work, and I'm going to revert to that because the cutting and pasting seems extremely error prone.
TL:DR
I use Airtable (in this case) as a CRM system and I track opportunities by academic year. Once a new academic year rolls around, I want to archive last year's opportunities. Essentially each year we start with a blank slate and create a new record in the table. So what I had wanted to do was create a new table that had all of the old opportunities. That way they could be there for reference purposes, but we don't need them cluttering up the table of current opportunities.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 06:36 PM
Ah I see! Hmm, if it's archiving, what if you duplicated the table instead? Then your historical data could still be referenced via linked fields if needed, and you could just clear out whatever fields that're outdated in your old table?
Or if you don't need to reference them at all you could just duplicate the entire base too
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 12, 2025 05:04 PM
Thanks. That won't actually work for us since I'm archiving a few records at a time... Since the cutting and pasting of records is so dodgy, I think I'll just revert to filtering to accomplish the same thing.
