Feb 12, 2024 07:57 AM
Hi All I am attempting to create an automation where a project can be copied or duplicated to another tab with all of its comments still included on it and then deleted from its original location. Does anyone have an idea where I can do this?
I am currently using an automation and a script to copy the project name and column fields but I am not sure how to also get the comments.
Feb 12, 2024 01:37 PM
Hi @prentie , would you mind sharing your use case on why you would want to do this? In practice, it would be best practice to keep all objects that are the same type in the same table. So it wouldn't scale to copy make copies of the projects table into separate tables.
Feb 12, 2024 05:20 PM
Yes, what @Dan_Montoya said is the best solution. You may want to explore Airtable's filtered views, which let you control which records you can see at any given time in your table. (I cover views in depth in my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning.)
Feb 13, 2024 04:55 AM - edited Feb 13, 2024 04:55 AM
You can access and create comments via the API, but you wouldn't be able to re-create the comments with the original authors though
Feb 14, 2024 12:33 PM
Absolutely! I am trying to move project items to an area labeled as archived to revisit at a later date.
Feb 14, 2024 01:24 PM
The way to manage this in Airtable would be to create a field called "status" and set the status to "active" or "archived".