Solved

New to airtable, how do I auto populate the current date to every new record that is created? Thank you!

Would appreciate some help on IF statements: I have a field for “WEIGHT” and another for “WEIGHT RANGE”. I would like user to enter his/her weight and need a formula to yield the weight range. eg 42 >> 40-45 48>> 46-50 52>> 51-55 56>> 56-60 63>> 61-65 69>> 66-70 Would there be better alternatives using AND or SWITCH or anything else? Thank you.

I’m trying to update an existing record by adding an attachment with a url that points to a remote jpg file. I’m getting the error “INVALID_ATTACHMENT_OBJECT”, which is not very helpful. curl -v -X PATCH https://api.airtable.com/v0/applxOrnAao5mXXXfek/Table%201 -H “Authorization: Bearer xxx” -H “Content-Type: application/json” –data ‘{ “records”: [ { “id”: “recySiYkz0crwyS5P”, “fields”: { “Notes”: “testing 1”, “Attachments”: [ { “id”: “1”, “size”: 26317, “url”: “https://www.filepicker.io/api/file/5YTJXioCQG0tYWPw6OPw”, “type”: “image/jpeg” } ] } } ] }’ I’m relatively new to the API so perhaps it’s something I’ve overlooked. Thanks

How can my Virtual Assistant update our Contacts table? How can my photographer add pictures to our Products Table? How can my Marketing Agency add notes to our Campaigns table? A read only link and/or a form is not “collaboration.” Giving 3rd parties access to my my entire base is not efficient or safe. Please tell me there’s another option!

Hello, I would like to use airtable for social media management and scheduling with someone else. It would just be between two people. Myself and another. For example, Person 1 - Uploads attachments/documents/images/resources Person 2 - Schedules and organizes the content for the week Person 1 - Can review and enter (text/copy/“caption”) where needed, as well as leave notes revisons Is a Pro plan needed for this? and if so, would BOTH of us need to pay for a pro account? Thanks in advance, I’ve searched high and low for an answer for this, even watched a few videos, and I’m still not 100% confident that I understand.

