Solved

Hello all, I am trying to use the WORKDAY_DIFF Formula but it is returning #ERROR and I am struggling to determine why.  The IF,AND piece is working, the WORKDAY_DIFF is not (on its own or with the rest of the formula). IF(  AND({DateSubmitted}, {DateCompleted}),    WORKDAY_DIFF({DateSubmitted},{DateCompleted}))My fields are set to ISO dates. DateSubmitted is the Created Time auto value, and the DateCompleted is a formula - IF(Status="Done",NOW())Any help you can provide would be much appreciated. Thank you! 

Hello,  I'm current working with this formula: WORKDAY({Start Date},{SLA Test})   ---which is the formula in the 'due date' column.I would like for the Due Date to be left blank instead of #Error if there is no start date or SLA.Can someone help with an additional formula that I could add to the one above? Thank you. 

HI All--- I have several automations set up and would like to create this one below. I am trying to set up what feels like a relatively simple automation, but cant figure this out. Can anyone help? Short explanation I want that....1. when a specific form that I use, is submitted...2. containing 1 of any 3 options in the dropdown,3. to update a different record in the base.---- More detailsI am trying to eliminate a manual step that I have to do each time this form is submitted. After a form is submitted, I have to find the record and update a field to "N/A" whenever a form is submitted as Paid. N/A tells other team members that the invoice does not need payment. Basically what I want is that any time a form is submitted as "paid" it should also have "N/A" applied automatically. But I can't figure this out?! We have 3 different credit cards that we use so, really, any time the form has been submitted with any of the three cards (Paid Visa, Paid MC, Paid Amex)...

Just curious, are there currently issues with Hootsuite & automations because of Twitter?I have some Airtable automations that allow me to send unique scheduled posts to Hootsuite for multiple platforms & accounts. I have seperate automations for each platform or have one for the option to send to all.Seems like Twitter has broken the API between Airtable & Hootsuite.I am getting an error from Twitter when trying to connect to Hootsuite. Seems like Twitter is even preventing the connection to the other platforms.Twitter returned an error. Error hashes: rm18c109a07cc4fc8a, ufm18c109a07cc4fc8aCannot use the automation for any of them now. p.s. Screenshot shows the ones I am speaking of as turned off. That is intentional so I can do things manually.Just curious if anyone is dealing with the same issue. I have sent this to support also. Figured I would give it a shot here also.

Until recently, we've had no problems with images and thumbnails displaying in Airtable. Over the last couple of days though, we've had a few images that come through without thumbnails. When you open the record, it shows a 'blank' image (see pics below).In two cases, when I clicked on the image from within the record, the actual image displayed, but for others it remained blank.Users are uploading images from their mobile devices. One is an iPhone user, one is not. Screenshot from expanded record:Screenshot from activity sidebar:Image that opens after clicking on the image in expanded view:For another record, when you click on the image in the expanded record, it shows as a broken image icon upon expansion:I don't know if this is an Airtable glitch, or if something else is going on. Any ideas? Anybody else having this issue?Thanks!Terry

Good morning team,I’m trying to run this automation script that works on a base with 82,000 records but now throws this error since May 3, 2023. This is the first time that it happened on my base.Just a bit of a background, my Airtable base is connected to Softr as well. This is the code developed:// Converts settings selections to variableslet sourceTable = base.getTable("Bulk Upload");let selectedField = sourceTable.getField("Attachments");let destinationTable = base.getTable("Bulk Upload Extract");let nameField = destinationTable.getField("File name");let attachmentField = destinationTable.getField("Attachments");let recordinput = input.config();let bulkrecords = await sourceTable.selectRecordsAsync();let chosenrecord = bulkrecords.records.filter(test => test.id === recordinput.record_id)

Hey, all!I was wondering if there is a way to gain the sum of values based on column data. Here is what I'm looking for:I have four tables--materials, packets, procurement, & purchase orders. I link the materials to the procurement table to populate all the details of the material. I link the packet to that line item to signify what I'm charging to (it has job info and everything). Then I need shipping and receiving to check the items in so that we can determine that everything from a given packet has been received which is being validated by the purchase order. What we currently have to do is check every line item in as received. This is rather tedious, and all I really want is to determine that everything on the purchase order is being received. Additionally, if I can solve this, I would love a sum of how much of each material I have in stock for a given job, not a given packet as there are multiple packets per job. While some of this may seem redundant, it is due to the number o

