Sum up several columns into another column

[Schuller]

Is this possible...
I would like to have a text file in certain folders where I typically sum things up for planning, budgeting, forecasting, etc. where this text file would serve to populate the total values from the custom columns in those folders into the corresponding text file columns. At the moment I'm using a summing script but it would be great if throughout the course of the year(s) that the text file simply updates automatically as I add things without the need to hit the sum up scripted button. Kind of like an excel chart. I'm not looking open the text file to view the values but would like to have a quick glance at the list throughout the years.

[highend]

I'm not really getting it...

The text file should contain lines that allow custom columns to be populated and at the same time is updated (through ccs again?) to hold new data?

Post a few sample lines which info this file would contain and to know how / what would be summarized...

[Schuller]

Screenshot 2024-11-25 102817.jpg (533.18 KiB) Viewed 848 times

Given some more thought, I don't think it will work as the values in these custom columns are derived from the filename so it will probably have to be the filename of the text file that keeps changing too every time I go to that location. I'm basically just looking for an easy way to display the totals when I go those these locations without any clicking anything. Maybe its possible to accomplish this another way. I don't know.

[Schuller]

Screenshot 2024-11-25 104836.jpg (35.81 KiB) Viewed 847 times

[highend]

01. The naming pattern of these files is 100% reliable so a script can know in which position with which delimiter it'll find the necessary data?
02. Are these kind of files only in a specific part of your folder hierarchy or can this "composition of files" be found anywhere?
03. Is there a way to know (e.g. because they have a special name) if one of your folders does contain such a composition?
04. Are they always .pdf files?
05. Are there any other file types in those directories apart from the ones that are necessary for the summing up?

[Schuller]

01. The naming pattern of these files is 100% reliable so a script can know in which position with which delimiter it'll find the necessary data?

Yes, I intend to have the naming pattern for this particular set of files kept 100% reliable in terms of formatting but it sounds now to me that even if you are able to script this, it would be specific for those set of files that have the file name format that specific way? I have several other documents in different directories where the file name formatting differs but parts of the file name are also placed into custom columns where, at the moment, I sum them up with my scripted user button and so was hoping to achieve something universal in nature like the summing user button that works on any column and in any directory.

02. Are these kind of files only in a specific part of your folder hierarchy or can this "composition of files" be found anywhere?

Yes, they are in a specific part of the folder hierarchy and organized by folder and kept consistent. In the example provided, those .PDF files are in a 2024 folder. If you back up one level, you'll get a list of folders dated by year going back to 2009 with the same type .PDF's inside.

03. Is there a way to know (e.g. because they have a special name) if one of your folders does contain such a composition?

Yes, I believe by path location.

04. Are they always .pdf files?

Yes, the files to be summed will almost always be .pdf's but there may be cases that its some other format.

05. Are there any other file types in those directories apart from the ones that are necessary for the summing up?

Yes, there are other file types, as well as some other pdf's in those directories, however, they should not be summed and they have different file name formatting that is more conventional.

Just a thought here..
The summing script that I have on a user button, which you created for me a while back, works really well in any directory and with all columns, and it gives me options to select which columns to sum. I use this button daily to sum things then I manually jot things down from the popup, either onto paper, into my accounting program, sometimes into the comment column, and so on. Is it easier, or possible that when I do use this button to sum up things, that I could have an option from the pop to save that information into a text file where that data would then be extracted into the columns. I saw somewhere on the forum that someone was able to get recipe data(calories) in the content of a text file extracted into a custom columns. Perhaps this can be done that way too where the summed info is in the file content formatted a certain way to be extracted into custom columns, then the file name convention is irrelevant. I don't really care about the file name if the content of the file can be put into these custom columns accordingly.

[highend]

The summing script that I have on a user button, which you created for me a while back, works really well in any directory and with all columns, and it gives me options to select which columns to sum. I use this button daily to sum things then I manually jot things down from the popup, either onto paper, into my accounting program, sometimes into the comment column, and so on. Is it easier, or possible that when I do use this button to sum up things, that I could have an option from the pop to save that information into a text file where that data would then be extracted into the columns. I saw somewhere on the forum that someone was able to get recipe data(calories) in the content of a text file extracted into a custom columns. Perhaps this can be done that way too where the summed info is in the file content formatted a certain way to be extracted into custom columns, then the file name convention is irrelevant. I don't really care about the file name if the content of the file can be put into these custom columns accordingly.

How are the CCs currently populated, where do they get their data from?
Be absolutely precise here!

[Schuller]

They get there data from the filename

[highend]

I see.

Send me the real file names of your screenshot here (in a .txt file):
viewtopic.php?p=225521#p225521
Select all of those files, Ctrl + Shift + P
Paste them into the .txt file

Additionally all the cc definitions that are used in that screenshot, one .txt file for each
To get each of them individually:
Configuration | Information | Custom Columns
Double click one of them
Ctrl + right click on the "Clear" button -> Copy as Snippet

Zip all .txt files, upload it somewhere, send me the link via pm

I need enough test data to see if this can be done...

[Schuller]

Okay