So I have a single Attachments field in a table that allows for multiple individual files to be attached to a record. I want to create another field that counts the number of files that have been uploaded/attached to that record. I then want to them pull this number into the primary field of the table to provide a quick way to see how many files have been attached to the record (e.g., 5 videos, 11 screenshots).
However, the built-in ‘count’ formulas seem to be only counting the occurrence of an attachment for the record, not the number of individual files within the record; so as a result, it is only showing things as having 1 or 0 attachments, even though there are multiple individual files that have been attached to that record within the Attachments field. I came across an old thread about counting attachments (for some reason it’s preventing me from including the link here) but it seems outdated given the formulas now available, plus I could not get the formula to work at all.
Any ideas on how (or if) I can make it count the number of individual files that have been uploaded/attached to a single record?
Edit: Forgot to mention I only have a very basic knowledge of formulas, so please bear with me