Ask the Community

I am struggling to figure out an IF/THEN statement that includes an OR. Here is what I'm needing it to do.I want to say "If there is anything populated in Column A, I want it to pull it into Column C. And if there is anything populated in Column B, I want it to pull into Column C, as well." Here is my current formula       IF(OR({DMSID Formula},{EG DMSID Formula}),{DMSID Formula},{EG DMSID Formula}) This is pulling in "Column A" (DMSID Formula) into "Column C", but it is not pulling in "Column B" (EG DMSID Formula).  Any suggestions??? I appreciate any help that anyone can provide!

Hi,I would like a new field that tells me if a date has passed on an old field, called due date.So I would like the new field to say 'Yes' if the date has passed, 'No' if the date has not yet passed, and blank if no date provided.Going around in circles with this one so any help would be appreciated. Thank you!

@Bill.French @ScottWorld I have installed the maps extension and successfully set up a field with the static map API to generate a static map based on an address and populate an image of that map as an attachment in a field for each record. How do I get this to run automatically when a new record is created or a new record enters a specific view? I have tried using the script from the extension in a script automation triggered by an event (new record, record enters a view etc.) and it doesn’t like the script from the extension

Hello all – Is there yet a way to access (i.e. read/write/update) a record’s fly-out comments via the API? We have another app in which there are comments that we want to merge with the appropriate record’s comments in AT. If not, is it anywhere on the roadmap? It totally affects how we plan this integration. Thanks!

Hi - I use this formula to figure out when to follow up with applicants: DATEADD({Initial Email Sent}, 2, 'week') But I'd like to have it return a different result (1 week vs 2) when my applicants are getting fast-tracked. I tried this: DATEADD(  IF({Send Initial Email}, "Initial Email"{Initial Email Sent}, 2, 'week',"FastTrack Initial Email", 

 STATUS  (multi select)RETOUCHING STARTS (date)RETOUCHING FINISHES (date)IN RETOUCHING  DONE  What formula or automation can I use so that when I change "STATUS" to "IN RETOUCHING" a date is populated in "RETOUCHING STARTS" and when i change the "STATUS" to "DONE" a date is populated in "RETOUCHING FINISHES?"I can not use the last modified because I want the date to remain the same when I change the "STATUS" to "DONE."

I need some way to log (or view) records that have been recently commented on (by me, ideally, but by anyone is probably OK). I go through a base and look at my employee’s work, then ask her questions about it – need to find a way to follow up on those requests I sent via comment so I can see if they have been resolved. Open to some sort of automation/trigger/integration (zapier or whatever) but I can’t seem to find a way to make it happen. Is this possible? I know i could create a separate “comments” table and do it that way but I don’t want to. Thanks!

How can i auto-fill a linked field?i have 2 linked tables in Airtable: CONTENT and CONTENT TYPESIn the table CONTENT i have two linked fields CONTENT TYPE and WORKFLOW In CONTENT TYPES i have the two "originals" of CONTENT TYPE and WORKFLOW If i select in the CONTENT table the linked value CONTENT TYPE and this CONTENT TYPE has a DEFAULT WORKFLOW (i.e. cell is not empty) then the WORKFLOW field in CONTENT table should auto-populate with the DEFAULT WORKFLOW value.Basically only if there is a default workflow (cell not empty) of the Workflow column in the content type table, then this value should be auto-filled on a linked field in the CONTENT table. Hope this makes sense? I know this can be done with an automation inside airtable. but how?

Hello! I have a rollup column that looks fine in the original base, but when synced to another base some of the cells seems to add extra information.For example, in the original base, a cell in the column will say "Person A, Person B"In the synced base though, the same cell will say " , Person A, Person B" instead, as if there's a blank record ahead of the rest of the list.This doesn't affect all cells in the column, just some. Would someone know how to make the column behave correctly in the synced base?

Hi,I cant for the life of me find a formula to I have 3 date columns in each record, only one of these will be populated per record, i want to create an additional single column which would auto populate with the date from either of these 3 fields so i can format it to a week number (and YY of possible).Is this possible to do and if so can anyone help with the formulae for this please?Thank you so much, Sarah 🙂

Hello everyone! I'm a new member in the airtable community and wanted help on my airtable problems. I currently have a base table that receives emails, the problem currently is that it saves the whole email chain instead of just the email itself. I wanted to ask if there's a way (scripting/formula) to automatically remove  lines of texts after the word "From:" for every new entry that comes in.  Thank you!  

Hello Everybody, I am new to Airtable, would like to ask for a formula that shows me all records coming next month depending on a start date. in other words, I am sending this for operations people, and they want to see all their projects a month ahead. Can you guys help me with that?

Hi, I'm really new to Airtable. I was wondering if there was a way to add a button to make fields editable for the Record Detail template. Basically, I want to be able to edit and update the current record on the Record Detail.

I have a table and each record includes a name, address, email address, phone number, and relationship. The relationship field is single select, and it consists of parent, student, donor, alum, and staff. I want to generate a report that gathers all of the records that are students and creates a report of each student's name and email address. How can I do this?

