Ask the Community

I'm getting a 422 error saying my column "Step" doesn't exists, but the column exists and I haven't touched it. When trying the module alone, it works. But when I run the automation and the strings are mapped, it doesn't  

Hi! I use Airtable for tv title tracking and I'm trying to see if it's possible to update a field ("Distribution Rights") when a separate field ("Distrbution Rights Details") is selected. Example listed below:When "EXPECTED: All Media Worldwide" is selected in the "Distribution Rights Details" field, populate "Distribution Rights" field as "Global Expected"Is this automation possible? If so, would it be possible to add additional options (when All Media Worldwide is selected, populate Global in Distribution Rights)?

Would someone from the custom extension review team be willing to pop in here and answer a question for me?  Would be greatly appreciated!I've been working on a single extension for 18 months and have a question about breaking one of the extension rules.  I would like to provide some context and see if a workaround could be found. Thank you!

This one is puzzling me. I have an automation that watches for a field to be updated, which then updates another field on the same record. It mostly seems to work as I need it to. However, I keep getting errors that the automation has failed as it "does not exist". It will successfully be triggered, but unable to update itself.Indeed, these records don't seem to exist. I expect they are deleted. However, I can't get the automation to fire by deleting a record.What could possibly be happening to the record between being the trigger and the update step?I haven't been able to "catch" this failing in action, as it doesn't have a noticable effect in use - I only see it when airtable emails me a notification. 

It is very frustrating to match up automations or API processes with data changes in a record's "activity" log with broad time information like "an hour ago" or "2 days ago." Please consider introducing fine-grained timestamps EVERYWHERE you log ANYTHING. As an Integrator née Software Developer, this is making me pull my hair out

Hi I have started another base. The main base is working fine and this base is for an add on registration service. I tried to create the form https://airtable.com/app6DqS2bqGtz03sG/pagZRFkh5bC0Ay4TK/formI have filled out the film and submitted it but it does not populate anything in the base. I also cant find the form when I go back to my work sheet.Please may I have some assistance

I've created a pivot table in a dashboard interface and I'm trying to summarize cost for projects. Each record is a deliverable which has a corresponding "Brief" that it's tagged to. Each deliverable also has a cost associated with it. Both "Brief" and "Cost" fields are lookups from another table.The pivot table:Rows: BriefColumns: Deliverable TypeSummarize by: FieldField: CostSummary type: SumUnfortunately, the pivot table just shows up completely empty. I created the same pivot table as an extension and that worked perfectly. I can't seem to figure this one out.Also, the Cost field is set as "currency" in the lookup table, if that's important.

Hi everyone ! 🙂 I'm running into an automation puzzle and would love to have a little help.Take a look at the picture attached. I have a list of clients (column A) and each of these clients are linked to their account manager(s) (column D). Other columns are various infos about each client (status or region - columns B and C - I've kept these as examples).I want to send a weekly reminder, by email, to each account manager, with all the clients they have to reach out to this week (according to a filter on which the view is based - Priority Status (not shown)). Things would then go like this : Charles receives an email with a list of every bar for which they are account manager, so everything from line 93 to line 108Ines receives an email with the 2 bars for which they are account manager, so only lines 100 and 109(and so on, for every account manager)I'd love to be able to do this without adding a new table to my board (i.e. without a separate table listing all the acc

Hello,I am new to Airtable. I am trying to do one automation which is as follows.I have a table named "(OMS) Invoices" having 2 newly added columns which I want to use for this automation.First Column name is "Generate Invoice" which is a button with following configurationSecond Column name is "Invoice PDF" which is an attachment.Manually when the button in "Generate Invoice" is clicked it loads an extension "Invoice" and performs the action as mention in button configuration "Open in Page Designer". This populates all necessary values in invoice PDF from airtable table "(OMS) Invoices".What I want to automate is, whenever "Status" is changed to "Order" in "(OMS) Invoices", it should programmatically click button inside "Generate Invoice" so that it loads up the extension with invoice pdf having values. Further to that this PDF will be saved in the "Invoice PDF" and then emailed to the customer associated with that Invoice.Is this possible by using ONLY AIRTABLE INHOUSE AUTOMATION? Ma

