Ask the Community

Hello all. I am considering Airtable for a product/portal I need to build. I can't glean from the docs and other info how my setup would be billed or if it is achievable so am looking for some guidance. - I manage a database with data relevant to different clients of mine.- I want to share that data with the different customers I have via an interface for a nice user experience. Each client gets a login, and can see the data/projects relevant to them- Those clients then have customers who need to have access to the specific projects relevant to them. Those clients will need logins also in order to access their specific projects - The only action both my clients and my client's clients need to take is updating the status of a row of data (think a list/queue of items to review and approve)I have attached a crude diagram explaining it. Is this setup achievable? How would it be billed? Thanks,Darrell

Hey. I have a gantt chart that shows when multiple items are hired and dates associated to them. Each record is one item and has fields for 'delivered', 'setup for use', 'deadline to be ready', and then 'collected'. This means each record is one item but has 4 dates / time periods attached to it. I dont want to split this into multiple records with steps for each date, as the overall specification of the hired items is dependent on one record per item (this is shared with the supplier as a list to cost up)However when I pull this into the gantt chart so I can get a full schedule, i can only use of the date two fields (start and end date) so I am not getting what I need from it. Does anyone know a workaround for this?

An automation of mine that usually runs fine started throwing this error and failing sporadically. It's for a webhook automation that brings in orders from Shopify. In my attempt to isolate the issue, I've deleted every field from my "Create Record" action, except for Name (single line text) field where I attempt to enter the Customer First & Last name, but it still fails. 🤔 🤔 There are no roll-ups on the table where I'm trying to create the records. There are some formula fields on the table, but I'm not trying to write to those fields. Any ideas? The other threads related to this error message in the community forum did not contain an answer.  

Hello. I am new to Airtable and have spent a better part of a week trying to figure this out and I'm stuck. I hope the community can help me out.Our Airtable connected to our Shopify store via Airpower, so everything is synced in real time.We have a Table named 'Order Line Items' that displays each Shopify order and each item (SKU) is separated in its own row within the order. What we are trying to achieve is to display the inventory number for each item.Inventory data is stored in another table named 'Variants' and organized by SKU in one field, and the inventory quantity in another field.Does anyone have experience with dealing in anything similar?I'm not sure if this is relevant, but I have gone as far as being able to create a field in the Order Line Items table that links to our Variants table (that contains inventory data). However, I have to manually enter the SKU that was ordered before inventory count can display. The example below where for it to work, I have to type in the S

Hey,Can someone tell me where airtable gets the highlighted names from? I can't find any settings. The table is also named differently.BestMatthias

Hi there, I’m new to airtable! I have a huge list of contacts that I need to categorize. I am using the drop down Multiple Select Field tool to create “Tags.” I have over 2,000 contact and airtable is only allowing me to select one contact at a time. Is there a way to select 100s of contacts and batch them all as the same tag? Thanks! Meredith

I’m managing service requests (tickets) for apartments using Airtable and need help creating a more advanced lookup field. Here’s how my base is set up:Tickets TableEach record represents a service request (ticket).Each ticket is linked to the apartment it is for, using a linked field to the Apartments table.Tickets have a Tags field (multi-select) where multiple tags can be assigned (e.g., Appliances, Plumbing, Internet, HVAC).Apartments TableEach apartment is a record in this table.It is linked to all tickets associated with that apartment.Current SetupIn the Tickets Table, I have a Lookup Field that retrieves all other tickets associated with the same apartment as the current ticket. For example:Apartment A has three tickets:Ticket 1 (Tags: Plumbing, HVAC)Ticket 2 (Tags: HVAC, Internet)Ticket 3 (Tags: Appliances)When viewing Ticket 1, I can see a list of all three tickets because they are all linked to Apartment A.What I Want to DoI want to create a field in the Tickets Table that o

