Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About andersmnystrom

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Sierra 10.13.6

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks for your reply! I think I have arranged how questions are created and answered so now I concentrate on how the answers should be aggregated, presented and analysed. I am reading about and trying to learn SQL, the web-viewer and java-charting as I find the built-in chart-function to be somewhat restrictive.
  2. Not that I have any right to expect an answer here but I was still a bit curious if you had time to check the file and if you had any input?
  3. I'm not entirely clear on how the information will be used, but I imagine that you should be able to follow the selected answers on a line chart over time together with a trend line, perhaps on a dashboard. Another part of the app will track all medicine and food that patients gets. It would be interesting if you could see any changes in the perceived health/mood adjacent to changes of the medication or diet. Or conversely, if you see shifts in the patient's perceived health/mood, one could examine if, before that, any changes were made to the medication, diet or otherwise.
  4. Thank you! I will keep this structure the with your suggested changes. Im very greatfull for all the input you can give me!
  5. Since the file contains quite a lot of sensitive information about a person, I do not want to post it all. But I removed everything except the survey-function and attached it here. Since this part is completely under development, it does not contain any actual data. The questions are, for example, only random simplifications etc. When answering the questions in the original file, you press a button bar with three buttons in it (Morg = morning, Midd = mid-day, Evening = evening). The button bar is there placed in a type of calendar layout, but here I have moved it to the layout “Create / administer Surveys”. The buttons are formatted in a way that should show if you answered one of the surveys or not but I’m unsure if it works now that I moved them. The language of the file is really Swedish but I have tried to translate what is important to English. Survey_part.fmp12
  6. Thank you for your answers. Some of the writing goes over my head, but I try to take in as much as I can. Perhaps I should mention that this is a "hobby project" where I try to make this app for a friend whose child is multi severely multi-disabled. Hopefully it will support them when they take care for her. I feel that the most important thing regarding this function is to get as much useful data as possible that then can be aggregated, analysed and followed up in different ways. That is, like you first mention in the top of your answer. Do I have a good basic structure for it now or is it something that should be changed or added? I'm a little unsure what you mean by "Survey Template Structure". Currently, one answer the questions on a layout based on the SurveyMoment table. It is controlled by a script that has Survey_ID as a parameter. The script then creates new response in a loop where the responses gets connected to the right survey questions.
  7. I have worked some more on this and believe that the structure I have arrived at isn’t optimal. I'll try to describe the function I’m building a little more. The idea is that the patient should answer a number of questions about their health a number of times a day. How many times a day and the number of questions should be possible to vary. An example: A patient should answer a couple of questions three times a day. Once in the morning, once in the middle of the day and once in the evening. Some questions will be used on each occasion, while some questions are used one or two times per day. Simplified examples of the questions are 1. How does the stomach feel (answer 1-10 where 1 = Very bad and 10 = Very good). This question is asked both morning, mid-day and evening 2. How have you slept this night? (answer 1-10 where 1 = Very bad and 10 = Very good). This question is asked every morning. However, I am afraid that I have made the structure overly complicated. I attach a picture of the tables that are included in the function and how they are connected. The tables are as follows: Questions: one record is a question. It also includes fields as “Type of question” etc. Survey: my idea is that a survey is a collection of a number of questions. It contains fields as “Description” and “Type of survey”. A question should be able to belong to different surveys. SurveyQuestions: acts as a join table between questions and a survey. Answer: one record is an answer to a survey question SurveyMoment: a record here represents the time that a survey and its questions is answered, i.e. when the answers are given. Everything feels exaggerated as said. Is there anyone who has a suggestion for a better solution. Right now, I feel that the SurveyMoment-table is completely unnecessary. The original idea was to be able to tie all the answers to a survey to the same exact time, but it can be solved in other ways. It feels like my head does not work at the moment so I appreciate all the help and tips you can give me!
  8. I am in the process of creating an app that will be a support for assistants to severely ill patients. The handling of medication, food, etc. One function should be the opportunity to track how the user is feeling and different health indicators. The idea is that one or more times per day you will enter how the person is feeling on a scale of 1-5 or 1-10. What one chooses to track should be able to vary from user to user. It can be things like sleep, stomach functions, epileptic seizures, etc. The idea is also that one should be able to follow the development of these indicators in some form of dashboard. How would you structure a function like this? I have come a bit on my way with other part of the app, but when it comes to this part, it stands completely still for some reason. English is not my first language so I hope it is possible to understand what I mean, if not, please ask!
  • Create New...

Important Information

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