Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About CoachMan

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Mojave 10.14.6

Recent Profile Visitors

673 profile views
  1. I was advised on another thread to use the virtual list technique because I needed the categories (breakfast, am snack, lunch, etc) to show even if there are no foods in them (preferably without creating a blank record for each meal for each log date). That way the user can tap on the meal name to add foods to the meal. It's also extremely slow running all the calculations over the network, to recalculate calories and macronutrients each time a portion is incremented or unit of measure changed...so the virtual list has solved that issue. I've set all of that up already and it's working much
  2. I was able to populate the table with distinct foods via a looping script after loading the virtual list. It's a small data set, so it's plenty quick doing it this way. Still curious how to handle it via the ExecuteSQL function though if anyone wants to take a stab at it.
  3. I'm trying to populate a virtual list table using ExecuteSQL, to show the most recently logged foods by the current user. I need to show several fields (FoodID, food_name, portion, unit, calories, log_date, etc) but only want distinct values based on the FoodID field. For any duplicates, I want to show the most recent one. For example if the data set is: 1, apple, 1, ounce, 10, 2020-06-10 1, apple, 2, ounce, 20, 2020-06-09 2, orange, 1, piece, 30, 2020-06-11 I would want it to return: 1, apple, 1, ounce, 10, 2020-06-10 2, orange, 1, piece, 30, 2020-06-11
  4. Is there a way of keeping the keyboard enabled with a list view 'filter as you type' in FM Go? When it performs the find it disables the keyboard, and then of course it enables in on the 'go to field' step...so it pops up and down on each keystroke. I'd be okay using a portal instead if needed.
  5. There won't ever be two coaches modifying the same meal plan...I'll have it set up so the coaches who work for me can only modify their own clients' plans, foods, etc. They would need to make a copy of an existing food, meal plan, recipe, etc if they want to edit it...unless it's one they created themselves.
  6. I think that's how I have it set up now. The user (coach in this case) can choose to copy a meal plan and then edit, thus not making any changes to the original meal plan. Or they can edit the original meal plan (e.g., if they made a minor mistake, or just hadn't finished it yet). Generally when I make client-requested revisions to a meal plan, I copy it and edit vs just editing the original. My question is whether it's necessary/best practice to import the meal plan foods to a separate table for editing and then import them back to the original table (if user opts to save changes), or
  7. Not sure if my title makes sense or not :). I'm building a nutritionist meal planning program for use with my coaches/clients. Currently I have it set up so that if the user selects a meal plan, and then clicks 'edit', it imports the meal plan's foods into another table and then opens a card window for editing. Once they close the card window and select the 'save changes' option, it then imports the records back to the original table. This seems to be working fine, but it did require a lot of new table occurances (there are tables for foods, food weights (various units of measure/their gra
  8. That's perfect, thank you! It makes a lot more sense now that I see it in a list view. Would you say a virtual list makes sense (particularly in terms of speed) even if I decide not to worry about showing meals that don't contain any foods? The user will be adjusting portions of the foods, requiring filemaker to recalculate calories and macronutrients for the food, meal, and entire day. It doesn't need to pull any data from related tables to do this UNLESS they change the unit (grams, ounces, cups, etc). In that case, it would pull data from food_weight and food_nut_def tables to cal
  9. Thanks for the quick reply! Most of the info I found in virtual lists was related to portals, and I couldn't quite get my head around it. So I opted to just create a duplicate list view layout based off a table that just has 1 record for each meal name (8 records total), and a sort field. When the user selects a date to log their meals, it checks for existing logs for the date/user id, and if none, it goes to the duplicate layout...otherwise it loads the records in the original layout. Seems to be fast enough for my needs.
  10. I'm building a meal tracking app (similar to MyFitnessPal). The list view layout where the user views/edits the selected day's log has sub-summaries when sorted by meal name (breakfast, am snack, lunch, aft snack, dinner, etc), which appear above the body. In most of the meal tracking apps I've seen, these headings show whether the meal has foods inserted into it or not, which is the behavior I want for my app. Is there a way of achieving this in list view when the meal has no records (foods) in it? I don't like the idea of using portals since they won't expand/shrink to fit the data, and
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.