Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 21, 2024 02:52 AM
Hello community,
I'd like to use a field from a different table in a formula.
How can I do this ?
--
I have a table with a list of attending people to a specific event and how much they paid.
I have a table with a list of the different events and I want to display the total payments received.
Marine
Aug 21, 2024 03:01 AM
Aug 21, 2024 03:03 AM
Hello Marine,
You can do that by adding a rollup field in your Events table.
First step, if not done yet, is to link "Attendees" table to Events Table:
Field "Events" is a linked field to table Events:
You then add a rollup field in table Events:
To get the following result:
Regards,
Pascal
Aug 21, 2024 03:04 AM
Sorry,
I started writting my answer before Adam posted his answer.
Do not consider my answer.
Regards,
Pascal
Aug 21, 2024 03:55 AM
@MarineSoratoAh, please consider Pascal's answer; his is clearer than mine and includes a step by step process of how to create the rollup field
@Pascal_Gallais-Hahaha I've done this a couple of times too, sorry about that!