I am trying to create a field that will say "❌ Incomplete Info" with a conditional statement.We two columns for custom products (price and description). If both columns are empty, info is complete. Record has no associated custom products.If both columns are full, info is complete. Record with custom product has description and a price.If ONE column is empty, and the other is NOT, we have incomplete info. If there is a price, but no description, or there is a description but no price, then that is when I want the "INCOMPLETE INFO" to appear. I can't seem to figure it out. I've successfully nested, but it will only ever apply to some of the scenarios provided.Thanks in advance!

I have a table that includes a date field as well as a single select field with options that are times of day (e.g., 9:00am, 12:00pm, 3:00pm). This allows users to select a date and time from a limited set of time options rather than Airtable's unrestricted datetime selector.I'd like to compose these fields into a single, calculated datetime field. This composition is a fairly elementary task, but the formula keeps parsing the time string in UTC. How can I get Airtable to read the time string based on another time zone (i.e., the time zone my team works in)?Here's the formula I've written so far. I've tried using `SET_TIMEZONE()` within the various `DATETIME_FORMAT()` functions, but can't quite get the formula output right: IF(NOT({Time option}), {Date}, DATETIME_PARSE( DATETIME_FORMAT( {Date}, "YYYY-MM-DD" )&" " &DATETIME_FORMAT( SET_TIMEZONE( DATETIME_PARSE( DATETIME_FORMAT( NOW(), "YYYY-MM-DD"

Hi I have a prefill for, formula in my base which ends with ?prefill_STWorkshopReference=PA007130&hide_STWorkshopReference=trueand it works fine when clicked in the base But when included in an automated airtable email the _ and _ are omitted and the text in between is italicised - presumably due to markdown languageIs there a way of solving this ?  

I'm trying to represent dimensions using concatenate and IF statements but it's not working.This is what I'm going forIf HEIGHT and WIDTH then H x W in.If HEIGHT and WIDTH and LENGTH then H x W x L in.If DIAMETER then D dia.I managed to get the first two fields working, but I'm not sure how to get the dia field to show up.IF({Length (in)}=0,{Height (in)} & " x " & {Width (in)} & " in.", {Height (in)} & " x " & {Width (in)} & " x " & {Length (in)} & " in.")I also tried the following based on reading some other threads and the formula works (without the & so I didn't get too confused), but doesn't actually produce anything (the Dimensions field stays blank):IF(AND({Length (in)}=0,{Height (in)}&" x "&{Length (in)},IF(AND({Length (in)}>1,{Height (in)}&{

I have three columns: 1st is the Sales Last Month, 2nd is Sales This Month and 3rd one shows the ratio of the two columns. I want to add the DateTime format so Sales Field will look - Sales: 137/150 (Apr: 201/200) instead of Sales: 137/150 (201/200).   

We are moving student metrics to Airtable and I am trying to create a backlog of attendance records for our students since they started. (we have two campus's with seperate start dates). I have an automation working fine for populating records with every new day but what i need help with is the back log script. Currently, I am trying to create a record for every student for everyday they have attended class thus far. Can someone help debug why this is not working? Nothing happens when I run the script and I do not get an error in the console, meaning the script is killed?  let studentTable = base.getTable("Participant Core Database"); let attendanceTable = base.getTable("Attendance"); let inTraining = studentTable.getView("Training View") let currentStudents = await inTraining.selectRecordsAsync({ fields: ["Full Name", "Training Facility"], sorts: [ {field: "Training Facility"}] }) //gets an array of all the dates the student has attended class since t

Hello Team, Is there any quick way to import mass data into an EXISTING TABLE? Importing a CSV file will generate a table, not append to the existing one. Copy and paste from excel or google sheet does not seem to work. Karl

Hello, I would like to integrate an Airtable workspace to QuickBooks Desktop (2021), not online. I need automate the creation of multiple sales receipts. Does anyone know how to set up this integration?

Hi,I've seen issues opened about this two months ago but we're experiencing this issue now.I tried leaving the script for an hour and the state doesn't change, though if I run a test of the automation, everything works. The status page shows there are no incidents.I've also tried creating a new automation that only runs the following script and it still gets stuck -   

Hey GuysI have a dynamic datefield (updates thru automations) that begins from todays date and records 10 days ahead. Is there a way to write a formulafield that ranks the date with numbers 1-10, i.e so todays date is 1 and tomorrow 2 and so on? I could use that info for navigation in an app.Thank you in advance.Jesper

I am trying to combine the lists in two different single select lists into one.  I'm not trying to concat the fields.  Combine the lists together somehow.

The open url button field you can create always opens a new tab, and i don't want it to do that, is there any way i can modify the formula so it doesn't open a new tab? I can make a script field instead that stops this but i really don't want to spend any more time on this.

I have an automation that generates an email.In some cases the fields I want to include in the email are not set yet.I want to add a conditional statement to the email composition, something like "If {name} is set, include {name} followed by a comma, otherwise skip straight to the text." I can't see a way to do this in the automations interface.I know that I can add fields to the table to do this but I'm trying to figure out whether there is a way to handle this logic temporarily within the automation.  

This is my first post so please bear with me. I have a base that I am using to track content and for project management of a newsletter. Table 1 Newsletter shows the newsletter project and has fields for Month, Year, Content (which is a linked record field), Content Attachment, and a checkbox for completed. Table 2 is where I am tracking content based on 8 common sections, month, year, content attachment, point person, notes, and content created checkbox.  I have an automation set up that when Content Created in Table 2 Content is checked it updates the Table 1 Content multilinked records. When I update more than one Content Created in Table 2 Content it only overwrites the other content in Table 1 Newsletter instead of just adding the subsequent linked record. Once all 8 Content Areas are in that field, an email is triggered to several people saying all the content is complete and is ready to go in the template for the newsletter. Is there a way to have the automation u

Hello, trying to set an advanced filter and it's not working.  Thinking I'm perhaps missing something obvious?  Looking to filter for projects that I'm working on and which are not "done" or "abandoned" or blank in their status.  See screenshots of my filter and what is currently displaying on the base (currently still showing done/abandoned items).  Thanks for tips/suggestions!Alex  

Have a base that looks at deal flow, including anticipated close date and value of each deal.  While we can easily view our "pipeline" at any time, struggling to figure out a way to store that snapshot of data on a routine basis.  We don't store updates to pipeline as a record itself, but update the record to the anticipated value.  At the end of a specific month in the past, what did our pipeline look like in terms of deal value, grouped by when we expect it to close?  Used to look at accuracy (anticipated vs actual) of our project pipeline projections.   

I need help in linking four tables in Airtable with automation. Our art group publishes monthly shows where our members showcase their works. To streamline the process, I have created four tables in Airtable, namely Venues, Shows, Members, and Exhibitions.The Venues table contains information on the places where members have previously exhibited their works. The Shows table tracks the shows entered by the members, with each show tied to a particular venue. We also have a Members table that includes all the members who can enter data into Airtable. Lastly, the Exhibitions table allows members to enter their current shows.I have created a form under the Exhibition table. If a member enters a show that is already in Airtable, they only need to enter their name and find the show in list. If the show is new but in an existing venue, they can enter show information. And if the show is in a new venue, they need to enter both show and venue information.I have not been able to link the Shows ta

Hey all!Currently, I have a client database with start date {start} and finish date {finish} fields.Once I have added a finish date, I then manually update the {status} field from 'In Progress' to 'Done' - it is a single-select field).However, I'd like to automate the above process, meaning I'd like to automate the following:If {finish} is not empty (meaning a date has been selected and the project has been completed), change the {Status} field from 'In Progress' to 'Done'I've attempted to do this but the automation comes back as an error.I look forward to hearing any ideas!