Optional Referencing

Hi I am working on an inventory app that has barcodes of the items, their names, and description on separated columns. I was able to reference the barcode from the Item list table to the inventory logs table so I can search for a barcode and get a list from the item list table. However, I realized that there are items that do not have a barcode so I set my barcode column to not required but I can not find a way to tell appsheet that ifisblank([barcode] then instead of [item list].[name] referencing command you should display the list of items without barcodes) something like that. I hope someone can help me?

additionally, I created a slice of items with blank barcode but I guess I can not make use of it

0 1 117
1 REPLY 1
Top Labels in this Space