Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Encrypt columns with sensitive information

Solved
Jump to Solution
3641 5
cancel
Showing results for 
Search instead for 
Did you mean: 
F_H
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey :slightly_smiling_face:

I would like to save sensitive information in AirTable.
Do you know a way to encrypt columns?

Thank you,
Frank

2 Solutions

Accepted Solutions
Dimitris_Goudis
10 - Mercury
10 - Mercury

Hi @F_H ,

how exactly do you want to encrypt those information? Do you mean to replace the data and keep the internal values or make a completed replacement ?

Thanks

See Solution in Thread

kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

If you want to store sensitive data in Airtable, please do so with extreme caution.

Every collaborator on the base, even read-only collaborators, can do all of the following without your knowledge or notification:

  • view all the data in the entire base
  • duplicate all the data in the base
  • share all the data in the base with someone else

Airtable does not have any native method of encrypting data. It is possible to use a custom script to encrypt data. However, keep in mind that if the data was stored in a record at any point, the original data is still visible in the record history.

You could use a script to input data, have the script encrypt the data, then have the script store the encrypted data in a record. However, that encrypted data is not particularly useful. If the base includes a system to unencrypt the data, everyone with access to the base can unencrypt the data.

See Solution in Thread

5 Replies 5
Dimitris_Goudis
10 - Mercury
10 - Mercury

Hi @F_H ,

how exactly do you want to encrypt those information? Do you mean to replace the data and keep the internal values or make a completed replacement ?

Thanks

F_H
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi @Dimitris_Goudis ,

I would like to make complete replacements.
In the best way AirTable should not see the real data at all.

Thanks

Dimitris_Goudis
10 - Mercury
10 - Mercury

Sorry for my second question. Do you plan use those data after replacement? or will you keep them in encrypted version?

kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

If you want to store sensitive data in Airtable, please do so with extreme caution.

Every collaborator on the base, even read-only collaborators, can do all of the following without your knowledge or notification:

  • view all the data in the entire base
  • duplicate all the data in the base
  • share all the data in the base with someone else

Airtable does not have any native method of encrypting data. It is possible to use a custom script to encrypt data. However, keep in mind that if the data was stored in a record at any point, the original data is still visible in the record history.

You could use a script to input data, have the script encrypt the data, then have the script store the encrypted data in a record. However, that encrypted data is not particularly useful. If the base includes a system to unencrypt the data, everyone with access to the base can unencrypt the data.

F_H
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you very much for your help :slightly_smiling_face: