How to auto-populate a set of field with a given set of values upon creation of a change record.

Shwetha Shenoy · ‎10-14-2023

Hi Community, here is a use case I need to auto-populate a set of fields with a given set of values (like how we do it for standard change upon creation) but for a different change model.

Not using any kind of templates here, please suggest to me any other way that I could use to solve this use case.

Please help me resolve this use case.

Thanks in Advance.

Sandeep Rajput · ‎10-15-2023

Here is how your html should be used.

g_form.setValue('u_html','<p>&nbsp;</p> <p>&nbsp;</p> <table style="border-collapse: collapse; width: 100.071%; height: 366.383px; margin-left: auto; margin-right: auto;" border="1"> <tbody> <tr style="height: 63.7969px;"> <td style="width: 41.1224%; height: 63.7969px; text-align: center;" colspan="3"> <p style="text-align: center;"><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </strong></span></p> <p style="text-align: center;"><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>SOURCE</strong></span></p> </td> <td style="height: 63.7969px; width: 26.1365%; text-align: center;" colspan="2"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>&nbsp;</strong></span></p> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>DESTINATION</strong></span></p> </td> <td style="width: 66.2292%; text-align: center; height: 63.7969px;" colspan="4"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>&nbsp;</strong></span></p> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>KEY DETAIL</strong></span></p> </td> </tr> <tr style="height: 68.1953px; text-align: center;"> <td style="width: 12.429%; height: 68.1953px;"><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>Application</strong></span></td> <td style="width: 14.7728%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>Hostname</strong></span></p> </td> <td style="width: 13.9205%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>IP Address</strong></span></p> </td> <td style="width: 13.6364%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>Hostname</strong></span></p> </td> <td style="width: 12.5001%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>IP Address</strong></span></p> </td> <td style="width: 9.73017%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>TCP Ports</strong></span></p> </td> <td style="width: 11.0057%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>UDP Ports</strong></span></p> </td> <td style="height: 68.1953px; width: 45.4933%;" colspan="2"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>Traffic Direction</strong></span></p> </td> </tr> <tr style="height: 234.391px; text-align: center;"> <td style="width: 12.429%; height: 234.391px;">&nbsp;</td> <td style="width: 14.7728%; height: 234.391px;">&nbsp;</td> <td style="width: 13.9205%; height: 234.391px;">&nbsp;</td> <td style="width: 13.6364%; height: 234.391px;">&nbsp;</td> <td style="width: 12.5001%; height: 234.391px;">&nbsp;</td> <td style="width: 9.73017%; height: 234.391px;">&nbsp;</td> <td style="width: 11.0057%; height: 234.391px;">&nbsp;</td> <td style="height: 234.391px; width: 45.4933%;" colspan="2">&nbsp;</td> </tr> </tbody> </table>');

This how the end result looks.

View solution in original post

Sandeep Rajput · ‎10-15-2023

@Shwetha Shenoy Simply set the field using following code in client script.

g_form.setValue('u_html','<html> <style> table, th, td { border:1px solid black; } </style> <body> <h2>A basic HTML table</h2> <table style="width:100%"> <tr> <th>Company</th> <th>Contact</th> <th>Country</th> </tr> <tr> <td>Alfreds Futterkiste</td> <td>Maria Anders</td> <td>Germany</td> </tr> <tr> <td>Centro comercial Moctezuma</td> <td>Francisco Chang</td> <td>Mexico</td> </tr> </table> <p>To understand the example better, we have added borders to the table.</p> </body> </html>');

Hope this helps.

Shwetha Shenoy · ‎10-15-2023

Hi @Sandeep Rajput,

I tried your code it works nicely,

But my HTML source code is this :

<table style="border-collapse: collapse; width: 100.071%; height: 366.383px; margin-left: auto; margin-right: auto;" border="1">
<tbody>
<tr style="height: 63.7969px;">
<td style="width: 41.1224%; height: 63.7969px; text-align: center;" colspan="3">
                        
SOURCE
</td>
<td style="height: 63.7969px; width: 26.1365%; text-align: center;" colspan="2">
 
DESTINATION
</td>
<td style="width: 66.2292%; text-align: center; height: 63.7969px;" colspan="4">
 
