Other Questions

Is it possible to copy color conditions to a new table or new view? I'd like to use the same conditions but not have to rebuild said conditions every time I create a new view or new table.Thanks!

Hello, I’m trying to sync my outlook calendar to my Airtable base, but it’s giving me the following error message: “Last synced failed # minutes ago (Microsoft may be experiencing issues with their API).” Are there any problem syncing the Outlook calendar? Here’s a screenshot of the error for your reference.

I use the script below to retrieve the latest date from all records in table 'personal expenses', and want to insert this value to all records in table 'personal budget' (this table is in the same base).The script works if I update the records in the same table 'personal expenses', but not when updating the other table 'personal budget'. In that case I receive this error: j: Error: Failed hyperAssert: undefined at main on line 33 Can someone help me with debugging? I'm in script noob and assume there's a missing link between selecting the records in tablePersonalExpenses and updating the records in tablePersonalBudget. Thanks in advance! // Replace "Table Name" with the name of your table let tablePersonalExpenses = base.getTable("personal expenses"); let tablePersonalBudget = base.getTable("personal budget"); console.log(tablePersonalExpenses) console.log(tablePersonalBudget) // Replace "Date" with

Hi, I need to check revision history beyond 1 year. Is there any way I can access that?For example, I noticed that Enterprise level subscriptions can access past 3 years' of history. If I paid for Enterprise, will the history from May 2021 be available to view?I only need the revision history for two specific records.I apologize for any inconvenience, this is for a legal issue we are involved in. Thank you in advance!

I am using an Airtable form for my site. But when I try to use it, I get a warning: " Warning: potentially risky form "The user-created form you are attempting to access has been flagged as a potential risk. If you wish to proceed and view the form anyways, please remember to never submit your passwords through Airtable forms. Please contact abuse@airtable.com if you would like to request a review of this form." Has anyone faced this and found a way to resolve the issue?

Until recently, we've had no problems with images and thumbnails displaying in Airtable. Over the last couple of days though, we've had a few images that come through without thumbnails. When you open the record, it shows a 'blank' image (see pics below).In two cases, when I clicked on the image from within the record, the actual image displayed, but for others it remained blank.Users are uploading images from their mobile devices. One is an iPhone user, one is not. Screenshot from expanded record:Screenshot from activity sidebar:Image that opens after clicking on the image in expanded view:For another record, when you cl

Hi all, I’m wondering if there is any third-party service that can assist in moving an entire CRM database from Salesforce into Airtable. I don’t think it’s as simple as a basic CSV import, as the database has a lot of records linked across tables as well as a lot of files associated with individual records. Is there any service that exists for this? Or is this something that would need to be done manually?

Hi all , What is the best way to save / backup an Airtable database ? e.g. GSheet via Zapier ? And how to automate daily save backup ? Many thanks Anthony

