Retrieve count from a large external collection


Wanted to see if anyone has any advice on this.

I have an external collection of addresses in Google Sheets. It is connected with SheetsDB. There are 225,000 records in this sheet.

I need to be able to allow a user of my app to put in a zipcode and return the number (count) of records that match that zipcode and place it with magic text in an Adalo Screen.

Is there a way to do this calculation outside of Adalo and then push the results to Adalo?

Sorry if I worded the question wrong. I am extending beyond my abilities with this one.

Thanks for any advice you can offer.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.