Other Questions

I am creating a calendar using dates from records. The records are all associated with different statuses depending on their life cycle. When someone clicks on the record in the calendar, it expands to show ALL of the fields - many or which are not relevant depending on the records status. Is there a way to hide fields in calendar view (the same way you can do in grid views)? I understand you can hide and show fields per record, but this is impossible, I have too many records which switch between different statuses. Please tell me there’s a solution that I am missing…? Also how does the calendar view decide what fields to hide? The number of fields hidden does not correspondence to any other view I have created??

I’m currently creating a web app where I’m pulling data from Webflow and Memberstack using Zapier. I have 2 separate tables. Table 1: On this table, I have a list of provinces each as a checkbox field. So if a real estate agent is licensed in a province, that province gets a checkmark. So if they’re licensed in Ontario, the “ON” checkbox field gets checked. Table 2: On the second table, I have a list of requests where there’s a province single select field, so if a request came from Ontario, “ON” gets selected. Right now, I need to have a reference field that assigns these requests from table 2 to the real estate agents that are licensed in the matching province. So if Request 1 came from Ontario, all real estate agents from Ontario should get assigned that request. Can anyone help me with this please? Totally stuck right now

Hi everyone! I was wondering if anyone might have an idea of a way that I can merge multiple tables into one table that constantly updates. Basically I have an accounting workspace that I am setting up and really like. But ideally in a base, I would like to have different worksheets for different revenue and expense categories, but also one sheet that summarizes all of those. For instance, I want a sheet for payroll that has all the information related to payroll (confirmation numbers, amounts, payee, etc. etc.), but then I would like another sheet for say office and managerial expenses and another for travel expenses (not that much of that is happening right now!). Then, I would like another sheet that shows all the expenses (say by date paid) and gives a summary of them (with less detail obviosuly, since details for payroll and travel expenses may not line up). So basically I’d like something that’s like: Paid to: Date: Category: Reference: Alice D

We have a base that lists all of our dealers’ contact information, including state. State is a single-select field, with all states listed, just to make it easier for people to enter the correct state, and also to ensure consistency of the state abbreviations. I created a grid view grouping our dealers by state, which worked fine. However, at the top of the list is an “empty” record – and I can’t figure out why. I looked in the single select list (where you manually input the data) and didn’t see any blank or empty fields. I also looked at all the individual dealer entries to make sure each one has a state selected, and they all do. Any ideas why that empty field is appearing?

I have set-up a sync. In my original base, I have current customer data that I am working with. In my synced table I want to have a historical record of the data for that customer. I have therefore set-up a sync so when the records are deleted or hidden in the source table I “leave the records in this table”. Now everything works well. However in my synced table, I want to delete historical data after a certain period of time, but it doesn’t allow me to manually delete records I get the message “You can’t delete this record because this table is synced from an external source” Does anyone have any suggestions/workarounds?

Hi I have taken over an airtable base from another person. This base has 3 tables, Cost Centres Transactions Summary In the transaction table I have groups of transactions that are linked to the cost centre table. Basically I need a new group with an unused cost centre in it. But if I create a copy of the groups I cannot change its title. I need to change this to an existing cost centre in the other table I have uploaded an image so you can see what I am on about Thanks

My office manager and myself are both owners on the same table which we use to track orders. Sometimes it is necessary for us both to be in that base/table at the same time but be filtering for a different thing (typically customer name). If I have it filtered for last name “Miller”, but in her workspace she needs to filter by last name “Jones”, I lose the Milers and suddenly see the Jones. This obviously doesn’t work for us! This is the reason that I created a separate user for her–I hoped this would solve this problem. I don’t want the same view as a different user, I want the filtered view I select. We both need to be able to make changes to the table so we both have full permissions.

Hi there, I created a typeform that integrats with Table A on Airtable. The integration works perfect. However, when I link Table A with Table B, the typeform integration breaks down and I start to see duplicate records. The first record is incomplete and the second one is complete. Anyone experienced the same issue?

Hi all, I’ve read various threads on permissions etc when sharing Databases. I am still confused if it’s possible for read only users to still be able to filter views or if there is any way at all to be able give people the ability to use filters without having to pay extra on my monthly bill. I think I’ve tried the various methods but every time I make the access privileges read only the filters disappear. For people viewing the data it is only really useful if they can filter it down to what they are looking for. I’m also a bit worried in my tests if I gave someone editor permissions im suddenly going to be billed for it *yikes! Any help would be brilliant. Glen

Hi there, I have 8 Bases with 1 sheet each, where I have partners that are entering Customer Data in different columns. I want to be able to aggregate all theses Bases into 1 Bases divided into 8 Sheets, so I can have an overview on what’s happening / has been updated / created on all those individual Bases, within 1 main Base. How can I manage it? Thanks

Hello. It appears the “sort by” option isn’t working in a couple of my bases. When sorting by the name field (A), it is creating two consecutive lists A>Z. It isn’t sorting them alphabetically as one column. They are not grouped, filtered, or sorted by anything else. Nothing weird with their names, no punctuation or anything like that. Checked two other bases, one is working (only has 43 records), and the other isn’t sorting properly either. Any suggestions? Thank you!

I received a link to input my available times into my organization’s AirTable Calendar, but the page keeps telling me to Sign Up or else I won’t be able to contribute anything. I had already signed in, but every time I clicked on this calendar link, I was unable to add anything link because it continuously told me that I wasn’t signed in! What should I do? Thank you so much!

Hi all, so my situation is I’ve got a bunch of automations in place for "if consult booked field is empty AND info session booked field is not empty, change the status field to “Info session booked no consult” and the like based on customer actions. But on the free plan I’m limited with the number of times it can be run per month so trying to find a way to make the status field a formula instead. I got this working for if both fields are empty so thought I was on the right track, but can’t work out how to change it for the info session booked field is not empty. Any help would be much appreciated. IF( AND( {Info Session Booked (session date)} = “”, OR( {Consult Booking Date} = “” ) ), “Info Session Booked - No Consult Yet” )