Hello! I am trying to complete a check-in form that takes in student ID (as the key), personal info (name, email, etc.), and the current project (ex. using 3D printer). I am trying to find a way so that what the student inputs their ID (the table's key), the personal info doesn't need to be filled in, just the current project fields. I don't want multiple records of the same ID to be combined (so not dedupe extension) but for the ID recognition to autofill the personal info fields. I've looked at the 'No-Conflict Asset Reservations' template from @Kamille_Parks11 but am 1. confused on how to adapt the code to my needs, 2. worried that it doesn't integrate into the form that would be available to students. Thanks in advance!

I'm trying to represent dimensions using concatenate and IF statements but it's not working.This is what I'm going forIf HEIGHT and WIDTH then H x W in.If HEIGHT and WIDTH and LENGTH then H x W x L in.If DIAMETER then D dia.I managed to get the first two fields working, but I'm not sure how to get the dia field to show up.IF({Length (in)}=0,{Height (in)} & " x " & {Width (in)} & " in.", {Height (in)} & " x " & {Width (in)} & " x " & {Length (in)} & " in.")I also tried the following based on reading some other threads and the formula works (without the & so I didn't get too confused), but doesn't actually produce anything (the Dimensions field

We are moving student metrics to Airtable and I am trying to create a backlog of attendance records for our students since they started. (we have two campus's with seperate start dates). I have an automation working fine for populating records with every new day but what i need help with is the back log script. Currently, I am trying to create a record for every student for everyday they have attended class thus far. Can someone help debug why this is not working? Nothing happens when I run the script and I do not get an error in the console, meaning the script is killed?  let studentTable = base.getTable("Participant Core Database"); let attendanceTable = base.getTable("Attendance"); let inTraining = studentTable.getView("Training View") let currentStudents = await inTraining.selectRecordsAsync({ fields: ["Full Name", "Training Facility"], sorts: [ {field: "Training Facility"}] }) //gets an array of all the dates

Is there an ETL app for Airtable? I need to do basic clean up, such as changing ; delimiters to , delimiters. Thanks.

My team has access to our individual OneDrive for Business accounts, provided by the company, and access to Sharepoint. When using the attachment field type, I noticed the OneDrive integration only allows for personal OneDrive accounts (not OneDrive for Business). Am I incorrect? Is anyone else able to use OneDrive for Business and/or Sharepoint integration with the attachment field type?

Hello Team, Is there any quick way to import mass data into an EXISTING TABLE? Importing a CSV file will generate a table, not append to the existing one. Copy and paste from excel or google sheet does not seem to work. Karl

Hi All, My use case is very simple. I would like to do following things. Connect to snowflake database using airtable script? Fetch data from snowflake table. Populate the grabbed data into airtable multi select field as option. I know the answer for third point as shown below. But didn’t find an relevant resource or answer for first 2 points. Does anybody know how to connect to snowflake database using airtable script? const multipleSelectField = table.getField('My multiple select field'); await multipleSelectField.updateOptionsAsync({ choices: [ ...multipleSelectField.options.choices, {name: 'My new choice'}, ], });

Hey there! So I am trying to figure out if this is even possible, we are trying to hook up some database tables (BigQuery) to airtable. I have gone through the API docs and I see there could be a method of uploading JSONs periodically to airtable, but I feel like there are a lot of limitations there. I’m wondering if anyone has done something similar to this? We use our database as a source of truth, and ideally want to clone the tables from there so that they can be used in airtable freely. Any thoughts / advise is appreciated, thanks!

Hello can anyone help me to get driver to install ODBC connection for integration of Airtable base to PowerBI

We use Airtable for our content calendar. We want to start putting in the analytics data on the records. We use Google Analytics and co-schedule to broadcast our social media. Has anyone found a way to bring this data in to Airtable without having to manually do it?

Hi everyone. For the last few month I’m working as a freelancer. I help my clients to automate different business processes, much of them contain Airtable. My last project was creating a custom integration, that pulled adsets data from facebook ads manager to Airtable. Now, I’m thinking about creating a system that could: First step:pushing all campaigns/adsets/ad data (including metrics) to Airtable Second step: ability to manage facebook campaigns from Airtable. I would like to ask the community, what do you think about that kind of system? what functionality would you like to be in there? any other social media ads that you would like to manage from Airtable? Kind regards

Hi there! Does anyone know if Airtable integrates with Smartsheets? Has anyone tried integrating the two platforms? We are trying to build out full blown production plans and proactively plan resources. Some producers are using Smartsheet, but I would like to keep our schedule closer to the project management system we have created inside Airtable if possible. Any ideas, experiences and/or suggestions are welcome - thanks! Smartsheet integration with Airtable?

Whenever I try to make a request using Datafetcher, it gives me a 403 error. It’s my first time using it so I don’t know if I’m overlooking anything. I’ve tried contacting support but so far, I haven’t heard back from them.

The open url button field you can create always opens a new tab, and i don't want it to do that, is there any way i can modify the formula so it doesn't open a new tab? I can make a script field instead that stops this but i really don't want to spend any more time on this.

I would like to share a base with an external party. I would like that recipient to be able to filter and sort the views however I want to prevent them from making any changes to the records themselves. Is there a way to do this?

Hello Airtablers, I’m totally stuck with the NoBull extension. When I go to publish the base to Webflow I get this notification: Also, the ‘Bio’ section won’t update. I.e the data doesn’t pull through to Webflow. Is this because I’ve setup the categories incorrectly? Appreciate your help on this. Cheers, Hamish — READ ONLY:

Myself and few of my users have noticed that using the keyboard Tab key to move through fields in an expanded record has stopped working as expected.It appears to be moving through multiple elements before the next input and then there's no focus ring when it does reach the input.Anyone else experiencing this? Airtable, is this known and likely to be fixed?