Creating records hash in Airtable

[Cedric_Roux]

Hello there
I’d like to create the hash (md5, sha-1, whatever) or a concatenation of two text fields in an Airtable table.
I have absolutely no idea how to do that - while in Google script it’s super easy…
Does anyone have an idea please?
Thanks!
Best

[Bill_French]

Cedric_Roux:

create the hash (md5, sha-1, whatever) or a concatenation of two text fields

This is possible using the new Script Block (in beta at this moment). This would not be a lights-out process though.

I had to do something similar for a client some time ago and I used Google Apps Script and the Airtable API to constantly update any fields missing the hash. It runs every five minutes and pulls the fields for the computation, performs the hash output and then pushes the value into a long text field. It’s been running for more than two years flawlessly.

[Cedric_Roux]

OK thanks a lot, i’ll have a look at both options

[Matt_Beyer]

@Cedric_Roux did you ever find a solution to this? I have same requirement, hoping somebody figured out a solution already.

[ScottWorld]

You could either script this with JavaScript, or for a no-code way of doing this, you could automate this process with one of the hash functions offered by Integromat:

Integromat Support

String Functions

ascii (text; [remove diacritics]) Removes all non-ascii characters from a text string. ascii(Iěnštčeřgžrýoámíaét)= Integromat ascii(ěščřž;true)= escrz base64 (text) Transforms text to base64. bas...

(I’m a Registered Integromat Partner and Airtable consultant. If you need to hire someone to help you set this up, feel free to contact me through my website at scottworld.com.)

[Rose_Haft3]

How would you store the hash via createrecordasync? The push function stores the string as a list of “object”