Other Questions

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?

I currently have a list of countries in one table but some are missing. I have a list of all the countries in an excel sheet that need to be added. I know there’s a work around to add the missing data by copying what you currently have with the excel sheet, but I can’t remember how to do it. Any suggestions? TIA!

Hi everyone Can help me with script adaptive for airtable ? I need to the amount into text format Summary let table = base.getTable(“Test”); // column Amount = number // column Amount txt = text function number_to_string(_number) { var _arr_numbers = new Array(); _arr_numbers[1] = new Array(’’, ‘один’, ‘два’, ‘три’, ‘четыре’, ‘пять’, ‘шесть’, ‘семь’, ‘восемь’, ‘девять’, ‘десять’, ‘одиннадцать’, ‘двенадцать’, ‘тринадцать’, ‘четырнадцать’, ‘пятнадцать’, ‘шестнадцать’, ‘семнадцать’, ‘восемнадцать’, ‘девятнадцать’); _arr_numbers[2] = new Array(’’, ‘’, ‘двадцать’, ‘тридцать’, ‘сорок’, ‘пятьдесят’, ‘шестьдесят’, ‘семьдесят’, ‘восемьдесят’, ‘девяносто’); _arr_numbers[3] = new Array(’’, ‘сто’, ‘двести’, ‘триста’, ‘четыреста’, ‘пятьсот’, ‘шестьсот’, ‘семьсот’, ‘восемьсот’, ‘девятьсот’); function number_parser(_num, _desc) { var _string = ‘’; var _num_hundred = ‘’; if (_num.length == 3) { _nu

Hi there, I adapted the below script by @Justin_Barrett. Everything was working great until I added a few hundred new records to the ‘TaskLog’ table. The script now throws this error: Exceeded quota of 15 mutations per second at main on line 20: let result = await table.selectRecordsAsync() In addition, the run time is now 23.8/30s - also an error for my purposes - as any run time that goes over say 6-seconds will make the script unusable. Can anyone tell me exactly how to edit the script to include batch processing or another solution that will solve the two errors at hand? Ideally, the script should be able to quickly search through thousands of records in the TaskLog table in order to mark the ones that match the Account ID from the first step of the automation (inputConfig.AccountID) Here is the script:

Hello, I have one table and would like to sync the primary field with the primary field in a second table. I tried this by creating a synced table, but the only bases available are the example bases. I moved my table to the example bases workspace, but my base still wasn’t available. Is it possible to do this? Can anyone help? Thank you.