Hi! I have two tables in my airtable - one has a list of providers, and the other table has contacts for that provider. There are often multiple rows for contacts (because one provider has multiple contacts. I have copied and pasted the data from Excel. In my provider table I created a linked column to link to the contact table. I expect to see two entries in that column most of the time. I’m copying the provider name (first column) into that column, and the provider name is also the first column of the contact table. However I only see one instance - it’s just picking the first row from the contact table. I can go into each cell and search for and select the second instance, that works fine! I’ve also tried copying and pasting the provider name twice, comma separated, but that didn’t work. It still just picks the first instance. Any ideas how I can do this not manually?

New user here, how do you set up an automation to move completed projects from a main view tab to a completed tab?

Hi Airtable Community, I have created several Page Designer apps that have been working great for months. Generating these one-page PDF documents which must be signed by our consultants with a quick turn-around has been a huge timesaver for us and we rely on them completely. We have several different versions depending upon some of the verbiage that is needed. We use Print -> Save as PDF to generate the documents needed. A member of my team just reached out to me because one of the Page Designer apps is suddenly freezing when they hit the Print button. I tested this with multiple records to ensure the problem is not just one record, and I tested other Page Designer apps that we have to see if the problem is the app itself. It does appear to be this specific Page Designer app. I also make a copy of the app in the hopes that whatever the issue is won’t be propagated, but the copy had the same issue. It freezes when you hit Print. To my knowledge, none of the Page Designer apps ha

Hi there! I am needing help to add ONE layer to this IF formula. It’s for an invoicing tracking base. Overall, we are looking at 2 columns. I found this super epic IF Formula here on the forum and need help. The OUTCOME: *This first part I need help with - If the Paid Date exists = PAID (the rest, the formula I have works) If the Invoice Due Date is same day = DUE TODAY If the Invoice Due Date is within 5 days = PENDING If the Invoice Due Date is 5+ days = UPCOMING If the Invoice Due Date is past = PAST DUE Here is a pic of the columns I am working with Here is the formula I am working with, I am fairly sure I need to change the first layer?? IF ( {Due}="", “Not Set”, IF( AND( DATETIME_DIFF({Due},TODAY(),‘hours’) >= 12, DATETIME_DIFF({Due},TODAY(),’days’) <= 5 ), “Due Soon”, IF( IS_BEFORE({Due},TODAY()), “Past Due”, IF ( IS_SAME({Due},TODAY()), “Due Today”, “Upcoming” ) ) ) ) Thank you in advance for your GENIUS!!

Hi, I have a field with 3 drop down statuses. One of them is ‘needs review’. I want to setup an automation so that when a date is met, the status of the relevant field is changed to ‘needs review’. The question is, what is the ID of the record I want to update? When I choose the ‘review status’ field, the options I see are ID, name and color. Is it ID or name? I’m not trying to change the name of the field. I’m trying to update the status of the record.

Hey there, trying to get an IF/THEN statement correct here. It’s a donation database. Each donation is linked to a Donor Account and a Campaign. In my Donor Accounts tab, I’m using a lookup field to determine which Campaigns each donor has donated through. In another column, I’d like it to populate “Yes” if the donor has already given/is tagged to a particular campaign, “No” if they haven’t. Thoughts?

I’m currently trying to clone one airtable into a different airtable. When I run my code, I eventually get timed out after copying anywhere from 100 - 700 rows. Is there anything I can do to ensure I don’t get disconnected to airtable. ‘’’ await airTS(‘Applicants’).select({ // Selecting the first 3 records in Students: maxRecords: maxRecords, view: “All applicants” }).eachPage(async function page(records, fetchNextPage) { await records.map(async function(record, count) { var keyValue = count.toString(); //each page resets count to 0, so count is 0-99 if (pageCount > 0) { keyValue = (pageCount*100+count).toString(); } // GCP Storage CODE const bucket = storage.bucket(bucketname); var theURL = record.get('Resume'); var bigtableResumeURL; if (theURL) { theURL = theURL[0]['url']; //create unique file name for gcp on storage and bigtable var lastPartOfFileName = theURL.substring(theURL.lastIndexOf("/") + 1);

I wonder if somebody familiar with Integromat can tell me if this can be done. I have a workflow starting with Airtable Watch Records module → Airtable Retrieve Record module ->… While this works OK, I don’t have many credits left at the end of the month with so many workflows I have running. I tested using Integromat iOS/Android app and it seems it doesn’t consume credits for stand-by operation, it just consumes the credits when the workflow is running. So I would prefer to run the workflow manually from the mobile device. It’s actually convenient. However, while most other workflows work that way, I can’t get it work with Airtable. Seems the Airtable Watch module is required, because otherwise, how would Airtable Retrieve Record module know what record to retrieve. Or is there any way to get around it? What I want is to launch the Integromat workflow from mobile. The issue is I can’t get the Android/iOS module connected with Airtable Watch module. This may be more or less questio

Hi! Is there a listener or hook to watch specific app lifecycle events? The main use-case we’re looking for is when the app gets uninstalled (aka deleted). Haven’t found any relevant info in the Blocks API. Thanks!

Hello! Is there any way to share the org chart block? I would like to share an interactive org chart with my company. Thank you!

I have a scripting block that, for each record R in a given table, pulls a bunch of data from a different table, calculates a number N, and updates a field F for that R. The problem is some records are updated and others are not. I know that records are being pulled correctly as I print N for every R and it all calculates correctly. I know that the update code works as some records will update. One interesting thing to note: the updated R I think are all old and the non-updating ones were recently added. I thought this might have been a Free/Plus/Pro account issue as only Pro supports Apps and maybe older records were grandfathered but I have paid for Pro and still no go. Is this a permissions issue? By the way, are apps the same as scripting blocks or different? Code in question below: let table = base.getTable(BaseSpecificNames.cashFlowTable); let view = table.getView(BaseSpecificNames.sortedView); let query = await view.selectRecordsAsync(); let filtered = query.records; let dtab

Hey People, i`m facing a problem i cant solve :frowning: I want to calculate Taxes in my Base. Ive got a checkbox called - SOLD A base which is called - Bought from Private (BFP) A Base called - Kommission A field which hold the SALES A Field which hold the amount of the kommission A Field which hold the amount how much i paid for the article. So i want to do this: IF(SOLD, AND (BFP) -> calculate (SALES-Bought for)/11919, IF(SOLD, AND KOMMISSION -> calculate (SALES-KOMMISSION)/11919) I cant find a solution to make the formulawork … Thank you very much!!!

I was supposed to be charged with 13$ & as soon as I put my card you charged me with 3 transactions, 520$, 45$ & 48$. That’s 613$ I need my transactions back now please.

Hi All, So I am trying to create a new record in Airtable using google app script. I have been using the API documentation and reading the forum but can’t seem to get it to work. Any help would be much appreciated. Thank you. Code snippet var baseKey = 'XXX'; var airtableAPIKey = 'XXX'; var airtableAPIEndpoint = 'https://api.airtable.com/v0/'; var tableName = 'Table 3'; var payload = { "records": [ {"fields": { "Name": "Jeff", "Date": "2020-11-15", "Status": "Done" }} ] }; function AirPost(baseKey, tableName, payload) { var options = { method: 'POST', headers: { 'Authorization ': 'Bearer ' + airtableAPIKey, 'Content-Type ' : 'application/json' }, payload : JSON.stringify(payload), muteHttpExceptions : true }; var response = UrlFetchApp.fetch(airtableAPIEndpoint + baseKey + "/" + encodeURIComponent(tableName), options).getContentText(); return(response); }

Hi all, I’m working with a set of formulas for calculating a page count estimate for transcription based on length of audio recording, and then based on that page estimate, calculating a price based on a per-page and copy rate. Here’s the formula I’m working with for the page estimate: ({Recording Length}/3600)*50 And the formula for calculating the price is: ({Page Estimate}{Job Rate})+(({Page Estimate}{Additional Copies})*{Copy Rate}) The problem I’m having is that even though the {Page Estimate} field is set to be a whole number integer and displays as such, when the {Page Estimate} field is used in the price calculation, it’s not using the rounded integer but the precise decimal amount. For example, the page estimate is 233.666, rounded to 234 as a whole integer. But instead of calculating 234 * {Job Rate}, it’s using 233.66666 * {Job Rate}. Thanks for any ideas to solve this!

Is there a way to see the history of view configurations? I have a view which had multiple settings and someone in my team must have re-configured it with realizing it was an important view. It was set up 3 years ago and I cannot recall all the settings I had in place. I need to revert it to previous settings, but do not believe this is possible in Airtable.

Hello everyone, I’m currently failing on something pretty easy to solve I think. I’d like to create an automation that will send an email when a record matches certains conditions. I also want this email to contain an attachment that is always the same (PDF file), that is not in my airtable. I cannot find any easy solution. Does someone have one ? Thank you Franck

I made this nested structure of linked tables: 1. Annual Goals 1.1. Quarterly Goals 1.1.1. Monthly Goals 1.1.1.1. Weekly/ Daily I expected that I could add an item to any linked table field, and the item would inherit all its up level links: For example: While in the Annual Goals table I made these entries: Annual Goal called “99 Annual Goal item”. Then (in the linked Quarterly Goal tables’ field ), I created it’s … Quarterly Goal –“99’s quarterly goal made at Annual Goals table”. Then (in the linked Monthly Goal field ), I created it’s … Monthly Goal - “99’s monthly goal made at Annual Goals table”. Then (in the linked Weekly/ Daily field ), I created it’s … Weekly/ Daily task- “99’s weekly/daily goal made at Annual Goals table” Here is the grid view- and it looks great: It’s even more (deceptively!) implied (or mis-inferred by me…) in a nested view: What am I misunderstanding here? How can I achieve what I want?: I add an item to any linked table field, and the item

Hi, Here is what I would like to do. I have a table T. This table has 3 views: TV1, TV2 and TV3. I know I can share publicly any of these views. But what I would like to share TV2 (and TV2 only) with joe@email.com. That means Joe needs an airtable account to access TV2. Is it possible? Thank you.

Hello Community, Trying to create my first Airtable App by following the Hello World example and running into a number of npm errors and issues. If anyone can provide a bit of guidance on how to resolve this it would be greatly appreciated! The first error occurs when trying to run ➜ Airtable npm install -g @airtable/blocks-cli npm WARN deprecated urix@0.1.0: P npm WARN deprecated resolve-url@0.2.1: npm WARN deprecated fsevents@1.2.13: fsevents 1 will break on node v14+ and could be using insecure binaries. Upgrade to fsevents 2. npm WARN deprecated chokidar@2.1.8: Chokidar 2 will break on node v14+. Upgrade to chokidar 3 with 15x less dependencies. npm WARN deprecated fsevents@1.2.13: fsevents 1 will break on node v14+ and could be using insecure binaries. Upgrade to fsevents 2. npm WARN deprecated chokidar@2.1.8: Chokidar 2 will break on node v14+. Upgrade to chokidar 3 with 15x less dependencies. npm ERR! code ENOENT npm ERR! syscall chmod npm ERR! path /usr/local/lib/node_modules/