How can I search in form

Ask for Help
1

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?

2

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.

3

Yes, the site does not require visitors to log in.
Could you explain how I can use a custom form

Thank you very much

4

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.
2 Likes
5

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.

6

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.

7

Yes, it has been successfully completed.

Sorry, I thought I would implement the above points in the form screen

8

I have one last question left:
How do I empty the existing row in the table used for the source?

9

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.

2 Likes
10

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.