Hello,
I’m totally new to appsheets and have basically no coding experience. I have a spreadsheet (google sheet) with 2 columns of data. One column (column A) with the name of an exercise and another column (Cloumn B) with a decimal value indicating MET value of the exercise. I want to build an app with the following fields:
Weight: User input number value
Exercise: A dropdown field allowing a single selection based on values from column A
METs: A “calculated” decimal value corresponding to the value of column B for the selected exercise from previous field. This would be a vlookup formula in a spreadsheet.
Minutes Performed: User input number value
Calories burned: A calculated field based on the following formula: Weight * METs * Minutes Performed * .008 = Calories Burned
I don’t understand how to make Appsheets create the dropdown field then populate the METs based on the second column. I also don’t understand how to do the user input fields. I read about virtual columns, but I’m not sure if that’s what I really need for the user input fields. Eventually, I think I would want it to create a log of burned calories for each user, but I’m ok with figuring that out later.
Any help anybody could give would be appreciated.