Can someone please help - I’m not sure if a formula, rollup, lookup or another option is best for this scenario. In order to job cost correctly, I do not need the duplicates of the payment amount, as it will show more was paid. I see a way around this by adjusting the amount due, however, with multiple people entering data, and checks being cut differently, based on 3rd party financing department details of payment are not known until the check is cut, typically 30-days after the invoice is received. When a contractor submits an invoice and it is paid as a partial payment - I am currently entering the information twice to keep up with the accounting end, however, as you can see from the example below it looks as if there is still a balance due, when in fact the invoice is closed out with no balance. Thank you.

I use Airtable for my accounting program. My goal with this post is to discover how I can allocate specific and different values from one payment record to multiple linked invoice records. The intent is to provide an unpaid/open balance which is simply the invoice value less the APPLIED payment. Currently, I have only two tables set up for this base. I am wondering if having a third linked table to address the application of different amounts going from one payment record to multiple invoice records will solve my problem. Background: In my base, I have two linked tables. The Invoice table consists of invoice records. (In the Invoice table, one record = one invoice). The Payment table consists of payment records made against specific invoices or a specific invoice. (In the Payment table, one record = one payment). I link invoice record(s) to payment record(s). In the invoice record, I have a column that calculates the open/unpaid balance of the invo

Hi,I'm really wrestling with finding a solution here and I am sure I am not the only one who has the issue.  I have 2 tables in Airtable:1) Skills Table - fields include SkillId, Name, Description, Link to Skill Definition table via DefinitionId2) Skill Definition Table - fields include DefinitionId, Definition, Level (Level is either Beginner, Intermediate or Expert)When I call the API and GET a skill from the Skill Table I would like the Skill Definition to nest as an object in the response.  I noticed this behavior is possible with the Collaborator type, shown below for the Assigned fieldAt the moment when I link the Skills Definition table to the Skills table and add lookup columns from the Skills Definition table, then call the API from Postman, the fields are shown in a flat structure as an array

I have two bases and two tables.  Base 2 Table 2 table has initiative name , objectives, key results, earliest date (based on all projects in base 1 table 1) and latest data (based on all projects in base1 table 1)  and list of all program that have the initiatives.  Base 1 Table 1 contains program name, program description, type, priority, start date and release date, status, initiative name.  Base 2 Table 2 is synced to Base 1 table 1 so I can have the product manager can select the appropriate initiative in their program. In base 2 table 2,  I want a field to automatically add projects that have the initiative specified..  Right now, base 1 table 2 (which is synced copy of the initiatives) has the correct project names listed. However in base 2 table 2 the field of the project'

I would like to ingest Airtable data into backstage. Frankly I'm shocked this doesn't already exist. I am currently building a plugin to facilitate this. If anyone wants to have an input, please reach out to me at hanfordn35@gmail.com.

I am trying to create a script using curl which basically would download the image from the url embedded within the field of the JSON I downloaded with the API. curl is supposed to use the whole value of the key `url`(https://v5.airtableusercontent.com/v3/u/29/29/1716998400000/APymLz9oGAW4AZ1vM_9z3w/53CMUJ...) + the value of the `filename` (SKM_36722071214070ff.pdf) and then the desired output name of the file. It would be the same that browsing the url + filename, but when passing just the url to the browser it displays the attachments as the are in the Airtable field, but if I add url + filename in the form url/filename it doesn't displays the file. Is there any other

I am creating an automation that sends a reminder email if a task is not complete within a certain date. That being said, some users have multiple tasks to complete and receive an individual email for each record they’re attached to. Is there a way I can have a reminder email sent with multiple records condensed into one message so the owner does not receive multiple emails?

Hi guys,i have an automation and want to copy that to another base.It's a base that will be created from a snapshot that was taken (if this is important).Thanks 4 help!Julian

Does Airtable support sandbox instances? So for example if I need to develop and test before moving those changes to production, is there a way to do that? What Airtable capabilities allow this? If not, what have people used as a workaround? 

I'm having a problem getting my airtable to properly work with a dynamic page created on our website. There is an embedded form within the dynamic page, and the HTML for this is linked to a record within the aritable "Form HTML".I have been able to get this to work with the simple form html. What I am now trying to do is add on extra criteria within the HTML so that a section of the form is pre populated when loading certain pages. As soon as I add the extra code in it results in problems. I either get that the page cannot be found, or it will say this for about 10 minutes and then magically load, but it will only load on a desktop and not a mobile. The mobile always shows page cannot be found.The standard html is <div class="beacon-form" data-account="isleofwightdonkeysanctuary" data-form="83485bc4"></div> but I need it to be <div class="beacon-form" data-account="isleofwightdonkeysanctuary" data-form="83485bc4" data-bcn-c-donkey="xxx"&g

I need to re-establish a formula all ready created for our Content Title field?  I changed this to a Single line text and it changed the whole field, how do I change it back?