# Add Rows with formula mapping and filter

**URL:** <https://connect.superhuman.com/t/add-rows-with-formula-mapping-and-filter/50547>\
**Category:** Ask the Community\
**Created:** [August 13, 2024, 3:44pm UTC](https://connect.superhuman.com/t/add-rows-with-formula-mapping-and-filter/50547 "2024-08-13T15:44:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joaquin\_Varela](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joaquin_varela/32/35419_2.png) [@Joaquin\_Varela](https://connect.superhuman.com/u/Joaquin_Varela)\
**Post date:** [August 13, 2024, 3:44pm UTC](https://connect.superhuman.com/t/add-rows-with-formula-mapping-and-filter/50547/1 "2024-08-13T15:44:58Z")

</div>

Hi everyone!

I’m seeking help from a Coda expert, as even ChatGPT couldn’t solve this issue.

I’m building a management system for a catering business that handles event food services.

Each event can choose from three different menus, and each menu has a defined proportion of food items listed in the `Menu_item` table. .

I’d like to create a formula that, when a button in the `events` table is clicked, adds a row for each item in the selected menu for that event in the `event_items` table.  
The quantity for each item is calculated based on the formula `event.Total_kgs * menu_item.proportion`

[Here](https://coda.io/d/_d6rs3m84veW/Backend_suW7y) is the link to the doc.

I managed to debug the formula to the point where the button is active, but when I click it, I receive the error message “unable to execute invalid action.”

Can someone help me understand what might be causing this error? Thanks a lot!

 ![image](https://global.discourse-cdn.com/coda1/original/3X/9/9/9987b3c3174f284a7399507ffa752576fa123a26.png)

---

<div class="post-metadata">

**Author:** ![Shaina\_Torgerson](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/shaina_torgerson/32/21147_2.png) [@Shaina\_Torgerson](https://connect.superhuman.com/u/Shaina_Torgerson)\
**Post date:** [August 16, 2024, 4:33pm UTC](https://connect.superhuman.com/t/add-rows-with-formula-mapping-and-filter/50547/2 "2024-08-16T16:33:48Z")

</div>

Hey @Joaquin_Varela , thanks for reaching out! For building help, our Experts Directory is the best resource for that. Our experts can be found here!: [Hire a Coda expert, connect with a Coda expert - Coda](https://coda.io/partners/hire-an-expert)

If you are looking for general Coda training, we host live weekly demos that I’d love to invite you to. You can reserve your spot [here](https://coda.io/resources/webinars)!

In addition, as you start to get more familiar with Coda, below are some resources you’ll find helpful:

1. [Coda Courses](https://coda.io/resources/courses) for video courses to build along with our experts
2. [Coda Guides](https://coda.io/resources/guides) for a library of guides to level up your Coda docs and skills
3. [The Gallery tab](https://coda.io/gallery) for inspiration and templates

Please let me know if there’s anything I can do to support you during your Coda journey!

Happy building!

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [November 14, 2024, 4:34pm UTC](https://connect.superhuman.com/t/add-rows-with-formula-mapping-and-filter/50547/3 "2024-11-14T16:34:37Z")

</div>

Closed on November 14, 2024, 4:34pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.