Lookup value from another table

[aslan.karimov]

I have a Repeating Group pulling data from Table 1. I would to add a column in that table that will show Open because at least one of the records in Table 2 for that StockID contains word Open.

[mikeloc]

Hi there, @aslan.karimov… if we take your question at face value (i.e., we don’t dig into whether or not your data types are “correct/ideal”), a text element in the repeating group with this condition on it should do the trick.

Hope this helps.

Best…
Mike

[aslan.karimov]

Thank you. Data for both tables is coming from external API and Search For function doesnt work.

[mikeloc]

@aslan.karimov

Data for both tables is coming from external API

Probably should have mentioned that in the initial post.

Maybe try this…

[aslan.karimov]

Thank you. I used filtered function too. I am having an issue with constraints. If I have Inventory Stock Number only, filtering works. But when I add Status, then no records are matched.