Hi everyone!I am trying to have an automated Slack message sent every Friday to notify about the leaves planned for the coming week.However, my current automation (trigger: at scheduled time + action: find record + Slack: send a message) uses the List of Records which ends up very bulky and unpractical for the team.Ideally, it would create a list like:@Marketing-team: no leave@Hardware-team: Joe (2 days, Mon-Tue, Leni (1 day, Mon)etc...Could anyone provide some ideas on how to make this announcement more digest?Looking forward to your solutions and grateful for anyone's time looking into this! 

Hi!I am looking for a way to connect airtable and slack allow users in my Slack to use forward slash commands to request data from from specific fields in a base in Airtable. The goal is to create a seamless way for teams to retrieve specific information directly in Slack from Airtable. I am the main admin in our Slack and Airtable so permissions arent an issue.Example:Use simple commands like /Airtable to retrieve theinformation.Information I am trying to request would includeRegionLanguageQualityetcBeing able to filter the content would be great too.I have tried Airtable automation but havent been able to figure it out.Thanks for your assistance in advance!

Hi guys,For each of my clients, I create a project management interface where they can keep track of the project's progress. One of the pages on this interface is a list of tasks.As of now, I have to manually link each newly created task to the proper project. So I would like to automate this process.Ideally, I would have liked to set up an automation chose trigger would have been 'when a new record is created on this interface'. But this trigger doesn't exist.So the only workaround I found for now is to create a List view with hierarchy on and to show the Project name on the level above. But I feel it adds unnecessary clutter to the page design since clients of course only want to see the tasks related to their project.I assume I'm not the first one to have this need. So do you guys any other workaround to suggest?Thanks for your help.

Hi All!I am trying to change a single select field in my base to a linked field, with all the single select options populated as rows in a new table. I have a long list of single select options that I do not want to have to re-type manually if possible.I could have sworn this was possible in the past with a right-click action, but I can't find it anymore (or I don't remember right).Thanks,Jaco

Hey guys!I am trying to link a Outlook 365 group calendar thats shared with me to airtable, but airtable only seems to see My Calendars (one's I've created).  Does anyone know of a way to get airtable to see the group calendar? I thought it might have it's own login since it has a email address, but apparently not. Let me know if anyone has run into this or has a solution. Thanks! 

Hi all;On Chrome, when inputting into an interface Long Text field, it resizes to half-width (see image), which is a pain in the butt for editing long copy on the fly. It's only recently started doing this, and it applies to both rich text and non-rich text fields.I'm not sure if it's an Airtable or Chrome problem. Does anyone have any ideas on how to fix this? Thanks!

me: Can it be? … me: Airtable has no “Signature Field”? no… me: realy? noo… me: joke, right? nope… me: WHY!!! … me: crying :sob: :sob: :sob: :sob: :sob: :sob: :sob: :sob: :sob: :sob:

I have a "master" table containing Clients, and an interface page that presents selected information as a dashboard launching point for each client. I have a separate table where clients can input "evidence" of all kinds, and from that I can filter, sort, whatever until I can work with that information however I like.  I have an interface page for this table as well, where I can manually select which client I want to review the evidence for - and that's where I need help.I want to have a button on the Clients interface page that will take me to the Evidence interface page with data already filtered to match the Client from which the Evidence button was clicked.  I don't know how to grab that information (client name) from the Clients interface and feed it to the Evidence interface filter element before I even land there, as a clearable filter (b/c I might then want to stay in Evidence but move around to a different client without backtracking to the Client interface).Tha

I created an interface dashboard with several groups (different charts, different numbers, etc.).  For aesthetic reasons (making the data make more sense to execs), I would like to have 2 groups side by side. For example, I would like to have a YTD group of numbers next to a Month's group of numbers.  The YTD and Monthly data will come from different tables, so they need to be in separate groups.  It seems I can only create a new group below or above another group, but I would like to create a new group next to an existing group.  Is this possible? Thanks in advance!

So I was following a video by AI Andy called Scrape 1000 viral content ideas: Mind Blowing Automation...I have never done anything like this and have ran the scrapers, entered the API keys, and followed the directions of ScottWorld for using MAKE with Airtable. Yet, I still get error 403. Do you need a paid account to get this to work from Airtable? Do I even get starting credits when I join? The credits say zero, but I am not sure if I need them or not. I guess there is no free trial offer? Any thoughts would be helpful!Thanks,Ryan 

