To get the last status of issued item

AppSheet AppSheet Q&A
1

Inventory Management System

having 2 tables first table for Item master and second table for issue and return transaction.

One item may issued & return multiple items. While return, have a provision to capture the condition of the item. This condition should be updated in master table.

How to get the last return of the particular item and capture the condition of the item?

Thanks.

@Aleksi @WillowMobileSys

2

Hi, as you have the virtual “Related Issues” column already, create a new virtual column with the appformula something like INDEX(ORDERBY([Related Issues],[_rownumber],TRUE),1). That will give a key column value from the latest Issue.

3

Partially got it. By having a key id, how to retrieve the desired column value please.

4

I applied the below formula, but results not come.

LOOKUP(INDEX(ORDERBY([xTransaction],[_rownumber],TRUE),1), “Tbl_TranMaster”, “_rownumber”, “RCondition”)

5

How do I get a column value from the last row of this thing only?

1 Like
6

Your rownumber is probably not the key column. Use..

LOOKUP(INDEX(ORDERBY([xTransaction],[_rownumber],TRUE),1), “Tbl_TranMaster”, “YourKeyColumn”, “RCondition”)

1 Like