Inserting from a directory all *.pdf or *.doc object , click a file and open it

[JACKNIEKERK]

i got this sofar 

for each File in filelist ('V:/1 KWALITEIT/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/*.*')
LOAD
'V:/1 KWALITEIT/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/' & '$(File)' as DocumentLink100,
Subfield( '$(File)' , '/', -1) as DocumentName100
autogenerate 100;
next File

this in  Graphic object , works ok  line click opens fileshows like

problem since all files moved to other directory, work not anymore'NEW VERSION

for each File in filelist ('I:/1 KWALITEIT-2020/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/*.*')
LOAD
'I:/1 KWALITEIT-2020/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/' & '$(File)' as DocumentLink100,
Subfield( '$(File)' , '/', -1) as DocumentName100
autogenerate 100;
next File

 reload looks like this and  no files anymore,  

 the expression

does not work

GONE 100

have to change more the 1000 files definitions,  in edit do a find change  ,

So looking for OR a better solution in code also due have to make for each directory hardcoding  in source also

if new directories arise

OR to get solution to make this one stable

[JohnPorter]

---

@JACKNIEKERK wrote:

i got this sofar 

for each File in filelist ('V:/1 KWALITEIT/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/*.*')
LOAD
'V:/1 KWALITEIT/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/' & '$(File)' as DocumentLink100,
Subfield( '$(File)' , '/', -1) as DocumentName100
autogenerate 100;
next File

this in  Graphic object , works ok  line click opens fileshows like

problem since all files moved to other directory, work not anymore'NEW VERSION

for each File in filelist ('I:/1 KWALITEIT-2020/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/*.*')
LOAD
'I:/1 KWALITEIT-2020/Organisatie Sunkip/Certificaten Sunkip/HACCP & QS Certificaten Sunkip/' & '$(File)' as DocumentLink100,
Subfield( '$(File)' , '/', -1) as DocumentName100
autogenerate 100;
next File

 reload looks like this and  no files anymore,  

 the expression

does not work

GONE 100

have to change more the 1000 files definitions,  in edit do a find change  ,

So looking for OR a better solution in code also due have to make for each directory hardcoding  in source also

if new directories arise

OR to get solution to make this one stable

---

I need solution for this.

[JACKNIEKERK]

I see a reading response , but no solution?