
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 23, 2018 08:00 AM
Is there any way of moving completed records to a different table so that I can remove finished jobs but still be able to access them for invoicing reasons?
A previous recommendation was to filter to exclude certain records but I can’t for the life of me see how to do this!
TIA
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2020 07:09 PM
Instead of using two different tables to separate incomplete and completed projects, keep them all in the same table, but create a field(column) with either a checkbox to represent that a project is complete, or single select options to represent the status of a project.
Then, use Views and Filters to create Views that show you all incomplete projects only, or all completed projects only.
When you mark a project record(row) as complete (either by checking the box, or by switching the single select status, whichever you choose), it will automatically disappear from the view that shows incomplete projects (because it will be filtered out), and it will automatically appear in the view that shows completed projects (it will no longer be filtered out).

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 23, 2018 09:34 AM
I recommend you to use Views, so you can show/hide based on a Complete field: https://support.airtable.com/hc/en-us/articles/202624989-Guide-to-views

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 18, 2019 06:04 AM
Thank you. I will look into that.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2020 03:05 PM
Hi There,
I have the same issue as Celia.
I am trying to move an “Incomplete Project” to a “Completed Project” Tab or Grid.
Is there any way I can select the project and “move” to completed grid?
Thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2020 07:09 PM
Instead of using two different tables to separate incomplete and completed projects, keep them all in the same table, but create a field(column) with either a checkbox to represent that a project is complete, or single select options to represent the status of a project.
Then, use Views and Filters to create Views that show you all incomplete projects only, or all completed projects only.
When you mark a project record(row) as complete (either by checking the box, or by switching the single select status, whichever you choose), it will automatically disappear from the view that shows incomplete projects (because it will be filtered out), and it will automatically appear in the view that shows completed projects (it will no longer be filtered out).
