How to search and select a name from google sheet - regd

Kodulars, I am having 1300 names in column A (A1 to A1300), And if theuser types his name in the field(text box or spinner or anything) it have to filer and show his name in the app.

Is there any option available in kodular?

My ultimate aim is the user need to pick his name from googlesheet into the field

-Jaisankar

If i upload all the names as CSV file, Will it be easy to select or pick??

Is it a google spreadsheet ? If yes, then you can use web component to get all data from column A (A1 to A1300) as csv and add them to a list so when the user types his name or … if he is in the list then …

2 Likes

You might want to consider Cloudsheets, it has a dedicated block for it and many more amazing blocks !!!

Let me try and tell you kodular.

Thanks for your suggestion.

1 Like

In order to work do not forget to set google spreadsheet to “anyone with the link can view”

1 Like

Yup sure…

One more doubt, you have given few blocks in the above post, but my doubt is Where will the csv file deliver the response content???

Do i havebto set it under required label??

Greate a global variable and set it to create an empty list.

1 Like

This is something i usually get worried about, this depletes the security, people can extract link from source and then you are destroyed, i like other options in this case, at-least the db is not directly accessible

In which case you can use a google apps script web app and access private google sheets, even the users own sheets on their own google drive. No need for any paid extensions / api keys…

1 Like

Yeh true, not everything is as easy is as it seems, no doubt if you make efforts it will be.

There are many other factors too, speed, efforts, and etc.

Thats the only reason it takes time to evolve services to a respectable level

Peace :v:

Unable to get the required one

Use query

Web url to : https://spreadsheets.google.com/tq?tqx=out:csv&key=
“insert your spreadsheet id”
&gid=“your gid spreadsheet”
&tq=
web uri encode text :
select * where A=’
eg John (name in col A)

when web get text
and you get responses about row of John

I TRIED BUT…

Thats wrong block

put your web goto url & web get to button verify

and try to show result in label (add new label)

when web got text
set label text to responses content

2 Likes

Oh superb… It works…

Now i will try to frame another rule there by Name, std and sec will go in the respective boxes… I am getting all the rrsponses content and all in the same box

Thank you @sugarlesscreator

1 Like

cause you are getting a list with 4 items. Use select list item list block, ixdex 2 is name index 3 is std index 4 is sec

image

1 Like

Tomorrow i will try to set up blocks.

Instead of text box 2 i have to add these block one by one, i think you r trying to suggest me… Thanks @dora_paz

Row 1 col 1 = 1500
Row 1 col 2 = Navin Kumar
Row 1 col 3 = VI
Row 1 col 4 = A (Sec)

1 Like