# Check a field in another table and if value found return true

**URL:** https://community.baserow.io/t/check-a-field-in-another-table-and-if-value-found-return-true/11586
**Category:** Uncategorized
**Tags:** baserow
**Created:** [November 25, 2025, 3:14am UTC](https://community.baserow.io/t/check-a-field-in-another-table-and-if-value-found-return-true/11586 "2025-11-25T03:14:06Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![gtrzcianka](https://community.baserow.io/letter_avatar_proxy/v4/letter/g/a4c791/32.png) [@gtrzcianka](https://community.baserow.io/u/gtrzcianka)
#### Post date: [November 25, 2025, 3:14am UTC](https://community.baserow.io/t/check-a-field-in-another-table-and-if-value-found-return-true/11586/1 "2025-11-25T03:14:06Z")

</div>

I have a table called 232\_tariff and a column called HTS, in another table called Product List I have a column called HTS\_Code and another column called 232 Check I would like a formula that looks at the value in HTS\_Code and if it finds it in the table 232\_tariff under the HTS column it returns true to the 232 Check column

. I have created a link between the tables.

 ![2025-11-24_22-08-00](https://community.baserow.io/uploads/default/original/2X/d/d8debdd8055dd1c8653ba32839bdceceb354eb1a.png) ![2025-11-24_22-06-39](https://community.baserow.io/uploads/default/original/2X/a/a43308be8ad201a1e93671492dcda3572f119478.png)

---

<div class="post-metadata">

### Author: ![frederikdc](https://community.baserow.io/user_avatar/community.baserow.io/frederikdc/32/2086_2.png) [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [November 25, 2025, 7:47am UTC](https://community.baserow.io/t/check-a-field-in-another-table-and-if-value-found-return-true/11586/2 "2025-11-25T07:47:01Z")

</div>

This cannot be done with a singe formula, because that would require a field in the Product List table that holds all the HTS codes for every record.

I would recommend to create an automation for this. The automation starts with a `Receive an HTTP Request` node. The url generated by that node can be used a the webhook url. Trigger the webhook every time the Link to table field HTS\_Code is updated.

The automation will search for a record in the 232\_Tariff table that has the same HTS\_Code. If a record is found, you update the formula field in the Product Lists table to true.

---

<div class="post-metadata">

### Author: ![gtrzcianka](https://community.baserow.io/letter_avatar_proxy/v4/letter/g/a4c791/32.png) [@gtrzcianka](https://community.baserow.io/u/gtrzcianka)
#### Post date: [November 25, 2025, 7:11pm UTC](https://community.baserow.io/t/check-a-field-in-another-table-and-if-value-found-return-true/11586/3 "2025-11-25T19:11:13Z")

</div>

Hi Frederik,

Just to clarify, I just want to check HTS field to see if it is anywhere in that column, if it is there then I want it to return a true statement so I know it was found in the table.

In Grist I did it with a simple formula:  
tariffLookup = T232\_Tariff.lookupOne(HTS=$HTS\_Code.HTS\_Code.strip()).HTS  
len(tariffLookup) \> 0

In another field in my Baserow I just needed it to check for one specific HTS Code and I did it with this formula: if(field(‘HTS\_Code’)=‘9507.10.0080’,true,false)

That is why I was hoping there is something similar to Grist with a Lookup option.

Thanks for your help and response.

Gary