Forum Discussion

AndresArcila's avatar
AndresArcila
Qrew Member
4 years ago

Autofill cell with last value known

Hello community.

I need some help to retrieve the last value keyed from an item and autofill the column, the information is in the same table.

EX:

    Quote         | item    | cost
quote n-1        | item a | 100 

quote n-1        | item b | 50

quote n           | item a | 80
quote n           | item c | 20
quote n+1        | item a | last value (quote n)
quote n+1        | item b | last value (quote n-1)
quote n+1        | item c | last value (quote n).


Plan B is create a new column and show the last known value from that item.
Open to ideas.

Thank you



------------------------------
Andres Arcila
------------------------------
  • I think Webhook like one of the ways, or Pipeline.

    ------------------------------
    Alex Priadko
    Senior Full Stack Developer (Php, React.js, Vue.js, Blockchain)
    Quickbase app builder too :)
    Email: mr.eskrano@gmail.com
    ------------------------------