How to select a file in open/save dialog by 1) file type and 2 )date added

This is cool, owen. Also like the aspect that spots to a certain time code. I'd still love to come up with a version of this type of macro that will just grab whatever video file is in the folder by some criteria, without user input...

Curious: is the the big-sur related code issue is the same code (or same type of code) as the stock SF command ""Navigate to Folder of Current Session"? Because I have another macro (discussed here: Can't navigate to session folder in PT "save a copy" dialog) where that command/code is not working properly, though it does work in other places i've tried it and I'm not sure what the difference is.

That said, I am planning on a Monterey update at some point soonish, and if things work better there, i may move the update up the priority list. You are on Monteray?

sorry, it still doesn't work in all the same ways, plus a new quirk:

• spot "yes" enabled does that same thing where it never completes an attempt to change the time code. Also, with spot selected, pro tools does not get activated. Previously when I tested presets, I ran the command straight from the "run command" button in soundflow. So this time, I had to make a new macro where ProTools is activated as the first step, then triggers the preset. But the same net result.

• With spot/timecode off, it still can't find the sheets.

FWIW, when it gets to the step where it should be doing sheets stuff, if I manually press "/" the go-to dialog does appear. So I wonder if it's a matter of putting the right kind of wait in there?

If it helps, in my "import" macro, this code does work for me to import a video and navigate to the correct folder:

sf.ui.proTools.appActivateMainWindow();
sf.ui.proTools.trackGetByName({ name: "MOV", makeVisible: true }).track.trackSelect();
//Calling command "Import - Video..." from package "undefined" (installed from user/pkg/version "srAasovvDiQacRZ2mcId4RrOA8R2/ckp49i4j60000a2100yfwywgf/ckyu15xww00004v10dq15rpgq")
sf.soundflow.runCommand({
    commandId: 'user:ckp49i4j60000a2100yfwywgf:cktcnf0ra000x9r109i8wen1u#cktcmu1ek000l9r107c7eyej0',
    props: {}
});
sf.ui.proTools.windows.whoseTitle.is("Open").first.children.whoseRole.is("AXStaticText").whoseValue.is("Select Video File To Import:").first.elementWaitFor();

function navigateToInDialog(path) {
    //Get a reference to the focused window in the frontmost app:
    var win = sf.ui.frontmostApp.focusedWindow;
    
    //Open the Go to... sheet
    sf.keyboard.type({ text: '/' });
    
    //Wait for the sheet to appear
    var sheet = win.sheets.first.elementWaitFor({ timeout: 500 }, 'Could not find "Go to" sheet in the Save/Open dialog').element;
    
    //Set the value of the combo box
    sheet.comboBoxes.first.value.value = path;
    
    //Press OK
    sheet.buttons.whoseTitle.is('Go').first.elementClick({}, 'Could not click "Go"');
    
    //Wait for sheet to close
    win.sheets.first.elementWaitFor({ waitForNoElement: true, timeout: 500 }, '"Go to" sheet didn\'t close in time');
}

var folderPath = sf.ui.proTools.mainWindow.sessionPath.split('/').slice(0, -1).join('/') + '/ASSETS';

if (sf.ui.frontmostApp.focusedWindow.title.value.match(/open|import/i)) {
    navigateToInDialog(folderPath);
} else {
    sf.system.exec({ commandLine: 'open "' + folderPath + '"' });
    sf.ui.finder.appActivateMainWindow();
    sf.ui.finder.windows.first.elementRaise();
}
sf.ui.proTools.windows.whoseTitle.is("Video Import Options").first.elementWaitFor({
    timeout: 20000,
});
sf.ui.proTools.windows.whoseTitle.is("Video Import Options").first.checkBoxes.whoseTitle.is("Import audio from file").first.checkboxSet({
    targetValue: "Enable",
});
sf.ui.proTools.windows.whoseTitle.is("Video Import Options").first.buttons.whoseTitle.is("OK").first.elementClick();
sf.ui.proTools.windows.whoseTitle.is("Video Import Options").first.elementWaitFor({
    waitType: "Disappear",
    timeout: 2000,
});
sf.ui.proTools.windows.whoseTitle.is("Open").first.children.whoseRole.is("AXStaticText").whoseValue.is("Choose a destination folder").first.elementWaitFor({
    waitType: "Appear",
});
sf.ui.proTools.windows.whoseTitle.is("Open").first.buttons.whoseTitle.is("Open").first.elementClick();
sf.ui.proTools.windows.whoseTitle.is("Open").first.children.whoseRole.is("AXStaticText").whoseValue.is("Choose a destination folder").first.elementWaitFor({
    waitType: "Disappear",
    timeout: 5000,
});

There's more code after that specific to my needs, but that's the gist of getting the video into a session and onto a track that I have established in my session template for video imports: "MOV". Line 3 is just pulling from the stock file menu command in soundflow.

Disclaimer: I had to copy-paste this code from a bunch of commands bc my actual macro pulls in several other macros, so there is no way to generate a script straight from my macro that doesn't have a bunch of command ID's. So not being used to doing this, it's possible I made an error copying/pasting all the code into one place.

I hope that helps.