Hi all !
Im currently creating a database for retrieve data from a questionnaire, in this database I have two tables, a “result” table where I store all the answers, and a “text” table where I store texts that will be displayed in relation to the responses obtained.
For example :
Part of my questionnaire is used to obtain a “self-confidence” score, depending on this score one of the 3 “self-confidence” texts will be displayed (low self-confidence, medium self-confidence, or hightself-confidence) .
To do this I first created a formula field “calculation text self-confidence” which allows me, depending on the score obtained, to obtain a value 1, 2 or 3 (this value is used to determine which of the 3 texts I want to display).
In my “results” table I created a “link to another table” field to the “texts” table where I retrieve all the records, then I created a lookup field in which I will look for the content of the text with the conditions that it be of the “self-confidence” type and that the value of “level” be equal to the value of the field “text calculation self-confidence” (1, 2 or 3, which allows me to display the content of the desired text according to the score obtained). And that’s where I’m stuck, I don’t know how to do it, or even if it’s possible.
To make it simple I would like the value highlighted in red of my first screenshoot to be the value of the field highlighted in red of my second screenshoot.
Which will give “and Niveau is 3” for the first record, and “and Niveau is 1” for the second record
So i would like to know if its possible and if yes, how to do it ?
Thanks in advance everyone !