Ask the Community

I am trying to setup our production tracker using Interfaces.  I am running into one very big issue though.  I have forms (currently in page designer) that need to be printed at certain times throughout the progress of each record.  I know I can add a URL to the button but we currently have the button setup to open that specific record in page designer and would like it to stay that way.  The button does not have to open to page designer if there is another solution that would pull data from that record and put it on a page that can be printed.  I am unsure if a script or API would accomplish this but would appreciate any help.

Hello AirTable Community,Im somewhat new to Airtable and I am currently facing a challenge in building an effective inventory base in Airtable, specifically when it comes to linking multiple promo products into one product and properly managing the inventory for each line item. I would greatly appreciate your guidance and expertise on this matter.Here's the scenario I'm dealing with: I have different office kits - mini, small, and large - each containing various promotional products such as post-it notes, pens, carabiners, webcam covers, mousepads, and business cards. I want to be able to track the inventory for each individual item as well as the overall inventory for each office kit.The goal is to manage and update the inventory levels for all the components within the office kits. I want to ensure that when one item from a specific office kit is sold or depleted, it automatically reflects in the inventory for that particular kit. Additionally, I need the abil

Hi, currently my team wants to have a form to submit warning for staff. A warning will last for 30 days, if staff violate within 30 days, it will automatically be their 2nd warning just by submitting formPlease help, i don't know how to set up the field automatically change from 1st warning to 2nd warning, or if they violate after 30 days, the old warning will be expired. 

Hi All,How can I configure different fields in card view and card expansion view?Use case: I want the cards to be smaller and neater, and show 1st tier information only at a glance. Upon card expansion, I would like to show more details.Basically, it should be able to select which fields would be part of the view, and the which fields would go on Card only and which ones on Card expansion.Im afraid I know the answer, because I searched for it. Its just that I cant believe that that functionality, with so much potential, is useless in any case that's not super simple, what a waste of a feature...Any plans from Airtable to improve this feature?Kind regards

Hello! I have a list of songs, and i would like to invite outside collaborators to rate each song. I know there is a Rating field, but I’m not sure if there is a way to let multiple people rate the same record and then view the results. Is there a way to create a “poll” to allow many people to rate each song, then I can see the total number of ratings and the overall average rating? Thanks for any and all suggestions…

Hey, Is it possible to rate one record multiple times (1 collaborator to rate same recordmultiple times), and later on to show an average rating? And to do that with multiple collaborators? For example, restaurant review, Can I rate the same restaurant multiple times, and calculate the average rating for that particular restaurant? And that average rating to be a combination of multiple different ratings from multiple collaborators. I’m not quite sure how to do that… Thanks

I'd like to set up an automation to send an alert when two records have the same value in a date field.For example, Record A has a date of August 6.  Record B has a date of August 7.  Then the date of Record B changes to August 6 (same as Record A).Can someone please tell me if this is possible, and if so, how?

Okay, this is another one that I feel weird asking. I can't imagine I'm truly the first person asking... I've poked around here, Reddit, etc. and I haven't seen a direct answer so I'm asking— and apologizing if I'm being a goober who missed the super-clear response in some other post/exchange.  Sooooo, Obsidian! Know it? Part of my problem is that I don't quite know how to phrase my question....Short and direct: is there an extension that will allow me to visualize my table/base like the graph view of Obsidian? I already have a big base where I keep notes, ideas, etc. It goes like this (roughly):Notes Tablenotetype (multi-select)topic (linked field)connections (linked field)creators (linked field)Topics tableincludes connectionsCreators Table(I'm not baking out the whole base here because I'm not sure it's needed, but I'm happy to

