Drop down of unique values

Baserow Help
1

Hi,

New to the world of Baserow, and am stuck as to whether this is going to be possible or not…

I want to use the Application Builder to create a tool where users can see the data they have already submitted. For example I have a table with 100 entries, previously submitted by 10 people. On a homepage I would like them to be able to choose their email, and then to subsequently display a table with just their already submitted data. But not by just giving them access to the data table, as that would enable them to see everyone else’s data.

I was hoping to use a drop down for them to select their email, have tried it out but there doesn’t look to be anyway of showing unique values in the drop down.

Am I missing something?

Thanks

P.S. Apologies in advance if this is a total newbie question!

2

Hey @david.r, currently it’s possible to authenticate users with the login element. You can then adjust the visibility of elements based on the user authentication. Here’s a video tutorial on this topic: https://youtu.be/SRBOZhgz1qs?si=pXzG8yPBRgQkHOLT

3

Thank you, that could work.

Anyway of doing it with just a username e.g email address?

We are self hosting, restricted to internal IP only, so authentication less of an issue.

4

No, the login element won’t work for this. You’ll need to add both an email and password field.

5

Thanks for clarifying.

Any other way you can think of?

Is it the lack of a unique filter that is the problem to do it another way? If so I might dig deeper and look at working directly with the database on the backend.

6

@frederikdc could you please jump in and advise if there are any alternative ways?

7

Hi,

There are multiple possibilities here. I would suggest that you work with 2 pages at this moment:

  • Page 1: contains a table or Choice element with all the users. Provide a button in the table, or next to the choice element to go to the second page
  • Pass the unique e-mail address of the user as a text parameter to that second page (check https://www.youtube.com/watch?v=LyWLJ5E15Qo for more info about parameters)
  • Create a data source on that second page that gets all the records for the users with that e-mail address. If you have a table with users, you can also refer to their id instead of e-mail / username.
  • Show this data source in a table element.

I know it is more user friendly to have this in one page where the page refreshes when you select a different value from the choice element. This is a feature that we are working on and will be part in one of the upcoming releases.

1 Like
8

Thanks very much - that sounds a good route forward.

Will work with that and see how I go.

Thanks again.