Use IF with topline

[Samy_Kermia]

Hello bosses!

I would like to do an auto compute with the top line.

Long story short, it's a sports app for me and my friends.

We have two lines one with the weight and one with the question "did you fail?" Yes No

The goal is that the next time I open a form it fills itself out with the following condition:

If the last line the answer to "did you fail?" is No then it will fill in the weight used before +1.
Otherwise, it puts the weight back on.

I imagine it must be the select or maxrows function but I can't seem to formulate it.

[Steve]

Re: FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), R... - Google Cloud Community

[Samy_Kermia]

Hello,

Since your message I have tried to document myself but I cannot find the formula that corresponds.
Because there is a column with text and a column with numbers.
I can't tell it "find the last value entered"

[Swoopy]

Assuming you have a table named "MyTable" and your mentioned form named "MyForm".

1. Create a new action.

2. In "Do this" option, choose "App: go to another view within this app".

3. In "Target", place this expression (don't forget to change MyForm, MyTable and KeyColumnOfMyTable to what you're actually using).

LINKTOFORM("MyForm",
   "Weight",
   IF(
      LOOKUP(MAXROW("MyTable", "_RowNumber"), "MyTable", "KeyColumnOfMyTable", "did you fail?") = "No",
      LOOKUP(MAXROW("TableName", "_RowNumber"), "TableName", "KeyColumnName", "Weight") + 1,
      LOOKUP(MAXROW("TableName", "_RowNumber"), "TableName", "KeyColumnName", "Weight")
)
)

4. In "Prominence", select "Display overlay"

Then save and try.

[Samy_Kermia]

I have use this solution but it doesn't work. 

With the MAXROW expression, formula return the first column like that : 

MAXROW(Musculation,Pendlay,[Echec_Pendlay]=No)

One randomly chosen value from this list ( ........The list of values of column 'Unique ID' ........from rows of table 'Musculation' ........where this condition is true: (ALL these statements are true: ............1: (The value of column 'Echec_Pendlay') is equal to ("NO") ............2: (The value of column 'Pendlay') is equal to (MAX( ....................The list of values of column 'Pendlay' ....................from rows of table 'Musculation' ....................where this condition is true: ((The value of column 'Echec_Pendlay') is equal to ("NO"))))))

[Swoopy]

You would need to show us what table and its data look like or you would get just widely replies.

[Samy_Kermia]

I've made a video hope this is clear ^^

Video 

[Swoopy]

Hope I understand correctly, try

LINKTOFORM("Musculation_Form",
   "Pendlay",
      IF(
         LOOKUP(MAXROW("Musculation", "_RowNumber"), "Musculation", "Unique ID", "Echec_Pendlay") = Yes,
         LOOKUP(MAXROW("Musculation", "_RowNumber", (ISNOTBLANK([Pendlay]))), "Musculation", "Unique ID", "Pendlay"),
         0
      )
)

[Samy_Kermia]

If i wrote this in the initail value it doesn't work . In Action? 

[Swoopy]

IF(
   LOOKUP(MAXROW("Musculation", "_RowNumber"), "Musculation", "Unique ID", "Echec_Pendlay") = Yes,
   LOOKUP(MAXROW("Musculation", "_RowNumber", (ISNOTBLANK([Pendlay]))), "Musculation", "Unique ID", "Pendlay"),
   0
)

[Samy_Kermia]

.

[Swoopy]

Recheck my 1st reply. This's not for app formula but an action.

[Samy_Kermia]

And great thanks for your help !!!!! 😍