How to count number of individual attachments/files within a record?

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?

Thanks!

Edit: Forgot to mention I only have a very basic knowledge of formulas, so please bear with me :wink:

1 Like

This is a cool concept and fairly straightforward. Each attachment is separated by a comma. So, you can count the number of commas in the Attachment field to see how many attachments there are. See this example. Hope it helps!

Wow this is perfect, thank you @VictoriaPlummer! I was able to copy the base you provided and adapt the formulas to my fields.

Oh shoot @VictoriaPlummer I spoke too soon. Looks like it is still counting records with no attachments as having 1 attachment. It’s also doubling the count in some instances; for example, a record with 5 videos attached is being counted as having 10 attachments. Any ideas?

Edit: The second issue with things being counted twice was due to commas in the file name. Still have the first one though with zero attachments being counted as 1.

Oh yeah that will happen in the way that the formula is structured. You can throw an IF statement around the existing formula to test for IF an attachment exists, then run the formula, otherwise return 0

Just test to make sure the Attachments field isn’t empty first.

IF(
Attachments=BLANK(), 0,
LEN(Test)-LEN(SUBSTITUTE(Test,",",""))+1
)

NOTE: I’m rewriting here the formula in the Test field in Victoria’s example, in which the Test field correctly counting attachments unless there aren’t any. The formula above fixes that.

William

2 Likes

@VictoriaPlummer and @WP_Rucksack yall rock! Thank you so much for the help, got it all working in my base.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.