Ask the Community

Hi allI'm trying to make a URL to link directly to show just images in an attachment field.I've created a shared view, and am happy making a formula which replaces the record ID to the correct record but I can't get the attachment ID programatically.  If I omit it from the URL (ie airtable.com/appXXX/shrXXX/tblXXX/viwXX/recXXX/fldXX/ then it directs the user to the full record page - I just want them to see the attachments so need the "att" IDAny ideas?Hope that makes sense!Andrew

I've been working on a project where I'm utilizing Airtable for data management and an external automation website for process automation. Everything was running smoothly until I encountered a peculiar issue. I'm struggling to seamlessly integrate the automation website with Airtable.The challenge lies in ensuring that specific triggers in the automation website accurately update corresponding records in my Airtable base. Has anyone else faced a similar situation or found a workaround for such a nuanced integration? Your insights would be extermely valuable in helping me to sort out this process.

Hey community, Aundre here. I hope you're all doing well!I found this script on YouTube that works once you're on any table view where applicable. I need to automate it to work without being on a specific view. When I run it from automations, it does not work, I get the error below.The automation I am trying to create is to run whenever a record enters a view. It should run the script which compresses images in the IMAGE column via TinyPNG, and then output them in IMAGE COMPRESSION. However, I find that I have to be on the view itself, click 'run script' for it to work. The automation however is not running from a view standpoint, hence why I believe it's giving an error.After the image has been compressed, I'd like the IMAGE column to clear (delete) the original image, leaving only the compressed one. I've been able to do a simple automation for this by making the action an Update record and leaving the IMAGE field blank. However, I need it to be in one where i

Hi everyone, I am trying to automate an SMS using a basic Twilio script that I found here: Twilio Script This script works when I run it within the script app, even with my changes made to disable to input text. When I run the same code in the automation run script action I get the error code ‘ReferenceError: btoa is not defined’. My code is below: * Twilio send SMS script * * Send a single SMS to a provided telephone number using the Twilio service * * The Airtable "Send SMS" Block (available to customers with a "Pro" account) * is capable of sending many messages in batches based on the contents of the * Airtable Base in which it is installed. * * **Notes on adapting this script.** * * The script prompts for input every time it is run. For some users, one or * more of these values may be the same with every execution. To st

Hi there - I am trying to set-up scripting to work with Whatsapp & Twilio. Which is the best and easiest language of those below to interface with airtable scripting?

I am trying to share specific views of my Airtable base, I specifically want users to see the Tables I am sharing collapsed into their groups, as it makes lots more sense for them to be able to drill down. However, despite me collapsing all within the view, my recipients are seeing the tables expanded. This also happened when I tried to share the whole base. How can I ensure recipients of a shared view or base will see the view collapsed by my groups.

I have email automations that are sent out when a record matches conditions. When a date is one day ago an email is sent. Overnight this has not worked, emails have sent even though the field date that triggers the email was not one day ago. What could be the cause of this?Could this be caused by the time zone airtable uses? It says it is in GMT, but the date generated in a field is the wrong date?

Hello!This is my first post, so I hope I'm posting in the right place.I am trying to use Airtable as a production board for my company. When an order comes through Shopify, I have Zapier tell it to upload the information with Line Items, but my team doesn't always know how many items may be in one order to complete it, so I started showing "1 of x" for my guys to know when they view the interface.Is there a way for Airtable to automatically mark a job with the same "Order Number" (as it is grouped right now) to autopopulate the numbers of the line items in a column, even if it just auto-numbers with 1, or 1, 2, 3 etc. then I can reformat the way it looks?Or is there a better way to go about what I'm trying to accomplish? I feel like I'm overcomplicating it.Thank you so much!

Hi I have an automation script, and run into a problem, it is not fetching the right recordId in the script, but it does in the previous step. Anybody with a larger brain that can se what I have done wrong here?All the BestJesper

