Solved

Hi there, I want to add a formula to result in a date. I have a delivery date column. and I want formula to calculate a date 7weeks (49 days) before the delivery date. I have this working in Excel & numbers, but copying the formula into Airtable does not work - results in NaN. Please may you help. Thank you, Sally

Hello I have converted an Excel spreadsheet into an Airtable base. In excel, I have columns that are formatted to show [month] & [weeknum] based on a date that is entered. Is this possible in Airtable? Kind regards, Sally

I have a table containing a PostCode column, and Address columns 1 to 6, all of type “single line text”. I wish to know which of the columns contains the PostCode and will use SWITCH(PostCode,Address1,1,Address2,2 …). However even when I can see which column contains the PostCode, let’s say Address3, a formula of PostCode = Address3 is returning false, when it should be true as they appear equal. Adding LEN() to both sides of the formula confirms they are the same expected length. The values I see in both columns appear identical. This behaviour is not the same in a table created with just these 2 columns and the values manually input. What differences in the values could there be that is not visible and how might the difference be eliminated?

I have a formula that’s doing what I want it to do. But I’d like the field {ACTUAL VALUE} to be currency formatted like {EST. VALUE} - I’d also like to get a SUM at the bottom of this column, so I need it to be a number. This is what I have so far. IF(STAGE="Executed", {EST. VALUE},"") What do I need to add? Thank you so much in advance.

Hi - please help, bit confused. I published a base up into the Airtable Universe (and luckily saved the link for it). If I search the Airtable Universe, I can’t find it anywhere. Any idea what’s going on? It’s a LinkedIn SSI Tracker (your Social Selling Index score on LinkedIn). The Universe base can be found here - but you cannot find / search for it via the Airtable Universe page. Any ideas? I’m presuming that nobody else can find / search for this? Here’s the direct link (to prove I’m not going mad :slightly_smiling_face: ). Airtable LinkedIn SSI tracker (Social Selling Index) - Airtable Universe Did you know that LinkedIn gives you a 'score' that determines how popular and visible you are on LinkedIn? It's called the Social Selling Index (SSI). If... It is real… but not searchable…

Hey, guys! I’m trying to add a column that return to me a specific message when attends some date criteria. Actually, I did the formula and it was working well: IF(AND(DAY({Final date})=DAY({Request date}),MONTH({Final date})=MONTH({Request date}),YEAR({Final date})=YEAR({Request date})),“ :warning: Warning”, IF({Final date}<{Request date},“ :red_circle: Wrong”,“ :white_check_mark: Right”)) But after some tests I noticed that something weird was happening How you can see, the first and the second line returned strange results… Is there something wrong with the formula? Thanks!

I have a base to keep track of the FESTIVAL PARTICIPATION of each of our FILMS. In table 1, I record the participation of each FILM on different festivals (which I pull from a FESTIVAL DB in table 2). This means that on table 1, on the first field {FILMS} film1, film2, film3 are recurrent values, appearing in as many records, as festivals where they get invited. In table 1, I include a text field named {SOCIAL MEDIA} where I include the film’s social media related profiles and hashtags. I do that on the first occurrence of each film on a record. MY PROBLEM: I can’t figure out a way to either LOOKUP, ROLLUP, or find a FORMULA to reproduce the info I entered in {SOCIAL MEDIA} for a particular FILM X in a record to another record in the same table where FILM X appears. In my mind is like making an intra-table “related field” but I cannot figure out how to do it.! I made the image below to better explain what I need, in case I did not expressed myself clearly. airtable-1|700x268

I am attempting to create a simple script which will count the number of entries in a linked lookup field. My plan was to invoke .selectRecordAsync() on the table of interest to pull the records and count the number of entries for a given record in that field. I’ve run into an issue early on with this script: the selectRecordAsync call appears to only be returning the name field and Id for the records, but no other data. My code is below. let vendorTable=base.getTable("Vendors"); let quoteField=base.getTable("Vendors").getField("Quoted Parts") let records= await vendorTable.selectRecordsAsync() console.log(quoteField) console.log(records) let exampleValue=records[0].getCellValue(quoteField) console.log(exampleValue) I’m getting the following responses in the console. My table is structured as follows: The only issue I can think of off hand is that all of the fields (aside from name) are linked or lookup values. What am I missing here?

