Building surveys - concatenate field values

LabKey Support Forum (Inactive)
Building surveys - concatenate field values simonm  2016-02-11 07:58
Status: Closed
 
Hi Jon,

Thanks for your response, and for the link to the example of skip logic in the documentation. I'll take another look at it.


Regarding my question on concatenating values in a survey to fill the primary key field, here is some more information:

I need to be able to locate and identify records after they have been entered using a survey, but the Surveys webpart will only display a single field containing identifying information from a record - either the Label field or, if you customize it, the user-defined primary key.

The date I am entering is uniquely identified through a combination of three pieces of data - the Patient ID, the Visit, and the Sample.

I therefore need to concatenate these three pieces of data into a single field to display it - and that field must be either the Label or the user-defined Primary Key.

So for example if the Patient was number 1, the visit was day 3 and the sample taken was blood, the data would be: PatientID = 01, Visit = D3 and Sample = PB, and the user will enter these three values in a survey form. The desired value for the field displayed (either the Label or the user-defined PK) would therefore be 01_D3_PB.

My question: is it possible to write the Survey form in such a manner as to automatically populate a field with this concatenated string once the user has entered these three values?

Hope this helps,

Simon