Other Questions

Hi guys, We are a builder and I want to be able to report on the Issue Types encountered during the each build and when and how often they are occurring. Therefore I have the following tables: Builds - (Linked to Issue Occurrences, Page Designer Based on this table) Issue Types - (Unique Types of Issue) Issue Occurrences - (linked to Builds and Issue Types) On site the guys register occurrences of different issue types against each Build as they happen. I want to produce a report on each build that summarises the build and gives information about what issues we had and how frequently they occurred. I have a Page Designer Report done up based off the Build Table. When I drop the linked field to Issue Occurrences onto the page it gives me a list of all Issue Occurrences. What I actually want is a summarised list of these occurrences. This would be solved with a Group By operation normally but that is not available in the Page Designer Options and the Group By function for the Issue Occur

When I scroll down on a table in the Grid view when I have more records than fit on the screen everything scrolls back up to the top. See the video below.

Hello, I do have a table with 10k rows in it. The table contains WooCommerce orders (including the address from both the buyer and recipient). Each address has about 5 different columns (i.e. address, second address line, postcode, ZIP etc.).So what I need to do is to append both address types (buyers address and address of recipients) in the same columns. At the end it won't make any difference if it is an address from the buyer or recipient. All data should be in the same columns.So at the end there should around 20k rows in the table (containing the addresse of both buyers and recipients). I.e. row 1–10000 should contain the buyers addresses and in the same columns from row 10001–20000 the addresses of the recipients. How can I add 10k more rows and copy paste the values from the columns (recipient) in the corresponding columns of the buyer? Thanks a lot for help, Michael

Hello. I've just started using Airtable today. I've created a database of workshops for my job. I have add a calendar view, which shows the workshop title and facilitator. It all looks great! However, when I subscribe to this calendar through Outlook or Google Calendar, it only shows the workshop ID. How can I also display at least the title, too?Thank you!

Hello, I have a table whose fields are mostly file attachments. when I 'send record' via email, the attachment resolution decreases and images are pixelated upon zooming. Also the file names are being changed from the original names.Are there workarounds?

We have a seasonal workforce of 2,000 to 5,000 people. During twice a year events, we need to email these people many times based on views. We 're wrapping up our first event of the year, and the messaging has been a disaster. We are spending (wasting) HOURS on email management.Our IT department will not allow us to use Airtable's built-in email features so we must use the SendGrid extension.RequirementsLook up a person and see which emails were sent to them.Resend an email to a specific person.Email templates that can be reused and/or copied for future events.The Extensions dashboards are impossible to manage. The "Manage Extensions" window is so narrow that you can't see the full titles of the extensions. Making it full screen doesn't help.Extensions appear to be ordered from oldest to newest with no way to sort or search them.When you do find the extension you want, you then have to choose the view for it. We cannot discover any sorting logic to that list. All you seem to be able to

I see the confirmation on my account page that all of my collaborators have joined. However, it was a few months ago for some and they do not remember accepting or logging in. Where can I send them to login if they don't know or remember creating a password? Is there a way I can send them another "first time / start" email? Should they just go do the steps for creating a new password?Thanks.

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:Very much a scripting newbie so any help or pointers very much appreciated!Allready a big thanks and any help is welcome

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.