Other Questions

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?

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: 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.

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?

I am pondering what will happen to extensions in the wake of interfaces?In our company bases have become the primary domain of the administrator setting up and managing the data, while Interfaces have become the dominant workplace for that data.This has made extensions obsolete for all of those working exclusively in interfaces. Will extensions find their way into interfaces eventually?

For the last 20 hours, I have not been able to access Airtable through the MacOS Desktop App.  Out of nowhere, the pages are all broken as if the CSS is not working.  I only see broken text.I uninstalled, reinstalled.  Reloaded pages, nothing.Anyone have insights?

I love the page designer extension and one day realized there are menu options for Records in a Specific View and layout options for a grid or list. I was so psyched -- I've only ever printed one record at a time.But the grid and list isn't working ... the result seems the same as one record at a time. I've done a few tests e.g. creating a new layout, using canned page sizes vs. custom, etc.Any thoughts?

If I have a selection of records showing in View A, I would like to have a button that opens the same selected records in View B.  Any ideas? Or am I missing something obvious? 

We used to be able to copy a formula field from one table and paste it in a linked record field of another table, but are no longer able to do so. Is there a way to re-enable this?

I’m new to Airtable, I’m trying to freeze several rows at the top, in addition to the ability to freeze columns (like “freeze panes” in Excel). Is this possible on the free plan? Is there a better solution? For example, let’s say my records are students and my columns are classes. Each class has some metadata - its location, times and teacher. Currently it’s specified in the first several rows, instead of them holding student data, so the student list begins at about row 6. I need to see this info when I’m scrolling the list of students. Thanks.

Hello, I’m experiencing a bit of an odd error with certain records now being encapsulated in “” quote marks when synced from one base to another. I can’t see any rhyme or reason as to why - some records in the fields are fine, but some aren’t; in other fields, all records seem to have ended up with quote marks. Example: As an aside, I did notice a few weeks ago, from a completely separate table, when copy pasting linked records into a spreadsheet (just for the text), some ended up with the random “” marks, whereas others didn’t… Is it a related thing? Any help much appreciated! King regards, Matt EDIT: immediately after posting this I noticed the difference. It’s the commas! Get rid of the commas in a field and it doesn’t happen. Mods you can close this, thank you!

Looking for suggestions. This is now coming up for two clients. We'll focus on one, for now, as the concept/challenge is the same.I have a client - mortgage company - using Airtable for group workflow. We move data between 3 systems for now. Airtable, a CRM (Bonzo), and their Loan generation software.There are times they need to compare data when there are discrepancies. The inability to generate a dynamic form, where I can display any discrepancies, the source data, and allow the client to select which data takes precedence, from within Airtable is a problem.Currently, for one client who uses Google Docs, I have a Google Apps Script app. For this client, I store the json from their external service in a table. I have a link to the GAS app that reads the log file, the stored JSON, presents the discrepancies, and allows them to choose their "correct" data.I would much prefer this process stay in Airtable.Are there any plans to provide any type of dynamic front-end HTML forms inside Airt