Have other Airtable related questions? Post here!
Recently active
Can you export Airtable to Method CRM or just in general in a csv or excel file format?
I use airtable primarily to make document product info with pictures in the grid view. It would be great if Iwas able to export the entire view with the pictures in their places in excel. Right now only the image irl is exported in those cells while rest is good. Does anyone have a way to fix this?
Is there a way to export a base table from Airtable to Excel and maintain formats? I’ve only been able to export to CSV and then I have to redo all the formats in Excel before sharing it with another person. Thank you Julie
I need help - my CSV file is downloading the line breaks in my long text fields - I tried to eliminate them running >REGEX_REPLACE for \r, \n, \r\n, u2028, u2029, u0085, u00B6This took care of most of the line breaks but there are still 2 stubborn line breaks I cannot beat HELP!
Hello everyone, I am a complete novice to coding anything - I still need to reference for spreadsheet formulas, for example. I am also a fairly light user of Airtable. That being said, I would love to figure out if there's a way to auto-total merchandise costs for a complete order coming from our online store.Essentially, we have two tables that pertain to orders - one is for an entire order which has basic things like subtotal, total, tax, etc that are pulled from our store via Airpower. We would like to create a Merchandise Cost field per order as well, auto-calculated from another table... but I'm not sure how to get that done. The second view (where the cost information lives) is a Order Line Items view that has the information for each item as a field - what order number, the number of that item, the cost, the sale price, etc. Is there a way to do a conditional sum by order number from the Line Items table (cost, quantity, order number) to the Order table so we ca
All was ok 2 days ago and now one of my client's guest accounts cannot log into their base. It is giving you a connection isn't a private error. I logged out all accounts under their name, refreshed, used incognito, cleared cache and cookies, and restarted the computer, they use edge so had them try chrome. None of this worked any one know what to do here?
My airtable base is used as a product. I provide access to people, by inviting them via email. I don’t want them (my clients) who are assigned as “collaborators” to be able to view the emails of the other people who have access to the base. How is it possible to do this?
I have created a pre-filled form link with the extention. Then I created a button field with the action to open the URL of the pre-filled from link field. The idea was to add this button field to a form view, but I am not winning... Any workarounds?
When trying to input data into my Airtable the iCloud auto-fill option for hiding my email keeps popping up. For drop-down inputs, the password autofill comes up instead. This is preventing em from choosing certain inputs and making t difficult to work with the application. I am using safari and I believe the issue does not occur on chrome. However, for my workflow safari is a much-preferred application. Has anyone experienced this issue before? I have already noted it through the support as a possible bug but would welcome any help on how to fix it. Below is an example.
Hi, we are an ad agency in South Africa that is looking to automate and improve our company data with Airtable as a basis. We are looking for someone with excellent Airtable skills, strong database knowledge and a good understanding of the kinds of BI tools and other add-ons that will enable us to better manage and report on our data. Please email me jarred.cinman(at)vmlyr.com if you're interested.
Recently something has changed as to photos can be uploaded to a table. I was able to do a multiple selection of photos and add them directly to a record. Don’t know when it happened but now I have to upload them one at a time not to mention when airtable looks for the photos it is not sorting them the way the phone does and it is a pain to refind the ones I want - one at a time. Any suggestions?
We have an existing base that has the fields we need to track each account. I am looking for a form template or one I can create that allows anyone wanting to request something from us to to fill out the form using a link. The link opens up to a fillable form that has preset fields (required or optional) and a way to attach documents, image, spreadsheet, etc. When they submit the form, it comes into a dedicated email address but also gets added to the existing Base in airtable we have. The form fields will be the same fields as those that exist in the base. Do you have such a template or format that I can customize?
I’m a pro wildlife photographer and am trying to use AirTable to keep track of my photos and associated info. Can I export a record? If so, how? Can it include the info plus the photo? What formats can it be exported as?
const common_js_object = {COMMON_OPTIONAL: 'Optional',COMMON_NA: 'N/A',COMMON_AND: 'and',COMMON_TERMS: 'Terms of Use',COMMON_PRIVACY: 'Privacy Policy',COMMON_OR: 'OR',}}));console.log(newRecords);const batchSize = 50;const numRecords = newRecords.length;for (let i = 0; i < numRecords; i += batchSize) {const batchRecords = newRecords.slice(i, i + batchSize);await table.createRecordsAsync(batchRecords);console.log(`Created ${batchRecords.length} records`);}I written this script to create a new record inside a table from a javascript object. But I want to be able to update the entire table from this object instead of creating new records. I am not sure how to use the updateRecordAsync method. I am new to coding. I tried different approaches but showhow they all gave error could anyone help me.
Hi all,I'm very new to scripting and am struggling with the syntax to write to a multiple select field. I have single select fields ("Monday AM", "Monday PM", "Tuesday AM", etc) that can be Y, N, or blank.I have formula fields ("First Monday AM", "First Monday PM", "First Tuesday AM", etc) that calculate a date based on a user-entered date.I have a multiple select field called "Availability". If "Monday AM" is Y, I want to pick up the date from "First Monday AM" and put it into "Availability."Here is my code: let scheduleArray = [];if (r.getCellValueAsString("Monday AM") == "Y") { monAM = r.getCellValue("First Monday AM"); scheduleArray.push(monAM);}if (r.getCellValueAsString("Monday PM") == "Y") { monPM = r.getCellValue("First Monday PM"); scheduleArray.push(monPM);}await s.tableSource.updateRecordAsync(r, {"Availability" : scheduleArray}); Error:Can't set cell values: invalid cell value for field 'Availability'. Cel
In the record review of a table I have a field for another linked table. When I click the “+” I get an option to create new records (linked table). How can I customize the form that appears after clicking “new record”, for the linked table? I don’t seem to find that option anywhere in the interface designer.
Love the new "List View"I created a List, but I see no way to PRINT it.Also, when I download the LIST VIEW to csv, I get a LOT more fields than are on the List View.Anyone figure out how to print the list in List View?Thanks!Lawrence
I want to sort these groups 1->9 by the Sum. There have been a lot of questions on the topic but zero definitive answers. I will buy the full version of Airtable, but only if this can be answered. Thanks!
Hi Everyone, I’ve got a table that pulls Google Calendar events for my team into Airtable. It’s there to build an interface that breaks the events down and gives summaries as to how many days are spent On Site, Working from Home, in the Office etc… I need to find a way to be able to filter out, or mark with a checkbox, the records that happen on, or span a weekend. Google Calendar only brings in start and end dates of events. Any pointers would be fantastic. I’m quite an experienced Airtable user, but have no experience of coding but willing to try. Thanks!
It would appear that the URL for attachments is no longer showing the file extension, and the location has changed a bit as well. It’s breaking things for me :sob: Wondering if this is a bug or a new way attachments are being handled. Any thoughts on this appreciated.
Hello, What is happening when the "open form" button disappears for certain users? Attached is my view with the button showing, but for colleagues it is no longer there: Thanks!
I use galleries to show selections of fonts and real-life projects using those fonts. Since the latest major app update, I have had numerous issues with the airtable app. The current one is that my gallery photos won't load unless I scroll through them all from the grid view first. Also, every time I change filters, the app crashes, and then I have to repeat the above process. Something that takes an average of 2 minutes every time. When I am working with a customer this causes a massive issue. Honestly, I miss the old app versions, but since going back to those is not an option, I'm wondering if anyone else had had he same issue; and if you have...were you able to find a way to fix it?
We use AT to manage our donors. I am trying to set up a reminder as I assign tasks to my team members. How do I do that?
Hi, I invited a new user to a base, however, the emails aren't arriving nor are the confirmation emails arriving.I emailed them the link to the base which arrived, however, they need to confirm their email but that confirmation email is also not arriving. AM I THE ONLY ONE HAVING THIS ISSUE?@dashler78 @support12
Is it correct that it is not possible anymore to add a new field within the mobile app? Or am I doing something wrong?
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.