Hey, thanks for sharing your app with us Regarding the 1st point, you can enable action buttons in your app so that the users can add their own records to a table/list block and filter the data based on their added records. Also, you should use conditional filters to allow the logged-in users to see their added records only.
Regarding the plugin, I am not aware of any such plugins, but let’s see what the community will advise.
1/ So they could theoretically choose to view either 1) the public database or 2) their private database (only records they have added)?
2/ When they add a record, does it get added to my airtable base with some associated value to show that they added it i.e. their email?
Because my app works such that I load data from airtable and use that to generate a response - currently all the records. But I want to add a feature where a user could choose to see a response only based on their records.
So if the user-added record goes into my airtable base, with their email somewhere in the base, I can make a system to load a response based only their data.
If you consider block content as a database, then, yes, your users can see the block content that belongs to them and/or the public content. This should be decided by you, as the website admin when building your use case.
When a user adds a record to the dynamic block, it gets added to the data source you, as the website admin, linked to that block. If you need to know who added the records, then, you will need to configure hidden fields to collect the logged-in user emails who added new records.
All in all, you definitely can have a table/list block for each of your users to show them their own records by using conditional filters (as I mentioned above).
I’ve now made this work. I think the issue was that I wasn’t logging in correctly via the sign up form (perhaps related to a separate bug).
The issue now is that I’d ideally like users to be able to submit a record, and to create their own inline filters. For example, my use case is that users should be able to add their own quotes, as well as who said them, and their theme. So they should fill in person/ theme, and that then becomes an inline filter.
I currently don’t think that’s possible? They can either select from a dropdown that is linked to source, but can’t add to it.
thanks so much. but my issue is no longer allowing public vs private database.
now my issue is that although users can indeed add their own records and they can view only the records that they have viewed…
when they add a record, the filters that they use are not auto updated. e.g. a user might add a quote by Elon Musk. so they add the quote, the source, the URL etc. but then when they go through the records they don’t see quotes by elon musk because the filters are not updated.