I have a base with a table full of tags that is used to tag different items along different dimensions. Each item can be tagged in alot of differnt categories. I’m trying to use airtable in conjunction with Bubble.io and it seems I’ll make life easier for myself if I rename the linked fields back in my tag table to something more meaningful rather than tablename 1, tablename 2, tablename 3… Is there a quick way to see what these field corresponds to, so I don’t have to toggle between tables and try to match up which tags are present where?

I wanna delete cells-value in Amount Field. I am referring to this↓ Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. but I can’t.参考にしています I wanna just all clear Amount field Value… help me. //get table let merchandiseTable = base.getTable("C_商品"); let fieldAmount = merchandiseTable.getField("amount"); let merchandises = await merchandiseTable.selectRecordsAsync(); let merchandise = merchandises.records; //console.log(merchandise); //Amaount-fields value to null while (merchandise.length > 0) { tmp

Hi, everyone. I’m wondering if there’s a way for me to adjust the date and time in the following format: [MM/DD/YYYY XX:XXpm] for Slack and Email. I can’t seem to do that in the automation box. Would I need to insert a formula or some other solution? Thanks.

I am trying uploading an image from webflow form to airtable using zapier. All the form data like name, email, etc are getting added to the table when I submit the form except for the attached image. The image column (Attachment) is always empty. So I tried manually add the image using the Link (URL) option and kept getting following error: “Error fetching URL metadata.” Following is the image URL generated by webflow: https://webflow.com/api/sites/3d-jobs-project/formUploads/8070822d-b223-4bfe-9d61-eab61d069dc4.png Any idea how to fix this?

