Hi All
First of all, first post, I haven't had to post since my appsheet debut simply because the community is so good and well made, we can find answers to our questions most of the time
I'm bulding an app that As a main table (RDV) and a child table (Route), this app is multiuser of course.
Now When I create a route, i want a collumn to have no start value if it's the first row for this RDV, however, I would like to be able to populate the rows only IF there is a previous Row for this RDV.
RDV has a key of "RDV ID" but I can't figure it out...
here's what I've tried so far :
I've put this code in the "Initial Value" of the collumn
IF(
FILTER("Route",([RDV ID]=[_THISROW_BEFORE].[RDV ID])),
LINKTOFORM("Route_Form","Route_de",[_THISROW_BEFORE].[Route_A]),""
)
It might not make any sense, but I am looking for directions
thanks a lot !
Solved! Go to Solution.
Hi @JpChapron
There must be a confusion on the use of [_THISRIW_BEFORE].
This must be used when it's about to get the previous value of a column, when you are updating a row.
You are probably trying to do this:
IFS(
ISNOTBLANK(FILTER("Route",[RDV ID]=[_THISROW].[RDV ID])),
LINKTOFORM("Route_Form",
"Route_de",
LOOKUP(
MAX(
SELECT(
Route[_ROWNUMBER],
([_THISROW].[RDV ID] = [RDV ID])
)
),
"Route",
"_ROWNUMBER",
"Route A"
)
)
)
By the way, I suggest you have a look on this post, it's the most useful I read when it comes to dealing with rows 😉
For reference:
https://help.appsheet.com/en/articles/2357267-isnotblank
https://help.appsheet.com/en/articles/2355961-ifs
Question: how did you manage to insert a code formatting ?
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |