![]() These can be public channels, private channels, or even direct messages. Then select the channel you’d like to post your message to. If it’s your first time connecting Slack and Airtable, you’ll be prompted to log in with Slack. If you would like to take your airtable databases to the next level and you need help in automations, scripting or multi-base workflows, this is the best gig for you. Next, choose which Slack account your message will come from. Airtable is a very powerful & productive tool in the right hand and it can do a lot more than just a spreadsheet. But we’re going to send a Slack message, so click that link. You could create another record in Airtable, send an email from your Gmail account, create a Google Calendar invite. So, what do we want this automation to do? Again, your options are expansive. It might not seem like much, but we’ve already created a complex system that understands “when a record is created in the “Launches” table, it’s time to do… something.” Now, we just need to decide what. But remember, this could be just about anything-like new projects in your “Projects” table or new candidates in your “Hiring Pipeline” table.Īnd poof-there’s your trigger. Because this automation is all about launches, we know we’re going to pull from our “Launches” table. Next, pick the table from which you want to receive notifications when a record is created. maybe we just cloned some records with sync or automation ot “horizontal to vertical” table transfer.Remember: this automation will fire-and a Slack message will send-every single time the trigger occurs, so make sure it’s not something that happens too frequently! Now i doubt that “Airtable can detect such case”. The method of storing attachments in Airtable is a mystery for me again. And it’s not true, Airtable can detect such case and store only one file, with 10 links to it.īut when i tried to test it and uploaded to small table, 3 files repeatedly to 10 records in random order and number per 1 record (by usual upload through user GUI), i found that all of them has different link, none repeated. ![]() Now i did some utility to backup/restore attachments including small script to display size of all attachments in all tables, and discovered that their actual downloaded number and size less than expected by script (link to attachment contain 8-digit code, which i append to filename for restore purposes, so i supposed 10 similar files must have 10 downloaded “versions”). Then I changed it to ‘merge removing duplicates’ and discovered another problem because similar file in two different fields has different links, and defininition “same name=duplicate” is of course wrong. (tl dr: “it’s still unpredictale and unclear for me”)įew mothns ago i did automation script to merge attachments from branch to main and hit ‘duplicates issue’(when you merge main’1,2’ with branch’3,4’, you receive ‘1,2,3,4’, but after branch update record(4=>5) it will merge 3,5 to 1-4, and 3 became duplicate. I’ll report back once I see the final results from my test. Maybe it’s a similar 10- to 15-minute refresh frequency like so many other things. I want to see how that indicator changes when I delete the test record (and its attachment) along with record revision history, and I hope that I don’t have to wait a full day for that figure to refresh.Įdit: it just updated. The base where I’m running the test shows 6.9MB of attachments, but that only accounts for the existing attachments before the 112MB file that I just added. Does it affect the quota when record revision history is deleted? I’m running a test now to see for myself, but the stats on my workspace settings page aren’t refreshing as promptly as I’d hoped (and I’ve reloaded the page multiple times). I’ve not delved into the guts of revision history yet, but this discussion has piqued my interest, partly because I’m trying to help a client who has hit an attachment limit. Airtable has not published now long old, deleted attachments remain, but a reasonable guess is at least one year (the length of revision history) without manual intervention by support. ![]() Old deleted attachments are not automatically deleted by Airtable and continue to count towards your base’s quota.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |