Other Questions

I have two tabs. In one tab there is a list of peoples names, contributions, and the date of the contribution they have made In the second tab are the list of contacts(the peoples names from above) with the sum of the contributions they have made in tab 1 I want to be able to run a filter (or something simple) where on the second tab. I can put in a date range and based on that date range it will show the sum of the contributions only within that range (right now it goes from the beginning of time to the present) I want to be able to change the date range easily and often. How can I accomplish this.

I am trying to create a booking tool for oral examination. I managed to create a form where the student can select a hour of his/her choice (in a list) and when submitted, that time slot is no longer available for other students. So far so good. But I noticed that students can add+ multiple slots; I would like this to be limited to 1. How can I fix this? Additionally is there a way that students can only submit the form once?

Our organization has several different bases for the different functional areas (sales, marketing, operations, product etc). Each of these bases has linked tables for projects and tasks. I am looking to create a master base with tables that merge all of the tasks, and all of the projects from the other bases. I can see how to sync tables separately from other bases but I’d like to be able to merge them into a single table. Any help would be appreciated.

Is it possible to have a Google like search bar for my Base? My use case: I will show a blank invoice with item field (users can add a new row for extra field) and then the user type something then the search bar suggests the relevant records

Hi everyone! I’m having and issue and I’ve seen some threads that sort of touch on the topic, but none actually solve the problem for me. I’m trying to analyse the answers of a survey and the big issue is when I attempt to group the answers by question. I’ve created a an example data table here Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. If you look in the “Analysis” tab, I am trying to group by the Questions (Rollup), but the group are duplicating for each “version” of the entry. Does anyone know of a simpler way to create a group for each question?

Hey everyone - sorry if this has been answered but I couldn’t find it anywhere. I just started using the Gantt table, been an Airtable user for few months now and love it more and more each day. The Gantt table is really messing with my head, though. I’d love to use it but the way it displays dates is super confusing. To my brain, the date range looks like it falls on a day after what I’ve actually set. For example - if I have a milestone set for October 20th, It’s diamond is showing on October 21st. Is there a way to change this? It is super frustrating and hard to look at, and is holding me back from using the Gantt (where it could be super useful). Thanks for the help!

I am attempting to create a Form to standardize intake parameters for a receiving team. I would like to know which user is responsible for submitting each record. Currently i am unable to find a way utilizing the Form view to have the user ID auto populated when that user accesses the form. Is this something that is possible. The only work around we have found for this is to create unique prefill URLs for each user, which is not ideal and still allows the user to manually modify that info.

I’m trying to create a form to collect information after a sports event. I need the following fields included ‘Competitor Number’, ‘Penalty’, ‘Penalty Location’. I created a second table with the fields but when I brought them into the form they are ‘Read-only and won’t be displayed on the form.’ Does anyone know how to get the fields to be displayed on the form so the event officials can complete this section with multiple responses, ie more than 1 competitor penalised? Thanks

Pasting this here again as my last post was locked.

Hi everyone, I know it’s probably a silly question but here I go. Table 1 ‘Classes’ has ‘Class name’ in col1 and ‘Enrolled Students’ in Col2. (All the enrolled students are listed into 1 cell and automatically populated from the Students table where we indicate which class they’re enrolled in). | ACTING CLASS | [Liam] [Fred] [Emily] [Ann] | So far so good. How do I create a new table for each class where the first column (or second column, doesn’t matter) displays automatically the names of the students enrolled on that class such as: |Col 1| Liam Fred Emily Ann Thanks guys.

Hi there . I have two related tables : Companies and Contacts . Lets say for example : Company A have Contact 1 and Contact 2 Company B have Contact 3 and Contact 4 Company C have Contact 5 and Contact 5 I want help to make a button with script on the Companies table that when I click it (on Company B for example) , it will go to a view of the Contacts table and automatically filter the contacts to show only contacts 3 and 4 . Can you help me please ? Thank you

