Other Questions

I have a list of volunteers that, when I collapse all, clearly shows their hours for the year - see attached.I would like to sort by this list in order to be able to see who had the most hours this year.Is that possible? If not - how else can I aggregate the info to get what I need?Thanks!~Lisa

Hi Airtable Community,I am wanting to create dashboards to represent my data from Airtable, using Google Looker Studio. What is the best way to get my data from Airtable into Looker Studio automatically? I have tried using the 3rd party Airtable Connectors offered on Google Looker Studio, but I keep getting an error where access is automatically revoked by Airtable due to  "security concerns". I have looked at the 3rd party integrations on Airtable and all seems fine there in terms of permissions.Using the Google sheets sync function won't work as my datasets are too large. And I am not too great at working with APIs either. And the Interface provided in Airtable is not an option.Any suggestions would be great!Thanks!!

Hi everyone, a few questions as I'm trying to find the best solution.Background; my employee would like to export client data from Airtable to import into a Google Sheet as they prefer working in that platform (they have issues with how AT can't filter/search via record comments, so we use a long text field for 'notes' but it overrides if someone else adds to it -- any solutions here would also be helpful).They will use the data to follow up with clients that have not booked their service after set periods of time (e.g. 3 months, 6 months, 12+ months).Anyway, back to the main issue - they want to be able to sort/filter, or automatically change the colour or move into a group after set periods of time since their latest booking. I'd prefer they work directly in AT as the data will always be up to date and it doesn't rely on automations. They also need to update data in AT after contacting the client so it'

This is driving me nuts and I can’t believe I’m a hard time figuring this out… I have a personal AirTable account for my freelance clients, personal projects, domestic stuff. I also have several partners that use AirTable. I do not wish to merge these accounts because that’s insanity, but I would like to be able to use both simultaneously without signing out/signing in constantly. Is this a very easy feature that I can’t figure out? Otherwise I’m launching a private window + the app or I could use something like Station to have multiple instances running. Ideally, I’d be running both my personal account and my work account from the desktop app, mobile app, etc. Any ideas?

I’m trying to create an online volunteer sign up system very similar to SignUp Genius, but through Airtable so that the data is easier to work with on my end for scheduling and data management. Ideally, it would show the event options, the position options, and then once all the positions are filled for each particular it would no longer show the option to sign up for that event. I would want to gather each individual volunteers name, email, and phone number. So this is less for long term volunteer management right now, but so sign ups and scheduling management for a series of related events with similar staffing needs. It’s pretty small scale, we have about 20 events that need 2-4 volunteer staff at each. Thanks in advance for any suggestions!

I’m working on a directory that has a Categories column set to the Multiple Select field type. I’ve cleaned up a good number of mistyped entries in this column, which created a lot of unused categories. Whenever I filter by a category, I see all of the unused data in the list. Is there any way I can remove all unused data?

I'm attempting to paste Date and Time information into an Airtable "Date" field which has the "Include time" option checked. But, when I paste Date and Time information, it all goes in the "Date" part of the cell, and none of the text goes into the "Time" part of the cell.For example, I'm trying to paste "11/21/2024 10:00 AM" into the Date and Time cell, but it puts all of this text under the "Date" portion, keeps the cursor in the "Date" portion, and enters the current time (i.e., 2:13 PM) in the "Time" portion of the cell, lol.How can I accomplish this basic copy-and-paste operation with Airtable's Date-and-Time formatted column so the Date goes in the Date, and the Time goes in the Time?For those unfamiliar, Airtable's "Date" field with "Include time" checked creates a cell with seemingly two cells within it, as shown in the screenshot below.Finally - I have all my dat

How do I make an attachment field editable in a synced base?  Any work around? 

Hello - I want to have a form that has different paths depending on your answer, but all link to an Airtable base. Is that possible? I think I need to use Zapier for that, is that correct? Basically, I do research - so I want the client to be able to choose the type of record they are seeking, and then it will pull up different fields depending on that answer. Once the rest of the form appears, they’ll proceed with their research request and submit it on my website. On the back end, the Airtable would have a combination of some fields that are awaiting input (e.g. their name, contact information, notes, etc.) and some fields that I already have the choices populated (repository, record type, etc.) I’m just trying to gut check that this is possible before I go creating. I would use the forms within Airtable alone for an easier solution, but it’s too complicated to include ALL the fields when some are only needed for certain types of records. Thank for any

I need to use Gravity Forms on my website because it allows me to take Paypal payments as part of completing the form. Can submissions via Gravity forms add records to an Airtable table configured with the same fields?

Hello, I want to show “0000009” in my cell inside Inventory table. I tried to use roll up but it shows “0000009” and “0000008”. How can i only show the latest one only (in this case is “0000009”) Thanks

I am fetching specific cryptocurrency data from CoinGecko using the Data Fetcher and populating it into a table called Tokens. Additionally, I have a table called Positions, which is linked to the Tokens table. The Positions table is where I track my Liquidity Pools.The challenge arises because the order of the Tokens table can change dynamically since it is populated with live data refreshed several times a day. Changes in market cap or the addition of new coins may shift data up or down in the Tokens table. This can lead to issues in the Positions table, where the linked entries might display incorrect coins.For example, let's say my Tokens table initially contains the following coins: BTC, ETH, ARB, USDC, SUI, FET, and MATIC. Suppose I’m tracking the MATIC/USDC pair in a Liquidity Pool within the Positions table. At

Is it possible to select a range of records in grid view using the checkboxes and apply a sort to just that range?

I deleted a couple of records from my inventory base (on purpose). Then I accidentally deleted a whole field. When I go to my Trash it says nothing has been deleted for 7 days. That’s not true. There should be two or three records AND the entire multiple-choice field in there. What do I do?

