Other Questions

If I can’t access airtable suddenly, (This morning I couldn’t access airtable for a while), how can I access my data? Can it be deployed locally?

I want a simple CRUD for my customers where they can create, read, update and delete records, including child records. What’s the best way of doing this, since form view does not allow the user to enter child records? 3rd party form integration?

Good day, I am new to Airtable and simply love it! I am eager to share this wonderful tool with my network and have had a great response. However, one person has shared that they are simply too busy to try out the tool right now. She has asked me if I can rescind my invitation. Is this possible? Can I remove her email from the list of email recipients? Best wishes, Angela

Hello, how can i detect any duplicates in a cell (in this case it’s “Accord”)

Is it probable?If I am in a table in workbase A, how can I jump to a table in workbase B quickly? Is there any shortcut?

Hey everyone! I open-sourced an Anki plugin that can pull from Airtable. I’ve been using this for a couple of months, and it’s been amazing. I’ve described it in more detail in the project’s README: GitHub sirupsen/anki-airtable anki-airtable - Sync Anki with Airtable! If anyone finds it useful / has trouble, let me know!

Hi there, AirTable does not require access to my contacts data when I sign in with Google. The desktop version of the site gives me an option to not provide access, but I just cannot login to the app on my iPhone / iPad as it REQUIRES I give access to my contacts. I love AirTable, but this leaves a bad taste in my mouth. At a time when the debate around Privacy is of utmost importance, things like these make me vary about what AirTable’s true intentions are, and makes me question whether I really want to invest my time locking myself into a company with such values. I’d rather suffer in Valhalla with Google Sheets than give away my data where it’s not required.

How can I Create tabs to filter my data pls have a look at screenshot

I’m working in an Airtable that lists about 75 records for individual slides for use in around 25 presentations. Each slide is synced back to another base where I manage code names/version numbers etc… Each presentation will use 10-15 of the slides in different orders and quantities. In a perfect world, I’d like to be able to drag and drop slides in Kanban stacks and allow collaborators arrange them in the way that fits each presentation. As it is, I tried sorting the slides using this method, but each new list unsorts the previous list. When I tried creating new synced tables in the base, I quickly maxed out the limit of tables I could duplicate in the base (never mind the redundancy of many tables containing identical data). Ideally, it’d be great to go down the master grid and use a multi select dropdown to put “slide A” in list 1, 7, 8, 12, “slide B” in list 1, 4, 13, 20, “slide C” in 1,2,3,6,8…and so on. Then use filters to show only the items in list 1, then sort manually into th

Good morning just a quick question about sharing an airtable. I have some records where I just want to share one line of a table with someone to view. Is it possible to do this? Thanks!

I have a retool app created that was working. It looked up all items based on submission number. Then you could assign a value to each one and save it and it would push those values back to Airtable. Now I am getting this error: {“status”:400,“message”:"",“error”:{“type”:“INVALID_RECORDS”,“message”:“You must provide an array of up to 10 record objects, each with an “id” ID field and a “fields” object for cell values.”}} Any suggestions? Table/columns have the same names as prior. Thanks for any suggestions

Hi there. I tried searching the forum, but couldnt find relevant solution to this: I am trying to upload a CSV file to the current airtable table. I need the uploaded file to ovveride anything in the table except of the field types. How do we do it?

I’m using Running total script, it’s works fine within the same table. But when I enter another table in first line, stop working! This is my script. // change these names to pick a view: let table = base.getTable(‘Purchases’); let inputConfig = input.config(); let view = table.getView(${inputConfig["Ad Set"]}); let result = await view.selectRecordsAsync(); let runningTotal = 0; for (let record of result.records) { // change the field names here to adapt this script to your base runningTotal += record.getCellValue('Price'); await table.updateRecordAsync(record, { 'Revenue': runningTotal, }); }

I use the form view as it is the easiest. If I was to add a field midway through then that new field appears in the grid view at the very end. Therefore the fields in grid view and form view do not match (in order). Is there a fix to this?

