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.
Hi, Usage example: INDEX(SELECT(...), 1) || 0 This would have the same
result as: IF(ISBLANK(INDEX(SELECT(...), 1)), 0, INDEX(SELECT(...), 1))
It would be much clearer and possibly a performance gain as you could
exec one query instead of two.
Hi, I have a list of “Month” with a “beginning amount” property, this
property should match the “end amount” of the previous month (“end
amount” is virtual, “beginning amount” is not). Each month has some
element, and on element update, I have to upd...
Hi everyone, After using the spec app creator, the initial app has
default data, which is good. But as soon as you modify any data
structure (let’s say, I add a column and a reference) those demo data
becomes obsolete and there’s no way to recreate t...
First, I think you can simplify your expression: … Yes, it’s just that I
wrote it from memory instead of copy-paste from the app, sorry for the
typos. My suggestion: … It seems I wasn’t clear enough. An important
detail: Beginning amount is not only ...
Let’s be precise then: Bank lines has Price(Price) property Ignore
Budget for now (let’s admit “Month has Many Bank Line” like budget
didn’t exist) Month as a Name(Date) property Month as a Beggining
Amount(Price) property Month as a End Amount(Price...
Yes I tried, (and my request looks like this btw) The problem is not
“how to calculate”, I know for a fact that requests are good. The
problem is the process of how to do those requests one after another.
For now, they seem to be done asynchronously ...
The problem would remain the same as I need to update all subsequent
months with their previous month synchronously. Let’s simplify scheme
for simplicity: Month A Amount A Ref elements Month B Amount B Ref
elements Month C Amount C Ref elements Here’...