I’m working on building a meal planning app. I have a working prototype built in Airtable, which relies heavily on formulas. However, it’s not user friendly enough for my clients, so I’m trying Adalo.
The problem is, I have no idea how to handle these complex formulas in Adalo in a user friendly way.
In Airtable, I have a Targets table. This is basically a list of weeks. Fill in the “Current Weight” field, the “Goal” field, and the “# of meals per day” field, and airtable uses the formulas I’ve set up to determine the goal daily calories, proteins, carbs, and fats (Each in their own field, each field using a formula).
Then I have a Meal Plan table. All I do here is select a “Protein Source”, a “Carb Source”, and “Fat Source”. Each of these is linked to the Ingredients table.
When I fill these in, Airtable uses the formulas and shows the exact quantities of each needed to hit the goals set for calories and other nutrients.
The only real manual work is creating the appropriate number of records for each day. (If # of meals per day is 3, I need to manually create 3 records per day in Airtable)
In Adalo, I can get the meal created, but I can’t figure out how to get the quantities for each ingredient to scale to the correct amount to hit the targets set for each week.
I hope this isn’t too complicated, but even if it is, what are the best practices for doing complex calculations with an app like Adalo?