Create Static Table in a Form in Zoho Creator

year = input.Select_current_year_CY.getPrefix("-");

nextyear = input.Select_current_year_CY.getSuffix("-");

Assigning Values to in the Input Fields 

input.Past_1 = (year.toNumber() - 2) + "-" + (nextyear.toNumber() - 2);

input.Past_2 = (year.toNumber() - 1) + "-" + (nextyear.toNumber() - 1);

input.CY = input.Select_current_year_CY;

input.Projected_1 = (year.toNumber() + 1) + "-" + (nextyear.toNumber() + 1);

input.Projected_2 = (year.toNumber() + 2) + "-" + (nextyear.toNumber() + 2);

Assigning Static Tables to 3 Input Fields

2 Row and 5 Columns

input.Years = "<style>table{width:500px;border:1px solid #b3adad;border-collapse:collapse;padding:5px;}th,td{border:1px solid #b3adad;padding:5px 12px;color:#313030;}th{background:#f0f0f0;text-align:center;}td{text-align:center;background:#ffffff;}</style><table><thead><tr><th>Past-1</th><th style=\"font-style:normal;font-weight:700;\">Past-2</th><th>CY</th><th>Projected-1</th><th>Projected-2</th></tr></thead><tbody><tr><td>&nbsp;" + input.Past_1 + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Past_2 + "</td><td>&nbsp;" + input.CY + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Projected_1 + "</td><td>&nbsp;" + input.Projected_2 + "</td></tr></tbody></table>";

2 Row and 5 Columns

input.Years1 = "<style>table{width:500px;border:1px solid #b3adad;border-collapse:collapse;padding:5px;}th,td{border:1px solid #b3adad;padding:5px 12px;color:#313030;}th{background:#f0f0f0;text-align:center;}td{text-align:center;background:#ffffff;}</style><table><thead><tr><th>Past-1</th><th style=\"font-style:normal;font-weight:700;\">Past-2</th><th>CY</th><th>Projected-1</th><th>Projected-2</th></tr></thead><tbody><tr><td>&nbsp;" + input.Past_1 + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Past_2 + "</td><td>&nbsp;" + input.CY + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Projected_1 + "</td><td>&nbsp;" + input.Projected_2 + "</td></tr></tbody></table>";

2 Row and 3 Columns

input.Years3 = "<style>table{width:500px;border:1px solid #b3adad;border-collapse:collapse;padding:5px;}th,td{border:1px solid #b3adad;padding:5px 12px;color:#313030;}th{background:#f0f0f0;text-align:center;}td{text-align:center;background:#ffffff;}</style><table><thead><tr><th>CY</th><th>Projected-1</th><th>Projected-2</th></tr></thead><tbody><tr><td>&nbsp;" + input.CY + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Projected_1 + "</td><td>&nbsp;" + input.Projected_2 + "</td></tr></tbody></table>";

Comments