Other Questions

For the Free version I only have 1 base for my social media calendar. Can i have 4 collaborators that can edit and comment without upgrading. This is the only thing I’m using Airtable for.

Hey Guys, could you tell me about the tools that you’ve used or heard to create a mobile app with Airtable as a database. I have some experience with Glide and Adalo but they do not have Airtable integrations, so I need to migrate data to google sheets somehow, looks like a complicated thing to do. I need to represent my Airtable data with some mobile app interface. What would be the best options?

In my template table I have a lookup field that is formatted as currency. In the child table I have the same field with the same formatting, but I'm getting an "root must be a number" error when I run the script. I'm guessing this needs to be modified in some way because of the lookup field issue, but I'm not sure how: 'templateRate': c.getCellValue('Rate')

Hello, When setting up the Gantt view, I have the start date field as 'start date' which is a date field that is added manually by the user.For the end date field, I want to add 'Due Date test' which is a formula field. If I select the due date test as an end date field, I cannot change the timeline (drag the box) in Gantt view since the fields in start date and end date are different. It looks like I can add dependencies. Does anyone have advice? I need to keep the due date test as a formula, but the Gantt view and making changes in that view is crucial.Thank you.

I have a table called Job Codes/Job Titles. I listed the job codes (numbers) in the primary field and then the job titles in the secondary field. In another table I added the Job Codes/Job Titles as a linked field. I want the ability to look up a Job Code (in this linked field) by its Job Title in case I can't remember the Job Code.  Right now I have to start typing in the Job Code number (but we have hundreds of Job Codes). Is there a way to do this other than making the Job Title the primary field?For instance, I may have a job code 0004 with a job title Academic Intern. In the linked field Job Codes/Job Titles I want to be able to start typing in Academic Intern and have it bring up both the job code (primary) and title (secondary).Thanks for your thoughts.

I'm trying to set-up some complex financial calculations, including amortisation schedules per new user record, based on data entered by the user as well as set annual figures from another table. I am struggling with the best way to set this up. There are 3 amortisation schedule type tables I need to set-up for each user, but am feeling that the horizontal nature of the table ( since the users are on the vertical axis) makes this a rather complex and confusing string of data. Perhaps there is a trick I am missing to make this easier? or have a nicer view without needing to automatically create tables for each new user and their specific schedules? 

I was creating a new base and went to add in a synced table from our main data set and got the above error. Has anyone seen this before and know how to fix it? We are on the Enterprise plan and as far as we are aware there are no limits on synced views

Does anyone have any feedback from being on the enterprise plan? I’m curious what the deal is and what the drivers were to switch from pro to enterprise.

I'm going through a pretty typical workflow here of mapping Airtable to Webflow with the NoBull Airtable Extension.1. I have a created two tables "Blog Posts" and "Categories" with the standard Airtable fields mapped to Webflow fields. All good.2. I have connected the "Categories" table to Webflow through a NoBull "Categories" Connect--All good. 3. I have connected the "Blog Posts" table to Webflow through a NoBull "Blog Posts" Connect--All good.3. I have created a linked field called "Categories" in my "Blog Posts" table which links to the "Categories" table. It works.4. When I go to map the linked "Categories" field from my "Blog Posts" table to the Webflow Categories field through the NoBull "Blog Posts" Connect, I am select the appropriate Airtable & Webflow fields, but I am not able to do anything with the "Select Reference Connect" dropdown, to connect the linked table--the option is not available to me. 

Hi there,I work at a chain of veterinary clinics and I'm looking to create a process for medical records upload.1) I have a grid created "Medical Record Workflow"2) Connected to the "Medical Record Workflow" grid I have a form that contains the following data points:Client Name (Short Text)Patient Name (Short Text)Medical Records (Attachments)Any other helpful information (Long Text)3) We have an automation that whenever a Checkbox field is checked it sends an email to the other veterinary clinic that we're try to gather information from In that message I'd like to create a pre filled form what the other Vet opens up and uploads medical records to. The problem I'm dealing with is when the form is submitted it's creating a duplicate row. Is there a way to prefill a form that updates the existing row?

After using AirTable for a few years to manage some operations of our company, I want to also use it for invoicing.As per our local regulations, this needs to be done via an approved platform. The platform that we are using integrates with Zapier and Make, so connecting between Airtable and the platform is very easy.However, I'm trying to make things a bit more complicated, and would like to know if its possible:1. Pushing a button / trigger for a record to call the automation and create the document.2. Retrieving the document via URL / Location on Google Drive and saving it as an attachment for the record.

The Airtable pricing page says that the Free plan includes up to 5 creators/editors and unlimited commenters and read-only users. Do those apply to the Plus and Pro plans? If not, why not? Am trying to get Airtable a paying customer and can probs get my client to go from paying $0/month to $10/month but they need those commenters and 1 creator (that’s me). I know that Enterprise is the latest and greatest thing, but they can’t afford $10K/year. Thanks so much.

Hello all,I have a table that's filled with (linked) dates. To be able to view all the dates in a list, i've created in the script app a script to give me that list. But, is there a possibilty to sort that list?Below the code: // Change this name to use a different table let table = base.getTable("Deadlines"); // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); let Weer = record.getCellValue('NB-Weer - DATE'); let Dag = record.getCellValue('NB-Dagkrant - DATE'); let Pagina = record.getCellValue('NB-1-1 Pagina DATE'); output.markdown(`**NB-Weer:** ${Weer}`); output.markdown(`**NB-Dagkrant:** ${Dag}`); output.markdown(`**NB-Dagkrant:** ${Pagina}`); ... and the result:

Looking for guidance. I have deleted/removed a collaborator from a workspace but for some reason they are still receiving email notifications whenever here is activity in that workspace. Not sure if I'm missing something?Thanks.

Has anybody tried this ?

I have an issues table and a issue log form is created where users use it to log their issues. Once the issue log form is submitted i want the Issue ID or record ID of that issue to be shown in the form(For example when we post a complaint on swiggy or zomato it will give us a unique ID for our complaint)

Airtable MacOS Desktop App v 1.6.1 – download button not working in the Attachment field. Previous version 1.6.0 works fine, and also the web version works. iMac, macOS 12.6.6 Monterey. Is there an archive of older versions for OSX somewhere? Is it possible to report a bug outside of the Community forum? Thank you.    

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, or

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?