Other Questions

I have three columns in Table A:a person's name (lookup of Table B)a person's role (lookup of Table C)a posted message (lookup of Table D)For some reason, my posted message column blanked out (Don't ask. I have no idea how.) So, I'd like to see if there is a way I can reconnect the lookup of Table D automatically without using an API. Or is there a way I can build another column in Table A that will return the record I need to reconnect (based on the matching criteria of name (table B) + role (table C))?

Hi all, Sorry for the long-winded explanation but I’m hoping to get my head around the best way to use the chart extension to show project starts for each Quarter. In short, we have a base where each record is a project, and one column nominates a yearly quarter each project to start (ie. “Q1/2021” for projects starting in the first quarter of 2021). Problem when charting is (1) I can’t seem to arrange the x-axis in the correct sequence, and (2) it doesn’t seem to allow for quarters with no projects starting. If I sort by ‘view’, it appears to arrange the x-axis by the order in which they appear on the grid: If I arrange by “X value”, it sorts all Q1 together, then all Q2 together: If I arrange by “Y value” it sorts by total count for each quarter: If anyone knows the best way to arrange the data so the X axis is in the right order AND allows for quarters with zero starts, that would be great! Do I need a separate view set up with only that data in the correct order, or can I use th

When I try and paste the URL for my base calendar to Google calenda nothing happens and the calendar won't add.I recorded a video to explain. Any ideas on what to do?https://www.loom.com/share/c6497492aa644119b05c1bb4411215aaSo far I can delete and create the view again but the calendar only works for a few days and then stops working again. However the URL does work when I paste by subscribing on Apple Calendar app.Thanks

Hi I'm fairly new to Airtable, I am using an Airtable form for my sign up and I haven't launched it yet but when I try to use it to make sure everything is fine, 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."I moved my form from Google form to Airtable thinking it would save me time thanks to the automation but if there's a warning like this then it's not worth it. Airtable hasn't answered me. Has anyone faced this and found a way to resolve the issue?

Attached is a video of the issue. I know I can access the tables from the drop down menu but sometimes just prefer going directly if I know where the table is. The tabs on the right are covered while clicking on the ribbon to move the tabs, it moves the tabs that were previously covered on the right, too far to the left, so that the tab is not covered from the left and can't be clicked on.  

Does anyone have a way to contact the maker of the extension ChatGPT Assistant? The company is called Oxygen Apps , but the support email bounces back, and the CEO's email is also invalid. 

Hello.I am new to AirTable. I am not a software developer. I was given the URL of some research data that somebody compiled on AirTable, and I would like to make use of that data for a project. The table has 2500 records, though, and 21 fields (columns). I don't need all of it, just a small subset. I don't know how to extract that data into something more useful, e.g. .csv, except to print it to a .pdf, extract to .txt, and then parse the text with a script that then saves it to .csv.The problem I'm running into is that I can't fit all the data onto a single page because it seems as if AirTable doesn't let me omit fields (columns) when I print to pdf. I can hide fields from view in my browser (Chrome, Safari), but they are included when I print to pdf. Unfortunately, this jams all the data and shortens it with ellipses (...).Can anybody provide a suggestion or guidance, either in how I can extract all the data from the Table using AirTable's API despite not having direct access to the

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 the name of the date field you want to find the latest date o

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 click on the image in the expanded record, it shows as a broken image icon upon expansion:I don't know if this is an Airtable glitch, or if something else is going on. Any ideas? Anybody else having this issue?Thanks!Terry

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 stays blank):IF(AND({Length (in)}=0,{Height (in)}&" x "&{Length (in)},IF(AND({Length (in)}>1,{Height (in)}&{

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 the student has attended class since t

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?