Other Questions

Hi! I’m looking for a formula that would allow me to find the intersection of 2 dates range. For example: Date range 1: 01/01/2021 → 10/01/2021 Date range 2: 08/01/2021 → 16/01/2021 Result: 08/01/2021 → 10/01/2021 I was hoping to find an already built-in formula but I can’t seem to find one. How would deal with this case? Thanks!

Hi, I’m brand new here and new to Airtable. I’m a psychotherapist and want to create a document template to make writing session notes easier. My wishlist includes: Sections that are only visible in the template when they’re selected. For example, if a drop-down menu has only variables related to symptoms of depression and there are no symptoms of depression that section won’t be visible when I print the document. hierarchical single/multi-select fields where the selection in column A creates the options for column B. I found a product suggestion post from 2017 (Hierarchical Single/Multi Select fields) requesting this feature, but no indication that it’s been created. I’ve been looking at various apps/software to create what I’m looking for (Filemaker Pro, Excel/Word, Smartsheets, etc) and Airtable is the most recent. If I can’t do this with Airtable I may need to move on to the next product.

Hi all ! I have 2 tables (N°1 and N°2) I have an automation on the N°1 that creates record (named tasks) in the N°2 On the N°2, I have a checkbox field for each records it creates. I’d like on the N°1 add a rollup or a formula that displays the latest checkbox that has been validated on the N°2. Right now, im able to display the unchecked checkbox using rollup - but I can’t find a solution to only display the latest checked task. Do you have any recommendation ? thanks !

Is it possible to set up autofill fields in a form without using a third-party app?

Hello guys, I am trying to insert Multiple Select data into Airtable. When I select only ONE data, it successfully inserts it into Airtable. But selecting more than one data gives error. Yes, I have already checked and data is perfectly identical on both sides, not even a space difference. (Note: I am not trying to insert new data, the same data is in the Airtable already) Query: mutation { insert_studentRecords( studentPreferences: "{{student_preferences.value}}" ) { studentPreferences } } Error: "errors": [ { "message": "Unexpected error value: { error: \\"INVALID_MULTIPLE_CHOICE_OPTIONS\\", message: \\"Insufficient permissions to create new select option \\\\"\\\\"Standard Selection,Premium Selection\\\\"\\\\"\\", statusCode: 422 }" Things I already tried but didn’t work: Using “typecast”: true as I found in other answers. It gives another set of errors. Looked everywhere but could not find the solution. Thanks.

My new collaborator never receives the invite email. If i provide him with the link for account creation he gots the following message (see picture) mynewuser@mydomain.fr doesn’t look like an email… He can’t access my workspace. Any automation including his email continously fails… What kind of evil is this…?? How is this possible???!!!???

I’ve just done a 67-entry long table, but only the first 13 entries appear on the website page - yes, it’s possible to scroll down to see more or to view larger table, but ideally I’d like all 67 entries to be visible at a glance. Possible???

In my mobile app, a linked record shows the opposite order from how it is on desktop. I’m linking to records where the name starts with a date. In the desktop app, it shows the latest on top (that’s what I want), whereas on mobile it shows the oldest on top. Does any know why? Feature or bug? Adding images of mobile vs. desktop below. Thanks!

Hi, I’ve created an Airtable with 3 different tables. -1 table for survey 1 -1 table for survey 2 -1 table to summarise both surveys In my “summary” table I need to get data from 1 column in survey 1 and from 1 column in survey 2. I’ve tried lookup and link record but couldn’t manage to do it. The surveys tables are made of copy/paste data from CSV files that I update when i need by doing more copy/paste. Columns name and order in both surveys table are different. Do you have any ideas on how I can manage this? Many thanks for your help1

Hello, I have a rollup of a linked field using the formula, ARRAYUNIQUE(ARRAYCOMPACT(values)) For all records which do not have a link, the rollup field is blank. When I group a view by this rollup field, most without the link used by the rollup are grouped by a blank value. For some, however, the rollup grouping’s value is (Empty). Any idea why this is happening? Thanks!

I have invited a collaborator to my base and she has accepted the invitation. However, I am unable to ‘tag’ or ‘ping’ her like I have been able to do with other collaborators I have invited to Airtable and the collaboration process becomes entirely dysfunctional without this. Anybody else experience this??

I have searched the community for an answer to this and I am beginning to think it isn’t possible. I am wanting to use the scripting app to generate unique lot numbers for products my company sells. To keep the lot number unique, I want to have a single field in a single record in a single table to simply keep track of the sequential number section of the lot number. I have had no issue accomplishing this using the scripting app and creating a new table in the same base. My boss really doesn’t like the idea of their being no security around that number, so I thought I might be able to “hide” it in another base and use the api to get and update it. I have no trouble getting the value from another base, but I can’t figure out how to update the record with the new value after new lot number are created. Here is the method I used to get the value in the other base using the scripting app. let response = await fetch('https://api.airtable.com/v0/appXXXXXXXX/Lot/recXXXXXXXXX?api_key=keyXX

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, }); }