Dear airtable community, i am looking for a function that: if a certain cell is modified, i get a value in a ‘last modified time’ field. after getting that, i want to know the work day difference between my ‘last modified time’ field and a ‘order date’ field. if the mentioned cell at first hasn’t been modified yet, i won’t get an return for the ‘last modified time’ field and so i want to have a blanc for the difference in work days. the function i was able to set up for now is: IF({found at},WORKDAY_DIFF({order date},{found at}, BLANK()) i’m aware of the fact that the point of formulating the conditon, isn’t fullfilled, but i have no idea what else to put there. if there’s an easier way of fullfilling my need than the if function, please. let me know :slightly_smiling_face: as always thanks in advance and stay safe guys

Not related to Airtable, but I wonder if anybody came across a service where I can push clickable URL address to. I created a dynamic URL formula to Airtable form with help of kuovonne’s Prefilled Forms. That URL changes and new URL is generated after the previous form was submitted. So now I am looking to upload upload that URL somewhere online where I can click it in a web browser. I am thinking Zapier or Integromat would watch changes in the field containing kuovonne’s changing URL and it would pick up the new URL and push it somewhere. Where … that I don’t know. I could setup twitter account for example and click the URL in the twitter feed. RSS could also work but I don’t want to display old URLs in the feed. I just want to show the latest version of the URL. However, I am looking for something simple, without need to open an app, something that would work without login, for example web-page and Zapier / Integromat would update that link there. Anybody knows anything like that? M

Hi folks, I am fairly new to the formula game and I’m working on a formula where I have 3 columns with dates {LOI Target}, {ETA to AMZ}, {Content Delivery Date} and i’ll need to calculate the latest date out of the three of these Add 7 days to the latest date Calculate to the next Tuesday input date correctly into column It’s a bit of a monster. Any help even in little pieces would be great. I’ve been wandering the forums looking for help and this one was the closest formula to one of my needs (latest date out of the 3 dates). So, is the following formula on the right track for what I want? I know that the MAX function doesn’t really bode well with dates but that’s about all I know. IF( OR( {LOI Target}, {ETA TO AMZ}, {Content Delivery Date} ), DATETIME_PARSE( MAX( IF({LOI Target}, VALUE(DATETIME_FORMAT({LOI Target},’MM/DD/YYYY’)), 999999999999999), IF({ETA to AMZ}, VALUE(DATETIME_FORMAT({ETA to AMZ},’MM/DD/YYYY’)), 999999999999999) ) , IF({Content Delivery Date}, VALUE(DATETIME_FORM

Hi, In my table I have a field where I want the expiration date of a contract be automátically calculated based on another date field (when the contract was signed) + 36 months duration period. The formula is as follows: DATEADD({signed}, 36, “months”) Most of our contracts are for 3 year periods, but because, we actually have some that are for one year, I thought I could create another number field where I could set as default the value “36” but eventually could change the number of months to “12”, for example. Now the new formula is: DATEADD({signed}, {contract duration}, “months”) PROBLEM: The date appearing in the signed field is June 20, 2015. In the first formula, the date that resulted was June 20, 2018 (signed date, 36 months later) The second formula however came June 19, 2018, a day earlier. I’ve tried with different month values. it always comes one day earlier. Any tips, suggestions, etc would be appreciated.

I’m on the free plan and when setting up an automation to send an email I get this error message: “On your billing plan, you may only email collaborators with verified emails. Contact your workspace administrator to upgrade.” However, the email address I’m putting in is my Airtable username and it has been verified. Any ideas on how to fix this?

Hi, I’m using the following formula in the column “is absent today”, but for some reason it isn’t correctly finding August 16th. I suspect this is because the linked “Absent” field is an array, which is why I included the &"" in my formula, but that didn’t fix it… IF(FIND({Today's Date},{Absent} & ""), 'Y', 'N')

Hey there I have a synced base that is pulling a “percentage” field from another base of mine. I am running a formula field on the lookup field, however it is giving me an #ERROR! as a result. I have tried using Value(), but nothing works…

Hi, Is there a way to ‘freeze’ a view so any newly created records don’t enter it. I’ve got to download a load of data from the table and run them through another software and then re-upload the results. I’m hoping i can just paste in the results but i new records enter the view that weren’t included in the original download then there might be a race condition. Thanks in advance

Hey everyone, Sorry if this has been asked before, I couldn’t find anything. I am still a beginner. My Problem is the following: IF({Laufzeit (Monate)}= BLANK(),"", DATEADD(Vertragsbeginn,{Laufzeit (Monate)},“Month”)) It works, but the result it is no longer shown as a date. I guess because it could either be a date or a text, it doesn’t recognize it. So what I want is to have an empty cell in case “Laufzeit (Monate)” ist empty and the calculated date as a date in case “Laufzeit (Monate)” is filled. Could anyone help?

Hi, I’m trying to set up a sheet to manage attendance for a preschool center. Kids have a different “weight” depending on their age, which I successfully set up. The weighting is used to determine how many kids we can have at once. What I now need to do is show a daily breakdown of those weights, because some children don’t attend preschool every day. I need a calendar where I can look at any given day and see how many total kids will be there. I’m trying to combine the weight formula with START and END date fields, but can’t make it work… Any advice is much appreciated!

I’ve got my PEOPLE and COMPANIES in separate sheets in one base. Cool. (Love it if we could link multiple bases!) I finally figured out I should link all their social media spheres into one sheet, too (so those entries don’t go on forevah!) Q: But how do I keep straight (i.e.: link) the many TITLES one person who wears a lot of hats may have with their variety of entitles? Example: A gal who’s the CEO of her own company but ALSO the VP of a joint venture/partnership, on the Board of a charity and maybe the President of a trade organization? Sure: I can reciprocally link her - as a person - to a variety of companies/entities (and of course, lots of peeps with one company) - I get that - but how do I keep all her various TITLES straight? So I know which title goes to which company - for the same person? A whole 'nuther “Titles” sheet? Like the Social Media sheet? Ugh. Better way? Beuller?

Record ID is not being detected by the automation tool. I need to change a status of a record when another record is created. But when I link them together it does not detect the ID and the error says the field is invalid. I have other automations done the same way. I am using “copy” tables so I don’t mess with my current data Flow wanted: The table that is going to be updated is “Control Modulos” When record is created in Cosecha → Change status of linked record to “Disponible” and then When record is created in Paso Modulo → Change status of linked record to “En operacion”

I have two tables: “Widgets”, “Sales”. A Sale record can reference one or more Widgets. When I create a new Sale record, I want the the “sold” field in the corresponding widget record(s) to be toggled. Sounds like this might be an Automation, but I’m new and not sure. Can someone please point me in the right direction? Thanks.