Number of files with a specific property in a folder

Help
1

What I’m trying to do

I am trying to display the Number of files that have a specific property. I am not very savvy with tech, and so I am not confident/confortable with programming/scripting.

The image bellow shows the files and the properties relevant.

image
image1178×184 2.84 KB

But, instead of showing two files that contain the id property, I would like it to simply tell me the number of files in the folder that have the id property.

id — 8 files

Any help would be appreciated.

Thanks!

1 Like
2

Managed to do the following:

image
image1205×363 7.88 KB

Here is the code used to reach the result: list([dimension_id].length)

The issue now is that it is displaying the files individually, which I do not need.

3

image
image1878×284 16.8 KB

Talk is cheap, here’s the code.

formulas:
  back: file.backlinks.length
properties:
  file.name:
    displayName: ID
  formula.back:
    displayName: backlink count
views:
  - type: table
    name: Table
    filters:
      or:
        - file.name == "3"
        - file.name == "2"
    order:
      - file.name
      - formula.back

property name: id

property type: Text

The IDs should have a file to define, like “3” or “2” here. Then for the note file who has this ID, use the property id and link to the ID define file, like [[3]].

Leave me a message if you have any question.