Document library custom column only in parent folder

Hi allanyip, my initial idea was to create two different views: the default view (AllItems) and a second view (SubFolderView). When users enter the document library, they will see the list of folders with the default view (AllItems.aspx).

The default behavior when clicking on a folder name is to navigate to the folder within the same view. In this case, I used column formatting to redirect the user to the folder but in a different view.

The column formatting I used:

But when I saw your description, I had another idea.

-------------------------------------------------------------------------

Maybe, as you described, you can create an additional list in SharePoint for all clients with described columns and an extra column that contains a link to the specific client folder on OneDrive.

This list could also serve as an admin list. Additionally, you can add a flow that reacts to the creation of a new item on the list and creates a new folder on OneDrive.