# How to create a search engine from text input, based on data from couple columns - google sheets

**URL:** https://community.thunkable.com/t/how-to-create-a-search-engine-from-text-input-based-on-data-from-couple-columns-google-sheets/1781019
**Category:** Questions about Thunkable X
**Tags:** design, beginner, google-sheets
**Created:** [March 13, 2022, 1:15am UTC](https://community.thunkable.com/t/how-to-create-a-search-engine-from-text-input-based-on-data-from-couple-columns-google-sheets/1781019 "2022-03-13T01:15:32Z")
**Posts on this page:** 1
**Showing post:** 13

<div class="post-metadata">

### Author: ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [March 21, 2022, 12:31am UTC](https://community.thunkable.com/t/how-to-create-a-search-engine-from-text-input-based-on-data-from-couple-columns-google-sheets/1781019/13 "2022-03-21T00:31:11Z")

</div>

> [@barchom91ahltd](#):
>
> I need to enter details from sheet1 and be able to edit that:/

what do you mean, you always have access to any row in the sheet from thunkable. in order to edit, you should setup your thunkable program to retrieve a row, provide input fields to allow data and entry and update that row in the google sheet.

my suggestion requires that you get your data from sheet3 not sheet1 - i think that’s what you meant. so you cannot easily update sheet1.

to do a search the way you want it, you can use the method suggested by @muneer - after you’ve mapped your DVL to your sheet , iterate over the DVL and if anything satisfies your required condition/s, set visibility of that DVL item to true else set visibiility to false.

see the method i suggested here:

> [@Create individual buttons to return individual filters from a range in a Google Sheet](https://community.thunkable.com/t/create-individual-buttons-to-return-individual-filters-from-a-range-in-a-google-sheet/1781042/2):
>
> this short demo illustrates the functionality you desire: enter day of week (1=monday…7=sunday) and the resulting list is filtered from the original list, showing all rows that have the corresponding day of week is populated. at the start, the list shows the full list then enter a one-digit day of week (eg. 3) at top and the displayed list should change to show only those rows that have wednesday (dayofweek=3) in them the number being displayed on the right (eg. 35…

maybe this method will work for you

---

_[View the full topic](https://community.thunkable.com/t/how-to-create-a-search-engine-from-text-input-based-on-data-from-couple-columns-google-sheets/1781019)._