Ask the Community

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 al

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 thou

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

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   

So I have PDFs that are standardized for our organization. Is there any solution to take records from airtable and insert the data in to my Form Fillable PDFs. Is this possible? I looked at a lot of the extensions currently and none of them, even talked to some of the extension sites and they don't have the ability to do what I need. 

Currently when viewing a record's details in an interface, Grid/List visualizations can be used to view the record's "linked records", however these visualizations cannot be used on the record itself.I.e, if I have a Customer record with Order linked records, I can view the Orders in Grid/List visualization, however, I cannot view the Customer record itself in a Grid/List on that same page.What I would like to do is to show some of the Customer's fields in Grid/List view. When there are many fields this allows to show selected fields in a neat one-row view. (Rather than having each field one after the other vertically).Currently my workaround is to create a new linked record field where I link the record to itself, but it would be great if this could be done without this workaround.

Hello everybody, i have a problem with an automation, it worked for more than a year without problems, but now it stopped to working giving me this error: attachment url is disallowed. I specify that nothing has been changed in the trigger, nor in the file to be attached (it is the same pdf format), the trigger starts when it finds the conditions inserted (and this passes) but when the email is sent it fails. Can you help me solve? Thank you

Is there a straightforward way to handle this?I have two tables:contactsemail addressesThere's a field linking them. Each contact may contain multiple email addresses. What I want is to have a field in the contacts table that displays one email address - but not just the first or last record, I want the best address for that contact.I've created a formula field in the email addresses table that assigns a score based on various criteria. Ideally, a 'top email address' field (in contacts table) would identify the highest-scoring address within the addresses linked to that contact and display only that one.---I realize I could sort the email addresses table and then have a lookup field take the first one. For several reasons, I'd prefer to not have to change the sort order.Any other suggestions come to mind?

Hi Airtable Community!I have a few legacy accounts with API keys attached that are currently paid licensed accounts. I'd like to convert these accounts to service accounts. Is there a way to do this?Thanks in advance for your help!

So I know this has been an on-and-off issue with Airtable or a long time and mostly resolves itself after a while but I thought this was an issue of the past but no, still happens now and then like today..see 100's of my images broken randomly, some show up, others don't. If you open it, it can't open. The temporary URL via automation can still be generated, but can't be downloaded, instead an HTML page is downloaded saying the access is denied - permissions problem? Wait for a few hours to see if it gets fixed before contacting Airtable. Last time they told me to restore from snapshots. No, that doesn't work lovely airtable support team, snapshots show also broken images, same images broken as the live version, I can go as far as to last year and still same images show broken in the snapshot. N-o-t great. 

Hello everyoneI'm NawafI have a long nested if statement that i used to use in excel but I can't figure out how to use it in airtable the idea is i have 3 columns first ( permit status ) second is ( remark ) when the conditions meet, I want the third column ( action ) to show as "action" or "no action" or "no action closed"(permit states) has only two terms closed or valid(remark) is different i want to find the word "renewed" or "to be" or "re-issue" or "on hold" "redesign"this is what i used to use in excel =IF(AND([@[Permit Status]]="Valid",[@Remark]="No need for renewal"),"no action",IF(AND([@[Permit Status]]="closed",[@Remark]="No need for renewal"),"no action closed",IF(AND([@[Permit Status]]="closed",[@Remark]=""),"need action",IF(AND([@[Permit Status]]="Valid",[@Remark]=""),"no action",IF(AND([@[Permit Status]]="Vali

Hi all, I'm trying to remove a deactivated User from my base with an automation. Has anyone managed to achieve this? 

Hi, Does someone else have problems getting webhook trigger from Hubspot ? Here is the response message that Airtable give to Hubspot:{"success": {"statusCode": 400},"fail": null} Wich apparently mean that things are not working properly.

Hello.Am trying to automate creation of document from airtable. The questions are in a lookup fieldBelow is the information i want to push to be created in a document and attached is my workflow.My problem is the out put is not correct.I will wish is the question to be created in the document and numbered correctly.How can i achieve this?Thank youThe outputthe flowget record from airtable 

Are swimlanes possible in the Kanban view? This would be a nice feature to have. I'm not seeing it. 

Hello ,I am trying to link a row to another row via an automation script , how can I get the url link to a cell because when I do a for(let  record of tableQuery.records) i can only get the record.id or record.name isn't their a way to get the record.urlLink ? Thanks for the help 

I am using the Airtable js package for nodejs and it is my first time. I have dynamic data that I would like to store in a table. Is there a way to send the request once by passing an array into the create method? I don't want to iterate the array and call the create method on each iteration. I'm sure there is a way to do it once, I must be missing something.const base = new Airtable({ apiKey: `${process.env.AIRTABLE_ACCESS_TOKEN}`}).base(`${process.env.AIRTABLE_BASEID}`); const tempOrderParticipantData = [...params?.participantData as participantDataAttributes[]]; const tempRecord: unknown[] = []; tempOrderParticipantData?.forEach((item, index)=>{ tempRecord?.push({ "Full Name": `${item?.participantNameInfo?.participantFirstName} ${item?.participantNameInfo?.participantLastName}`, "First Name": `${item?.participantNameInfo?.participantFirstName}`, "Last Name":`${item?.participantNameInfo?.participantLastName}`,

Hello Community,I'm encountering an issue with the resource allocation timeline in Airtable, specifically when switch between the daily and weekly views for team utilization when people taking leaves.In the daily view, everything displays correctly; for example, team member Chanpory’s leaves on February 28 and March 11 are shown accurately.However, when switching to the weekly view, these leaves are not represented, what even worse, it incorrectly shows overutilization for Chanpory, despite his absence on these days.This issue is impacting our ability to manage and report on resource allocation effectively. Does anyone else experience this problem? Any suggestions on how to ensure that leaves are accounted for correctly in the weekly view to prevent it

Hi,I am trying to create an automation that will create a quarterly report for me every 3 months.How can I make a report be created every 3 months for each client?I'm using docsautomator so I tried this: https://imghostr.com/938e92_l5x but it didnt work  

Hey guys,I am looking for a way to link sets of dates together across different tables. I have a schedule table and a tasks table (tasks are nested under schedules), both have their own dates, I would like the tasks to move with the schedule they are linked to. I am using the predecessor field within those tables already for that functionality, but also want a way to link the tasks to the schedule. Let me know if anyone has any ideas on this one.Thanks!

Hi! I'm building an app with Bubble.io. The problem I'm facing now is that I need to create new records in my Airtable Base, from my Bubble app's UI. I do not have any problem to create new records, except when I need to populate a linked field. The new entry is created as expected, but the Linked field remains empty. Do you know how to process? Thanks a lot!