# How can I search in form **URL:** \ **Category:** Ask for Help\ **Created:** [May 25, 2023, 9:41am UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132 "2023-05-25T09:41:06Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [May 25, 2023, 9:41am UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/1 "2023-05-25T09:41:06Z")
I have a table in which I have saved subscriber data. I created a button on my site, When a visitor wants to request a maintenance service, a form will appear to enter data. One of the fields is to check if he has a membership with us. If he does not have a membership, an error will appear before the request is sent How can I search for his membership before click submit? ---
**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:** [May 25, 2023, 9:45am UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/2 "2023-05-25T09:45:36Z")
Am I correct in assuming that the visitor will not be signed in to the App at this time? If that’s the case, you would need to use a custom form so that the membership ID that they enter will be stored in a User Specific Column. You can then use that to check against your subscriber table and take appropriate action. ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [May 25, 2023, 10:04am UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/3 "2023-05-25T10:04:02Z")
Yes, the site does not require visitors to log in. Could you explain how I can use a custom form Thank you very much ---
**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:** [May 25, 2023, 10:16am UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/4 "2023-05-25T10:16:46Z")
You could do something like this: - Create a table with a single row, and use this as the source of your screen - Add a RowID column, and a User Specific column for each of your form inputs - The first one will be for the MembershipID. Create a relation column that matches this with your Subscribers table. As long as this relation remains empty, that means they haven’t entered a valid ID. - Add your input components to the screen. For all of the components other than the Membership ID one, you can use the state of the relation column as a visibility condition. ie. only visible when the relation is not empty. - Add a button to the screen. Configure an action on the button that adds a row to the appropriate table, using the values in the user specific columns as inputs. ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [May 25, 2023, 11:24am UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/5 "2023-05-25T11:24:50Z")
Thanks for all you give me, I didn’t find a solution according to your explanation. I’ll try again. If there is a video explaining something close to this I would appreciate it. ---
**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:** [May 25, 2023, 11:26am UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/6 "2023-05-25T11:26:45Z")
If you can show me what you have so far, and where you got stuck, I might be able to guide you to get it working. ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [May 25, 2023, 12:08pm UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/7 "2023-05-25T12:08:00Z")
Yes, it has been successfully completed. Sorry, I thought I would implement the above points in the form screen ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [May 25, 2023, 12:10pm UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/8 "2023-05-25T12:10:15Z")
I have one last question left: How do I empty the existing row in the table used for the source? ---
**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:** [May 25, 2023, 12:18pm UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/9 "2023-05-25T12:18:31Z")
Let’s imagine that you have a button that is used to navigate to that screen. What you can do is modify the action on that button so that it first uses a Set Column Values action to clear all values before it opens the screen. ---
**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:** [May 26, 2023, 12:18pm UTC](https://community.glideapps.com/t/how-can-i-search-in-form/62132/10 "2023-05-26T12:18:41Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.