Passing parameters from one Caspio Datapage to another

[kmorse]

I have in mind a Caspio Datapage that would query data from one Caspio data table and, when a link is clicked on, open a new browser window containing a different Caspio datapage is connected to a different Caspio data table. These two tables would have several column (parameter) names in common and these would be the search criteria for each datapage.

Another way of putting it is this:

If I query Table A using parameter [field@School] and then click on the link to open up the other datapage, can I pass that parameter (field@School] to the new datapage and bring up the results I desire?

Also, do Caspio data tables have size limits, either in the number of rows, columns or kilobytes/megabytes? The tables I have in mind for this application are rather large.

Thanks in advance.

Keith Morse

[davep]

This can be done rather easily. Let's say your original query string parameter is called \"school\". In your first DataPage create an HTML block and in there put something like this:

http://www.mydomain.com/SecondDataPage.html?school=[@school]

So what you're doing is taking the paramter available to DataPage 1 and passing it as a paramter to DataPage 2. Of course you could wrap the link in a proper HTML tag.

Caspio tables can reach over 1 million records without problem. For large table request that Caspio apply optimizations to the table for best performance.

Regards,

[kmorse]

Dave,

Thank you. I will give it a try and see what happens.

Keith

[kmorse]

Dave,

And just to be certain: this will work even though the two pages are linked to different data tables which happen to have a column or columns with identical names.

Keith

[cheonsa]

Hi @kmorse,

Just to give an update and for future reference, you can pass a parameter from one DataPage to another via Caspio Bridge or as  Query  String.

You may check these links for more information:

https://howto.caspio.com/parameters/passing-parameters/

https://howto.caspio.com/parameters/parameters-as-query-string-values/

 

-kristina

[AtayBalunbalunan]

As an additional reference, here is a video guide that explains passing of parameters:

 

On 9/1/2019 at 11:03 PM, kristina said:

Hi @kmorse,

Just to give an update and for future reference, you can pass a parameter from one DataPage to another via Caspio Bridge or as  Query  String.

You may check these links for more information:

https://howto.caspio.com/parameters/passing-parameters/

https://howto.caspio.com/parameters/parameters-as-query-string-values/

 

-kristina