1 ACCEPTED SOLUTION
Hi ggg,
I am not sure about the above post, but I have used the below to achieve a similar requirement which would add a button 'Add Row' on top of the Embedded List and a drop down next to the button to insert multiple rows at the same time, something similar to below screen shot.
My use case may slightly differ from yours in the sense I am not doing any validations but instead inserting rows with some calculated values based on some field values on the parent form. I basically created a UI Formatter and added it to the form right above the embedded list.
Below is the script inside the macro used in the formatter
<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
<script>
var checkExist = setInterval(function() {
if ($j("table[list_name='parent_table_name.embedded_list_table_name.parent_reference_field_name'] tr.list_add").length) {
$j("table[list_name='parent_table_name.embedded_list_table_name.parent_reference_field_name'] tr.list_add").hide();
clearInterval(checkExist);
}
}, 1000);
function insertRows(){
if(!g_form.isNewRecord()){
//Basically do your server side thing here, like inserting rows into the emebdded list with pre-set values or whatever your use case is
//var ga = new GlideAjax('scriptIncludeName');
//ga.addParam('sysparm_name','functionNameInScriptInclude');
//ga.addParam('parm1',g_form.getUniqueValue());
//ga.addParam('rows',gel('rowselector').value);
//ga.getXML(checkRowsInserted);
}
else{
//If record is a new record - prompt the user to save the record
alert('Record must be saved before adding New Rows.');
}
}
function checkRowsInserted(response){
var resp = response.responseXML.documentElement.getAttribute("answer");
if(resp == "rowsInserted"){
try {
var elementLookup = $$('div.tabs2_list');
var listName = "Embedded List Name Here";
for (i = 0; i != elementLookup.length; i++) {
if (elementLookup[i].innerHTML.indexOf(listName) != -1) {
var listHTML = elementLookup[i].id.split('_');
var listID = listHTML[0];
nowRefresh(listID);
}
}
}
catch (err) {
//alert(err.message);
}
}
}
function nowRefresh(id) {
//Refresh the EmbeddedList
GlideList2.get(id).refresh('');
//Hide the Add Row Functionality after inserting row
var checkExist = setInterval(function() {
if ($j("table[list_name='parent_table_name.embedded_list_table_name.parent_reference_field_name'] tr.list_add").length) {
$j("table[list_name='parent_table_name.embedded_list_table_name.parent_reference_field_name'] tr.list_add").hide();
clearInterval(checkExist);
}
}, 1000);
}
</script>
<style>
#rowselector{
background-color: #fff;
background-image: none;
border: 1px solid #bdc0c4;
border-radius: 3px;
height:25px;
width: 75px;
}
#insertechrow{
box-sizing: border-box;
font: inherit;
overflow: visible;
text-transform: none;
font-family: inherit;
font-size: 13px;
line-height: 1.42857;
font-weight: normal;
text-align: center;
vertical-align: middle;
cursor: pointer;
background-image: none;
border: 1px solid transparent;
white-space: nowrap;
display: inline-block;
color: #fff;
background-color: #278efc;
border-color: #0368d4;
padding: 2px 4px;
margin: 1px 4px;
border-radius: 3px;
}
</style>
<table width="100%">
<!-- -->
<tr class="list_row list_even embedded list_row_compact">
<td>
<span>
<input id="insertechrow" type="button" value="AddRows" onClick="insertRows()"/>
<select id="rowselector">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
</span>
</td>
</tr>
</table>
</j:jelly>
I hope this helps you ggg.