Hello Airtable Community, I have a timeline display and group on three levels (market, category, linked event)For some entries, there is no linked event. However, it is very important that it is also displayed for the entries with linked events.Can I somehow prevent the entries without links from always showing (empty)?Thank youMirko   

Hello!I am trying to create a formula that categorises ships by type, then size category, and if they meet both of those criteria they are assigned a value that is annual fuel consumption appropriate for the vessel's size category. If not, the IF test continues through all size categories and finally ends on "NA" if nothing it true. I would have thought I would be able to nest like the below example, but for some reason it only generates the correct answer for the first two size categories, then everything higher in size gets the same second highest fuel value:IF(AND({VESSEL TYPE} = "SHIP TYPE1" , {SIZE CATEGORY}<=1000),"XX Fuel consumption value",IF(AND({VESSEL TYPE} = "SHIP TYPE1" , {SIZE CATEGORY}>=1000<=1999),"XX Fuel consumption value",IF(AND({VESSEL TYPE} = "SHIP TYPE1" , {SIZE CATEGORY}>=2000<=2999),"XX Fuel consumption value","NA")))Below is the actual formula if that helps anyone understand. I also hoped to be able to have all vessel types an

It would be great if you could select or filter records by a pop up / embeddable calendar in interfaces.

Is there anyway to set up timeline or gnatt views to see more than 2 dates?Currently I have the "duration" of the record, but there is a repeated "event" that happens through the duration of the record (recorded in another table with a link to the first table). I'd like to be able to visualize when these events are occurring on the same timeline, is that possible?

I am setting up a new system for our company to track our projects and record how many days each designer has worked on a project and, equally, how many days a project has been worked on. The calendar view doesn't work for us, as date ranges don't work here. We also don't want to have to fill in time sheets anymore, we just want the table to calculate the number of times a record (project) appears in the design schedule. The rollup function isn't working here to add up each instance of a record.Can you help me figure out how to set this up so that the "Projects" table, and the "Design Schedule" table link to count up how many times a project appears across the 5 days. Ideally it would be great to figure out how to show how long each person has spent on each project but ultimately the goal is to work out how much time has been spent on each project total. I don't know much about functions and their language so I assume this is where I will need the most help! Th

I have an interface in a list form.  I added a button to the interface. I want the user to be able to select multiple records from the list and click on submit. However I see that the button is disabled and it does not detect the source. I tried adding a dummy record picker element at the top and I could then see the button. But my question is I should not have to add that dummy element because I just don't need it on my interface page. It just creates a lot of confusion for the user to see that dropdown. Is there a resolution for this? Do automations only run when there are record pickers in the interface? Because that is pretty weird according to me. 

I am learning automations and I have hit an error I cannot figure out.There are two tables involved in this automation:People table where the client master data residesClient Funding table where clients' stipends and grants get recordedHere is the logic I am trying to make happen:When Client Funding Indicator field changes to "MicroGrant Invited", do two thingsCreate a new Client Funding record for the client <-- This step works correctlyReset the Client Funding Indicator field to "Funding Not Specified" <-- This step gives me the error "Received invalid inputs."Thank you!!!

I tried to search the community before posting and found this question (with no solution) several times, but the posts I found were pretty old so I just wanted to double check to make sure this was still impossible using Airtable alone.I'd like to use the Date Dependency features to help with automatically shifting task and displaying in a Gantt chart. However, many of the tasks span less then one day. For example:Task 1: Purchase Paint - Start 6/12/2024 - End 6/12/2024Task 2: Paint Wall - Start 6/12/2024 - End 6/12/2024I can't paint the wall until I purchase the paint, so I want to setup a dependency. But it doesn't take an entire day to purchase paint. When I setup Date Dependencies, the only option I have for creating a duration field is at the "day" level and setting dependencies means my tasks on the same day can't overlap. Am I missing something? Is there a workaround? Or is this still an issue?

