Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 17, 2022 06:22 PM
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 !
Solved! Go to Solution.
Dec 20, 2022 07:37 AM
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
Dec 17, 2022 11:13 PM
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
Dec 18, 2022 11:16 AM
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.
Dec 18, 2022 02:23 PM
Hello, no there won't be many, 50 at most. Thank you for your answer.
Dec 18, 2022 03:36 PM
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
Dec 20, 2022 07:37 AM
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