How do I case check for multiple List/Relation

1

Hi, I require some assistance on the difficulties of doing like an inventory management.

For more technical explanation:

  1. Tray Inventory (Tray 1 | Tray 2 | Tray 3 - With quantity of 1 for In Stock and 0 for Out of stock
  2. Form selection relation to Tray Inventory, will only show quantity that are 1, aka In Stock
  3. User Select Tray 1, Tray Inventory will automatically update to 0, aka Out of stock and prevent subsequent filling of form to not show Trays that are Out of stock.

Currently issue faced is:
when multiple selection of Tray in the form selection, it does not return true.
Suspect that the formula read it as string of arrays
e.g: Form Selected Tray 1 and Tray 2, quantity will return 0 to Tray Inventory. Subsequent form filling will not show Tray 1 and Tray 2 anymore.

Similar reference:
image

2

Dear @An_Rong_Low , welcome to the Coda community.

From the screenshot it’s not clear how the table has been setup.

Would you mind to share a anonymized copy of your doc? This will make it so much more easy to provide support tailored to your use-case.