Display Multiple Fields In A Lookup

[OKProgram]

Is there a way to display multiple fields in a Lookup?  My DataPage adds records to an Activity Log.  Some activities are related to a record in the Students table, some are not.  I would like to have a Lookup Table for the Student_ID field that displays First_Name and Last_Name from the Students table, but the value for the field is Student_ID. The field can also be left blank.

[OKProgram]

Found this script worked:

 

<SCRIPT LANGUAGE="JavaScript">

 

function concatenate()

{

var first_name = document.getElementById("InsertRecordFirst_Name").value;

var last_name = document.getElementById("InsertRecordLast_Name").value;

 

var full_name = first_name + " " + last_name;

 

document.getElementById("InsertRecordFull_Name").value = full_name;

 

}

 

document.getElementById("caspioform").onsubmit=concatenate;

</SCRIPT>

[aam82]

yes, first add a pre-concatenated field to your Students table. Going forward, use hidden fields and javascript to concatenate on submission. Use this as a guide for the needed javascript. 

http://howto.caspio.com/tech-tips-and-articles/common-customizations/separate-input-fields-for-datetime-parts/

 

 

Next, make a dropdown on the Students table, filtered by ID, Display as First Last, Value as ID.

[OKProgram]

Having trouble with the javascript.  Would you mind reviewing? My target field is named Full_Name. Not sure how to pass parameters.

 

<script>

document.getElementById('Submit').onmouseover = function(){

var first_name =

document.getElementById('cbParamVirtual1').value;

var last_name = 

document.getElementById('cbParamVirtual2').value;

document.getElementById('InsertRecordFull_Name').value = first_name + " " + last_name;

};

</script>