Is it possible to use a scrip create a daily diary of the documents that were added, created, or modified on a given day? If it is, can someone help me with the script?
I want to create a group (smart or not does not matter) for a given year, add groups for each month (either smart or not) and then use smart groups for each day so that I can see what documents I have created, added, or modified on a given day. Here is a screenshot of what I am doing manually. Can this be automated?
I use a daily group for my journal notes
Here’s code from the script I use to auto-create the group
and populate the group with templates of my daily planner and review notes
set theFilingGroup to get record with uuid "878AADEA-A15F-4DBD-B9B9-BF59099F5554" in database "FilingCabinet"
set theNewFilingGroup to create record with {name:("Journal [⭕️" & dddd as string) & "] " & yyyymmdd & " Type-Journal", type:group} in theFilingGroup
set tags of theNewFilingGroup to {"Type-Journal"}
set theTemplate to get record with uuid "C827694F-3C7F-411D-B4DC-5A0CEC69F45E"
set theNewRecord to duplicate record theTemplate to theNewFilingGroup
set name of theNewRecord to ("Journal [Planner " & dddd as string) & "] " & yyyymmdd & " Type-Journal Journal-NotePlanner"
set creation date of theNewRecord to current date
set modification date of theNewRecord to current date
set tags of theNewRecord to {"Journal - NotePlanner"}
set theTemplate to get record with uuid "E113ACA5-37ED-41E7-B268-42C6D83C27E9"
set theNewRecord to duplicate record theTemplate to theNewFilingGroup
set name of theNewRecord to ("Journal [Review " & dddd as string) & "] " & yyyymmdd & " Type-Journal Journal-Review"
set creation date of theNewRecord to current date
set modification date of theNewRecord to current date
set tags of theNewRecord to {"Journal-NoteReview"}
so that I can see what documents I have created, added, or modified on a given day
Notes are already tagged with the date in the metadata
Why not simply sort the note list by date
Yes, it’s possible (though not without some scripting) but why does it need to be smart groups?
Can it just be filing those items in dated groups?
If you must have smart groups, where is your list of dates to match coming from?
I do not really know what are dated groups. I can see smart groups that are based on either Created Today/ This Hour/ etc. but that’s a smart group. I could be wrong and may be that is what you call a dated group.
It does not have to be a smart group. I just want to see what documents (any type – .rtf, .pdf, etc.) I have created, added, or modified on a given day within the entire database, not within a specific group though it would be nice to have the latter too.
Hopefully someone can help me with the script.
Thank you so much for the script. I am not sure if it was meant to work for my database, but for some reason I am getting an error message.
You mention ‘notes’ in your response, and I am not sure if you mean exclusively .rtf files. I want to all types of files.
I am not sorting the notes by date because they are in all kinds of groups and subgroups. I want the smart group to grab the files from the entire database so I can see the different projects I have worked on on a given day.
Your smart groups are clearly named for specific dates and I’d assume their criteria are date-related, hence the term dated groups.
It does not have to be a smart group. I just want to see what documents (any type – .rtf, .pdf, etc.) I have created, added, or modified on a given day within the entire database, not within a specific group though it would be nice to have the latter too.
This is an important thing to decide. A smart group only exposes matching items. They aren’t moved, copied, etc., but remain in place. Creating groups would either require moving the items or replicating them.
And it sounds like you just need this behavior infrequently, not something you’d be referring to often. If that’s the case, then just create a smart group with your criteria for the current date you want to filter on. Then edit and change the date the next time you need to filter on another date.
Can you clarify exactly what your need and purpose are?
Got it. You were referring to my dated smart groups. Yes, the dated crops should be smart groups because I do not want the original items to be moved. I do not want the dated groups to be replicated groups because when I Reveal a file, I want to go to the correct group where the item is placed not to the Diary.
Ideally, the script would be flexible enough to generate this diary for any specified year. The structure I would like is:
Year > all 12 months > all days for each month > all types of items and files from the entire database based on their date of creation, modification, and date being added.
I want to be able to review what I have worked on on a regular basis.
Thank you for reading.
the ‘file web clippings ‘ smart group script from the ‘extras and add-ins ‘ tab seems to me to approximate the goal u describe. if you playaround with that script you might find that it only requires an edit to (and better name ,lol) to serve your purposes
After the smart/tag group “grabs the files from the entire database”
they can be sorted by date