Nov 05, 2023 08:30 AM
Hi Community!
We have the employee information on our Airtable.
Also, we have some forms that they can submit, for example leave requests or overtime requests.
It would be nice that they can see their own records they submitted in the past but it would be anooying to create one interface for each employee.
Using the thrid party like Stacker might be the best option but we are wondering if there is any best way that they can see their responses for just their own somehow.
We have different bases for Emplyee information and Leave request form/record but they are connected.
Thank you,
Nov 05, 2023 09:54 AM - edited Nov 05, 2023 09:55 AM
If they are all Airtable users, you can just create one interface, and filter that interface to only show them their own records.
If you would like to go down the path of an external portal app, I would not personally recommend Stacker.
My favorite portal tool for Airtable is Noloco, but there are other portal tools for Airtable as well, such as Softr, JetAdmin, and Glide.
I give a brief tutorial of Noloco on this episode of the BuiltOnAir podcast.
And I also presented a full one-hour webinar on Noloco called Building a Client Portal on Noloco powered by Airtable.
p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
Apr 22, 2024 01:29 AM
Try Softr 🙂
We have a vacation-tracker template with user groups and access levels, a leave request form: https://www.softr.io/templates/vacation-tracker
Sep 13, 2024 10:51 AM
Hi @takafumi !
miniExtensions has exactly what you need!
Your use case is actually a perfect match for our Portal extension, which allows users to log in using data you specify in Airtable (for example username/password or email with email verification, but any combination of fields works!) and then see all records linked to them in the tables you want to show.
You would only need to create one Portal for the entire team, since each of them would only see what's linked to them. They can, of course, also create new records straight from the Portal as well! As mentioned, you get to choose which tables you present to your users, so you could a single Portal for many different things at the same time, for example leave requests, overtime requests, registrations for company events, internal support tickets and even their day-to-day work, provided you're using Airtable for that as well 🙂 Each table is simply represented as a separate tab that users can switch between!
Feel free to let me know if you have any questions about this. I'd be happy to answer them for you!