Hi everyone! first time posting here, I’ve read many posts already and they have been very useful but I need guidance about this issue.
I’m creating an app that makes a nutritional plan according to the user, they send their details through a form and can edit whenever they want.
I have a sheet that calculates their caloric needs and according to that needs creates a plan to lose weight, maintain or gain weight.
Problem is: through the google sheet I’ve made it so far using many IFS formulas (choosing either to lose weight, gain weight, maintain and the nutritional plan they want -there are three kinds-) on top of that in regards to which week the user is in (plans last 8 weeks), the app through another big big IFS decides which image to show.
I don’t know if it’s because of connection lag or too many calcs to resolve before the apps shows results but the user feeling is terrible, it takes about 10s to update the data and maybe more than a minute to show the image. I started doing with math columns (which show data instantly) via data editor but I need sooo many columns that I have the feeling that this must have a better solution. What do you guys think?
Not so many but the ones I have are very long formulas, something like:
IF gender = “male” AND activity level = “loe” AND goal = “lose weight” AND calories needed are <2000 AND <2500 AND diet = “low carb” then X
And so on for the 2 choices for male/female, caloric ranges from 1250 to 3750 every 500cals, 3 kinds of diets, 3 types of goals, 3 activity levels, 8 weeks… one more similar formula to choose one image or another… quite messy, formula is not exactly like that of course but I hope you can get yourself an idea!
I have just tested it. I would say its flow is very well organized and it generated pretty quick. As you have mentioned you’re currently using Glide’s Math column for this?
I don’t think speed is an issue anymore, at least from my experience. How many Math columns are you using to achieve this?
Did it? I haven’t changed anything yet, I have math columns for the starting values of carbs protein and fats, the rest comes from the sheet.
Sheet calculates the total calories, then math columns for the partitioning and sheet again to choose proper values according to the user.
The best way to speed up any app is to use Glide data columns rather than spreadsheet formulas. Spreadsheet formulas = lag. Data columns = instant gratification