How to show records from Zoho Reports in a paging table/grid?
I am trying to use Zoho Creator (ZC) to allow a user to select a range of criteria and return a list of records. These records, however, are not stored in my app but in Zoho Reports (ZR). There could be a million or more rows in the ZR view.
I want to show the selected records in a grid so the user can select one of them and show the record in a read-only form.
I have already written the read-only form as a Page. I can already read the data using the ZR API but I'm struggling how to show the records in a paging grid/table. I thought maybe I could use a "postback" technique as used by ASP.NET web forms but this doesn't appear to work:
I have an anchor link which uses this function (String.Format is my version of the .NET String.Format method):
string Leadz.NextPage(int pPageNo)
{
/*
<summary>
Returns the page url with the page number parameter.
</summary>
<history>
[JOHN] 09/Oct/2017 Created.
</history>
*/
return thisapp.String.Format("
https://creator.zoho.eu<0>#Page:Search_Results?pPageNo=<1>", {zoho.appuri, input.pPageNo.toString()});
}
newURL = thisapp.Leadz.NextPage((pageNo + 1));
<a href="<%=newURL%>">Next</a>
I'm sure I'm pushing the envelope with this approach but short of importing the records into a form which is not cost-effective, how can else I achieve this?
Any ideas?