auralsculptor

Hi I would REALLY appreciate your FM solution, as this is something I've tried to build a few times and struggled with the basic relationships between tables I think I'm probably skilled enough to de-construct but not to build from scratch. Happy to repost my modifications as a starter for others Colin

Mr Vodka, much progress has been made but somehow between yesterday and today the script seems to have broken ... It should create a new survey (from the new survey layout) and populate the portals with the correct questions from the user-responses table. I can not see what has happened ... CPI_Database_EG.fp7.zip

No, the field to be summed and the "if" field form part to the same record ... I have attached the file conditional_calc.fp7.zip

Apologies for double posting - its getting difficult to figure which forum area to post under ...

OK The structure is making sense now, but I need to create a conditional sum of four fields but only if a related field has a specific value. Kind of like a sum on a found set, without the "find". I would have several of these fields for various values of the related field The logic works like this sum (field1; field2; field3) if (tableA::fieldX = "1") I found a "SumConditionalFields" custom function, but could not adapt it to my needs ....

I am trying to create a custom function or calculation to no avail, Please help me! a conditional sum of four fields but only if a related field has a specific value. Kind of like a sum on a found set, without the "find". I would have several of these fields for various values of the related field The logic works like this sum (field1; field2; field3) if (tableA::fieldX = "1") I found a "SumConditionalFields" custom function, but could not adapt it to my needs ....

Thanks, I think I did not explain well I am trying to create a custom function that will do this to no avail so far I need a "conditional sum" of four fields but only if a related field has a specific value. Kind of like a sum on a found set, without the "find". I would have several of these fields for various values of the related field The logic works like this sum (field1; field2; field3) if (tableA::fieldX = "1") I found a "SumConditionalFields" custom function, but could not adapt it to my needs ....

I need to sum values from a field (A) based on the value of another field in a different table (X). I can do this by "finding" X=1, sum A but I want this in a calculation. In fact I need to show three values in one place if X=1, Sum A if X=2, sum A if X=3, sum A can someone show me a calculation that will do this?

Thanks OK I'm going to look at this tomorrow (australian time) what you say makes sense. expect more posts this time tomorrow!

At this stage there is just the 3 sets (60 x 3), but I'd like to keep it open to an additional survey to be added at a later date

The file I uploaded was adapted from mr-vodka's upload, which displays the questions really nicely but is only suitable for a single set of questions. I am not wanting to duplicate the questions, but the format. I'll explain more specifically. each Subject will complete 3 sets of 60 questions, Which I would like to deliver one after the other in a single session, (page 1, page 2, page 3 - 3 layouts of the Subject record showing a different portal???) These measure different things and are assessed seperately. Their data must also be accessable seperately for analysis - hence the need for multiple tables (for each set of questions and their responses. Each set of answers must remain indentifiable to the Subject.

OK. Yes the current Survey's table really refers to subjects, and the Questions table contains the questions for multiple subjects. The upload is the halfway house when I realized that I should be able to do multiple tests for each subject and have them under a subject's record. The tricky bit for me is duplicating (triplicating?)the questions and answers tables and getting the relationship and the scripting right to make them come up on a portal as the first one does...

OK got this working nicely so far. The next step for me is that there are in fact 3 surveys to be completed by each participant, so I need to somehow make the "participant" the primary key to keep the data linked to the person. I'd like the script to generate the three surveys in portals on the same layout, I guess I need three import calls??? CPI_Database_EG.fp7.zip

Thanks so much. This is exactly what I needed to get my head around the ID relationships.

I have seen references to this but really need a bit of a startup. I am developing a survey with radio button responses eg yes, no maybe I need to score these responses, (which vary - some questions yes is worth 1, some its worth 3) and then sum the scores I have seen postings referring to 3 tables for survey, questions and answers but don't understand how to relate these. If someone could post a basic structure, I will be able to learn from it