data.reference = document.getElementById(`name${0}`).value;
            data.email_ref = document.getElementById(`email${0}`).value;
            data.explaination =             document.getElementById(`explaination${0}`).value;

            data.reference2 = document.getElementById(`name${1}`).value
            data.email_ref2 = document.getElementById(`email${1}`).value
            data.explaination2 = document.getElementById(`explaination${1}`).value

            data.reference3 = document.getElementById(`name${2}`).value
            data.email_ref3 = document.getElementById(`email${2}`).value
            data.explaination3 = document.getElementById(`explaination${2}`).value

            data.reference4 = document.getElementById(`name${3}`).value
            data.email_ref4 = document.getElementById(`email${3}`).value
            data.explaination4 = document.getElementById(`explaination${3}`).value

            data.reference5 = document.getElementById(`name${4}`).value;
            data.email_ref5 = document.getElementById(`email${4}`).value;
            data.explaination5 = document.getElementById(`explaination${4}`).value;

            data.reference6 = document.getElementById(`name${5}`).value;
            data.email_ref6 = document.getElementById(`email${5}`).value;
            data.explaination6 = document.getElementById(`explaination${5}`).value;

            data.reference7 = document.getElementById(`name${6}`).value;
            data.email_ref7 = document.getElementById(`email${6}`).value;
            data.explaination7 = document.getElementById(`explaination${6}`).value;

            data.reference8 = document.getElementById(`name${7}`).value;
            data.email_ref8 = document.getElementById(`email${7}`).value;
            data.explaination8 = document.getElementById(`explaination${7}`).value;

            data.reference9 = document.getElementById(`name${8}`).value;
            data.email_ref9 = document.getElementById(`email${8}`).value;
            data.explaination9 = document.getElementById(`explaination${8}`).value;

            data.reference10 = document.getElementById(`name${9}`).value;
            data.email_ref10 = document.getElementById(`email${9}`).value;
            data.explaination10 = document.getElementById(`explaination${9}`).value;

            data.reference11 = document.getElementById(`name${10}`).value;
            data.email_ref11 = document.getElementById(`email${10}`).value;
            data.explaination11 = document.getElementById(`explaination${10}`).value;

            data.reference12 = document.getElementById(`name${11}`).value;
            data.email_ref12 = document.getElementById(`email${11}`).value;
            data.explaination12 = document.getElementById(`explaination${11}`).value;

            data.reference13 = document.getElementById(`name${12}`).value;
            data.email_ref13 = document.getElementById(`email${12}`).value;
            data.explaination13 = document.getElementById(`explaination${12}`).value;

function goSubmit(){
    var flag = 0
    var element = document.getElementById('submit_id');
    var name = element.querySelector('#Signature').value
    var date = element.querySelector("#date").value

    if(!name){
        M.toast({html: 'Name required!'})
        flag = 1
    }
    if(flag)
        return
    {//submit
        var data = {}
        data.email = email_first
        data.candidate_code = candidate_code
        data.date = date
        data.signature = name


        for(let i = 0 ; i <= numbers; i ++){
            var number =  i + 1
            var name_property = 'name of reference ' + number
            var email_property = 'email of reference ' + number
            var explaination_property = 'explaination ' + number
            data[name_property] = names[i]
            data[email_property] = emails[i]
            data[explaination_property] = explainations[i]

            data.reference = names[i];
            data.email_ref = emails[i];
            data.explaination = explainations[i];

        }

        google.script.run.appendData(data);

    }
}