Hi, everyone!
I’m building a fitness app and need some help creating a formula that depends on the user’s gender.
I want to calculate and display the Basal Metabolic Rate (BMR) after the user completes the form on the first screen. The formula changes based on gender (e.g., different calculations for male and female users).
Here’s how I’ve structured it:
- On the first screen, the user fills out a form that creates a new User Profile.
- I’ve tried setting up a formula that creates the BMR only when the gender is “Feminino” (Female), but it’s not working as expected.
- I’m working with three collections: Users (where BMR is stored), Gender, and User Profile.
Does anyone know the best way to set this up so the formula can check the user’s gender and apply the correct BMR calculation?
Thanks in advance! 
