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