Currently, I’ve got two bases, one that is a master sheet where invoices are entered for multiple projects along with a base setup for each project to track other more detailed records. I’ve got the master base synced to the sub-base for each job along with a filtered view that only shows invoices for the specific project. Inside the individual project base, I’ve got the field “Cost Code” on both the Bid & Synced Table, however I’m not able to rollup the data from the synced table without creating a lookup that has to be manually entered. I tried finding a workaround in finding some kind of script to set the lookup field value based on a text string but really can’t find any documentation on it.

I have synced our main Inventory base (shared by all staff) to our Billing base (limited access to staff). I’d like to be able to create a lookup field within Inventory that shows attachments I added in Billing. Alternatively, if I could just restrict user permissions/hide a table in the Inventory base, I wouldn’t need to sync between two bases and could merge into one. Is there a way to do either of these? Thanks!

I have a problem with a synchronization: Base1: Table A: different invoices Table B: summary of invoices by invoice date (via “link to another record”) Base2: Table C: Share view of table B (synchronized). I am concerned with the invoice amounts: Via link to table A, table B shows different invoice amounts from different invoices for a given day (ex: on 1/1/2020 we have invoices, for 100, 200 and 500$; so in total 800$). Now I would like to calculate this sum in table C via a rollup field. The problem: Due to the synchronization, the invoice amounts are displayed as text and I cannot offset them against each other. Does anyone have a solution? Can I make presettings so that the formatting of the fields is retained during a synchronization? Thanks in advance!

Hi, Can you please tell me if there is a way to calculate the % of a project progress? For example, can this be fone using the formula function? Thank you

Hello everyone, I’m fairly new to Airtable, and I’m unsure how to accomplish the query(ies) I’m performing in a simpler manner using Airtable commands. The Base I have an API with two tables: Classes and Students. The Classes table consists of classes and all the students enrolled in each class. The Students table consists of students and all the classes each student is enrolled in. The Task A user searches for a specific student on the front end. Using Airtable formulae, I need to query the Students table for the classes that student is taking. (NOTE: I need to return the class names, not the record IDs/codes for those classes, which are unintelligible for the user.) Using those class names, I then need to ask the Classes table for the students associated with each class, again returning the students’ actual names, not their record IDs/codes. Finally, I need to return the original student’s classes to the front end, along with the other student names associated to those classes. I wou

Hi dear folks, I’m trying to build the unique ID for all the items that in our company, I’m thinking about how this request will be working through airtable, for instance, is there any way that I can build the ID like XXYYY001–XXYYY999, or anything like UUID? Actually, I’m learning how to build the database, so any suggestion help, I want to learn how you will plan the data on the inventory. thanks.

Hi- I have a free account but my boss is going to start paying for my account. Is there a way for her to be on my account and pay without me losing all the data on my bases? Thanks

Trying to count meeting dates that have passed, but it keeps counting empty cells. Can someone help or offer a better solution? IF({Meeting Date} <= TODAY(), “Yes”

MY SITUATION I have a base containing several tables: ‘Translations’: Using DeepL API this 10 row table converts the record contents under 3 distinct fields ‘header’, ‘subheader’ & ‘cta’ into 10 languages ‘Banner Orientation 1’: Has fields ‘lang’, ‘target-header’, ‘target-subheader’ & ‘cta’ etc) & 1000 rows Table ‘Banner Orientation 1’ has: 100 rows where the field ‘lang’ records hold the 2-letter code for the 1st language 100 rows where the field ‘lang’ records hold the 2-letter code for the 2nd language etc… THE PROBLEM All 100 rows for the 1st language contain the same record value for each of the 3 fields mentioned above (and the other 9 sets of 100 rows each share the same 3 translated phrases). So… table ‘Translations’ only has to do 3x10=30 translations ONE TIME. The alternative to these 30 API calls? If I translate each row record separately I get 3 records x 1000 rows = 3000 API calls to DeepL for only 30 unique phrases… not good! MY GOAL I want those 3 transla

I’d like to set up logic/automation so that when we win a deal and moved it into “won” category in our pipeline - that a new record is generated in our production table so that we can start planning for the project. Any ideas on how to do this?

My company, which has an enterprise plan, has a base, and tables for individual departments. Every day, my department will add one hundred records with attachments. When unfiltered, the table is very populated. The mobile app takes forever to load the table (view filtered to each day) and crashes every time a record is added or was updated. Could an admin repair the issue?