[TuringTest]

When you want to take different actions, you can use the Stream metaphor (a.k.a. Observables) instead of variable bindings.

Streams maintain the same functional reactive execution paradigm of spreadsheets and property bindings, but you can compose several of them into a new stream with complex conditional logic. You can use the streams as event propagators, and understand the program state as a series of successive updates every time a new event appears on the stream.

https://www.didierboelens.com/2018/08/reactive-programming-s...

[usrusr]

That's essentially what the "copy formula down the entire column, updating relative references as you go" pattern of Excel abuse does, right? Might be quite interesting to have a UI that takes all the tedious and distracting column-filling from your shoulders but keeps the tabular representation for debug/understanding.

[TuringTest]

Yes, that's how it is done in a spreadsheet.

A stream allows you to generalice the computation, not depending on the number of data items that were available when you defined the function; i.e. not different from a function with a loop.

Applications like AirTable and other modern outliners are exploring interfaces to model that kind of generalized data tables and relations with visual metaphors.