We are using two bases to work different steps of a workflow but are having difficulty syncing all the data back to the original record source in “base #1”. “Base #1” has the planning, design request & scheduling executed and “base #2” has the designing, design proofing & final design attachment executed. We have synced a table from base #1 to base #2 but then created new fields to be worked in base #2, how do we update the original record in base #1 to the applicable new fields created in base #2? As a note, we were able to sync all the applicable fields back to base #1 in a new table but that did not fulfill our workflow need as we require the new field data to be included in the original table in base

Hi there--I'm trying to setup a three-tiered list in the interface builder. Some of the tiers also leverage linked records. I have enabled click into linked record and even designed the card that should fly out when the record is double clicked, but it is not behaving as expected. Instead, it just reopens (click 1) and closes (click 2) the record when I double click on it. I'm experienced setting up interfaces with openable linked fields in general, but have not worked in the multi-tiered list format before. Does it behave differently here?Thank you 🙂

HiI have a field called {Total Duration} where the user enters the length of a video in h:mm:ss format. This formula is going to be used to calculate the costs of video editing. We charge in 30 seconds units. 1-30 seconds is charged as one unit, but 31-60 is charged as two units.I have been using the following when {Total Duration} was set as a simple number fieldCEILING({Total Duration} /30) * 30This almost works. If I enter 32 it rounds up to 60, which is what I want, but if I enter 31 it rounds down to 30.  Any ideas how I can solve this? 

I have around 40,000 addresses that need to be assigned to a precinct. I was curious to find out if there was a way to give airtable a range of addresses, so it knows what precinct to put them in, and assign the addresses a precinct automatically. Thanks!

I’m having issues adding a miro board. Upon clicking “Add a Miro Board” in the Blocks tab, Google Chrome opens but to a blank page. I am logged into my Miro account in another tab. I’ve also tried logging out of my Miro account prior to clicking “Add a Miro Board,” and Google Chrome opens a page that only displays “Not Authorized.” Can someone advise how best to solve for this?

Does anyone have guidance on how to split multiple choices into list view? For example, I use Airtable to track participants for trainings we offer and in some cases participants will take more than one of our trainings. When I group in list view by training, it is pulling and sorting these participants into a new category rather than just having them show up in both individual training lists. Is there a way to fix this?  Thanks!

Hi there!I am getting start and end date as a text in one field.BUT format could be different in each record (mm/dd/yyyy OR yyyy-mm-dd)I want to find a formula to split A field (which could be formatted in two ways) into start (B) and end (C) datesTime shown in B and C is not relevant. Most important to have it formatted as date.ABCTest Dates (single line text)Test Start Date (Formula Formatted by ISO)Test End Date (Formula Formatted by ISO)11/28/2022 - 12/23/20222022-11-28 02:00 2022-12-23 02:002022-1

The Utilization Summary works differnt than I expected, and I can't figure out why.I think this image summarizes my question: In short:I have 5 working days (40 hours) per employee as ''Available hours''And my tasks are split into working days, where ''Hours required'' is calculated as [WorkingDays]*8Now in the example above I have a ''task'' of 15 working days, spread over 3 weeks, resulting in 5 days per week. I would expect to get three weeks with 100% utilization, but instead, I get three weeks with 300% utilization. It seems like Utilization Summary takes all Working Days for every week the task occurs in.How can I solve this?  

We have a nonprofit Pro Plan for 60ppl.Re-upping for the year was a scramble to find the money, so I just put it on a personal credit card to see us through. I paid the bill today, which was one day after the account defaulted back to Free Tier. I have just paid for: NFP Annual Pro Plan 60 Nov 12, 2023 – Nov 12, 2024, but the Workspace still shows Free only. I need the account to be returned to the NFP Pro Plan we just paid for.AirTable is a central part of how we organize ourselves and our work--being on Free Tier has brought all the work we're doing for communities to an abrupt halt.  How can I expedite the process? (I've submitted a ticket and have yet to hear back.)

