Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Help with update record

Topic Labels: Automations
Solved
Jump to Solution
319 3
cancel
Showing results for 
Search instead for 
Did you mean: 
KanerH
4 - Data Explorer
4 - Data Explorer

Hi there,

It seems a simple thing but I can’t figure out what is wrong…

I have sales table and another table for totals by category , I try to make an automation to update the total sum with the new sale 

I tried to use find records but it returns a list and no matter what I do it tells me I’m giving wrong inputs…

if someone can help please 🙏 

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

You don't need an automation for that.

In your "Sales" table, you need to create a linked record field called "Category". That field needs to be linked to a brand new table that you create called "Categories".

Then, in your "Categories" table, Airtable will automatically create a new linked record field for you there that links back to your "Sales" table. Leave that field alone.

Next, in your "Categories" table, you would create a Rollup field based on the linked record field, and choose your "Total" field from the "Sales" Table. For the rollup formula, type in: SUM(values)

Then, you will have the Total for each category.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

You don't need an automation for that.

In your "Sales" table, you need to create a linked record field called "Category". That field needs to be linked to a brand new table that you create called "Categories".

Then, in your "Categories" table, Airtable will automatically create a new linked record field for you there that links back to your "Sales" table. Leave that field alone.

Next, in your "Categories" table, you would create a Rollup field based on the linked record field, and choose your "Total" field from the "Sales" Table. For the rollup formula, type in: SUM(values)

Then, you will have the Total for each category.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Does this look right?
Screenshot 2025-01-19 at 6.03.20 PM.png

Screenshot 2025-01-19 at 6.03.18 PM.png

Link to base

If so, you'll just need to create a link between your 'Sales' table and your 'Totals by Category' table, and then create a rollup field in 'Totals by Category' to sum the totals

To populate all your existing data, click on the field header for the existing 'Categories' field in 'Sales' so that the entire column is selected then hit CMD/CTRL + C.  Then, hit the field header for the linked field to the 'Totals by Category' table, then paste in the data.  This'll link everything up for you and if you go to 'Totals by Category' you should see all the data you want!

ScottWorld
18 - Pluto
18 - Pluto

Thank you for repeating the solution that I outlined above.

Also, he wouldn't need to copy and paste the old category field to the new category linked record field. For a quicker approach, he can just convert the existing category field to a linked record field, which will automatically create the new table for him.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld