Other Questions

Hi Everyone, We’ve been using Airtable for awhile now. Unfortunately the company direction is to use SharePoint List or MS List from now on. Is there an easy way to migrate data from Airtable to SharePoint/MS Lists? Tried the Airtable CSV download and import that to SharePoint/MS List. However the Airtable File Attachment column is not included. We dont want to go through each row in SharePoint/MS List to re-upload those Airtable File Attachments. Is there a 3rd party tool or some form of Powershell scripting to migrate Airtable data to SharePoint/MS Lists? Thank you.

I’ve imported some data into Airtable which includes a column with dates, but as a text string. I would like to be able to sort, filter and group this data by date, so I need to figure out a way to turn that text string into a date field type. I created a new column with both the DATETIME_FORMAT and DATETIME_PARSE formulas, which returns the date in the format that matches Airtable’s date field type format (i.e. MM/DD/YYYY), but this is still a text string. I’m trying to figure out how to turn this into a date field type in some way - possibly using an automation? Another important piece of information is that I will periodically be updating the original text string with updated information (copy + pasted from another source in the same original format) - e.g. for the first column, I would be updating the “Last Financing Date (PB)” to a more recent date like 05-Oct-2022. Therefore, I need something that will auto-populate. I’ve seen related posts where the solution was creating the DAT

Hi all I have a table, which has lots of PDF’s with random filenames. I’d like to batch rename them into Determination.pdf I’ve had a look at other similar posts, but the script keeps saying: ERROR TypeError: Cannot read properties of null (reading ‘length’) at main on line 9 Here’s the modified script by Justin_Barrett which I found here. // Setup const mainTable = base.getTable("Projects | Applications") const mainQuery = await mainTable.selectRecordsAsync() // Build new attachment data let updates = [] for (let record of mainQuery.records) { let attachments = record.getCellValue("Determination") if (attachments.length) { updates.push({ id: record.id, fields: { "Determination": [{ url: attachments[0].url, filename: ("Determination.pdf") }] } }) } } // Update records while (updates.length) { await mainTable.updateRecordsAsync(updates.slice(0

Hi there, I am creating a database that includes organizations, the services they offer, and their clientele. In the client tracking log, I have a linked field for organizations contacted, followed by a lookup field that lists all of the services provided by those organizations. What I’m hoping to achieve is a multiple select field to mark which of those listed services were accessed by our clients, only allowing options to be selected that correspond with the lookup field values for that specific record. Simply put, for each record, I want to limit the service options available in the drop down menu to only those offered by the linked organizations. Is this possible, and if so, how might I make it happen? Thanks a mil, Jacq

I have related tables with clients and appointments. the appointments are dates that are selected via linked record in the client table. I need to be able to sort by date in the client table, but it is not working. I have tried to create a formula field with the related date being parsed but it still does not sort by that. Please help!

Hi. I have a recurring bug. When I create a public link to an AirTable calender, the calender that appears when we open the link is always empty until the visitor change the scale of view. Then the events appear. I tested the bug with my colleagues.

Since October 4th 11:42pm GMT, all airtable.update calls are failing with Uncaught exception errors. UnhandledPromiseRejectionWarning: TypeError: Cannot read property ‘records’ of undefined at /workspace/node_modules/airtable/lib/table.js:110:35 at /workspace/node_modules/airtable/lib/run_action.js:70:17 We’re sure this is not a result of any changes to our system. Is this a new bug on Airtable’s side? Thanks.

Good everyone, I have a form in airtable that I use for the employees of the company to fill it in case they have an incident. The question is if the same form that they fill in, later they can evaluate their satisfaction with the response received, speed etc. Thank you very much for your help, have a nice day!

Hi Guys, Struggling with something that I’m sure is super simple! I have the following configuration to do list - each record is a to do projects - each record is a specific project these tables are linked, with each to do belonging to a specific project. I want the linked records for each project to be a live representation of what is still to be done I have pressed ‘limit selection to a view’ and connected this to a view that has a filter that removes ‘done’ to dos however the ‘done’ to dos still remain as linked and shown in the projects table. Any ideas? Thanks

This might be a bug. On Gantt chart, I changed the End Date column to a formula (DATEADD) in order to insert the start date and the duration. It works fine in the table view. But when I change the settings of the Gantt chart to use the formula column, the click and drag feature of the records in the chart is disabled, and I can only reschedule by typing into the record fields.

I have a base for my wife’s resale business. She sells items on Ebay, Mercari, Poshmark, Facebook Marketplace, Depop, and Shopify. I am looking for a way to upload the listing reports from each platform and to compare it against the current inventory table in my base. I have imported the active listings for each platforms into a separate table in my current base. Trying to find a way to find listings that may not have been ended when an item sells on a different platform. Any thoughts would be appreciated.

am having an issue notifying non-airtable collaborators who have access to a dynamic shared view of when that shared view is updated. Specifically, we have a lot of external partners who have access to personalized shared views. When records enter their view, I see it on our side as admin, but the external users have to refresh their page to get the most current information. Is there a solution to this where the page automatically refreshes every so often, or automatically when a new record enters the view (similar to how it is on the admin user).

