This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Add lambda() functionality as it is currently available in Excel Insider Beta version, where the user can define his own named functions with parameters, which can be called recursively.
Like all other expressions it can be reused in different parts of the app. Recursion can solve some problems that can not be solved by any other current means known to me?
Why would AppSheet prioritize this request over others, is what I’m getting at. Yours is the first request I’ve seen for this, and it’s a feature that isn’t even publicly available yet.
This is my problem.
I have a sheet with columns Id, Parent and some data columns.
This creates a tree structure where the branching is “unlimited”, TopNodes, Grandparent, Parents, Children, GrandChildren etc Where I link the current row to it’s parent in the same table. Something like ThisRow.Parent = (Parent).Id.
I want to build a description dynamically (virtual column) like in windows explorer navigation bar C:\users\xxx\yyy\zzz etc. for each row.
It seems only possible with recursion
Somethig like:
ThisRow.Description & LookupTheParent.Description
If it is the topnode do nothing
If Not call the same process
In general I feel like everyone should enter to the AppSheet platform with an open mind and without any preconceived assumptions of how things should work.
In other words, I think you can make more if you forget everything you know about Excel/Sheets first and then, after eating the whole documentation, you can start applying some of the knowledge you had
Regarding no-code.
If this is considered no-code:
(
COUNT(
TOP(
LIST(
[Answer 1 Player 1],
[Answer 1 Player 2],
…,
[Answer 1 Player N],
),
[Player Count]
)
- LIST("")
)
= [Player Count]
)
Then I am sure this can also be considered no-code: