Re: A way to create a text field of all the sub-folders that an item is in?

You could try the following rule in the Categories folder:

++:!F:IFF([Name1], 'Name1, ', '') + IFF([Name2],  'Name2, ',  '') + IFF([Name3],  'Name3, ',  ''):

It’s just a series of IFF operators, one for each of the subfolders you wish to track. The outcomes of the IFFs are glued together by + signs.
Flag ! means to update the result each time there is a change.



From: mailto:[email protected] 
Sent: Friday, January 12, 2018 15:59
To: [email protected] 
Subject: [eccopro] A way to create a text field of all the sub-folders that an item is in?
  
Knowledgeable help on this would be much apprciated

I need to create a text folder/column that concatenates all the 
sub folders that an item is in. As an example I have something 
like the following folder structure

Categories (text)
Name1 (check mark)
Name2 (check mark)
Name3 (check mark)

So for an item that is in Name1 and Name3 I want the 
Categories column to show "Name1, Name3". For another item 
that is in Name2 and Name3 Categories would show "Name2, 
Name3"

Is there a rule that would do this? There's no way to use the 
'Column Properties/Sub-folders that Contain Item' as the values 
are not accessible as text.

Many thanks in advance,
David

---------- AllinOneFilms.com ---------