Hi, Going to throw a curve ball here not sure if this is even possible. I must warn you I am not a programmer or have any knowledge with html or programming. So please bare with me. I provide long distance services in the US. I am trying to create an application where someone could put in a 6 digit area code, then after pressing like maybe a submit button, it would display the corresponding rate for that 6 digit combination. For example, I could have a box where the user could type 212200, press look-up, then the app would provide a rate for that 6 digit exchange or combination of numbers. Any ideas? Is this even possible? Were talking about 150k different rates. Thanks.

Totally possible. You say you are not a programmer but are you willing to learn a wee bit and have a huge payoff? I'm assuming since you said 'you are' that you have this data stored in a DB or something at the moment? You are on the right road, you'll have a form where the user submits the code of their choice, the code then queries your database and posts back the result. Job done.

The data is compiled in an excel spreadsheet. 2 columns, 6 digit number and rate. Column A would contain the number and column b the rate. Yes I am very much willing to learn. I do not have the rates in a database of any kind. Would not even know where to begin with that. I appreciate your encouragement.

Hi @scubabermuda, Welcome to buzztouch! @MacApple is right, this is totally possible with some work. Glad to see that you're willing to learn! This sort of layout totally begs for a mySQL database and a PHP call to it. Would be pretty darn simple, and I'm sure the Excel data can easily be exported to mySQL. Is this data fairly static, or does it change a lot? Mark

Hi Mark, Thank you for posting. It is not static, it would change about once a month.

Cool. Still sounds like database material to me. And, since it's related to phone stuff, you'd assume they had a connection to the network all the time, so doing such a configuration (mySQL+PHP) is for sure one possible solution. By the way...take some time, go to your My Account tab, and sign up for v1.5 Early Adopter. There are a lot more features in v1.5 than v1.4, and you would need v1.5 to accomplish what we're talking about anyway. Mark

You can query a spreadsheet as well, Google have an API that allows you to query / treat your spreadsheets just like a DB. Have a search on Google, see if you can follow some of the guides if not post back and someone will jump in.

I will do that, thanks guys.

@MacApple has been doing his homework! When I first saw this post, I Googled Javascript and spreadsheet, and saw that you could use Javascript to query Google spreadsheets. That would be an even easier solution (well, for somebody...PHP is easier for me), since it doesn't involve server side PHP. Mark