Other Questions

I've seen variations of this question, but can't seem to find the best solution for my use case. (FYI - I'm on the Free version) I need to create sequential numbers based on a linked record. Example: Our "Jobs" table has all our jobs and their corresponding data. At times, certain jobs require a change order.  The format we use for this is the 544-01, 544-02, 652-32, 652-33, and so forth. The first number specifying the previously assigned Job# and the second being the change order #. When using autonumber the numbers aren't sequential if a record in between isn't specified by a single select as a Change Order. Making our records seem scattered and really confusing the customer when they received change order 15 and the next one change order 18. Any suggestions? 

Hello folks! I am trying to run updates to a table with a CSV file but I’m not seeing the option to merge records, only import them. I tried this on a few different tables and am still not seeing it. Anyone else? Troubleshooting ideas? Thanks!

I am looking for a way to import data from a CSV file but match on more than just one field. The CSV Import App appears to be limited in allowing matching to occur only on one field. Is there an alternative solution to importing data and matching on multiple fields? My use case is I am importing people who have purchased tickets at a recent event but I know some of the people are already present in the base. I would like to match on Full Name, email address, and Street Address 1 to avoid duplication of existing records while also preventing inappropriate overwriting of data. Thanks!

Привет! Я пытаюсь импортировать данные из Google Таблиц в AirTable через «Импорт данных> Google Таблицы». Доступ к аккаунту Google открыт. Я выбираю нужную мне таблицу и настраиваю столбцы для импорта, но возникает ошибка. Пытаюсь ответить и снова открыть доступ, но ошибка остается.Мои коллеги имеют доступ к этому рабочему пространству AirTable. Когда я пытаюсь импортировать эти данные из Google Sheets в AirTable в своей личной учетной записи, все работает.Пожалуйста, помогите мне решить проблему.  

Somehow the base I was working on erased some critical information from my base. is it possible to reverse these errors as in a time-machine backup? 

[iOS] Unexpected cursor jump to end of textbox by_a_Replacing Paste :::1️⃣ The flaw.  Here's a crooked example of it – just for putting an Airtable non-rich text data box to the test on iOS.  All I would ask you to do is go through the almost stepless scenario of an immediate and in-place "Select / Copy / Paste", or perhaps "Select / Copy / Reselect / Paste" – the latter in case the selection gets dropped upon Copy.  The selection can be just a_single word, or it can be whichever text portion you choose to select. The outcome of this essentially meaningless scenario will be particularly striking when performed from an editing position somewhere early in the text box at hand.  Indeed, the result of the "whole" operation is supposed to have nothing actually changed, but a side-effect makes the insertion point out of the blue jump to end of field

AirTable v9.6 on iOS (v16.6) seems no longer able to open up any linked record. At least that's what I_see when checking out the "Simple Project Tracker" demo base.// AirTable v9.6 on iOS ;// 2023.07.26.Wed.16:44.

Did I miss the announcement where Airtable said that they were changing the format for share links for Forms?The change briefly broke access to my form and now my prefill formulas are no longer working. Is anyone else seeing this change / am I late to the game?" 

I do not use AirTable but am in charge of the billing. A team member added 3 people to edit a document and their permission level is EDITOR. How can they edit the document without being charged?Can someone explain how can I make this unpaid and they have access to the document. I've been trying to chat to a person for the last week.

Hi All,I use Airtable on my iPhone, Mac.I have photo attachment on a record 360. I can see the photo attachments in full, on the Mac, but I cannot see the photos in the same record, on the iPhone.I can only see the thumbnails.Also, I can still see the photo attachments on record 1-359 on my iPhone. However, cannot see photo attachments from record 360 upwards. Again, only thumbnails. 

Hi All I am creating a New Patient Form which requires the patients physical address set out as following. Address line 1 Address line 2 Address line 3 City Country Postcode Is there a way of creating one Question on the Form (ie Address) that bring up those fields as answer boxes to that question? Thanking you in advance for your help 🙂

I have created a new form and set email triggers based on a form condition. Each trigger sends to to 3 google groups. I tested quite a bit and all seemed well until I just learned that not everyone in the groups are receiving an email when a form is submitted. We uses the groups regularly so I know the problem is not with google. Is there any reason some recipients in a group, including myself, would not be getting a notification when a form is submitted?

Sometime between two weeks ago and today, my INTERFACE form changed on create (submit) - from having just the create button when click which showed a small dialog that popped up (still leaving the layout behind empty asking 'do you want to create another entry' which I tend to close to now a full fledge white page with the verbiageThank you for submitting the form!Submit another response If I wanted this I would have made an outside form.I have folks entering data into the system - they do not need this.  And there is no way to customize it, and turning it off the submit another , prevents them from getting to the form at all. Please bring back the keep the form present / small dialog option! More so - please make change notices available.  Al

Hello all. I am hoping to organize my backpacking gear with AirTable. Weight is an important attribute of each item. What’s the best way to add a field for weight? Ideally, I would like to set up the field so it could calculate both lbs and oz. So 18 oz would recalculate to 1 lb 2 oz. Is that possible, or should I just keep things simple and record everything in ounces? Thanks for your help.

Hello, I was curious if it’s possible for a formula to return the Day of the Week from Date Field? So, if my Date field reads, “9/27/2022,” is it possible for a formula to understand that this date is, “Tuesday?” Thanks.

Hi there!Does anyone know if there is an app that Airtable uses that takes emails from Gmail and filter it in a base for tracking purposes?

Hi All! For the Gantt Chart view, does anyone know if there's a way to have airtable automatically adjust all dependent task start dates when the predecessor task is moved up (backward in time)?  I see that airtable automatically pushes out all dependent tasks automatically (this is great) but if a task duration is shortened or end date is moved back, all of the dependent tasks stay exactly where they are. Is there a setting I need to turn on to enable automatic date adjustments in both directions?  This seems like a very basic feature for Gantt charts and doesn't quite make sense to have it only for updates in one direction but not the other! Jack

I have a database of students in various "home rooms" each assigned a teacher.  I can easily create a view that shows the students in that homeroom that I can send to the teachers, however, there is one more record in another table that is linked to the teacher that shows their budget of what they can spend each month and how much they get for each class.  How can I send them a "dashboard" that has the records of their students, AND the one record for each teacher that has their budget? Thanks,Jeff

Hi, I am using an attachment field and looking to upload the attachments from my google drive. I was able to connect my google drive however it is only letting me choose attachments from ‘My Drive.’ I am looking to choose the attachments from ‘Shared Drives’ as it is a team folder. Does anyone know if and how this is possible? Thanks in advance.

Apparently when a dash aka minus sign is used as the first character of a text field, a single quote is inserted in CSV export. There's no need for this and it confusing when you expect a normal CSV export behaviour.Can you please list the extra character insertions you do beyond what the CSV format requires?EDIT: it's inconsistent even. Sometimes it inserts a single quote (that isn't there in the data) and sometimes it doesn't. Even two rows below each other.% grep -o '..\- C[^ ]\+' exported.csv,"- Choice"'- ChoiceAfter experimentation, we found that a single quote is inserted at the start of the value if:- The value starts with a dash- The value contains an opening round bracket (aka parenthesis)This sounds like a bug rather then a feature to me.

Hi,I am stuck with the following (most probably simple) problem -I am getting a records list of a tableI am filtering the list acc to 3 criteria (name, type, date) this all works fine, I log a correctly filtered object in the consolethen I want to get the value of the column with the name „tac_descr“ (variable set at the beginning of the script) of the found object/row.This should be done in the „active_descr“ definitionPls see the error in the console; no clue what is wrong; I have the correct object filtered (active_immo_tacs) and I just want to display the cell value of the column „tac_descr“ of „active_immo_tacs“. Could anyone pls help me on that? thank you very much - I am now trying to solve this since hours…

Was not able to find anything in the documentation or on Google about this:

Wondering if there is anyone interested collaborating on the creation of a habit tracker base I’ve been working on. The idea is this: Place those paperthin RFID tags in the places where my habit takes place. Reading → Kindle Cover Exercise → On my shoe rack next to my gym shoes. Brush/Floss —> Next to my tooth brush When I do that habit, I just bump the tag with my phone. (This is basically a frictionless way to habit track, which I like) If that specific habit is a Yes/No kind of thing, a checkbox will be ticked in my Airtable. (I’m presently accomplishing this through IOS Shortcuts though I’m sure that Tasker can do the same thing for Android.) If the habit isn’t a simple checkbox, for example, reading – I can have it prompt me for how long I read. Up to this point, all has been relatively easy. Now, however, I’m struggling with some base design issues. Designing the base so that I can see

So I know how to create and restore from a Snapshot.As I understand it, I can rename the restored snapshot with the name of the old (corrupted, that's why I'm restoring) Base, and go on my way.But wait! All the links, forms, and sharing relate to the old base (of course)! So I have to reshare the new Base with all those folks, update links to the Base anywhere they exist, and give people with links to the old Forms, Views, etc, new links. What a pain!Am I missing something? Is there a better way?

I have tried to contact AirTable support, but can get no response from them so I will post this here.Airtable has a very nasty bug if you change a text field containing a large numeric value to a number (integer) field, it changes the data values.  The attached video shows two fields, the left one is a TEXT field, the right field is just a copy of the left for reference.In the video you will see me change the type of the left field from TEXT to NUMERIC (integer) - See that this changes every value in the field with no warning at all.  I am guessing that it only does this on large numbers, I have not tested further.