You could do a Container with External Storage to keep your file small. Same issue if you move them but at least they are out of your database.
Well, what you describe would be a Catch 22 when using a reference. You could of course import them after you added them to \SCANNED folder.
From the back slash path syntax I take it you're on Windows; on OS X, I'd have suggested using a folder action with an AppleScript to automate the import of newly added documents; not sure if/how this can be automated under Windows.
I add files as references, then move the file (manually or using a plugin) and run a script like this
set variable ( $FilePath ; "filewin:/X:/APInvoices/Scanned/" & GetValue ( ContainerField ; 1 )
Insert File [ Table::ContainerField ; $FilePath ] (as reference, no dialog)
If it were me I would use External storage for the container field, import the PDFs using Import Folder, then delete everything in the folder (since External storage means the original scans are no longer needed). The folder is then empty and ready for use next time.
In English can you explain what is happening. I presume I am running your script on the found set (newly created records). But I am unclear what is happening.
Yes, I am running this on Win10.
Oops: the first line of code should be
set variable ( $FilePath ; "filewin:/X:/APInvoices/Scanned/" & Substitute ( GetValue ( ContainerField ; 1 ) ; "file:" ; "" )
In a calculation, a container field has a list of characteristics, the first item in the list contains the file name.
I use GetValue to extract that, Substitute to remove the prefix, then add the full path of the folder where the PDF is moved to, and put that all into a variable.
That variable is then used as the source of the Insert step.
You would run that on each newly created record, so a loop would be good.
NOTE: This assumes that all users are on Windows and can see the PDFs at the same drive mapping.
Some more complexity is required if there are other platforms or drive mappings involved.
... or you could use External storage.