Solved

Is there a formula where I can convert a date in a date field to a string of numbers? For example, for today (2020-11-20) I would like it to return “201120”

Hi all!! I have a list of participants in a project, but as this list of participants is a lookup from several tasks linked to the project, it has duplicated items. I want to count the number of unique participants. I’ve tried transforming this list of participants into a string, I know how to count the number of participants in that string but I need to remove the duplicates. Does anybody know how to remove duplicates from a string? I know how to remove completely a participant from the string (using SUBSTITUTE), but I don’t know how to make it appear only once. SUBSTITUTE({Participants}, Find, “”) (Find is the name of the table with the name of the participant I want to remove) Thanks in advance!!!

I’m not sure the best way to ask this question, but here goes! I have the following formula… Model & " " & VAR_Color & " " & VAR_Type & " " & VAR_Weight_Name & " " & VAR_GRIP_Circumference Some of my “Models” are missing one or several of the VAR (fields) and when that happens I’m left with a double or even triple space. I want to concatenate the formula in such a way that IF a field/VAR is empty that the VAR and the space in front of it are omitted, but if a VAR exists, then the VAR and the space in front of it are displayed. Thanks in advance for any advice on how to revise/simplify this formula!

I need a formula to round seconds to the closest 15 second mark in the hh:mm:ss time format… i.e. say 1:01:10 needs to be rounded to 1:01:15 , say 0:34:20 rounded to 0:34:30, say 1:02:55 to 1:03:00 Hope someone can help as in excel I can use the MROUND formula but this is not in Airtable.

I hope that this is not a topic that has been answered already but in my searching what I found is that there are several ways to filter out empty fields but in my use case I want to keep the records that are empty in certain fields. I have had success using NOT({Field Name} = " ") and some success using IF and SEARCH in various forms but they are all getting rid of the fields that are empty rather than keeping the ones that are empty. For clarity’s sake let’s say the records have a likes icecream and the people who don’t like icecream have nothing in that field. I want to be able to filter out the ones that do have something and keep only the ones that don’t. If anyone has any suggestions it would help a lot (also I am doing this via API).

Hi ! With Zapier or Airtable Automations, I can trigger a certain mail to be sent when a record is added in a view or met a condition. However with Sendgrid Block, that seems impossible, I’ve been testing different things for hours ! Any idea? Many thanks

I want to calculate a deadline that is 30 days prior an App Release date for daily content. But I also want a deadline that is 60 days after the App Release for project types that are not daily. The 1st step of my goal works correctly with this formula… DATEADD({App Release (from Master List)}, -30, ‘days’) Here is an IF statement attempt to include the 60 day delay for all other content that does not work. What am I doing wrong? IF ({Project Type (from Master List)} = “DAILY Meditation”), DATEADD({App Release (from Master List)}, -30, ‘days’), DATEADD({App Release (from Master List)}, +60, ‘days’)

I am trying to build an external web app through either Pory or Softr, but my API key seems to have stopped working (I keep getting an invalid key error). Does any one know how to fix this? I’d hate to delete my current API key (I currently have some forms live on my site through Mini Extensions and it would break that connection (although it would be relatively easy to re-do…just not sure deleting/re-generating would really solve this problem - there’s no reason it should have stopped working in the first place). Any ideas? Thanks in advance!

Hi All, Simple one but I’m a but stuck… so it’s ask questions time. As per above I’m trying to convert the simple 24 hr formatted column into JUST a h:mmA format. My formula is: DATETIME_PARSE({Confirmed Time - 24 Hr}, “h:mmA”) How do I stop it showing the date portion (11/19/2020) in my result? EDIT: Here are my full fields. Ultimately I’d love to create a single output that combines ‘Confirmed Meeting …’ with ‘Confirmed Time - h:mmA’ (eg November 19, 2020 at 2:00pm) that can be used in as a simple trigger in a Send Email automation on Airtable… I’m just getting my head and logic brain around Airtable though.

This is the formula i am using to manually override my default date entry IF({Date Override Entry} = BLANK(),{Default Mixed Date}, {Date Override Entry}) i attached a screen shot that shows the result that i am getting. It returns a result that is a day off and i am not sure i am not sure why. Thanks in advance any help it is much appreciated. :pray: Screen Shot 2020-11-21 at 11.57.57 AM|700x308

Hi I am not sure it is an IF formula or a switch formula that I need but I cannot work this one our for love nor money. So I am trying to write a complex risk assessment and within it is a simple single select column where my options are Improbable Remote Possible Probable Almost Certain What I was hoping to do is have a column next to it that converts the different options into numbers 1-5 (which I would then hide but use in calculations.) There are lots of different versions of this within the base but for the life of me I cannot work out how to take the select options and get it to return a number am I going crazy? Any help greatfully recieved xx

Per the title. Is this a bug? If so, is there an ETA for a fix? Is there a workaround?

I’m trying to automatically name experiments based on the user that performs them. The numbering is sequential. However, I want the numbering to relative to the user. Here is the formula I’m currently using: {Initials (from Owner)}&"_"&"EXP"&REPT( '0', 4-LEN( {Autonumber}&'' ) )& {Autonumber} The issue is, I want that next experiment (MP_EXP0005) to start at MP_EXP0001, rather than 5. Is there a way to do that with a formula?

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);