Add Rows with formula mapping and filter

1

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 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
image1030×416 22.4 KB

2

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

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!

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

  1. Coda Courses for video courses to build along with our experts
  2. Coda Guides for a library of guides to level up your Coda docs and skills
  3. The Gallery tab for inspiration and templates

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

Happy building!

3

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