Other Questions

Me and my team is often using Airtable on our phones. One of my colleagues is editor in two bases. However the app only allows her to filter on her phone in one base and not the other. They're both personal grid view.Is says this when she tries to filter in the base she can't filter:"UNSUPPORTED FILTERSThis view's filters cannot be displayed in the iOS app yet. Please use airtable.com in a desktop browser to display and edit it."Does anyone know why that is?

When creating filters for views, I often have to select a lot of options from a multiselect field. Once i've selected more than a couple, it becomes difficult to see all my selections. It would be great if the filter view area could be enlarged to full screen or expand to display all the available options. 

Hi Everyone, I’m getting a few enquiries about clients wanting to move from HubSpot to a Airtable based CRM. It looks like HubSpot allows the export of the Contacts, Accounts, Deals and probably other related activities but I wondered if anyone has been through the pain of doing this and associating the records back in Airtable. Any advice, tips, lookouts is greatly appreciated. Jason

What is the best form app which enhances airtable forms ?https://on2air.com/forms/https://www.fillout.com/airtablehttps://miniextensions.com/category/form/airtable-form/https://www.feathery.io/blog/airtable-forms-a-comprehensive-guide-for-2023 https://www.dronahq.com/airtable-forms/https://nativeforms.com/airtablehttps://www.formstack.com/integrations/airtable[Create Airtable records with Webflow Logic ](Create records in Airtable with Webflow Logic )https://www.typeform.com/connect/airtable/ 

Hello, I have a price list table and I want to update them following sector index.I will use api from the french statistic instute to automate the process but I am not sure which tool to use. I woyld be keen on just doing an airtable script.I am able to use the api of the institute (but I don't know how to code it into airtable script), the answer is a big xml file which contains basically a large number of series with dates  and values for each in two lists of the node serie X. What I want is to be able to parse this xml to merge the dates because there are the same and put it in a column and create one column for one index with the value.There are plenty of tools but I don't know which process is the best.Thanks you for your help!If required, I can attach the xml response file.

I’m very new to airtable but have learned a lot by watching tutorials and searching the community. I’m not sure if I’m searching for the right thing for this particular issue though. I’m setting up an airtable for a client who has a form that needs to be completed by his clients on a weekly basis. He needs to know who hasn’t submitted the form 3 days past the day he sends it out which will be on the same day each week. For instance, he’ll send the email with the form attached to be completed every Monday and if someone doesn’t fill it out by Thursday, we need to automate an email to follow up and remind them to complete it. I’m thinking I need a field dedicated to auto-populating whatever the current day is or at least a formula that shows when the week starts and when it ends. What formula do I need for this? This is literally the last thing I need in order to complete this airtable setup but I can’t figure it out. Any help would be greatly appreciated!

I have a solution with 2 tables: An Invoices table containing invoice information (date, amount, etc.) A Payments table containing payment information (amount, method, date, etc.) I want to link these tables so payments can be applied to invoices. I need a column that shows the remaining balance of each invoice after full or partial payments are applied. I created this using a lookup field and formula field in the Invoices table. However, I'm having trouble when I need to apply one payment across multiple invoices (either to the same vendor or different vendors). Currently, the lookup field calculates the full payment amount towards each invoice, which is incorrect. Is there a way to split a single payment across several invoices, allowing me to specify how much of the payment should be applied to each invoice? I need the final balances to correctly reflect the payments for each invoice.

Hi,I am setting up an automation with integration with Outlook emails. I can only find limited trigger options. I don't want all my emails to go into AT, only select ones. I figured I would do this by making the trigger conditional, i.e. only when an email is designated with a certain category will the integration trigger and the email post in AT. Does anybody know if this is possible?Thank you in advance, Christopher

Hi there-- When working with the Form builder (NOT the interface or the form view), I get the following message when I go to publish a form with a linked field. Does this mean that the linked record itself is somehow exposed, or is this warning just in regards to the fact that the linked field in the form builder can be configured to show additional fields and not just the primary field? Thanks in advance for any help.Linked records will be visible to anyone on the web.To hide sensitive data, edit the linked record field to limit what users can select. 

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's a bit of double-handling, but I'm trying to work with them and wh

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 data in a Google Sheets spreadsheet, which I could easily copy-and-paste into the Airtable table. BUT, right

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 input! Alexa

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 first, MATIC is in row 7, and USDC is in row 4 in the Tokens table.Now, if the market cap changes or I add a new coin, such as SOL, which is inserted into row 4, the dat

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 issue with our phones being a bit old