API Workflow to convert list of things in a field to records in a table - high workload usage

Need help
1

I am building a meal planning app. I have the following datatypes:

  1. Meal Plan Entry with fields like Day of the week, Recipe
  2. Recipe with fields like Name, Ingredients (list), Quantity (list)
  3. Shopping List with fields Ingredient, Quantity

Essentially, I want to get the ingredients for each recipe listed in the meal plan and consolidate (remove duplicates) and aggregate the quantities required for the week. While this is fairly easy in SQL, I am stuck in bubble and using backend workflows that are looping through each meal plan entry’s recipe, each recipe’s ingredient, checking if it exists and then adding a thing to the shopping list datatype. This is causing large workload usage.

Is there a simpler way of doing this? Thanks in advance!

1 Like
2

This topic was automatically closed after 70 days. New replies are no longer allowed.