Have other Airtable related questions? Post here!
Recently active
We have an internal custom (based on the print records app example) for printing a list of all records (project items) that are linked to a record in another table (projects). I’m trying to find a way to open that extension from an interface. In the table I added a button to the projects table that opens the extension with the project selected (through the useRecordActionData hook) but that field is not a button when added to an interface. So, I am wondering whether there are other ways to open an extension with dynamic input: Is there another type of component that can be added to an interface similar to the button fields? Extensions can be linked to in order to open them in fullscreen mode. Can additional query parameters be passed to the extension? (Then I could use an interface button with a dynamic link.)
I’ve done something and it might not have been that smart. I’ve built a webapp using Airtable as the backend. It’s a PHP app, using Angular, and so far it has mostly been working. Nothing super complex, just a customer engagement forum with the usual registration, access management, profile, and then some document management stuff (file / image upload), and a little calendar tool. I have limited coding ability, so have been working with a pretty good development shop in Vietnam, who have hacked the app together using the Airtable API. Everything has been working OK, and using Airtable has certainly supported me as a non-technical user in creating the table structure I want, but I’m starting to see some cracks appear. We hit the 100 record API limit last week, which caused some disruption, and I feel performance could be snappier. Currently we only have a few dozen users on the system, but I hope to scale this to a few hundred over time. My question is, will Airtable be able to scale wi
Hi. I am trying to create long-form articles where I manage the in Airtable. However, the long-text format has limitations and is unsuitable for this purpose. So I try the MarkUp plugin or RichText editor but don´t get it all the way.I aim to manage articles (blog) and digital assets (images, files, prez, hidden links) in Airtable and show them all on a web front such as Softr or similar.I see a base with two tables. Articles and Digital Assets.Do you have any suggestions on how this setup could work?
I'm new to Airtable.I'm thinking of creating a journal in Airtable. I currently use One Note. A nice feature of One Note is the drawing tool. I like to annotate text using it. Is there a way to do this with the rich text field type or another field type in Airtable?Thanks
Hello! I have a button which is posting Airtable data into a Data Pipeline via a script with a fetch request which returns a success or error via status codes on the fetch response. This action only needs to happen once so I’d like a way to disable the button when I receive a successful response but I can’t figure out how to do this. Interestingly I found another topic on here where a button is disabled but I can’t figure out how to replicate this for my use case. Here is tat topic - Button disabled when lookup field has value Does anyone know how I might be able to achieve this? Thanks!
Hi, newbie here ...I am building a table of lawsuits.I have a numerical field of $values, but sometimes this field is not a number, but rather an unknown value and it would be most appropriate to state "varies" for some records.What field attributes/other methods can I use to accomplish this?Thanks in advance
I plan all of my content in Airtable with detailed notes but my creative teams prefer Google Docs. Is there a way to automatically populate a multi slide brief in Google Docs?
Is there support for highlight, indent, and text size for the rich text/long text field? If so, how do I use it?
Hello,Previously in Airtable, it was possible to just drag and drop a serie of images on the + icon of a gallery view and all the records was automatically created with the image and his filename. It was great to create story boards or catalogs with a very fast operation. Now, when I try to do that, the + return "choose an attachement image field". But even if I create this field, my images are refused. I can only drag images in one record, but I can't now create automatically one record for each image.Thank you in advance if you know the solution.
Hi, I' new to Airtable. What I'm trying to do is to create a gantt chart with the start and end dates for the phases in a record to follow up the peoples workload which is different for each phase of a project. In one table I have the phases of a project in one record. I want them in a chart like below. I can create this with an automation via a "planning" table but I can't seem to update this table when a date changes in the original table. The link in the original table to the planning table contains the ID of each created record in the planning table (so 4). Can some one help me ? An alternative is to delete all data in het planning table on a certain time interval and rebuild the entire table but I cant find the way to delete all the records in a table. thanks, Koen
Greetings all I recently signed up to Airtable under the free pro trial. After deciding I wanted to continue with this platform I have opted to pay for the Pro Subscription however due to the trial they won’t charge me until it is over. I don’t have access now to Pro capabilities like uploading my own logo to a form and removing the Airtable branding. I hope to present this in an official capacity to my employer on Monday and not having access to Pro capabilities will hinder this presentation. Does anyone have any advice please? I have emailed customer support however not heard back from them as yet (two days ago) Thank you kindly for your assistance :slightly_smiling_face:
I’ve embedded the Gallery view on to my website, but I know that having all filter options available will be confusing and hard to navigate for my users. How can I specify what filter options I want them to be able to choose from (and ensure the other options are not available) in the shared view.
Hey all!So I am having a small issue with a report system I am trying to create. I have created everything but I am just not able to filter by dates. Let me give you some context below:The report layout looks like this, I am dragging information from 1 master database with about 1.3k rows into a report table I want to do. I made it so in the report table would have 1 row per type of report (1st row = annual report, second = Quarterly, etc). In this image you will see how I linked both tables and dragged the records and all of the other data.The data from the master database to my knowledge is being dragged perfectly, except for the dates.I have spent all day trying to figure out how to filter by "This year" or "This Quarter" with no success because when I try to filter by the look up field (the dates) really nothing happens as you can see here.Any thoughts? Thank you in advance!
I have read many responses that said this is a no-no but no one says exactly why. Yes, I know it is the first field - so what? Yes, I know that it is how other linked records get to it , but that doesn’t mean it needs to be visible in all the grids, forms, etc. Most of my primary fields are composed of bits and pieces of the record and are by themselves ugly and not useful to someone looking at a view. I usually shrink them down to the 50+pixels that I’m allowed to. Just, please, tell me why this is the case. Love most everything else in the heavy use I’ve given it during my trial.
I guess this is a dumb question ...If I design a to do list will my tasks sync between the Android app and my Windows app?
Hello, I'm looking for a way to add multiple linked records.Exemple : in the main table, I have a list of photo studios. For each photo studio, I want to save the number and type of electric power sockets available for each photo studio.In another table, I have all the types of sockets. I want to add as much link between a studio and a type of socket as the number of sockets present.Once I link a studio to a socket, this stocket disappears and I cannot link it "twice" or more depending on the number of sockets.Which solution would you suggest in this kind of situation?Basically, I'm looking for a way to store the information "This studio" owns "This Number" of "This Type of Sockets", and "This Other Number" of "This Other Type of Sockets".
Hello,I'm learning to run scripts and have been able to successfully write a couple of scripts for my work as a coach. I already know how to ask for the number of sessions (eg. ¿how many sessions?: 3) and then automatically create 4 records that are as follows: KickOff, Coaching1, Coaching2 and Coaching3. My difficulty is in how can I automatically create dependencies with linked records to the same table. So for example: Coaching1 has KickOff as predecesor, Coaching2 has Coaching1 as predecesor, Coaching3 has Coaching2 as predecesor.Attached you can see a simplified table... The script I have up to now is://Create Table Variablelet TableCreateDependencies = base.getTable('CreateDependencies')//Ask for Number of Sessionslet NumberOfSessions = await input.textAsync('¿How many sessions for this process?');//Create KickOfflet CreateRegister = await TableCreateDependencies.createRecordsAsync([{fields:{"Activity": "KickOff",}}])//Create Selected Number of Sessionsfor (let step=1;
When choosing a "Date" column, it only lets me add a specific DAY and time... but what if I ONLY want to add the year. Or a month and year. Is that possible?
Importing into a table (CSV, Excel, Pasted, etc.) with linked records will not allow mapping to linked records. The exact same data can be pasted into the GridView of the table and Airtable will expand the table to include the record count of the pasted data and correctly add the records to the table. The values for the linked records exist as would be expected by the paste into the GridView working properly. I am I doing something wrong? Thanks, Don
I’m creating a workflow to help with video production and scheduling. Is there a way to give feedback immediately when someone is filling out a date box on a form that will block that date from being submitted if another submission is already set for that date? For example, the client puts in a production date of January 1st. But a previous submission is already booked for that day, so their form will get feedback that date is already in use and another will have to be selected.
Hello! I have a base with ingredients, recipes, and meals. I’ve seen similar bases but none that ask this specific question. Airtable Ingredients Example - Airtable Explore the "Ingredients Example" base on Airtable. Meals reference recipes, and recipes reference ingredients. The meals table has a lookup to list all ingredients for the given meal based on the listed recipes for that meal. How do I get the number of times each ingredient has been used based on the meals table?
Hello! I‘m currently struggle with one problem. I want to make a system that allows a user to see recipes and calculate their costs. In a conventional database it’s pretty straightforward: you need a Recipes table used to present all know recipes and let user choose one than Ingredients table with actual costs of the ingredients and IngredientsInRecipes table telling us how much of each ingredient is in each recipe. Than we do SELECT from IngredientsInRecipes JOIN with Ingredients and have all costs for a given recipe at our disposal. It should be easy but I can’t do it in Airtable at the moment. Linked tables work in a peculiar way here and it seems there is no way to get a separate table including amounts of ingredients from one table and prices from another. Can you give me some advice?
I guess I have deleted a base, but I do not remember when I deleted it.Actually, I am not even sure I indeed deleted it.Can I see deleted bases and undelete them?
Hi, We have a Form that we are filling out and i would like to be able to refer to an instruction document for more detail. Can i add a pdf attachment or directory link to the document which will be there every time the form is opened? Cheers
I have the pro version of Adobe for availability to fill and sign documents. (Pro Version for Airtable too) However, the program only allows me to email the document to a person needing to sign. Is there an easy way to upload fillable/signature documents in Airtable? We have a shared table that has all forms employees need to complete and most of them use their phones and are not able to complete or sign these forms. It’s becoming to be more painful than helpful.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.