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. drose0321

    Table with many fields or table with generic field?

    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. drose0321

    Table with many fields or table with generic field?

    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. drose0321

    Table with many fields or table with generic field?

    I'd love to do it as a merge with Word, but unfortunately, that is not an option here. Thanks!
  4. drose0321

    Table with many fields or table with generic field?

    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. drose0321

    Table with many fields or table with generic field?

    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 every question) that I can then use to create the legal/medical document (with specific answers to specific questions in specific places and various calculations based on specific answers) that I need in the end.
  6. drose0321

    Table with many fields or table with generic field?

    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. drose0321

    Table with many fields or table with generic field?

    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. drose0321

    Table with many fields or table with generic field?

    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 which does, in fact, have one field for each question, which I populate with a script that looks at each record in the questions table and, based on it's number, sets a variable and then the proper field in the table with one field for each question. It's cumbersome, but it let's me write the final output with considerations like: If number of children is greater than 3 and your share of expected health care costs is greater than 40%, then an amount no greater than 25% of Adjusted Gross Income (where the bold represents fields in the table with 180 fields).
  9. drose0321

    Table with many fields or table with generic field?

    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. drose0321

    Table with many fields or table with generic field?

    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. drose0321

    Table with many fields or table with generic field?

    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 (e.g. we don't print the "France" part at all if they don't go to France).
  12. drose0321

    Table with many fields or table with generic field?

    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. drose0321

    Table with many fields or table with generic field?

    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 reports and I wonder if I could do something similar using a table with lots of fields (e.g. a field for "Been to Paris" and a field for "Eiffel Tower - Y/N and basically 180 fields). The question is, is there a reasonable way, with that setup to control the way the user sees the questions?
  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, going to the questions table, look for the question number that corresponds to the user's first name and then add that to a variable and etc. I wonder if there is a better way to handle this. Am I missing something obvious? Thanks!

Important Information

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