What are FolderPath
and RecordID
? Perhaps field names? If they are field names, then the list should update when moving to a different record.
What does “if nothing matches” mean? That there is no such folder? If there is no such folder, the result will be an error, and in that case, the text list won’t update.
I’m not sure why you are using the folder( function – perhaps just as a holdover from Panorama 6. It doesn’t hurt anything in this case, but it’s unnecessary.
I think the formula you are looking for is:
catcherror("",listfiles(FolderPath+"/"+RecordID))
(Note that the second parameter of listfiles( is also optional now in Panorama X, so I left it out.)
You mention that you tried catch error(
, is that space a typo? There is no space in the catcherror(
function name.
I’ve added the RecordID to the formula
In this case RecordID is already part directly of the formula, so this isn’t necessary. If it was necessary (for example if it was included in a formula that was quoted, which would make it “invisible” as far as record updating goes), the ignore( function is designed for this purpose. For example:
ignore(catcherror("",listfiles(FolderPath+"/"+RecordID)),RecordID)
However, this is not necessary in this situation.
That wouldn’t have worked either, because the error would have stopped the code and the list wouldn’t be filled. Basically exactly the results you’re getting now, for the same reason.