Sharepoint lookup to populate form value

Question

I'm working on leave request SharePoint form. I have two lists :

• a first list (list1) will record the request of form submission and calculate the remaining leave
• then update the second list (list2) with the column emp_name,manager,balance leave.

I want to do is :

For example if an employee has a leave balance of 6 in list2 then when i open a new form and pick up the employee_name then the leave balance of 6 for that employee should show under "balance leave" . Is it possible to achieve it?

Field Type of remaining balance

Answer 1

The example below for your reference, when use enter the value in emp_name field and blur, the value will auto fill in the balance leave field.

Add the code below into script editor web part in new form page in list2.

<script src="https://code.jquery.com/jquery-1.12.4.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
    var listname = "list2";
    $("input[title='emp_name']").blur(function(){
        var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('" + listname + "')/items?$filter=emp_name eq '"+$(this).val()+"'";
        $.ajax({
            url: url,
            method: "GET",
            headers: { "Accept": "application/json; odata=verbose" },
            success: function (data) {
                if(data.d.results.length>0){
                    var item = data.d.results[0];
                    $("input[title='balance leave']").val(item.balance_x0020_leave);
                }
            },
            error: function (data) {
            }
        });
    }); 
});
</script>

If the emp_name field is a lookup field, we need use the code below.

<script src="https://code.jquery.com/jquery-1.12.4.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
    var listname = "list2";
    $("select[title='emp_name']").change(function(){
        var url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('" + listname + "')/items?$filter=emp_name eq '"+$(this).val()+"'";
        $.ajax({
            url: url,
            method: "GET",
            headers: { "Accept": "application/json; odata=verbose" },
            success: function (data) {
                if(data.d.results.length>0){
                    var item = data.d.results[0];
                    $("input[title='balance leave']").val(item.balance_x0020_leave);
                }
            },
            error: function (data) {
            }
        });
    }); 
});
</script>

Answer 2

You can reach that througt REST API. Try to get the Balance leave depending in the employee control with a rest api query. then store the result in a variable and play with it with rules.

Answer 3

I think you need to replace following line in LZ_MSFt code

$("input[title='balance leave']").val(item.balance_x0020_leave);

replace with:

$("input[title='balance leave']").val(item.Remaining_x0020_balance);