How to Filter Data Based on User Given Input?

[Sudipta]

Dear Friends,

I need some help Can you guys help to find the particular data based on User Input?

• User Will Enter (Run time) Phone Number and Password
• Based on Phone Number and Password Combination ( Name and other data will show from database/google sheet )
• If Not found then will show message " Phone Number and Password Wrong "

[Darren_Murphy]

The general approach to this is:

• Store your input in User Specific columns
• Create a template that combines the two provided values
• Create a similar template joining the two associated values in your data
• Create a relation joining those two templates
• Retrieve whatever values you need through the relation

If any of the above concepts are unfamiliar, here is some recommended reading/viewing:

• User Specific Columns
• Template Columns
• Relations

[Jeff_Hager]

I feel obligated to mention that creating your own methods of signing users into the app is not secure. Anybody would be able to view the phone numbers and passwords of any other user with some minor digging through the data.

[Sudipta]

Thank you for your suggestion
Can the User Login via Phone Number instead of Email Id?

[Eric_Penn]

RE login with phone number… at the moment no.

[jnthnn]

I just got the same problem, and a little bit confused about your third point.

@Darren_Murphy

Create a similar template joining the two associated values in your data

let me make it clear, did you mean this template column should joining all data like Name and other data?

[Darren_Murphy]

The idea is to create a column in each table that can be used to link the two tables, and at the same time filter according to some criteria.

So going back to the original example, the OP wanted to match two values - Phone Number and Password. Presumably he had a sheet with a list of phone numbers and associated passwords. So he could create a template column in that table that joins those two values together.

In the user interface, he would have two input components to capture a user supplied phone number and password. Each of those would write the supplied values in to two separate user specific columns. He could then create a 2nd template column that would join the two column values.

And then it’s just a matter of creating a relation between the 2 template columns - if the relation is not empty, then a match is found.

Note that in the real world, I would never recommend trying to do this with user supplied phone numbers, because there are so many different ways that a phone number could be formatted, so the chances of finding a match would be low.

[jnthnn]

I begin to understand with your point.

@Darren_Murphy

Note that in the real world, I would never recommend trying to do this with user supplied phone numbers, because there are so many different ways that a phone number could be formatted, so the chances of finding a match would be low.

thank you for your suggestion, but in my case I have to do this even this method probably doesn’t effective.

another question, how can I get user input (form) in a user specific column? since I tried but in form editor I cannot make it to user specific column, and I have read other topics that have the same problem about user specific column from user input form. any suggestions for this problem? thank you!

[Darren_Murphy]

@jnthnn

another question, how can I get user input (form) in a user specific column? since I tried but in form editor I cannot make it to user specific column, and I have read other topics that have the same problem about user specific column from user input form. any suggestions for this problem? thank you!

Yes, you would need a Custom Form.

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

Can you describe in a little more detail exactly what it is you’re wanting to do? There is probably an easier way to get what you want.

[ThinhDinh]

@Darren_Murphy

Note that in the real world, I would never recommend trying to do this with user supplied phone numbers, because there are so many different ways that a phone number could be formatted, so the chances of finding a match would be low.

What I would do is to use an API to return an internationally formatted number. That way you can make sure it’s a valid number, and it’s well-formatted.

Disclaimer: I’m using a random phone number from https://www.randomphonenumbers.com/.

The API in question:

Phone Validation API - Neutrino API Docs

Capped at 50 per day and 10000 per month on free tier.

[jnthnn]

actually i want to create such a login method, where user input an ID and their occupataion. the data will showed to them is the data related to that pair of ID-occupation only.

[Darren_Murphy]

Glide doesn’t natively support this type of login method. You could try to create it yourself, but that’s not recommended and if you manage to succeed it won’t be secure.

A better approach would be to use a standard authentication method, and then ask people to select their occupation from a list, then filter according to their selection.