Other Questions

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) { _num_hundred = _num.substr(0, 1); _num = _num.substr(1, 3); _string = _arr_numbers[3][_num_hundred] + ’ ';

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: // Remove all existing markers (ie make all Task Log records 'current' value null) let TaskLogTbl = base.getTable("TaskLog"); let TaskLogRcds = await TaskLogTbl.selectRecordsAsyn

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.

just an excel with 20k records. i tried to import from excel, soooooo slow. i save it as CSV, and import it again, still very very slow. so far, still not finished. which way i can choose to import it?

As I reorganize my workspaces, I am wanting to move a handful of files from one workspace to another. The files have attachments. Is this possible?

Hey there, My production team is using one base to handle our production. (supply, suppliers etc) One table in this base is dedicated to our PRODUCTS. We have one column for price (currency type). An other table, in this same base, is dedicated to VARIANTS. It is simply a linked record to a PRODUCT and a size. The price is “looked up” from product, and thus is showing as a currency type on the variant record. On the other side, the SALES team is sync the VARIANTS table from production to another base (SALES) to get a list of all of our product. To create a sale in the LINE ITEMS table, they pick a VARIANT from the synced table in their base. They write a quantity. And obviously the quantity should be multiplied by the VARIANT PRICE to have the line price. My problem : in the synced table (in SALES base), the price is shown as a TEXT. (“€60.00” for instance) And I cannot manage to make the formula work. I tryed VALUE({price})*quantity but it says #ERROR! It seems like sync records con

Here are my criteria: Display a limited # of events (10, for example) to website viewers, using the “Embed this view on your site” functionality. The list must be dynamic and not static. To that end, the Airtable view I created makes it easy to filter out expired events and sort by end time in ascending order. Help me, Obi-Wan…!

I’ve searched here and google searched for a way to add holidays to the calendar. It is for staff time-off. It would be nice to see holidays in the calendar view, along with staff time-off requests. The main question is, how do I add holidays to my calendar?

I know that values from the Summary Bar cannot be used in formulas, but I would like to be able to at least right click and copy-paste them. Right clicking on the summary bar does nothing and left clicking only allows me to change what value is displayed. Am I doing something wrong here? Is there perhaps some add-on that would allow that? I am using Mac if that makes any difference.

Hi! How does one import a .csv into a specific view? I understand how to import a .csv into a table and select how to map fields for import, etc., but I don’t see a way to import data into a specific view (i.e., not the entire table). For example, I have a table where I do not want some rows overwritten by a new data import. I can easily filter these records/rows into a view where the only visible rows are ones that I DO want to be overwritten with new data. Does that make sense? Thank you!

Hi, I have a table with records, which acts like an overview. What I want to do is simple, I want to have a field in the row, that when I click that, I will jump to a different table (a specific view in there). That’s easy to do in Trello, Asana etc, but I can’t seem to find a way to set this up here. I’ve tried to search everywhere, but everything talks about linking records, which is not what I want. Literally just a way to jump from the overview table to the detailed table. Is this possible?

We at Outfunnel have added an Airtable integration, that makes it super easy to connect Airtable to email marketing tools like Mailchimp or ActiveCampaign, or web forms like Wix Forms, Elementor, Contact Form 7 and Facebook Lead Forms. For example, you can sync new web leads into Airtable with Outfunnel, and then sync a table or a particular view of a table to a Mailchimp audience, so that the next time you send out a newsletter, you can skip the export csv-import csv bit. We’ll continuously be adding marketing tools you can create connections with (at least 2-3 more coming before the end of the year). How is this better or different than tools like Zapier, you may ask. Generic app integration tools are great for creating simple connections between Airtable and other apps. But deeper marketing use cases can get complex and pricey very quickly. We’re a team of marketing and sales pros and we’ve poured our hearts into making our marketing integrations super useful and easy. (Hope this wa

Ok So I have a Google Sheet and I wish to create something similar in Airtable since Google is limiting the project basically So, we have people that put in information on a form on Slack The form includes: Month Date Year Product Name Type of Submission Marketplace Type of Market IP Violation Type Country URLs References Submitted by Submitted From On the URL field people put in various urls example. https://example.com 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. So when it goes into the Google Sheet it counts that entry as two urls that were submitted by John Doe. The Google Sheet also checks that the url is active or removed usually giving out the 200, and if removed 404 error. Is this something that can be replicated on Airtable? Here is the link to our google sheet

Hello! I’m trying to set up a Gantt view for our team. The tasks are primary deliveries which last less than a day, and in the view the task is a block that spans the entirety of the day. Not sure if this can be changed to specific slots to show the portion of the day! Added context: my start and end dates are computed (formula) fields. Screenshots of the view and the formulas are below. Thanks in advance :))

Clicking on “Help” and then "“contact support” goes nowhere. No page opens. No dialog. Nothing…

I am using Airtable as a CRM, and have a ‘clients’ table, with a primary contact email field. I have a project for which I will need to contact each client, but would like to do this one by one, rather than emailing everyone at once. I have created a button field and set the button to trigger a SendGrid app email. By default, this will send to all records in the table. I realise I can filter and configure the SendGrid app to only send to a given view. But is there any way of having a button trigger an email for that record only, without having to first check a box to stick that record into a given view?

Is it possible to assign the same task to multiple projects/records, and then be able to mark that task as completed on specific records only? For example, I have a table with a list of clients, and have another table with all the tasks that could ever need to be completed for those clients. One such task is to send new client letters to each new client. If I go to my clients/projects table and assign that task to each new client I have- we’ll say Jane Doe, Sally Doe, and John Doe, how can I mark that task complete for just Jane? Right now, if I mark it complete for one client, it currently says it’s also complete for all the others that need that task as well. Is there a way to make this show complete for some and incomplete for others?

Hi, I have changed the field type of some columns from “Attachment” to “Long text”. However, now I need to go back to the old format without losing the data. If I try to do so, the content of the columns is not converted and it is lost. So is there a way to convert columns from “Long Text” to “Attachment” type ? Thank you for your help, Damien ROCHE

At my organization we have a table in one base (Primary Base- PB) that lists members. I have another base (Outreach Base - OB) that is constructed to capture outreach efforts related to the members in the PB. Till now I have been using Zapier to update modifications of key fields within PB in my OB. Sync is going to change that I hope. However, I’m in the midst of organizing a new synced PB member table in my OB and I’ve hit a major road block. I am unable to upload csv’s to the new synced table! I’m not interested in creating new records, I’m just modifying additional fields that are not synced to the PB. When will this be resolved?

Hello! I would like to create a Grid view that only displays the latest record. I’ve played around with formulas, but am not finding success. I’m sure it’s something simple and stupid. I don’t want to have to interact with the Table to get it to update. I have a Field for the Creation Date and I also have an auto-number ID that I could compare against. Again, I just couldn’t get the logic right. Thank you, in advance, for your help.