Retrieve the sum of the columns

[Cyrille_Maurice]

Hello everyone, I would like to have the sum of each column of Table 1 in a row of Table 2. My problem is that on table 2 I did a rollup and a link, so I have to add the clients one by one in the Clients column. 
Is there a solution so that the Customer column fills automatically when I add a customer in table 1? 
The ultimate goal of my question is simply to be able to retrieve the sum of the columns Achats - Sous traitants - Salaires Flo - Entrée of Table 1 to be able to make a percentage in an interface. 

I hope I've been clear enough for you to help me 🙂
Thanks to all of you !

[TheTimeSavingCo]

Hi Cyrille, you can do this via an automation
1. In Table 2, in the `Name` value for the first record, type in "Helper"
    - I would also suggest just deleting the two other records that aren't in use to keep things clean
2. Create an automation with the trigger "When record created" in Table 1
3. For the automation, give it an "Update Record" action to update the linked field to Table 2 with the text 'Helper'

This should do what you're looking for I believe

[kuovonne]

I call the technique that you are using having a "Control Record" in a "Control Table". 

Note that if you plan on having hundreds or thousands of records in [Table 1], I don't recommend this method of linking all records to single control record, as it can slow down your base.

[Cyrille_Maurice]

Hello, no there won't be many, 50 at most. Thank you for your answer.

[Cyrille_Maurice]

Hello and thank you for your solution. I have created the automation with the trigger "When record created" in Table 1.
Then I am not sure about the second part. I attach a screenshot because I have an error.
Also when you say that I should delete the two other records you mean which ones?


Thank you very much for your precious help

[TheTimeSavingCo · Accepted solution]

In the first record of `Table 2`, type in the text "Helper"

In your "Update record" automation, the table value should be `Table 1`, the record ID should the ID of the triggering record, and it should update the field `Table 2` with the text "Helper"

If you provide an edit link to your base I can do it for you real quick