Hi everyone, Hope you are doing well. I need help regarding an automation 🙏 I'm struggling to do it so I'm asking the help of the Airtable CommunityOn my base, I got a table calls "Project table" where I put all my project here. In this table I got a Multiple select field calls "Deliverable" where I put all the deliverable of each project : Email, Post, Analysis. On my base I also got a table calls "Task table" where I want to automate the creation of all the tasks regarding each deliverable of each project. For example:- I got a Project on my "Project table" with 2 deliverables : Email and Analysis - I will need to have on my "task table" an automation who will automatically create all tasks regarding the creation the deliverable "Email" and "Analysis" (as it's the same tasks for each email and Analysis) My problem here is when I have multiple deliverables, my automation will only

Hello everyone, I need help with automation. 1. I have Table 1 with the primary field 'Date' where I receive in a column 'Complete Description' a long and annoying detail2. I want to simplify step 1. based on the primary field of Table 2 'Expense' where I have a list of expense types. 3. So, when a record is created in Table 1 AND CONTAINS ANY OF THE WORDS from the primary field of Table 2 'Expense', I want it to be placed in the column 'Details' in Table 1. How could

- I have a source table and a synced table- The synced table feeds Power BI- The person that set up these connections is no longer with us and my knowledge here is limitedQuestion: How can I sync newly added fields in the source table to the synced table? We have added new fields to the source, but I don't see them in the synced table and I need them so it can then feed to Power BI.

Hello! I figured this out before and accidentally cleared it a while back without noticing. For context, I am trying to find the total cost associated with ordering additional curriculum books. In the form submitted, customers can select additional books for purchase at $45 for K-2nd and $60 for 3rd-6th.I am trying to find the sum of:multiplying the following columns by $45: Additional K English, Additional K Spanish, Additional 1st English, Additional 1st Spanish, Additional 2nd English, Additional 2nd Spanish multiplying the following columns by $60: Additional 3rd English, Additional 3rd Spanish, Additional 4th English, Additional 4th Spanish, Additional 5th English, Additional 5th Spanish, Additional 6th English, Additional 6th Spanishfor a total cost to appear in "Additional Books Purchased:" ex: 1 additional K Spanish & 1 additional 6th English would equal $105 in the additional book

Hi there, I'm essentially trying to set up two overwrite fields in my formula. So if field 1 is blank, then use the data from field 2, but if field 2 is blank, then use data from field 3.I have the formula for one overwrite which works fine (see below), but I can't seem to work out how to add another condition to it. IF({Company Invoice Contact}, {Company Invoice Contact},Company) I want it to work like;IF Invoice Contact Overwrite is blank then use Company Invoice Contact but IF that is blank, then use Company.  Any help would be much appreciated.

Hi,I want to create an IF formula but the result I get is not what I expectedHere is the formula: IF({Date effective de fin du cadrage (from Date effective de fin du cadrage)}<{Date estimée de fin du cadrage (from Date estimée de fin du cadrage)},"In time","Late")I want to get: "In time" if the effective end date of the scoping is before the estimated end date of the scoping and I want to get "Late" if the effective end date of the scoping is after the estimated end date of the scopingHowever, I'm getting "Late" whereas I should get 'In time".Could you please help me? Thank you very much

Hi there,New to AirTable and Automations but was hoping to get some help with setting up my first workspace. I currently have 3 tables: Project PortfolioProject WorkplansProject StatusesIn the first table, I would like to display the Next Milestone and most recent report / status. On the milestone side, this would somehow be a lookup of the tasks in table 2 (All workplan records are tagged with the right project). So if there were 5 records for Test Project and the next future dates were 11.30 and 12.04, I would want just 11.30 to display.This is what table 1 looks like right now. For status, I can manually pull in the status I would like, however I would like the status to update from Nov 27th to the next week when a team member submits a form with a new status update. I am struggling with the automation there, spec