Conditional multiple select

Topic Labels: Formulas
937 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I would like to had a record depending of a cell from a link.
I Explain myself Capture
The result in “field 12”
“Product 1” is a link to an other table
“Unit cost” and “in stock” are colomn from the other table depending of “product 1”

I would like to display in field 12 only the first product in stock.


2 Replies 2

Is this related to the other thread where you’re asking to only see certain items in stock? It feels similar, but I’m not sure that I understand this scenario from what you’ve described so far.

Yes, I tried various thing. The last one is the closest of what I want