Skip to content

Instantly share code, notes, and snippets.

@CubeYogi

CubeYogi/showing_record_summary_on_add_notes_field.js

Last active November 19, 2020 08:02
Show Gist options
  • Save CubeYogi/b3ca115182efb8cbc28d60278ccda7f9 to your computer and use it in GitHub Desktop.
Save CubeYogi/b3ca115182efb8cbc28d60278ccda7f9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
showing_record_summary_on_add_notes_field.js
if(input.Accession_Number != null)
{
table_style = "<html><head><style>table, th, td {border: 1px solid black;border-collapse:collapse;</style></head><body><table style="width:100%"><tr><th>Nursery Name</th><th>Action Date</th><th>Action Field</th><th>Qty</th><th>Size</th><th>Bench</th></tr>";
for each daily_log in Daily_Nursery_Log[ID == input.Accession_Number] sort by Action_Date desc range from 1 to 3
{
table_style += "<tr><td>"+daily_log.Nursery_Name+"</td><td>"+daily_log.Action_Date+"</td><td>"+daily_log.Action_field+"</td><td>"+daily_log.Number_Containers+"</td><td>"+daily_log.Container_Size+"</td><td>"+daily_log.Bench_Location+"</td></tr>";
}
input.Rec = table_style;
}
else
{
info "Accession_Number is empty";
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment