h a l f b a k e r yCall Ambulance,
Rebuild Kitchen.
add, search, annotate, link, view, overview, recent, by name, random
news, help, about, links, report a problem
browse anonymously,
or get an account
and write.
register,
|
|
|
A special spreadsheet application implements web response
handling by integrating with a proprietary web server module.
It synchronises request parameters into specific cells B3-B15.
And
preparses the URL into fields and parameters in B5-B20.
I type SQL into a cell in the first Worksheet.
You
construct a web response by using functional programming:
map - apply a function to list of things getting a list of things
back
reduce - apply a function repeatedly to a list, reusing the same
iteration object
In worksheet 2 (tab 2) you assign fields to the response.
A1= load_template("template.html")
A1 fills the screen and contains HTML on one side of the screen
I find a block of HTML I want to iterate over and select it and
type into the formula block =iterate
Somewhere after A1 I type =map(SQL cell, Worksheet3)
and I can map the SQL into a response HTML.
Please log in.
If you're not logged in,
you can see what this page
looks like, but you will
not be able to add anything.
Annotation:
|
| |
I like APIs, spreadsheets and luxury apartments for all. Do you
have a problem with that sir? |
|
| |
My best idea is lifestyle subscriptions. And Auto API Import. |
|
| |
And the links to my 205 tech ideas in my profile. Check them
out, you'd have to be a developer to understand some of them
though. |
|
| |
Spreadsheets are underused technology. They are awesome
and functional programming! |
|
| |
Parsing your idea I can see you're talking about spreadsheet-driven
website. I think, Google spreadsheets already have forms, you just want
to tear a few levels of abstraction down, to the level where you
define
how spreadsheet makes http responses, by defining that directly on the
spreadsheet. |
|
| |
What an awkward way to get an accountant to make websites. Though,
you could say it's already baked, as pretty much every website works
based on a database, which if relational, is based on a bunch of tables,
for which you need just a spreadsheet UI, and a master sheet holding
schemas. |
|
| |
Named ranges might be your friends. |
|
| |
I want the GUI of a speadsheet to be used to develop
backends. Functional programming and SQL type cells would
make mapping database responses easier. I think it would be
beautiful. |
|
| |
The back end in question was not to a collection of web
services, but to a BI tool, but the development environment was
an Excel workbook, which was then compiled into something
else. |
|
| |
I worked with it for a while, and was quite glad to stop working
with it. |
|
| |