Hi!  I feel like I did decent job searching around to see if the answer to my question already exists, but I apologize in advance if I failed and it's been answered (or/and worse: multiple times. It would mean I suck at searching and my whole identity would be called into question! Egads! And, jokes. I'm joking.) Now, the question:How do I automagically get photos into a table with the meta-data? (Fields, yes, but that's not what I mean.) I assume there's a script or something somewhere (as opposed to this feature being relegated to the IFTTTs and Zapier's of the world.) (I assume I'll be able to figure how I get the pics into the table without having to manually attach each photo bc... well, there's just no way someone didn't solve for this.) Thanks so much! 

Morning! I'm having trouble getting Airtable to recognise the output of this formula as a date. It is basically saying "if it's in this city/country, you need to begin the project x,y or z number of months before the required by date". The last "otherwise" was "" but I've changed it to -999 so the none of the formula would spit out a string value, but that still doesn't seem to have worked. The {Client Required By Date} field is a date field in the same table and is date only (no time), so that shouldn't be an issue, I don't think. Formula below:  DATETIME_FORMAT( IF( OR( {Town/City} = "Glasgow", {Town/City} = "Edinburgh", {Town/City} = "London", {Town/City} = "Liverpool" ), DATEADD({Client Required By Date}, -7, "months"), IF( FIND({Country}, "United Kingdom,Spain,Portugal,Republic of Ireland,Poland"), IF( AND( {Country} = "United Kingdom",

Hey guys,I have a lot of blog posts that I am trying to showcase on my website but I don't have the room to store them in the webflow CMS since I use CMS for a lot. I would like to avoid upgrading the website plan as my blog posts will eventually out grow the limited amount of CMS items webflow offers anyways. Is there anyway to view my airtable CMS items to my website WITHOUT storing them in the webflow CMS?Thanks!

Hi community!I have an airtable that tracks VFX shots as they come in from vendors.One sheet (delivery) tracks every shot as it comes in, including the same shot with a different version number due to fixes or changesOn a separate sheet (topsheet) I have a master list of all the VFX shots in the filmOn the delivery sheet, I link each record to the master vfx record on the topsheet. That way I can see every version of a VFX shot delivered and track commentsThe issue I have is that the producer likes to see a list of every shot that is either 'not started', 'has issues' and 'passed quality check'. The issue is, because multiple deliveries are linked to the master shot, the master shot can be both 'has issues' and 'passed quality check' as the old versions are linked. Is there a way to group the 'topsheet' so that one group is all shots 'not started', all shots that have issue but none that have passed qc, and a group that is any shot that has at leas

See GIF below: Basic project/sprint setup for Gantt view with the "Sprints" here grouped by Project.If I try to add a sprint by dragging out a timeslot in the relevant project, the created sprint/task is created, but not associated with the group/project I tried to create it in. It pops to the top and is not associated with any project. I can't associate it with a project by dragging it down to the relevant project. You would have to click the Sprint and associate the relevant project from there.I find that this breaks my flow when managing multiple projects or just trying to quickly add something during a meeting. It's also made worse by the fact that the left record list (where I can see the name of the Project and associated sprints) is replaced by the record details every time you click a sprint record. This is problematic because I sometimes forget the name of the project, as many of our projects have relatively similar names. So I can s

I am trying to do a simple GET request using Airtable API in Postman to retrieve my records. But it's not working. I am a newbie here, any help is much appreciated.GET: https://api.airtable.com/v0/appkEdlvHkUVyG1QC/Sample%201?maxRecords=3Headers: "Authorization": Bearer Personal_Access_token

I have a base which has the design of one date field and 8 image fields .  It  has been working well - with one entry a day since 20 June 2023.  About 3 days ago it stopped letting me upload photos.  I've checked my stats and I am nowhere near my limits. I have also deleted and reinstalled the app on my phone without success.  My other bases are working fine.  I love airtable however cannot work out what is happening.  Any suggestions?

Hi I got help with this a little while ago and it was perfect but now I want to add to it and anything I try does not work.This is relating to an commissions payable per situation.IF(  {Booked By} = 2,  {Points Paid} * 0.04)The above works however I want to add more situations -IF booked by 0 points paid is 0.00 IF booked by 1 points paid is 0.03 ORIF booked by 2  points paid is 0.04 ORThanks in advance. 

I am trying to create an automation so that everytime a new record is created in the "link to another table" column, the SUM tag is automatically printed. This is because I am trying to do a cumulative sum but am unsure as to how to get it to automatically update and display the sum when a new record is created.

How would you set this up?Department 1 is in charge of sending contract to customer, receiving contract, sending invoice and receiving invoice for initial payment. Once initial payment is received, Department 2 is notified and now needs to complete a certain number of tasks for 'onboarding that customer'. When those tasks are complete, Department 3 is notified and they have their own number of tasks for that customer, and so on.Thanks for any advice!

Um, yeah - it is. But first, a little of the backstory. As is often the case just when you’ve thought you’ve seen it all, a client asks - Is it possible to chain blocks and run them sequentially - as one completes, the next one starts? No, right? But then she tossed in another requirement - The computational results from the first block must be available to the next block and sometimes to all subsequent blocks. Oy! Nothing like a mind-bender for a Monday morning. This business requirement is daunting – indeed, impossible given the nature of Script Blocks. I’m sure the Airtable folks have pondered this, but as it stands, it’s off the table for now, right? Indeed, Script Blocks are simply not capable … until and unless … you factor in the amazing power of that which Airtable is known and most famous for - simple data/content

Why when loading words with the api, it does not load accents or letrta ñ??? Spanish characters

Hello Airtable Community,I am new to Airtable and currently working on a custom mini extension in Airtable that aims to upload CSV files into multiple tables within my base automatically. I have written a script for the mini extension to handle the CSV upload and record creation, but I'm encountering some errors.- The script prompts the user to upload a CSV file using the built-in file picker.- The CSV file has data that needs to be distributed across different tables, namely: contacts, company, line items, services, and invoices.- Each table has unique fields and linked records, and the script maps the CSV data to the appropriate fields accordingly.- I am using native JavaScript to read and parse the CSV content.Issue:When testing the mini extension and attempting to upload the CSV file, I encountered the following error: [Describe the specific error message you received, if any].Code

Hi! I’m not sure if this is possible and if so, how. But is it possible on Airtable to use a script so that when a record status changes, to get a popup to appear that contains information relative to that record and a confirmation button that will allow the base user to launch an action through that button (via webhook for instance) ? Thanks 

I have a base with a table that calculates commissions for employees based on the type of revenue is generated (e.g. Service Revenue, Sales Revenue, etc.). Each revenue type includes a specific commission rate. The Revenue Type field is a single select field. I have created a view that shows information for each revenue record. One of my colleagues is a collaborator for this base. I have created a Revenue Commissions view and created a share link and sent it to my colleague, whose job it is to select the correct Revenue Type for each revenue record. He can open up the view, but when he tries to make a Revenue Type selection nothing happens. When he places the cursor in the Revenue Type field, no drop-down arrow (or + sign) appears. In fact, he has tried to actually type an entry in this field and the field will not accept any input.In the Field Manager I have chosen "Specific Users" to define who can update values in the Revenue Type field and selected

Since today, our Airtable base has become extremely slow and is always being delayed by the attached message. We haven’t really changed much from yesterday/last week. It seems like Airtable has changed their loading behavior of views. It’s true, our base is large but it hasn’t changed much in size recently. Still, Airtable is hitting us with this kind of throttling. Anyone else experiencing it? Temporary issue?

Hi! How many tables can a base store? over 100?Is there any way to sync tables within a base?I have 6-7 tables in a base that stores task templates (based on accounts that get managed by various people). Originally I synced them to another base but changed each tab to specific accounts we manage. Since there is a 10 sync limit, I am trying to find a work around.Is there any way to have a template of tasks in a base and sync this to 30+ accounts other tables within the same base for task manage. I ask because, I am thinking that if a change needs to be made to the task manager, it would be quite labor intensive to change each accounts task list. it would be nice to change the template and have this apply to all of the tables the template is synced to - one swoopfor context: we have 90+ accounts we manage (schools). Tasks vary based on school system but are generally the same for all school systems. Staff manage multiple accounts across a variety of sc