Anyone else experiencing buggyness and general slowness after the airtable update Friday evening?

Hi, Is there a way to order my attachments by Last In, First Show? Now it shows first attachment uploaded first and you have to scroll through other attachments to see the last attachment uploaded. Thanks.

Hi Airtable community, I have a table which has rows of products one of the columns is a field type attachment which contains an image of this product. I am looking for a Airtable native solution using either Views, Pre-fill forms, Page designer etc… to allow users only to have the option to replace the image of the product. Look forward to what can be done without using third party apps.

I’m trying to send an invite, I’m the owner and every time I try to invite someone I get …“Failed to send invite Non-owners are not permitted to invite users.” We have the enterprise version and this just started recently. Other owners in our group have tried and get the same error message.

Hi everyone, I’m looking to create a Field where I can mark tasks as either “Complete”, “In progress”, or “Not started” based on the Percent Complete I have manually entered in another field. I’m using this formula, and it’s working for everything except Complete: IF({Progress} = 100, “Complete”, IF({Progress} = 0,“Not started”, “In process”)) I’m also including a screenshot. What am I doing wrong? Thanks! Mica

I’m just looking at using Airtable to see if it will meet our needs for a community volunteering project. Am I able to switch to another grid and back again? If I can then can I automatically apply a filter when the other grid displays? Thanks

Hi All! I’m new to this community and hope to contribute as well as to learn from you all. I have a form created in Airtable. How do I create a formula so that when the form is submitted, airtable would insert the date of the submission automatically in a specific field I created beforehand. Thanking you all in advance for any assistance.

Hello.When I open the shared link on Wechat the Sign up and Logo buttons pop up and take away reader’s attention. It’s clickable. Is it possible to remove or replace it with my own website link and Logo. Please see the image for reference. Thanks a lot

Is this possible? I would like to send a view to other people without the “sign up” option being displayed. Thanks! M.

Is it possible to create a auto generated ID in combination with text and Number…e.g. I need to generate some ID like OHBL20081/OHBL20082 Thanks in advance! Nurul

Hello, I created a form in order to book parking spots according to the dates. I would like to find a way that a parking space can only be taken once a day. If someone fills out the form and chooses the spot 1 for October 5, I would like the next one to be unable to choose this same spot and only be able to see the remaining spots. Is there a way to do this in a form? Thanks for your help Louis

I need to create a Year to Date field that calculates YTD pay, but I am unsure of the formula to use. All help is appreciated.

We’re in the process of building out some serious zaps and need some guidance on what will happen if we use zapier to ‘add’ items to a “link to another record” field which already contains values. We have tables for both Clients and Meetings which are linked. Over time, multiple meetings are linked to existing clients. Often we can add new meetings and link just that specific meeting to an existing contact, HOWEVER sometimes we need to update an existing contact and link it to a new meeting (this is caused by the case of sometimes having one meeting attendee and sometimes having two, where attendee 2 is sometimes blank, so we need to run a filter before search/creating attendee 2 as a contact, and this happens after the meeting is already created). The issue here is that these contacts likely already have various linked items (meetings). So, my question is, do you know if you run a zap to “add” a new meeting ID to the linked meeting column of a contact, will this: a) overwrite all exis

I have been an avid AirTable and Slack user for years now. We use AirTable and Slack integrations for three separate bases; two are on a paid plan and one is not. A couple variations of such (update certain channel when something the entire base is changed; update certain channel when something in a certain view is changes, etc.) and they have worked MOSTLY perfectly. Until today. Well, Saturday, October 16, I should say. We are receiving NO notifications from either of the paid bases on any of the channels we have the notifications set for. I have tried deleted and re-enabling them, I have tried disconnecting and then re-connecting our AirTable and Slack accounts. I have successfully sent “test” messages to all of the channels from AirTable’s “send a test message” option. It has also posted in my Slack channel that the AirTable integration was configured successfully! And nothing, not a single thing, has come through today at all. And myself and my team rely HEAVILY on this integratio