Hello Airtable Support Team,I have a question regarding permission settings and billing policies in Airtable.I am currently on the Business Plan.In the workspace settings, a specific user’s seat is set to Viewer.However, I was able to assign Editor permissions to this user at the base level, and they are able to edit the base as expected.I would like clarification on the following points:Why is it possible to assign Editor permissions at the base level while the user’s seat remains set as Viewer in the workspace?In this case, does Airtable’s policy ensure that no additional charges are incurred?Could you confirm whether this behavior is in line with Airtable’s current policy or if it is a system error?I would appreciate a clear explanation of the policies surrounding this matter.Thank you for your assistance.Best regards,

Over the last week or 2, the android airtable app has become next to unusable.If I perform any operation in the airtable app (modifying a record/creating a record etc), and then need to switch to another view or another table, I can't. I tap to change view/table and just get a loading wheel of death. The only way to open a new view/table is to restart the app. At which point, the problem repeats.We are a 3 person charity, 2 of us (full time) use Androids, and we have invested a lot of time and effort into building our airtable systems. We use it on mobile 95% of the time, and designed it to do so.Yet it's now totally unusable. My other full time worker needed to sign check hundreds of people off today at an event on airtable and could not.We asked our part timer, who uses an iPhone if she was having the same issue - it doesn't seem to be an issue for her, although she interacts with the data a lot less often.Is this happening for others? Is this an

Hello Airtable Geniuses:I own a custom window covering business and am trying to create a customer questionaire that can be imbedded onto our website or emailed to a customer. I'd like for the customer to start by entering their contact info, and then add ROOM NAME, and then under each ROOM be able to add several WINDOWS. For each WINDOW they would then be able to choose from drop-down lists for several items (ie size, colour, oerating system etc). Is this possible to do using Airtable and Forms, and if so does anyone have a sample template they could share? Or point me in the direction of a youtube video? 

HiI would like to compare 2 text fields. The first in "Internal" and the second is "External".I saw this solutionhttps://community.airtable.com/t5/formulas/comparing-of-two-values-in-rolled-up-fields-and-showing-true-if/td-p/61679IF( ARRAYJOIN({Internal}, {Internal}) = {External}, "same", "different" )which works only if the text fields are excatly the same including lower and apper case. ,eaning it is case sensitive.I am looking for a non case sensetive solution.IF( LOWER(ARRAYJOIN({Internal}, {Internal})) = LOWER({External}), "same", "different" )but "= LOWER({External})" is illigelHow can I useIF( ARRAYJOIN({Internal}, {Internal}) = {External}, "same", "different" )to be non case sensetive?   

How to add multiple images to Airtable's WebClipper inside a single attachment field?I know how to use css selectors to get a single image in an attachment field. I know I could use multiple attachment fields to get 3 images from a website with 3 css selectors. But I want to have all the three images (or however many exist) to be all added in a single attachment field.

Hi All,We are in the process of migrating our database from Airtable to MongoDB as part of a scale-up effort, and I was wondering if anyone here has experience with such migrations.Specifically, I'm looking to understand:Key considerations to keep in mind during the migration process.Potential risks or challenges we should prepare for.Limitations or differences between the platforms that might impact the transition.Any tools or best practices that helped make the process smoother for you.Your insights or lessons learned would be incredibly valuable to us as we plan this migration.Looking forward to hearing your thoughts!

I created a new view in a base with existing shared views. On this new view, the share button is not visible like it is on the others (see attached screenshot). I submitted a support ticket for this last week and airtable hasn't gotten back to me yet. Can anyone help?

I'm a video editor, creating a client portal in Softr. On the Video Details page I want to embed the video player review page (external). If I use a URL field for the embed code, Softr is fine with it. However, I set up a Formula field to concatenate the first part of the embed code, then the url of the review page, then the last part of the embed code. The formula works, but as mentioned, Softr doesn't like Formula fields. I set up a URL field, but just need to figure out how to get the results of the formula into it so I can embed it on Softr. How would I automatically/dynamically copy the results of the formula into a URL field?Thanks

I'm attempting to make a csv import into a synced table. I've curated the data to import and I'm 100% sure that it would only be updating existing records, not creating any new ones, but as soon as I set up the field to map by, I get this: Like I said, I have 100% verified that no records would be created with this import, I am 100% confident, yet this still pops up. Is this just a built-in constraint disallowing imports to synced tables, or is there something I can toggle to allow it?If push comes to shove I can create a helper table, import the data, then use automations/linking to get the data from the helper table into the synced table, that just seems like such a pain in the butt for what could be a simple import.

Hi, I am creating an app that takes user input and puts it into a Gantt chart. I am using Thunkable for this, however, when I run the code to display the Gantt chart, the screen shows: “airtable.com refused to connect.” I have attached the code blocks and the screen that is displayed. In the code for the URL, I am using the private link for that specific view. Let me know if you know how to fix this issue.

Hi All, I’m building out a comprehensive recipe / ingredient / shopping list tool which aims to be the place where I can convert 15 years of working culinary knowledge and interest. I’ll share this when I’m complete. I’ve read about junction tables, implemented one, and have looked at nearly all examples on Universe. Let me first apologize if I’m searching for something that’s been asked 100 times before in with different language. I’m just getting a handle of airtable (and quickly starting to love this product), but don’t yet intimately know the product / language. Today I have three tables, “Recipes”, “Ingredient lists”, and “Ingredients”. “Ingredient lists” is a junction table which forms the many to many association between recipes and ingredients. Avocado toast and guacamole both share avocado. This part makes sense and works well. Here’s where I’m getting stuck. Let’s say I have a recipe called “buttermilk dressing” and another recipe called, “little gems