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
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 …
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…
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