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?
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.