KEY DETAIL
</td>
</tr>
<tr style="height: 68.1953px; text-align: center;">
<td style="width: 12.429%; height: 68.1953px;">Application</td>
<td style="width: 14.7728%; height: 68.1953px;">
Hostname
</td>
<td style="width: 13.9205%; height: 68.1953px;">
IP Address
</td>
<td style="width: 13.6364%; height: 68.1953px;">
Hostname
</td>
<td style="width: 12.5001%; height: 68.1953px;">
IP Address
</td>
<td style="width: 9.73017%; height: 68.1953px;">
TCP Ports
</td>
<td style="width: 11.0057%; height: 68.1953px;">
UDP Ports
</td>
<td style="height: 68.1953px; width: 45.4933%;" colspan="2">
Traffic Direction
</td>
</tr>
<tr style="height: 234.391px; text-align: center;">
<td style="width: 12.429%; height: 234.391px;"> </td>
<td style="width: 14.7728%; height: 234.391px;"> </td>
<td style="width: 13.9205%; height: 234.391px;"> </td>
<td style="width: 13.6364%; height: 234.391px;"> </td>
<td style="width: 12.5001%; height: 234.391px;"> </td>
<td style="width: 9.73017%; height: 234.391px;"> </td>
<td style="width: 11.0057%; height: 234.391px;"> </td>
<td style="height: 234.391px; width: 45.4933%;" colspan="2"> </td>
</tr>
</tbody>
</table>

But I am unable to get the table right using client script.

Thanks

Sandeep Rajput · ‎10-15-2023

Here is how your html should be used.

g_form.setValue('u_html','<p>&nbsp;</p> <p>&nbsp;</p> <table style="border-collapse: collapse; width: 100.071%; height: 366.383px; margin-left: auto; margin-right: auto;" border="1"> <tbody> <tr style="height: 63.7969px;"> <td style="width: 41.1224%; height: 63.7969px; text-align: center;" colspan="3"> <p style="text-align: center;"><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </strong></span></p> <p style="text-align: center;"><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>SOURCE</strong></span></p> </td> <td style="height: 63.7969px; width: 26.1365%; text-align: center;" colspan="2"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>&nbsp;</strong></span></p> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>DESTINATION</strong></span></p> </td> <td style="width: 66.2292%; text-align: center; height: 63.7969px;" colspan="4"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>&nbsp;</strong></span></p> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>KEY DETAIL</strong></span></p> </td> </tr> <tr style="height: 68.1953px; text-align: center;"> <td style="width: 12.429%; height: 68.1953px;"><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>Application</strong></span></td> <td style="width: 14.7728%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>Hostname</strong></span></p> </td> <td style="width: 13.9205%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>IP Address</strong></span></p> </td> <td style="width: 13.6364%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>Hostname</strong></span></p> </td> <td style="width: 12.5001%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>IP Address</strong></span></p> </td> <td style="width: 9.73017%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>TCP Ports</strong></span></p> </td> <td style="width: 11.0057%; height: 68.1953px;"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>UDP Ports</strong></span></p> </td> <td style="height: 68.1953px; width: 45.4933%;" colspan="2"> <p><span style="font-family: verdana, geneva; font-size: 8pt;"><strong>Traffic Direction</strong></span></p> </td> </tr> <tr style="height: 234.391px; text-align: center;"> <td style="width: 12.429%; height: 234.391px;">&nbsp;</td> <td style="width: 14.7728%; height: 234.391px;">&nbsp;</td> <td style="width: 13.9205%; height: 234.391px;">&nbsp;</td> <td style="width: 13.6364%; height: 234.391px;">&nbsp;</td> <td style="width: 12.5001%; height: 234.391px;">&nbsp;</td> <td style="width: 9.73017%; height: 234.391px;">&nbsp;</td> <td style="width: 11.0057%; height: 234.391px;">&nbsp;</td> <td style="height: 234.391px; width: 45.4933%;" colspan="2">&nbsp;</td> </tr> </tbody> </table>');

This how the end result looks.

Shwetha Shenoy · ‎10-15-2023

Thank you so much @Sandeep Rajput

This works as required.

Danish Bhairag2 · ‎10-14-2023

Hi @Shwetha Shenoy ,

Can u try removing the condition from when to run & keep an if condition in ur script itself like if current.model is something update the value as something.

Thanks,

Danish