Hi.. guys i need help complex expression

[Jpoza]

Stocks inventory Database

Release stocks

Hi.. guys I have multiple Stores and All Stores have a same inventory Item but Item Quantity is Different in every Store,  So I wont users select Store ID and automatically generate Item name and Item code with selected store's  Item code.
And one more thing...
Is it possible to after selecting Store ID, item name column showing all item list ? so user easily add Quantity of item name. { Users don't won't to select one by one item name}

[WillowMobileSys · Accepted solution]

3 things:

1) Your item column should be a Ref type column to your "Stocks Inventory" table.  I know you want to show the Item Name and you do this by setting the   Item Name column as the Label column in that "Stocks Inventory" table.  AppSheet will automatically display the Item Name instead of the row key - which will be the value stored in the data.

2)  You will want to add/adjust the "Valid_If" expression in your Item Name column to select the items based on the Store chosen, like this:

SELECT(Stocks Inventory[ID], [Store ID] = [_THISROW].[Store ID])

This will filter the list to show ONLY the items for the chosen store.

3)   For any other Item details you want to show, such as [Item Code], you want to retrieve them by DEREFERENCING the [Item Name] Ref column like this:

[Item Name].[Item Code]

[Jpoza · Accepted solution]

can you explain path and column ?

3)   For any other Item details you want to show, such as [Item Code], you want to retrieve them by DEREFERENCING the [Item Name] Ref column like this:

[Jpoza · Accepted solution]

Thanks dear...I appreciate your time.

[WillowMobileSys · Accepted solution]

---

@Jpoza wrote:

How do i get Available stocks Amount in [Available stocks] column ?

---

You can use the same manner I described above in #3:

[Item Name].[Available stocks]

If you want this value to keep updated as the [Available stocks] value changes, then leave the column as a Virtual Column just update the expression to that above. 

[WillowMobileSys · Accepted solution]

3 things:

1) Your item column should be a Ref type column to your "Stocks Inventory" table.  I know you want to show the Item Name and you do this by setting the   Item Name column as the Label column in that "Stocks Inventory" table.  AppSheet will automatically display the Item Name instead of the row key - which will be the value stored in the data.

2)  You will want to add/adjust the "Valid_If" expression in your Item Name column to select the items based on the Store chosen, like this:

SELECT(Stocks Inventory[ID], [Store ID] = [_THISROW].[Store ID])

This will filter the list to show ONLY the items for the chosen store.

3)   For any other Item details you want to show, such as [Item Code], you want to retrieve them by DEREFERENCING the [Item Name] Ref column like this:

[Item Name].[Item Code]

[Jpoza · Accepted solution]

can you explain path and column ?

3)   For any other Item details you want to show, such as [Item Code], you want to retrieve them by DEREFERENCING the [Item Name] Ref column like this:

[Jpoza · Accepted solution]

Thanks dear...I appreciate your time.

[Jpoza]

Hi...WillowMobileSys

How do i get Available stocks Amount in [Available stocks] column ?
I use this App Formula

Any(select(stocks inventory[Available stocks],[_THISROW].[Item code]=Item code]))
But It's Not working, Could you help me please?

[WillowMobileSys · Accepted solution]

---

@Jpoza wrote:

How do i get Available stocks Amount in [Available stocks] column ?

---

You can use the same manner I described above in #3:

[Item Name].[Available stocks]

If you want this value to keep updated as the [Available stocks] value changes, then leave the column as a Virtual Column just update the expression to that above. 

[Jpoza · Accepted solution]

Amazing guys thanks buddy.