Other Questions

First using airtable but profecient in Python, SQL and some JavaScript/Vue3.js for house needs. I dont consider this a "complex problem", but havent been able to crack it in Airtable env. only.I have a scenario where i want to dynamically control form field visibility based on "boolean" values from another table. I am aware that form defaults to communicate with one record at a time given the table it belongs to.I have a table named "application" and another "analysis" and fieldsnames are generally the same. once "application" has a PDF file attached, analysis makes a "lookup" and a python script executes 16 rather complex regex patterns and saves the output as boolean values, could be "1 or 0", "yes or no" and "ja or nej".From the analysis output, the idea is/was to use these booleans as a condition to manage visibility and nothing else. Because, as you can see in the bool_update_flow.png attachment, the users are to upload specific images.If it is, can

Hi all, New to Airtable and trying to find a way to do the following:We have an existing base with all projects as a furniture staging company. These projects are based on addressesEach project has inventory associated with it in a separate Excel doc at the momentWe want to now add the inventory associated with each project in Airtable without having to manually add each item one by one to each projectThe excel would have the project title + associated inventory in individual rows. Is there an easy way for the import to recognize the project title (address) and then easily "assign" the inventory name and QTY to that project title?  

Hey all, just trying anything at this point, I have an airtable Team account that was made forever ago, and was grandfathered into the $10/mo plan. I accidentally aded a billable user but then removed them, but the system kept trying to bill for it, and not my account is cancelled, along with the money I have already paid, and the $10/mo plan I had.I have emailed half a dozen times now over a month and no response, and my account is going to get shut down.Anyone here that can help?

I have a table with a count field that is supposed to count the number of linked records in another field that meet certain conditions. For some reason, the count field is not properly filtering the conditions and is counting ALL linked fields. I am not sure why this is happening as I have set this up properly. I have checked off "Only include linked records from X table that meet the following conditions" where "Status" has any of "X, Y." It is still counting fields where the status is not X or Y.Does anyone know why this might be happening and how to fix it?

Hi all, I do property inspections and wanted to create a template where I can fill out every time I do an inspection but it can create multiple records. For example, here are the main items I inspect (doors, walls, drains, landscaping, etc) And I would like to fill out a form that can create a different record for each of those items. Is that possible at all? Thanks in advance!

I cant figure out how to get the text to wrap here.

Hi there!I work for a nonprofit that sends frozen meals to families with children with cancer in British Columbia.We've leveraged Airtable to run our inventory and order management, but we've gotten some feedback that families are having a hard time with seeing the dietary restrictions for a specific item on our order form.The order form is set up so that it pulls products from a specific view that categorizes the product into a main, side, etc.Does anyone know of any way to make it so that the families could see the whole text?A workaround is that when they actually add the product it shows all of the information - if they saw something concerning and wanted to remove the product they would just have to remove it and then add another, but this is counter-intuitive and confusing to many people.You can see a video of the cut off text at the following link:

I cannot figure out how to recreate the interactions table in the templates (for CRM) made by airtable. I'd like to make a form that references that table so each time I make a contact with a customer or contact, I can record it in that table. I could try to make a table myself, but I don't need to reinvent the wheel. How to I get that Interactions table into my Base?Attached are screenshots of the Real Estate CRM of the Interactions Table and the Form that goes with it.Thank you!

I’m looking for a better way to save and share images through Airtable. We use ShareX to capture and comment images which we typically share in Slack: hit ctl-printscreen to grab an image, paste into a conversation and hit send. We’d like to use Airtable to document more of those tasks but it’s a hassle to get images into Airtable: browse to the ShareX document folder, find the file, upload, wait… ShareX can automatically upload to Imgur and put a URL on the clipboard instead of an image. It would be super-great if Airtable could show those URL images, page previews, poster frames etc. It would also be super-great if we could just paste images into the attachment field.

Hi, new Airtable’r, I searched around but couldn’t find answer to this! I’m surveying my customers about their opinions on products we’re considering developing. I have a base that contains a table with details about all the potential products, including a field I made customer ratings. I’d like to create a from that displays every product in the table, showing its image and description, and a place to collect their rating for that product. I’d like to be able to use that form to see customer’s average ratings of them. Is this possible? Thanks!

Since personal views cannot be restricted to 1 user, I'm looking for a workaround.I'd like our users to be able to create their own personal views based on a master table.I don't want them to see anyone else's personal views (which AT currently doesn't allow).I need to set up automations based on each user's personal views (so I don't believe we can use interfaces).The solution I came up with was a master DB 1-way automatically syncing with multiple bases, but the problem there is the sync feature is unreliable. AT claims it's an "instant sync" but it is not. Many of the child bases do not get updated data for minutes or longer. I've been trying to find a solution for almost a week but haven't had any success.

A number of other services that I've worked with (Tadabase, Knack, SmartSuite to name just three) have a field type called 'Address'. This streamlines the entry of addresses (by autocompleting) and at the same time validates the address. Is it possible to do this in Airtable? There's an extension in the extension "store" called LOB but I can't get it to work. And that's it. Is there a way to use a Zapier automation for example to do the validation at least, even if it's not possible to help with autoentry?This is a huge deal for my users, who spend a lot of time entering addresses — often making mistakes that cause problems down the road. 

Hi there,We are attempting to create some sort of conversion tracking tool for our leads. The fields in our data table that are relevant for this are: Account Type (Lead, Customer, Rejected), and Source.There doesn't appear to be a way we can easily create a table, like in Excel, where we can simply name columns and create formulas in each cell.Here's the table we're attempting to recreate: The issue we're running into is we can't create the majority of the columns seen in this screenshot. Any ideas to help?

Hi all, We use Airtable as our internal operating system but our customer-facing web-app is built using a Postgres DB. So, we’re trying to two-way sync our Airtable base with our Postgres DB. We’ve looked at other tools such as Retool or UI Bakery that allow for SSH tunneling but really don’t want to leave Airtable. We’ve also looked to connect Airtable to our db by way of Zapier but Zapier currently requires us to whitelable essentially all IP adddress for the Eastern US to enable the connection, which we’re not comfortable doing for obvious security reasons. Also, Zapier does not currently support SSH tunneling. We welcome any solutions or suggestions. Thanks, A.J.

Hello!I am trying to sync my airtable to a SQL Server Management Studio Database. Essentially, I want the database to update every time I make changes to the airtable. Is this possible via code? I have looked everywhere on the internet to find a 3rd party solution, but none seem to accommodate for MSSQL, and if they do, they are faulty. Has anyone solved this issue using Python code, so when the code is run, the database updates based on the airtable?

Hello,We use airtable to manage a database of audio assets and often use the preview function to listen to the songs. The previews regularly freeze like it's a buffering issue and we need to refresh the page or skip the audio a little to get it to work again. It used to be now and again, but now it happens every single time we try to play a song. It affects multiple users across multiple fibre optic wifi connections and has been ongoing for years. We tried all the usual stuff like different browsers, clearing the cache etc. but nothing seems to make a difference. It feels a bit random and buggy. It happens in table views, record views, list views and where we mostly use it... interfaces. It has also happened on hundreds if not thousands of files from various professional sources.  We can still preview everything eventually but it just slows down our workflow dramatically. I understand this might just be something specific to our use case and I can i

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/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 appr

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.