How can I automatically Copy projects from one tab to another w/ comments?

[prentie]

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. 

[Dan_Montoya]

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.

[ScottWorld]

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.)

[TheTimeSavingCo]

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

[prentie]

Absolutely! I am trying to move project items to an area labeled as archived to revisit at a later date. 

[Dan_Montoya]

The way to manage this in Airtable would be to create a field called "status" and set the status to "active" or "archived".