Hello AppSheet,
We are trying to find an easy website builder that will do the following. Will you please let us know if your tool can do this?
Data
Our data will be in a single Google Sheet (we could use Airtable as an alternative if the best tool for this requires it, but we would rather avoid that extra expense). It will have 4k records (which are colleges). It will have just three fields:
- Name of college
- Logo of college
- URL of college page on our separate website
Collection Page
We want to use it to generate a very simple one-page site. That page would show the names and logos of the colleges in a list view.
- Do you offer a choice of list view and grid view?
- We would want the items to appear alphabetically.
- Can we customize the layout of the page (size of image, font size, etc.?)
- What is the largest number of products or records that we can show on the page?
- Do you have pagination so that we can accommodate all 4k colleges?
We do not need a page for each record.
Publicly-Accesible
We need this to be publicly-accesible with no log-in.
Search
The visitor needs to be able to search for the college of their choice. For instance, if they enter “Texas,” they should see Texas Tech, Texas A&M, and University of Texas.
It would be ideal if, as they typed, the saw a list of all the matching colleges, and that list shrunk as they typed, but that is not essential. Do you have that?
Is the search fast with 4k records?
Filtering
We do not need any filtering. Just the search.
When the VIsitor Clicks a College
If they click on a college name or logo, they should be taken to that college’s URL in a separate website (that is, not to a product or detail page for the college).
Embedding in Our Separate Site
We would want to embed the page that we create with your tool in an iframe on our Shopify store. It should be responsive to that it works, regardless of whether the visitor to our SHoify store is using a comptuer or phone.
No Header or Footer
The one-page site we create with your tool should not have a header or footer, as we will want to embed it in our Shopify site.
Traffic
We expect fairly significant traffic, but each visitor would likely use it only to do a quick search. Please explain if there are limits to visitors, simultaneous users, bandwidth, or anything else. Extra cost for additional traffic? Does using a Google Sheet limit the number of simultaneous users or anything else?
Other
Is there anything we forgot to ask?
Please cc our Founder on Your Reply
Please cc rtolmach@gmail.com when you reply. Thank you very much for your time and consideration.
Very best wishes,
Michael Mu