Other Questions

Is it possible to enter a stock symbol such as AAPL and get the price update as is offered in other spreadsheet programs? Thanks

Hey all, I am using Airtable to count the number of weeks each staff member is working as we work on different time strings. However, some of these time strings include holidays (e.g. Christmas and Easter). Is there a formula I could use to count weeks but exclude certain date ranges? For example I work 25/07/2022 - 13/01/2023, however, 26th Dec til 8th Jan is a shutdown period so wouldn’t count as 2 weeks of work time. Thanks so much in advance!

Hi! I’d like to use the Batch Update extension to sort fields for certain things, but so far it seems I can only sort by the main field. In my case, the field I would like to sort links to a table featuring members. I have the name of each member as the main field. However, I want to be able to sort it by the date each member joined – which I have filled out in a separate column. This way, the members are automatically sorted by seniority instead of me having to do that manually every time. Is this possible with this app, or do I have to write my own script (or edit someone else’s!) to accomplish this? I can do it manually if I have to, but I’m talking thousands of records, and sometimes there are well over 30 members. Since the members change over time and aren’t all in the same records, I can’t just copy and paste things, either. Cheers!

Can I transfer my workspace including all bases from my pro plan to another person’s pro plan?

I am creating a base that will track my staff’s required training classes. The classes vary in their renewal times, some only have to be taken once, some are required to be taken yearly, every 3 or 5 years. I created the following tables: Staff - contains Name and other pertinent info. Classes - lists all the required classes and their expiration times in number of years: 1, 3, 5. I created a table for training records and linked the staff and class names to this table, along with training date (date the staff took the class) and if it is the newest record (as there will be multiples.): This is what I would like to happen and I don’t know where to start: I would like to set up an automation that sends out an email when a staff is within 90 , 60, and 30 days of the class expiring. This would entail taking the Training Date from the Training table and the expiration time from the classes table using a formula to add the years to the training date and return the expired date. Then tak

I am struggling to to create a new table that pulls data column by column from two other existing tables. I how do that? I need to set it up to pull data to Klaviyo.

I have a base with 5 tables. Just in the past day, the tabs showing the different tables, in the iPad and iPhone apps, seem to have been replaced with an icon you click on to bring up the list of tables, so you can select the table from that list. I much prefer just seeing the tabs along the top or bottom of the base and select from there. Did I mess up a setting, or did Airtable change how this works? I don’t see an announcement of such a change, and a browse of tutorial topics for Mobile still refers to visible tabs in the base.

I am a tour bus operator, I started using airtable to keep records of my fleet, drivers, and reservations (three tables), but since then I’ve added sales, expenses, work orders, banks, and other workers. I need to collaborate with three users/departments which currently use forms to intruduce information, but depend on the clunky workaround of creating an automation and another form to select what to edit, and I need to limit their access to some tables. Since sync works only one way, creating another base feeding from my existing one doesn’t solve the problem, but I was wondering if anyone has tried duplicating and dividing the main base and then invert the direction of the sync so the new divided bases are the ones feeding the main integrated one.

Thanks in advance for your help

Thanks in advance for any assistance!

Hi guys, I’m having a slight issue with a synced table. It has added 6 blank records that don’t exist on the source table and that weren’t there after the destination table was created/before the sync. There’s definitely nothing to delete (first thought was pesky blank records that have been created accidentally in the source table), and I have run the sync multiple times in case there was anything that needed refreshing (even though there were never any blank records in the source table). And I can’t delete them on the destination table. I also don’t want to risk breaking the sync, as these have a lot of linked records within the destination base that I can’t risk losing. Any thoughts?

I currently import my calendar date, times, attendees, etc to Airtable. My goal is to try auto calculate my charges based on my time spent with clients. Currently it imports all events with all attendees. However I want to remove my colleagues email addresses from the list so I can allocate the a lookup to the email address to get the timing correct. Is there a way to import address and just exclude certain addresses? Or can I remove the address once imported and just have the client address? Any help would be appreciated.

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!