[HN Gopher] Spreadsheet with compute-like functions: GET(), POST...
       ___________________________________________________________________
        
       Spreadsheet with compute-like functions: GET(), POST(), PARSE(),
       ASK_OpenAI()
        
       Author : luisb
       Score  : 65 points
       Date   : 2023-01-05 17:51 UTC (5 hours ago)
        
 (HTM) web link (rows.com)
 (TXT) w3m dump (rows.com)
        
       | gr wrote:
       | I use this, Rows.com is very cool stuff. Not (yet) a full
       | replacement for G Sheets but 10x better for widgets and
       | interactive tables and reports.
       | 
       | And the built in forms are excellent!
        
         | gr wrote:
         | ... :chef: :kiss:
         | 
         | No emojis ;-[
        
           | [deleted]
        
         | culi wrote:
         | Seems like they have sort of a Notion-like approach to
         | spreadsheets
         | 
         | I agree it's pretty cool. What I'd _really_ love to see though
         | is something like Jupyter Notebooks + Spreadsheets. If blocks
         | of code and blocks of spreadsheets could talk to each other, it
         | 'd definitely be a killer feature for me
        
           | breck wrote:
           | > something like Jupyter Notebooks + Spreadsheets.
           | 
           | We built something like this at Our World in Data
           | (https://pldb.com/languages/explorer.html) and it is still my
           | favorite tool for building charts.
           | 
           | I expect there to be more things like that. Another one I
           | built is https://ohayo.computer/ (but it's due for a
           | refresh).
        
           | mediaman wrote:
           | I'm not sure if this is what you're looking for, but Grist
           | has relationship-driven spreadsheets where the formulas are
           | all Python code. And you can have multiple tables show on the
           | same page, where selection of one filters the others.
           | 
           | The tables are more database-style than pure unstructured
           | Excel sheet style, but I've found that having a full Python
           | environment in each cell to be pretty powerful, and I've
           | started turning to it for analytical work because I can avoid
           | the mess that larger Excel formulas can turn into.
           | 
           | No relationship except as a customer -- they're at
           | getgrist.com
        
             | dsagal wrote:
             | Ooh, excited to see mention of Grist (I am a cofounder).
             | Python code and structured data are a great combination,
             | and are particularly good for AI. We did an experiment
             | where AI was quite impressive in writing Python formulas in
             | Grist based on simple prompts:
             | https://news.ycombinator.com/item?id=33809111
             | 
             | I suppose it's similar to rows.com's ASK_OPENAI("write a
             | spreadsheet formula that..."). Most impressive is that it
             | knows relationships between tables, and can construct
             | correct lookup formulas, and do useful things with their
             | results.
        
             | patife wrote:
             | Looks cool too! Python!!
        
       | ent101 wrote:
       | aside from the tech, I also really like the examples (e.g.
       | cleaning addresses), they are practical uses of GPT. Gave me some
       | ideas too!
        
       | oi_ocha_please wrote:
       | really cool! fyi, i'm having trouble clicking on certain cells in
       | the demo.
        
         | [deleted]
        
       | akickinthestone wrote:
       | Has anyone tried asking open.ai for spreadsheet formulas?
        
         | patife wrote:
         | Yes ASK_OPENAI("write a spreadsheet formula that averages
         | values in column A if column C equals Facebook")
         | 
         | That worked for me!
        
       | dang wrote:
       | Related:
       | 
       |  _Rows.com - Spreadsheet that supports external API integration
       | and collaboration_ -
       | https://news.ycombinator.com/item?id=29171490 - Nov 2021 (75
       | comments)
        
       | choraria wrote:
       | When are webhooks going to be released? Webhooks inside a
       | spreadsheet would be :fire: (looks like emojis don't work on HN,
       | SMH).
        
         | ent101 wrote:
         | also subscription via websockets! it's an interesting new
         | trend.
        
         | [deleted]
        
         | [deleted]
        
         | xnx wrote:
         | There's an add-on for Google Sheets that does this:
         | https://workspace.google.com/marketplace/app/webhooks_for_sh...
        
           | danielvaughn wrote:
           | lol this is _dangerous_
           | 
           | I know what I'm going to be playing around with this weekend
           | :p
        
       ___________________________________________________________________
       (page generated 2023-01-05 23:01 UTC)