Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About drose0321

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

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

  1. It's complicated. Because we are a public interest law firm, many of our clients don't pay any fee. The point of the software is to let clients determine if they can file themselves (and then produce the necessary forms) or if they require assistance from us. The lawyers here are uncomfortable (from a liability and legal ethics standpoint) with storing "non-client" data on a server that we own or control. So, this is the compromise solution.
  2. Because this will ultimately be a runtime app distributed to our clients (we are a public interest law firm) and we can't count on even a significant portion having word. We need a self-contained solution...
  3. I'd love to do it as a merge with Word, but unfortunately, that is not an option here. Thanks!
  4. Ok. Thanks. I basically am doing your first option. Filemaker is a requirement for this project and when the only tool you have is a hammer...
  5. Thanks. I'd like to see how you handle the data type control and branching. If I understood the video,it looks like you end up with all the answers in a table with generic fields, Question/Answer/Number - So I still need to parse the data by question number to extract the answers to fill in the forms (and make the calculations) that I need as my output. Again, to me it seems that the only way to do this is is to look at each record in the questions table, set a variable based on it's record number and then, optionally (although I opt to do it) use the variables to set fields (one filed for e
  6. I'm sorry. I'm doing a terrible job explaining this project. It's not a generic questionnaire , the end product is a medical/legal document with boilerplate and specific answers in specific places and calculated results (based on other specific answers) in other places. So, it's like a questionnaire in that the user answers lots of questions, but that's just to gather the specific information needed to generate the documents. Then we need to parse the answers to extract the specific information we need. Does that make it clearer?
  7. Nobody has yet to propose a different solution. As you'll see from my post above, I need to extract information from the generic answer fields and use it to determine the output based on various answers to specific questions, I can do it with variables, but that's just one step less than sticking the values into a table and I have to re-run the script to acquire the variables every time the application is reopened, so a table seems like a better choice.
  8. Thanks. I like the idea of using a navigation field in the questions table, it keeps the logic closer to the questions and should make it easier to change. I didn't build a precisely formatted form for the sample, the idea I was trying to get across is that specific information needs to be extracted from specific questions and displayed in a specific context. Yes, the formulation of one answer does depend on the answers given to other questions, thus my current solution (and the one I was looking for an alternative to, although I was unclear about it), which is to build a table
  9. Ok Let's try this again. Here is a very basic sample file - it has a questions/answers/number table and a control table and a bit of the question flow logic and an idea of the kind of output that is needed. I guess I wasn't explaining things properly. You can see that I'm using variables to parse out the individual questions so that I can set them into the kind of output format I need. If anyone has a better idea for how to do this I'd love to hear it. As you can imagine this is pretty cumbersome with many questions. example.fmp12
  10. You people are surprisingly unfriendly. I'm trying to ask reasonable questions. Unfortunately, I can't upload a sample file because the intellectual property belongs to my boss. I can't use a report, I need a precisely formatted form as the end result. I have a solution that works, but is cumbersome and I just wondered if anybody had any suggestions for a better way to do it, so far I haven't seen anything. Really, only Comment has even tried to be helpful, the rest of you just seem to be killing time making unnecessary comments.
  11. I can't think of any other way to do it. The user answers question # 1 "Yes, I went to Paris" and 170 other questions each in it's generic question/Answer/number table. Then later I want to print a form (Name - from question # 8) and Paris (from question # 1) and wedding date (from question number 73) and all the other questions. So how do I get them into my form? I'm going to the questions table and searching for question # 8 and filling the $Name variable (so I can put it where it belongs) and etc. I can't think of any other way to fill a complex form (with many logical decision points
  12. Thanks. I didn't think there was a better way to do it, but I wanted to see what other people thought. I think I'll add a section to the script to go to the next question that captures the answer in a variable and enters it into a table with all the fields as the user goes along. I do want to end up with all the answers in a table for use in reporting and forms generation.
  13. The flow is controlled means, for example, if question 1 is "Have you ever been to Paris?" And the answer is "no", rather than show question 2 (which is "Did you go to the Eiffel Tower?") the next question the user sees will be question 6 (which has nothing to do with Paris). This is a single user application so the questions and answers are in a single table (rather than a one-to-one related table). It just seems cumbersome doing it like this, collecting all the questions in generic fields and then, later, parsing them out into fields or variables to be able to use the data in forms or rep
  14. I'm designing an application in which the user has to answer lots of questions (about 180). I want to show the user just one question at a time and control the flow based on prior answers. My current solution is to use a table with generic fields (e.g. Question, Answer, Number) and then use a related command table to move from question to question by changing the number of the question. This works great to present the questions to the user and collect their answers, the problem is that since the fields are generic when I later want to use the data I have to parse it out by, for example, goi
  • Create New...

Important Information

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