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> " + input.Past_1 + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Past_2 + "</td><td> " + input.CY + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Projected_1 + "</td><td> " + 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> " + input.Past_1 + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Past_2 + "</td><td> " + input.CY + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Projected_1 + "</td><td> " + 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> " + input.CY + "</td><td style=\"font-style:normal;font-weight:400;\">" + input.Projected_1 + "</td><td> " + input.Projected_2 + "</td></tr></tbody></table>";
Comments
Post a Comment