Hey all, I have a CRM base with a few tables for tracking leads, opportunities and those warm introductions to people I usually get. I have created a table with default options to choose from: And on my Leads table for instance, I would like to set when the next follow up should be, by choosing from this list. Based on the time I do it (now), Id like to output a date to follow up, which I can then use to schedule a formula running my follow up tasks in another table. In case I change it from 3 days to 7 days for instance, output date should update. How to achieve that? Thanks in advance!

Hello. I’m new here and so far I’m quite impressed with all the possibilities Airtable offers. I searched all the help topics and community topics for the answer to this question, but I may not be wording it correctly. I have set up a Product Inventory and Sales base for my fledgling business this past few week, with no problems. Yesterday I received a notice of price increases from one of my mfrs to take effect 5/1/17. When i change to the updated price, the change affects all transaction from the past. How do i input these price changes to take affect only on and after 5/1? Maybe i should create an additional column and use updated pricing? Thank you.

Hi, I can not upload a record in Airtable using W5100S-EVB-Pico . Its support ethernet connectivity and uses micropython-urequests library to ‘get’ and ‘post’ data. Kindly help…

Is there a way to “publish” an Airtable database that family and friends may access without needing the Airtable license? Considering Airtable as a replacement for Zoho Creator (which does allow for database publications). Thanks so much.

Hello community!! I’m really hoping for some help here as I’m struggling to find the solution. Here is my problem: I’m running a survey into multiple schools / classes, and I can’t link the # of the survey to the students in each class automatically. So on one hand I have a table with the surveys that I will be running in each school and class. On another hand I have a table with all my students with the class they are in as well as the school. If I would be in excel, I would create a basic concatenate of the unique combination of school+class and link to the student table. In Airtable I’m able to link yes. But by doing this through the link to a record field, I need to manually associate the students to to the other table, which when I will have 2000 students it’s going to be a huge problem. I’m attaching screen shots… thanks for the help!!! Patrick

I’ve got a Pro account, so I can see the counts and types (field, view, sync) of dependencies in Field Manager, but not the details. What does it mean for a field to have a VIEW dependency? It doesn’t seem that it means that particular field is shown in a view, because when I hide that field in a view, the number of view dependencies doesn’t change. Does it mean that the field appears in a shared link of a view?

I’m using the Timeline view to display a project duration for resourcing purposes. I recently learned how to add a milestone. However, from my understanding, you have to create a record separate from the project. Is there a way to combine these records in order to have the milestone overlay (aka live within the start/end date range) the start/end project display?

I’m trying to create a form that allows residents to sign-up for one of the programs we offer. One of the common issues I’ve had with sign-ups in the past is that residents are allowed to type in their address and then select the neighborhood they’re in. However, usually they don’t select the correct neighborhood so it creates more work on the back end having to fix it. I have an excel doc that contains everyone’s address and their associated neighborhood. Is there a way to connect excel doc (or the data) this with my form somehow so that when a resident types in their address it automatically fills in what neighborhood they are associated with? That way they don’t have a choice about what neighborhood they’re in, it just tells them.

I have my main contact database in Airtable, and I’m using Zapier to update the information when we get new registrations in other apps as well. It all works great, but I’m looking to remove a bulk list of inactive people based on our email list. I pulled a CSV from MailChimp and I want to remove those people from my Airtable contacts. Is there a way to segment out that group to bulk remove them from my main list?

Hello Everyone, I have a table that is linked from another table that gives me a summary by percentage for every group. Now I need to take that percentage by month vertically. I wanted to create something like this, see screenshot below for reference. Is this possible in airtable? Thank you so much for future response!

Purpose: In a table where the field is a “LINKED to record” field. Many times the value for the LINKED field is a value in another text or formula field. A script that can take the value of a string field, and insert that value to the LINKED To field so that the lookup is somewhat automatic. Currently the only way to do this is to manually do a copy/paste from one field to the LINKED Field. I believe what would need to be done is - Copy the table field from to a variable Do a lookup in the LINKED Table Insert the valid lookup into the LINKED TO Field If there is an invalid look - then don’t display anything ie. Master Table Phone # Link to Contacts via Phone Name Lookup 111-111-1111 111-111-1111 Abe Lincoln (This is the desired result) Lookup Table Phone # Name 111-111-1111 Abe Lincoln

Hi there, we try to sync a calendar view from one base to an other but it says its disabled but when we try to enable it its gryed out. Any help please? The grid view from the same base works fine and the enable / disable option is functional. Thanks.

Hello everyone, I am currently using make.com to supplement some of the functions on AirTable. I have a table of my Leads, with the {Lead Status} as the focal point here. When {Lead Status} is updated to ‘Closed Won’ I want make.com to create a new record in my customer base. I’ve set up make.com to watch the {Last Modified} field (which was set to only change based on {Lead Status}) The formula used was {Lead Status} = ‘Closed Won’ Then there is a filter set up, where {Last Modified} is “now” However, nothing seems to be able to pass through the filter. Even when I set the formula in the first Watch module to AND({Lead Status} = ‘Closed Won’, {Last Modified} = {Now}) Where {Now} is a simple formula field on AT, where SET_TIMEZONE(NOW(), ‘Singapore/ Singapore’) But still, nothing passes through the filter. What can I do better here? Thank you