Have other Airtable related questions? Post here!
Recently active
I have a table with multiple tabs that delineate project categories (I’m in Marketing so eblasts, social, blogs, etc.) and each of the items has an “owner” field with a collaborator assigned. Is there anyway to create a view or additional table where I could log in and see all the projects I’m working across all those tabs? I know within one tab I can filter for things assigned to me but I’d love to see everything I’m working on easily in one place
Hi. I want to use features like record coloring and manage fields, that are in the Pro plan. Others also use my tables, but I'm the one who would use these feature. Can other users see the result of my changes if I'm the only one with Pro plan?
Hi, i have problem with form responses, so i have created form from multiple table but there's no option to get from responses, is there something missing or i need to do something for someone who fill the form can get the form responses?
Hi,Sorry about the newbie question: via scripting, I´m trying to import a csv using .parsedContents however my csv has several spaces and non-AlphaNumeric characters in the headers so when I come to map the fields I don´t know how to specify them, for example line 4 in this snippet there´s a space between LAST and NAME:1 let newRecords = fileRows.map(fileRow => ({ 2 fields: { 3 'Email': fileRow.email 4 'Last Name': fileRow.last name, 5 } 6 }))As I have several files to import several times a month I would not like to have to "cleanup" the csv in some other spreadsheet as it´d defeat the whole purpose of using airtable as I already have (an ugly) way of doing it all in excel.Or is there a way to use the extension CSVImport via scripting using a predefined csv>table field pairing for each table?Also, I´m wondering if it´s possible to run a script any other way apart from the side extensions panel. Is there any way to have a custom but
Hey there!Started playing with the new "List" view type and noticed that there is no way to reorder "Level 1" records. When I hover on a record, I can see the icon that usually implies ability to drag and drop the record... but when I try to do this - the record just gets selected (check mark on the left) and nothing happens. I know how to reorder records on grids. I made sure the view doesn't have any sorting rules or anything else that could interfere with the drag and drop function (reordering)... and nothing helps. Is this a BUG?p.s. thanks to the Airtable team for the new view type! I'm overall enjoying it so far.
My code is really long so I'm not posting the whole thing, but here's the gist: let choice = await input.buttonsAsync('Is the stock received from a pending order, transfer or unsure?', ['Pending Order Received', 'Transfer', 'Unsure']); if (choice == 'Pending Order Received') { //code here with no errors } else if (choice == 'Transfer') { //code here with no errors } else if (choice == 'Unsure') { //code here } I'm getting this error with the last if statement for 'Unsure' and I don't know how to fix it:
I'm attempting to create an invoice and all fields are pulling in except one. No matter what I do, it isn't being imported into the Google Doc. Here's the formula:"$" & {Materials to Plain Text} & ".00"The formula works fine and returns the value I'm looking for in the base, but it won't come into the Google Doc. All other fields are coming in as expected. What might be going on?
I added all my files to my projects a few days ago. After I uploaded them, I realized I was WAY over the limit. (I had misunderstood how that worked). So, I went through and took out all of the photos and voice recordings. It got me back under the limit. I decided to add links to my published articles for each project. As I'm doing so, I realized I was over the limit again.What all goes into the amount of space that causes an account to be over the limit? Right now, upgrading plans isn't something I can really afford but I can't keep going forward in adding things to this chart if I have no idea what the parameters are. By the way, I've looked at the tutorials and either this question isn't answered, or I missed it.Thanks.
I know Airtable was experiencing issues this morning but I continue to have trouble with bases not loading. Anyone else? I have tried all recommended troubleshooting and one base in particular that is showing an issue with records loading is one of my smallest datasets, so I am confused.
I'm creating a project management platform and need some help in terms of organising tables.I have three different tables:Users - containing private informationProject - containing projects we haveProject participants - containing a row for project name, user id, and custom fields (columns 1,2,3) which contains information about that user for the project only. For example project user id or if they are participating in the project currently.I'm having some hard time as we use Softr for this development, and I would like to be able to allow a manager to add or remove participants to a project via the project participants table. That is at least the workflow I have now, but might be that it needs a full redesign. Anyone who can help on suggestions and best practises?
I have granted external 3rd party apps access to a base for testing purposes. How can I remove this access again?
Hi everyone!I want to get Cell values with ID from multi select field by field id of a table using php.https://prnt.sc/HasxED_1cZTbI have a table named "Cand", and there is Irish_Affinity field in Cand table.I know the field ID of Irish_Affinity.So, I want to get Cell values with IDs based on Irish_Affinity field id using php.I can't find any fomulas in airtable API.Is it possible?Please let me know, thanks!
Maybe someone knows what to do… We use Airtable for order management and are filling in new orders with a form. If a new row is created by form, prefilling cells doesn’t seem to work (we have a column for the approriate amount of VAT which is used to calculate the right invoice amount). The cell is correctly prefilled IF we create new rows straight in Airtable without using the form. This seems to a bug, right? Or does anyone know how to fix this? Thanks!
Hello community, there's an overwhelming number of suggesting apps (eSignatures, Docupilot, SignRequest, PandaDocs, SignNow, PDFFiller, DocAutomater...) to create docs with an e-signature from a template. I'm particularly looking for a recommendation that works with Make/Integromat and supports line items to build dynamic pricing tables. Thanks!PS: Alternatively, what service would you recommend to add e-signatures via Make to unique Google Docs.
Hello,I have been building a database for my small newspaper/publishing company. We want to track accounts information, ad orders and runs. It's important information.It seems to me on the pro plan that anyone can share any table by default is they're able to add data?? How can this be? Is there a workaround? If I hire someone, they could theoretically share the data with someone else or clone the entire database without my knowledge? I've read the other posts and documentation and this seems to be the case...Can anyone enlighten me on this? It's such a glaring issue that it is making me stop the Airtable process. Is this better controlled in Enterprise?
Hello, I’m trying to send a Javascript array with multiple values to my Airtable (multi-select field). Array example: var colors = [ "#4BC2A4-a", "#4BC2A4-b", "#4BC2A4-c", "#4BC2A4-d", "#4BC2A4-e", "#4BC2A4-f", "#4BC2A4-g", "#4BC2A4-h", "#f4a261-j", "#f4a261-10-k", "#EF616C-11-l", "#EF616C-m", "#EF616C-n", "#EF616C-o", "#f4a261-p", "#f4a261-q", "#f4a261-r", "#f4a261-s", "#EF616C-t", "#EF616C-u", "#EF616C-v", "#EF616C-w", "#f4a261-x" ]; But Airtable creates only one unique item with all the values inside: How it should be: How I should format the array to make sure Airtable will separate the items by comma ? Thanks.
I tried to set up a Zap to create detailed events in Google Calendar when new records enter an Airtable view – the Zap will NOT work (error 400 bad request) if I try to update the event's visibility (public/private) through Airtable mapping. So my question is WHAT kind of field in Airtable will cooperate with updating event visibility in Google Calendar? Through Zapier, when mapping Airtable fields, there are options to select the calendar default, public, private, or 'custom' where you can then map the Airtable field. I selected 'custom' and have tried a single select, multi-select, and even (ick) a single-line text field to be able to update event visibility through the integration, but no luck yet. Any advice?
Hello, I am relatively new to Airtable and I am having difficulty creating a simple clustered bar chart in the chart block. In excel my table and chart looks like this… Any suggestions?
Hey! 😄I'm trying to use for the first time Airtable in a Macbook Air with MacOS High Sierra 10.13.6 and it won't work - error pglhNFcYRPMwnZ6Ry will appear constantly.I tried to refresh the caché, the page, use different browsers and use the Incognito mode, but still stuck with the same issue.Any ideas on how to fix it? Thanks in advance!
My friend shared an interface and gave me editor permission, but I don't have edit mode on my page and can't type anything in that interface, what could be wrong?
Hi, I wonder if anyone know detialed rules about what should happen when data is pasted into a table where the data is sorted.I have one table sorted by non-Key field (a-z). I was pasting a set of data from another table to this sorted table every day. All new data have the sorted field value > exisring value, so they appear at the bottom of the table. However, I found out recently that only 1 data was added (because I need to create 1 new record when pasting the data), and the rest of the new data was overwriting the data at the top of the table with the smallest sorted value.I guess that the 1st pasted record has the sorted field = blank for a split second which placed the first pasted record at the top of the table. This would have made the rest of the records to overwrite existing records. However, I didn't receive any warning messages during this process. I was believing that I was adding all of the pasted records to this table for a long time.Now, I am reviewing all of th
I've been unable to find or devise a way of chaining two actions in a row, triggered from a button on an interface.I'd like to automate two actions with a single button:run a script to prepare some data and,take the user to another interface, where those data will be presented to support another activity.Both actions are offered as separate options by the interface editor for a button, but I want to have them consecutively executed with a single keystroke, that is, associated to a single button.Anyone that can provide an idea / suggestion, I'll be happy to know.Thank you.
So we use Airtable to house an inventory system, for both existing and new assets. New assets are written into the system as a new record via a form. Up to this point, we’ve used autonumber to generate a unique easy value for vendors to reference to as a PO. I was under the impression that autonumber values COULD NOT be user changed unless the user was changing the field type to another value and changed it back, etc. We’ve spent about 6 hours today chasing down problems with the autonumber field seemingly renumbering itself, based on how a filter or sort is applied at the time a record is added into the system, or another user is editing a record, etc. Does anyone else have any history or ideas on this issue?
We are using airtable to manage our content with around 10 accounts. Now, our accounts are PRO (Comprehensive collaboration) level with 50000 records per base. We want to upgrade to ENTERPRISE (Maximum business value) with 100.000 records per base. I want to know how the cost will change per user / month. (Currently, we are paying $ 20 / month per user)
Hi all, Is anyone else experiencing quite significant issues with the new Airtable App update? We’re heavily reliant on using the app as a company & the update is throwing up a lot of issues. Couple of issues we’ve encountered so far… Opening a linked record will not present any data, just a blank record. To get around this, we’re having to create a new record and then it will allow you to open the linked record. Frustrating! Linked records are hit and miss with even opening. Having to close the app down and re-open and it will work. Cannot edit records. Again, having to close the app down and re-open to get any joy. We would love the ability to transition back to the old version! I really hope I’m not the only one struggling with this. Cheers
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.