# Discount coupon system

**URL:** <https://community.thunkable.com/t/discount-coupon-system/2935016>\
**Category:** Questions about Thunkable X\
**Created:** [April 8, 2024, 11:13am UTC](https://community.thunkable.com/t/discount-coupon-system/2935016 "2024-04-08T11:13:55Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [April 8, 2024, 7:19pm UTC](https://community.thunkable.com/t/discount-coupon-system/2935016/5 "2024-04-08T19:19:04Z")

</div>

> [@steve\_synopsis](#):
>
> Unfortunately, SQL type searches are not supported on the local datasource, so you would have to retrieve all of the couponIds and iterate through a loop comparing the Text\_Input to the cell value.

The best way to do this is to use the Find First Occurrence block, as mentioned [here](https://community.thunkable.com/t/thunkable-and-returns-a-corresponding-value-from-my-sheet/2446081/2).

That block returns a 0 if the search term is not found and a positive integer corresponding to the row number it was found in if it exists.

---

_[View the full topic](https://community.thunkable.com/t/discount-coupon-system/2935016)._
