Assistance Required: Displaying Dynamic HTML Table in Zoho Creator Dashboard Page

Assistance Required: Displaying Dynamic HTML Table in Zoho Creator Dashboard Page


I am currently stuck while creating a custom dashboard page in Zoho Creator. I want to display a designed HTML table showing Teacher Registration data with this condition:

If Total Allowed Leaves < 10, display those teachers in the table.



  • Page Scripts do not support fetching multiple records directly.

  • aggregateRecords() only returns grouped data, not full records.

  • HTML/ZML snippets can’t fetch form data themselves.

I tried Page Variables, Page Scripts, aggregateRecords, and referred to:

…but couldn’t implement this logic successfully.


Request:

Could you please provide:

  1. A sample code snippet or approach to fetch multiple teacher records conditionally and display them in a custom HTML table on the page.

  2. Best practice recommendations for such conditional data display using Page Variables.


Thank you so much for your support.

Best regards,