I have a automated email that goes out to a group of non-collaborators when a form is filled out.  The emails contain an inserted grid with designated information from that form including any attachments that were submitted.  These attachments are, however, not viewable by the non-collaborators.  Share and sync is turned on.  Is there a setting I am missing?  Is it not possible for non-collaborators to view the attachments?  Is there a workaround that doesn't involve giving the non-collaborators access to the base?Thanks for the help!

I'm trying to create a weekly digest of invoices submitted in the past week. The idea is that people submit invoices via an Airtable form, then the automation sends a message to a Slack channel and a person in that channel presses a button shown in the Slack message once they've all been paid. Pressing that button then marks them all as 'Paid' in Airtable. I've gone through other similar threads about this and I'm not able to understand why I keep getting the 'Received invalid inputs' message. I'm quite certain that I've linked the correct Airtable record IDs (i.e. the ones found in the intermediate Find Records step). See screenshots, but any help would be much appreciated!

Although the Kanban view has many limitations it was working before the last released update...the bugs are really annoying...limiting staffs ability to work effectively in the Kanban view without refreshing the screen every 2-minutes...what is the plan Airtable? It would have been nice to have a heads up on the change or at least a "we're working on a solution" message.1- after expanding a record and closing it, the scroll option simply does not work...in order for the scroll feature to work the screen needs refreshed- major pain in the a$$2- when entering a new record from the new carrot at the top of the uncategorized category, the system is automatically assigning a category...the add task at the bottom still works but you have to scroll (or attempt to scroll and then refresh the screen) all the way to the bottom to add a task. Oh, where did the new uncategorized record go- good question...oh look- it was automatically assigned to the wrong group...fun times for all.3- when closing

I have a table of pricing data for products. It has several hundred products.  Without too much modification to that table and its data, I want to add a field with a checkbox so that if Check/Uncheck it will Copy or Remove the data to another table.  On this other table, there will be additional fields added.  Really a newbie to Automations but I started with the Trigger when the Checkbox is updated and that seems right, but I can't seem to figure out the Action part.  Would that be an if/else statement?

Hi allI am using the Make.com modules to create a scenario where an address input into AT triggers an automation that generates a google maps link with transit options for travel from A to B.My question is if I can enhance this to provide me with a string of text for the directions, e.g., "Take Bus 83 to X and then walk 8 minutes to Y" Many thanks ! 

Hi Folks,I am essentially trying to automate quota calculations for the sales team in Airtable. As I explore setting up the tables, I'm running into constant brainfogs.1. Im dividing the "record" (quarterly target) by "3" (to break this into a monthly target) but i'm receiving a #ERROR. Can anyone help me fix this?2. The way I set up these records is to have the employee ID + Month when the plan start date is; Therefore, each employee has 12 records. How can I build a reference table so I can link the records and specifically link the values into the current table? I currently calculate the quotas in Gsheet to then copy and paste in the current process but I'd like to automate this. Additionally, if I need to link the record to each of the 12, how can I automate that? Seems like automation setup could address this issue.I thought about setting up the reference table to still have the following (see below) but if the records are currently by column, how do I link it in a way where

I'm experiencing something weird - I have a formula field ("Cheque 2 amount") set up to subtract different currency fields. All fields, including Cheque 2 amount are set to currency format with 2 decimal places.  Everything looks normal in Airtable:However, I have a "send email" automation set up that uses the Cheque 2 Amount as a token, and some of those emails are displaying this token with 14 or so extra decimal places (here is the email generated from that same record above): Seems to be happening to maybe a quarter of the 160 or so records I was working with this morning. I can't see anything different about the ones that are experiencing this glitch. My best guess is it has something to do with the Cheque 1 Amount field, which is a formula that calculates a percentage (SUM(.75*{Approved budget})) - however it is also set to currency format with 2 decimal places, along with all the other fields. Anyone have any ideas???  

Hi, I have an Interface with an attachment field and I'm adding small PDF's. These are sometimes multipage PDF's All good on PC but when opening via the Airtable App on Mobile, it only displays one page. Multiple pages can be viewed if download but not just by opening. Happens on multiple device (Android). Am I missing something ?CheersJason