SItuation
A directory "DirName" is shared with profile "to everybody having the link". The link to access this directory is something like "https://drive.google.com/drive/folders/blabla..."
IN this directory DirName, hundred of files with each a unique name and all the same suffix.
Somewhere else, a google sheet with the list of all the file names.
What I want to achieve is : when you click on a filename, this filename, stored in DirName should open.
SO I think to a kind of new link beeing the concatenation between the "link of the directory" + "the name of the file"
How to do that ???
Claude