HI @michaelmaghi - thanks for for the additional info. From the info you’ve provided, it sounds like you’re not expecting the patients to create an account in your app meaning each patient would not have their own unique username (their email address) and a password (ie they won’t show up as type “User” in the database).
You’re going to run in an issue when your app does the search for “Mary Jackson”. Bubble will be searching your database (Searching “List of patientss”) and if you have more than one Mary Jackson, Bubble will provide data on one of them (I’m 99% sure your app will return data on the first Mary Jackson it finds).
There are two ways to prevent this issue.
First is to have your patients create an account and login to get their info.
The second doesn’t require them to have an account. Instead you’d do a similar approach I outlined above but instead of sending “Current Page User’s link” you’d be sending the specific patient a “List of patients link” based on that specific “Mary Jackson”. And if you have N-number of “Mary Jackson” in your database, Bubble will create a unique link for each one of them. If you watch my video from above at the 13:45 mark you’ll see some examples of what these links would looks like
I suppose a third approach which also doesn’t require patients to create an account is to have a third input field which would be for a unique, random number created for each patient. They’d need to input that number in addition to their name to get access to their info. I mention it in the spirit of providing ideas - I don’t recommend this approach for a medical type of app such as yours.
Hopefully this info makes sense and helps.
One other thing. I’m not an expert in medical type of apps, but there’s been forum discussions on Bubble and HIPPA compliance. Here’s just one example: HIPPA Compliancy
If it’s relevant to your app, you probably want to do some research on building a medical type of app using Bubble and HIPPA compliance. Other forum members can give you their feedback.