Other Questions

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

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, w

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 o

Hey guys, first thank you for taking your time to read my question! I have a column where there could be from 0 to infinity amount of “Strings”, these look like this “, 20457-268, 28649-882, 28964-2899”. As you can see it starts with a Comma and every set of numbers (divided by a dash) represents something to me. Based on the given example, I’m trying to find a formula that will give me a number of the “Strings” you see, for the example I provided it should give me a 3. Since the numbers change and I have no control over them, and the last number never ends in a comma, I figured all I have to do is Count the commas, in the example given as you can see it starts with a Comma and the comma itself separates each string and the count should be 3 because it has 3 commas. Can anyone help me with this formula? Many thanks in advance!

I’ve added a new collaborator and she can see our base and edit records. She cannot however create new records. Where I have a +, she has a lock. I’ve tried changing her permissions via the table’s drop down edit permissions menu. I’ve tried each option for her on the workspace, editor, creator etc. I’ve also tried manually selecting her via the “specific users” option on the table. Any tips on how to enable her to add records?

Hi, How can I add formula which autoadds date field to be +1 day to date field in previous record? I am working on content publishing base and want to automate publishing date field. For example: in record 1, my date field is: 10/13/2021 and I need formula which gives date 10/14/2021 in record 2 and 10/15/2021 in record 3. Thanks in advance!

I have a base table in the following format, many groups each with tags and a count of the tags. I can currently chart the count of tags, but it shows all groups. I’d like to only chart one group at a time. Is this possible?