Storing users in a base

[chetem]

Hey guys, I’m pretty new to Airtable but it looks extremely powerful and I’m pretty excited about what it can do.

I do have one question though – is there any way to store Users in a base? In particular, I’m asking about users that would need to log in to a website so there would be a password field. From what I can see, there’s no way to hide the contents of a field and I don’t think storing a password in a base would be secure enough.

Does anyone know much about this or any workarounds? Thanks!

[Mac]

You can hide fields.

Airtable - Support

Guide to hiding fields and field visibility

One of the core features of views is the ability to hide specified fields (columns, in grid views). When a field is hidden, it is not deleted and none of the values in that field are affected—it's ...

[Jeremy_Oglesby]

I’m not entirely sure what your need is for storing user passwords, but I would say no, Airtable is not secure enough for that.

Some web applications that have to store user passwords use a process called hashing to store the passwords in an unrecognizable form, and then use that same process to check user input against the hashed password when a user logs in.

Unless you are writing a hashing algorithm into a formula field, and then deleting the users raw password once it is hashed, you don’t want to store user passwords that could present a security issue in Airtable.

[chetem]

Thanks @Jeremy_Oglesby. That’s what I was thinking too about it not be securing enough and wasn’t sure if there were any workarounds available. It seems like Airtable can do just about everything for managing content for a web app except for User management. Thanks for your reply.

[Elias_Gomez_Sai]

You can also check this:

Airtable - Support

Airtable security practices

Maintaining the security and privacy of our customers' data is our utmost concern at Airtable -- our success and credibility depend on it. All data you enter into Airtable remains yours, and we are...

[Shubha_CHAKRAVA]

Yeah I already read this but it doesn’t address the first question. I am also trying to simplify things to just the Airtable app and all I need is a user management capability. Does the community have any simple suggestions (read, suitable for a noob) to help with that? Thanks for any help!

[Enrique_Torrebl]

Hi, I use php to integrate Airtable as a database. You can use a hash function like md5 or other more secure functions in your backend code and then save that value (nonsense string of characters) in Airtable.

[Dennis_Layden]

Would love a tut on that

[Itera_Consultor]

chetem:

oo about it not be securing enough and wasn’t sure if there were any workarounds available. It seems like Airtable can do just about everything for managing content for a web app except for User management. Thanks for your reply.

This guide might help:

https://chinarajames.com/user-database-with-airtable-part-1/