- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 25, 2024 07:48 PM
Dear All,
Newbie here! To simplify our current workspace, we would like to duplicate our main base (let's call it A) and delete any entries in the duplicated version (B) with a deadline after June 2023. B will be used as archive for our past work.
Then we would like to run an automation in A to remove any content with the deadline set till June 2023 (so we are only using what is for use " current content")
This is a one-time automation; we do not need it to run multiple times. How can I set up the script for each scenario?
Thank you in advance for your support and guidance,
Best regards,
Catherine
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 26, 2024 01:03 AM - edited ‎Aug 26, 2024 02:21 AM
Hi Catherine,
If you need to clean your base, (B or A), one time only, i suggest you to do it manually :
- filter on your deadline column to get record older than June 2023
- then select those record and delete it.
If you need an automation to keep your base up to date, you can chose scheduled trigger then execute a script like :
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 26, 2024 01:03 AM - edited ‎Aug 26, 2024 02:21 AM
Hi Catherine,
If you need to clean your base, (B or A), one time only, i suggest you to do it manually :
- filter on your deadline column to get record older than June 2023
- then select those record and delete it.
If you need an automation to keep your base up to date, you can chose scheduled trigger then execute a script like :
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 26, 2024 04:31 PM
Thanks. I ended up doing it manually, as suggested as this was a one-time thing, but good to now how to run a similar script if needed.
Many thanks
Catherine
