4 ms·
Excel is still the biggest and most successful no-code tool. The real problem with no code, is the tools take a lot to learn well and it rarely transfers betwe
by Retric 6y ago
Excel is still the biggest and most successful no-code tool. The real problem with no code, is the tools take a lot to learn well and it rarely transfers between roles at the same job.
- msla 6y ago> Excel is still the biggest and most successful no-code tool. Yep, people sure write a lot of code in Excel. (Well, what do you think formulas are?)
- waynecochran 6y agoWith spreadsheets, particular google's flavor, I still think of it as functional / declarative programming.
- mainstreem 6y agoEver seen Smartsheets? I know someone I'd have described as "nontechnical" several years ago who is practically building business-specific applications complete with frontend interfaces and backed by spreadsheets and almost all of this person's code is formulas, which are very "functional programming." This person has asked to be coached in writing a "real" programming language and it's a challenge to think of how to approach the problem based upon the person's existing skillset and understanding, which is entirely backwards (FP instead of imperative) from the usual student's!
- thisisnico 6y agoAnd some of the most advanced Excel spreadsheets make use of Visual Basic to automate processes. Even with no code solutions, The most advanced users will want to automate and integrate, using code.
- tabtab 6y agoI've seen end-user-built-app Excel code enough times to have a distaste. Maintenance is 2/3 of average software cost, and that [bleep] ain't maintainable. It's good for prototyping, but shouldn't remain in production for anything of importance. As far as general "low code" or "no code", I've seen that promise for many decades. They keep reinventing failed ideas under new names. Clickable wizards, rule lists, and drag-able flow-charts can only take you so far. The devil is in the details, and these don't handle details well. And they are hard to factor. Your Uncle Bob may be able remodel your house for cheap, but what do you do when rain leaks in and the lights stop working? Or worse, catch on fire? Remember: Total Cost of Ownership.
- samhain 6y agoThere was a post on here a few weeks ago that discussed code as the translation between the desire for a particular behavior from the person coding, and the machine instruction that needs to be executed. The comment section had a video of Guy Steele talking about growing computer languages, and was trying to make an argument for Computer Science Metanotation being one of them. [1] He started of the talk describing Regex, and how it came to be, and basically showed how that functions have been/could be formally described in papers the same way that Regex is used. In the same way regex formalized the notation for string parsing, so too will the next language regular function expression formalize. Perhaps computer meta notation is the source of true no-code solutions? Perhaps instead of reading articles about "The Unreasonable Effectiveness of Regex," in the future, we'll be reading about "The Unreasonable Effectiveness of Computer Science Metanotation." I also understand that what no-code solutions we are typically talking about is a user interface that is graphical, drag-and drop. But who is to say we don't create a tool that does that with CSM? [1]: https://www.youtube.com/watch?v=qNPlDnX6Mio&ab_channel=ErlangSolutions https://www.youtube.com/watch?v=qNPlDnX6Mio&ab_channel=Erlan...
- tabtab 6y agoI find declarative and functional (D/F) code is often difficult to debug. It's generally easier to break imperative code into fractal-like steps, sub-steps, sub-sub-steps etc. D/F just can't be dissected fractal-ish like that nearly as easy. It's just a magic property of imperative code that's hard to replicate in other paradigms. It's why imperative still dominates after 50+ years of D/F attempts. Someone once said that D/F makes it easier to express what you intend, but imperative makes it easier to figure out what's actually happening. One improves writing, the other improves reading (or at least debugging).
- BenoitP 6y ago> tools take a lot to learn well and it rarely transfers between roles at the same job So, great lock-in capabilities? I can see why money is pouring into these tools.
- rllearneratwork 6y agoit is often easier and much much more useful to invest in learning to code rather than invest in learning a proprietary "no-code" tool
- open-source-ux 6y ago"Excel is still the biggest and most successful no-code tool" What's interesting is that many users build quite complex formulas and spreadsheets, yet Excel's formula and VBA syntax is (in my opinion) harder to learn than other programming languages. For example, I'd argue a language like Ruby is simpler in many aspects than using VBA or building complex formulas. Like Microsoft, Google Sheets also has quite an ugly, clumsy feel to its syntax. The terrible programmable usability of these products (Excel and Sheets) could only have come from the mind of a developer (harsh I know, but true).
- Retric 6y agoI don’t think most people have issues with programming because of syntax. It’s the lack of visual feedback that’s making things so difficult. Click on one of those cells and it’s color coding which cells make up that formula. Sum(everything in this box) is really easy to get where a foreach loop doing the exact same thing is more abstract. People just kind of default to {do some magic} on [various things] -> (Some result that looks about like I was expecting). What’s really interesting is Spreadsheets tend to have bugs where the result is incorrect but reasonably close to reality. Aka 38 vs 35 not Null Pointer Exception, this makes them in many ways seductively dangerous in a this looks close therefore it must be easy to fix way.
- benhurmarcel 6y agoMy company is pushing Python to mechanical engineers as an alternative to complex spreadsheets (with many sheets, complex formulas, and VBA). In practice it's already a massive pain to just get a working installation with the correct modules. Even if I make a working script, 95% of my colleagues can't run it. While Excel is just there, everywhere.
- commandlinefan 6y ago> the tools take a lot to learn And eventually require VBScript if you want to really automate anything anyway.
- ebj73 6y agoI wouldn't call Excel a no-code tool. A formula is sort of code, in my mind.
- FartyMcFarter 6y agoFormulas (at least the kind people typically use) are not Turing complete, so they are not as powerful as what most people associate with the word "code". Edit: I know there are lots of people on the Internet saying you can simulate Turing machines in excel, but they're usually manually unrolling the computation in successive rows, which doesn't really count. For one thing, this style of simulation doesn't even allow one to make an infinite loop, let alone a more complex self-contained loop.
- contravariant 6y agoOf course by far the biggest problems with Excel sheets are caused by the code in them. That and Microsoft's insane theory that about 50% of user input is dates.
- Ma8ee 6y agoOr that long numbers, like Order Numbers or Customer Numbers should be considered floats.
- indymike 6y agocalling stuff like this no-code is incorrect: =RIGHT(A5, SEARCH("FOO",A5))="BAR"
- Retric 6y agoEvery no code solution has such scripts under the hood and most let you edit them. However, drag and highlight a row of cells and click sum, min, or max and your not editing code directly which is really all there is to the ‘no code’ concept. There are plenty of ways in these tools to select a bunch of data and click make a chart, but guess what that’s just another way to write some code.