# Search for users then add them into a form **URL:** \ **Category:** Ask for Help\ **Created:** [June 15, 2022, 2:17pm UTC](https://community.glideapps.com/t/search-for-users-then-add-them-into-a-form/43100 "2022-06-15T14:17:52Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 15, 2022, 2:17pm UTC](https://community.glideapps.com/t/search-for-users-then-add-them-into-a-form/43100/1 "2022-06-15T14:17:52Z")
This is supposed to be like a POS system. Pretty much when a customer comes into the store you need to input their name into this form to create a new order. Is there a way to make it so that as you type their name into the field there is a list or a drop down menu of the existing customers in the database? ![Screen Shot 2022-06-15 at 10.11.42 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/36031fbca9f43b7d16faace40cc841ea0a4c82ca.png)| 1. Customer walks in 2. Employee asks for customers name 3. Employee types down customer name into that field to generate a new order Instead of depending on the employee to spell the name perfectly, it would be cool to have a drop down of existing customer that he picks from, hopefully that made sense! Thanks team ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 15, 2022, 3:36pm UTC](https://community.glideapps.com/t/search-for-users-then-add-them-into-a-form/43100/2 "2022-06-15T15:36:05Z")
Yes, it’s possible. At a high level, this is what you need to do: - The text input component that you have should be directed at a user specific text column - You then need a single value column in your Customers table that takes the value of that user specific column and applies it to all rows - Next is an if-then-else column in your customers table: – If Customer Name includes Single Value, then true - Then back on your screen, add an Inline List component that uses your Customers table as a source, and filter it where the if-then-else column `is checked` - Finally, create a custom action on your Inline List that opens the form and pre-populates the Customer name and/or whatever other customer details are needed. ---
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 15, 2022, 11:16pm UTC](https://community.glideapps.com/t/search-for-users-then-add-them-into-a-form/43100/3 "2022-06-15T23:16:23Z")
You are a genius my friend, I was stuck on this for such a long time. Right now the app only shows the customer that is typed, which is awesome. The only part i’m stuck on is this part > [@Darren\_Murphy](#): > > Finally, create a custom action on your Inline List that opens the form and pre-populates the Customer name and/or whatever other customer details are needed. Not sure what you mean/how to do that exactly (sorry I’m a noob). Because right now the list populates if & only if the customer name is spelled perfectly, I’m guessing that last part I quoted from you would fix that problem? ![Screen Shot 2022-06-15 at 7.25.59 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/9005887dc433d22ab80a53a14506e3e3d29a1dd1.png) ![Screen Shot 2022-06-15 at 7.26.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f09f3d430315a57539f2b4e067eadd6fc5883c49.png) ![Screen Shot 2022-06-15 at 7.27.28 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/1390b4523b6b93d456976c78cb77e7e8796143f2.png) Thank you ---
**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\ **Post date:** [June 15, 2022, 11:48pm UTC](https://community.glideapps.com/t/search-for-users-then-add-them-into-a-form/43100/4 "2022-06-15T23:48:06Z")
OHHH Sorry it’s all fixed now brother, I completely read this wrong \<3 > [@Darren\_Murphy](#): > > If Customer Name includes Single Value, then true You’re the best ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 16, 2022, 1:12am UTC](https://community.glideapps.com/t/search-for-users-then-add-them-into-a-form/43100/5 "2022-06-16T01:12:45Z")
Excellent, glad you got it working 👍 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 17, 2022, 1:13am UTC](https://community.glideapps.com/t/search-for-users-then-add-them-into-a-form/43100/6 "2022-06-17T01:13:04Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.