Hi everyone I am struggling with expressions...

expressions
(XJH GOV) #1

Hi everyone

I am struggling with expressions. I have the two following columns :

B

14499

A

12000

B

14499

A

12000

A

12000

B

14500

B

14500

A

10001

B

14500

A

10001

C

9200

C

9200

In a new form, when I first select B, I want the “INITIAL VALUE” of column n°2 to be 14500 (the last value linked to B). Is it possible with a combination of MAXROW / SELECT ? Or maybe a TAB with a FILTER but can’t put the tab name as a variable in expressions ?

Thanks for any advice

(Reza Raoofi) #2

Yes, you should be able to use MAXROW(…); however in order to find the last linked value to B you need a criteria like a Date/Time column or an increasing number or something to use in MAXROW() function and find the last row along with a

[Column]=“B” condition.

(Fernando López) #3

@RezaRaoofi, Is _Rownumber column valid for doing this?

(Reza Raoofi) #4

@Fernando_Lopez Yes, of course, but since we do not know all the details about the column structure I will leave that to @XJH_GOV’s discretion.

(XJH GOV) #5

Hi all Many thanks for your advice. @Fernando_Lopez, you’re right, the only parameter I can use is the rownumber as DATE exists but not increasing nor any other param. Anyway I didn’t go this way because Im not used to interwined expressions in appsheet (I’m familiar with code in general and it’s not intuitive at all) So I did it with adding a new tab with the last information I needed using spreadsheet formulas. ++