Is there a way to share a link for gantt just like how i can share a link to my table?

I’m trying to check if users input intervals in a correct usable way for my script to handle an input. I expect my users to write something like 4-50=£54, -4=£45, +50=£89 I’ve split up every part into an arrays. And I have the following array I want to check if the ranges overlap [“4-50”,"-4", “+50”] Does anyone know the best way to check if any of the ranges overlap?

Hi! I have a database of image link URLs in a CSV file and in google sheets. How do I automatically upload the database of these links directly to airtable in png image format? I will be very grateful for your help.

Hey everyone! My name is Jillian, and I work for Unito - a company that creates deep, two-way integrations between project management tools. I have some exciting news, Airtable is our newest integration! That means if you’re syncing Airtable to Jira or to any of our other 15+ tool integrations, you’ll be able to map all your most important work data and have it continuously updated in both tools, almost in real time! You can read about what you can get out of our Airtable integration, here. If you have any questions, I would be happy to help!

When searching a base, would love to have AT give priority within results to the primary field (e.g. Name). It seems to weight all fields equally, which is highly inefficient for our primary use cases. Any way to change the default?

Who can help us out. We made a database for people to search trough for hairproducts for the curly girl methode. We use the free version. We embedded it on our website. It works fine on laptop or pc , but on the mobile version the magnifying glass is not there. Not in grid or gallery view. So our public can not use our website on their mobile to search in the database. The magnifying glass is there when I use the share url and go to the airtable directly. But not in the embedded view. Is there a way to get the magnifying glass on the code? Or any way to get it so it works. Look at www.ishetcg.nl/test-kolommen we need it to work there. The direct url is Airtable - www.ishetcg.nl has the magnifying glass. This is what we want our users to see. We are not a compagny, just girls who want to help curly girls to find the good products. So no, we cant afford a paid account. I hope someone has a sollution for us.

I am working on automating a workflow that includes dates. I have a Task Specifications Table that defines the phase of work, the different tasks for that phase and associates estimated time frames for each task. For Example the first phase would be Onboarding and it would contain 4 tasks. So when a new person enters the system and I select the check box it adds four records to the Onboarding process table. From the creation date I wanted to be able to generate due dates referencing the estimated time frame from Task Spec Table. The tables are linked by the task name and subsequently looks up the estimated time frame. I have tried DATEDD({TaskName},+{TaskDuration},‘days’) and I get an error. If I type in the number from the Task Table associated with TaskDuration: DATEDD({TaskName},+3,‘days’) then it works. Any thoughts?

Hi Airtable Community, I’m trying to build a tool that will automate a complex schedule process. I run a music institute each summer, which runs for 5 weeks, with 35 musicians involved, all collaborating with one another. Musicians are assigned to small music groups, and are scheduled weekly for a certain amount of instruction, sometimes with their music groups, sometimes individually for lessons. They remain in the same music group for the entirety of the 5 weeks, but their coaching/instruction time varies week to week, in a pattern determined by our program director on a weekly basis. We’ve been utilizing macros in Excel to keep music groups together and alert when there are scheduling overlaps and coaching overlaps. But, I’m hoping that perhaps AirTable could help us automate some or more of the process. Can anyone help? Thanks in advance.

Is there a way to create a duplicate record button in a submission form? For instance, if a client is submitting a request and wants to create another request nearly identical, is there a way to set it up so they choose duplicate and it submits the form and creates another duplicate that can be changed with a new date for instance but rest of the previously entered information remaining? I hope that makes sense.

I don’t know if this is possible in Airtable, but I thought that I would ask anyways. In the screenshot below, you can see that we have a travel itinerary which is grouped by country name. The groups are sorted alphabetically by country name. However, we would actually like the groups to be sorted by a completely different field altogether. We would actually like the groups to be sorted by the “earliest start date” within each group. In other words, we want each group to appear in chronological date order (like an actual chronological travel itinerary), as opposed to alphabetical order of the country names. Is there any way to accomplish this in Airtable?

OK, with the risk of this being too big a question: I am working on porting a pretty massive scoring system of grant applications. Each application has let’s say 100 questions, each ranging from 2-15 possible answers (some multiple, some single select) and each answer is worth a certain number of points (integer). I’m thinking one transparent way to do it without massive scripting (which may be what we end up doing), is to have each answer in a linked table, and in that answer table, have a column that is the point value. Then use roll-up to calculate a score (except where the score has to choose the highest scoring component, which i can do with a formula). HOWEVER - I don’t want to have a different linked table for each question. SO - I can use the ‘Limit record selection to a view’ option to narrow the options for each question. HOWEVER, this would result in hundreds of views to cover every question in each of four program areas. Maybe I could break up the linked answer tables

Hello guys. Can you help me with a question? We assume I have: Table 1 | Name | John Table 2 | Office | Deliveryman Now I’m going to create a link for [Name: João] into Table 2: Table 1 | Name | Link Cargo | João | Deliveryman Table 2 | Cargo | Link Name | Delivery man | John What I want at the moment is that only [Name João], be included in Table 2. This would solve the whole problem and not create a link in Table 1. But so far so good, because I can hide the Link Title of Table 1. My difficulty is that when I delete [Link Name] from Table 2, there are always scattered and old links that are not automatically deleted. In my example, [Link Cargo] in Table 1 will remain there, even though I already deleted [Link Name] in Table 2. Is there a way to delete links from other tables automatically, when I delete only 1 link? Or at least manage those links that no longer serve me? Thanks!