Hi Airtable community,I am an avid user of Airtable for some time now, and am going deeper into spreading data in different bases (within 1 workspace) and letting these bases interact. I checked some other forum posts and the Airtable notes on how to get tables to sync manually, however am only able to find the below:beyond the manual trigger button, there is no way to directly trigger a sync action between 2 tableswork around is to update a record in a synced table, to trigger Airtable's automated sync actionanother work around, or combined with the above, is to use 3rd party tools eg. Zapier to touch a record and trigger a syncI was hoping for another way to trigger a sync action (API or Airtable functionality) directly eg. by automation, so not by doing the above. But to my understanding this does not (yet) exist. FYI I am on a Team plan. The use case would be to overwrite data for scenario management, meaning different bases represent different scenario's that need updating on

Hello Airtable Community, I've started building a Project management tool on Airtable for a marketing agency that sells consultants time.The Project management part is quite straightforward even though I believe this might change based on the agency needs and internal processes.However, I am now facing some difficulties to implement the "Time reporting" part to this tool. (bases are connected) :   1 - Project (information regarding customer, start/end dates, tasks, sub tasks, consultants,  #total available hours, #total spent hours #nb of tasks completed ...) This is meant to organize projects, track budget and project progress. Projects, are tracking time on related tasks. 2 - Tasks (information regarding the tasks to perform : start/end dates, sub-tasks, status, priority, consultants, predecessors/sucessors, time for the task, time spent on task ... ) these are the main action to perform within a project. Tasks are tracking the time spent on related subt

Hi all,I'm trying to set up an automation that sends an Outlook email with an attachment. The email works and sends, and the test email is received into the inbox but the attachment isn't there on the outgoing email.The attachment field is filled 'Doc 1st Email' from the relevant column, the attachment is in the column,I'm really at a loss as to what I'm missing here.

I am trying to use Airtable to fulfill Dialogflow requests. I have limited coding knowledge. Wondering if there is anyone who has got this to work? This thread seems to imply it is possible - Create Slackbot for Airtable Lookup.

The Customer Rewards Extension Management codeunit encapsulates most of the logic and functionality that is required for the Customer Rewards extension. This codeunit contains examples of how you can use events to react to specific actions or behavior that occurs within your extension.This extension includes a requirement to make a call to an external service or API to validate activation codes that are entered by the user. Typically, you would complete this verification by defining procedures that take in the activation code and then make calls to the API. Instead of using that approach, you can use events in AL.To create a new codeunit in your project, create a new file with the name CustomerRewardsExtMgt.Codeunit.al.Next, add the following code to the codeunit:al-languageCopy codeunit 50101 "Customer Rewards Ext. Mgt" { EventSubscriberInstance = StaticAutomatic; // Determines if the extension is activated procedure IsCustomerRewardsActivated(): Boolean; v

Use-case: As an Automation user, I have a use-case where I want to on a weekly scheduled (cron) basis query records that meet the criteria in one table and then create new child records of another table to the parent table and then email a consolidated report that includes the newly created childed records to the relevant recipientsCurrent outcome I can use the `Find` action to query for the specific and relevant records just fine, however, it is my understanding that once I use a `repeater logic` block, I can't "exit" the loop and append an Action outside of the repeater block once that the repeater has finished,Is my understanding about this feature limitation correct? Current work-around: I set up two separate Automations, both triggered by a cron schedule:The first Automation is triggered by its cron schedule, finds a list of records and then in a repeater block iterates thru each record in the list and creates a child record of a differ

Hello! I am currently pulling info from Jira into a table, and then pulling Sprint Start / End dates from Jira into another table. Because Jira doesn't expose that information directly, it is pulled into a GSheet, which I then pull into Airtable.The Sprint Name is pulled from Jira directly into my main table, and there is an exact match for each in the Sprint Info table. I created a Link to Another Record field which sources from the Sprint Info table, and corresponding Start / End date Lookup fields based on that table. I created an Automation that looks for any records in my main table that have a non-empty value and updates the Sprint Info 'Link to' field with the value from the Sprint field (screenshot below).When I generate a preview of the automation results, I can see that the Sprint Info linked field gets a value, but when I go back to my table, nothing is actually being updated. Any idea what I might be doing wrong, or a better way to accomplish this? 

Our team is moving from Power Automate Flows to Airtable and I would like to see if its possible to replicate the automations. I understand that some features are very similar however Power Automate has a 'Parse JSON' feature that Airtable does not have. Do you know the best way to replicate this into Airtable?