Other Questions

Hi there! I've been searching across the Airtable (AT) community for answers, and none so far.I am trying to create a production schedule that has multiple dependencies across time. I followed the template that AT provided. I also included a new formula (found through the AT community) so that the End date is calculated by using the Start Dates and duration (Days it takes) for each task while excluding weekends. IF Formula below:IF(AND({Start Date},{Days it takes}),WORKDAY({Start Date},{Days it takes}), {Start Date}) The Main Problem: When I go into Gantt view, I am not able to click and drag on a task box to move the start and end date.This shows up as one of the things mentioned that should be available in the Gantt View. I found it from "Working with records in the Gantt view" on Airtable:"You can also adjust the dates that a record begins and ends (without changing its duration) by clicking and dragging the bar earlier or later on the ti

Hello!I'm hoping you guys can help. I'm a total newb with formulas.I'm trying to build a animal shelter manager and usually we don't have the exact date of birth. Just an approximate age (ie, 2 years, 5 months, 4 days, etc.). Is there a formula that can calculate an approximate date from those numbers?I've looked everywhere and tried a million different formulas.

I have a form within a table. This form has a field that's a link to record type - City. When I view this field +Add City, it shows me the City and the State so I know the context. This works within the Airtable app only.  If I share this form and then want to +Add City, it doesn't show me the City and State so the context is lost. I have two cities with the same name but I don't know which state so I can't pick the right one.How do I see the same pop-up modal with City AND State view that I see when I am in the Airtable app? I am just choosing the City and the state is auto filled but the user needs to see the State so they know which City to Add.

Hello,I'm looking for a way to hide records that have a certain single-select status.For example, I have some statuses like 'Pre-Production, Production, Published, Archvied' and I want to create a view where all records with the status of 'Archived' are hidden but I can't seem a way to do that. I can only show records from a certain status but I would like the reverse - hide records with status while showing others.Possible? Thanks

Hi there, I have a conundrum that I hope someone can please help me with! It’s all about the final “/” Basically I want to extract the last part of a file path + filename string, to leave only the filename. The path and name can all be different lengths, and have different folder depths. The key is to take everything AFTER the final “/” Examples below… /Volumes/my_drive/documents/pictures/A001.jpeg /mnt/usb/pictures/123456.tiff /Server/over_there/no_really/this_one/what a long path/Big File.mov would parse… A001.jpeg 123456.tiff Big File.mov Any ideas please, fantastic Airtable community? Thanks!

Here’s how Airtable is sorting my text col: 2XY 11A This logic seems to be unique to Airtable: 11 is after 2 (not 1 is before 2, as expected). This causes problems trying to match a sorted list in Airtable with the same list sorted in another program. Is this a bug, intended behavior that can be worked around, or something else? Thanks!

Hey there,I'm new to Airtable and want to count all the checked boxes in one column. Anyone know how to do this? Please help! Thanks in advance.Dorus

My database disappeared. It's not in any deleted folder. When I log in, Airtable acts like I'm a first-time user. Help!

iPhone iOS: new version forces edit field to disappear when keyboard is opened. 

I swear this is the most basic problem ever.The **bleep** promo on my side menu is covering all my work spaces.The Airtable bot and I...we don't vibe. Can someone please help me

Not sure where the correct place to put this one is. I am trying to get a formula or automation to update the period field in the attached screenshot based on the cadence. I have tried using automations, but it essentially circular references itself and won't allow me to select the Period to replace with Next Period, because Next Period is calculated based on Period and Cadence. I have tried using a forumla in stead of an automation to make the Period date a live field but it only updates to the current month not the quarter and when the month is a non quarter ending period.I have an automation created to create tasks on a new tab based on the period date monthly, but tasks that are quarterly don't need to be added until the last month of the quarter.  Essentially what I am looking for is a way to have task 1 be monthly and update to the last date of the month every month so that the automation will create it monthlyTask 2 is quarterly and the period should onl

I'm attempting to read the current status of a single select field, what I'd like my script to do is read the status of the button and simply return that status as a string. For example, if I manually set the button to "Doing" and run the script, my script should return "Doing" from the console. My airable is setup with a single table called "Item Status" that lists all the records in the table. Each record has a "Current Status" field, a single select field with "To Do", "Open", and "In Progress"   // read the current status of a record let table = base.getTable("Item Status"); let queryResult = await table.selectRecordsAsync({fields: ["Current Status"]}); console.log(queryResult); let record = queryResult.records[0]; console.log(record.getCellValue("Current Status"));   The problem is when I run this script it returns more data then I want.   CONSOLE.LOG {id: "selkMEZY58GC8AUfc", name: "Open", color: "blueLight2"} id: "selkMEZY58GC8

Hello, my workflow uses Integromat to create new records on Airtable. I have an attachment field, to which PDFS are uploaded to. Up until February 9th, a thumbnail / preview of the attachment was always displayed in my table. However, since the 9th, both the thumbnail and preview of the attachments always show as a generic document icon. I have to click the attachment to actually view it in full. Was there some change that makes previews & thumbnails no longer available as of Feb 9th? All the records prior to the 9th still have working previews in my base. Is there something I can do to get this feature back with the more recent records?

Not sure how to make suggestions to Airtable developers, so I'm putting mine here. Am I the only one who would think it'd be cool if we could reorder the items in a linked field's cell? The way that, say, one could reorder songs in a playlist in Spotify? I know we might be able to do so numerically or alphabetically, but I'm talking about custom reordering. That would mean being able to decide the order in which ingredients are put into a dish or the order in which products should be listed in a catalog, and then easily change your mind later–without having to delete the list and start adding from scratch. Just a thought.

I’m struggling to get my head around how to draw a line chart in Vega-lite that displays multiple fields. I can get one field working, but am hoping someone can post an example of syntax required to do something like this (example from random values in Google Sheets); Appreciate any help on this. Reading through the Vega-lite documentation is leaving me cross-eyed. :frowning: Extra points to show how a line can change colour as its value gets highter or lower. :grinning_face_with_big_eyes: EDIT: Ok, making progress… point data in 3 different graphs. Now to see if I can layer them. { "title": "Data", "repeat": ["Value A", "Value B", "Value C"], "columns": 1, "spec": { "mark": "line", "point": true, "encoding": { "x": {"field": {"repeat": "repeat"}, "bin": true}, "y": {"aggregate": "count", "type": "quantitative" } } } }

I import data into a table, and one of the fields is a booking number, which is unique.How can I make this field unique, that the import doesn't import the same ID including all the other data several times? Thank you,

I designed a base and had someone I hired on Upwork make a base on my free account. Now I want to start my paid PRO ACCOUNT - However the dialog box says " Your paid account will start in 7 days"  I need it to start now because I need to add more extensions than free allows....  PLEASE HELP

I’m in the process of creating a form the interested clients can fill out and submit. One of the fields is a Number (Integer) and I wanted to know if there was a way to give a maximum value. We don’t want to accept the entry if the value in this field is over 100. As far as I know, there is no way to pop up a message or to prevent the entry from being submitted. We would not want the client to proceed with all of the actions driven by the form if their numeric value is greater than 100. I know I can use a formula to determine if the value is greater than 100, but I don’t know how I could use that formula in a form. Thanks in advance.

I require a client to advise me of the show name, ep & series number and duration of each ep they are sending me.I've created a form which works great but only for a single entry. I need them to be able to do bulk sending of this dataI know I could create fields for Ep 1,2 3, etc and separate duration fields for each ep to help capture the detail via a Form but this seems inefficient and some TV shows have 100s of eps and multiple seasons. Is there a better way to approach this which allows for a Form to capture the ep number and its corresponding duration for an entire season of a show? 

Hi,I use a numeric field and sort my linked records in the Interface Designer based on the numeric field. I have some automations that set the number of new records and users can also manually renumber records. This works well for creating records one after the other. However, I want to be able to insert one or more records between two records and keeping the sort order.Example: I want to add one or more items between items 2 and 3. I get stuck!

Is there a way to synch with Mapsly when a record is deleted in Airtable?

My VA has been trying to import files from Google Sheets for days but always ends up having the same issue.Each time she asked to log in to Google Sheets to import from there she ends up having an error 400. We have been cleaning cookies and all but nothing seems to work - See video recording of the error hereAny help/ guidance or how told solve this would be extremely valuable.Thanks

So my title may not make much sense, but here is what I have going on.I have a base that has 2 tables. I have a building table and I have a Tasks table. I have them linked in that some tasks are needed in multiple buildings, so when a task is created it can be assigned to any building that needs that task. However, what I want to be able to do is make a building specific note for each task that only shows for that buildingAs a hypothetical example: I create the task "add signage" and it can be assigned to building A, Building B, Building C, but not D or E, etc.In addition on the "tasks" table I have a "notes" field, and a "status" field for each of the tasks, So I can say "label needs to say "welcome in"" or something like that and know if it is "to do" "in progress" or "done". Here is the part that gets sticky; when I am looking at the buildings page (and it is linked to the tasks page, and have notes show (with a lookup field)) it will show me the notes for any linked task. If I

Hey All,Plugged this automation in and initiated it/turned it on yesterday. It worked once, and had no errors. The next day, it was supposed to repeat (it's set to repeat every day) and it didn't work. (There's plenty of records that satisfy the conditions). Any ideas? Thanks.   

I’ve read many Count Records threads, haven’t found my answer. Table A lists organizations (schools) I’m tracking. Schools have attributes such as public/private, updated/not updated. Once a month or so (automated if possible) I want to count how many schools meet various criteria and record in Table B So Table B will be: Fields: Date, Public Updated, Private Updated, Public not Updated, Private not Updated, etc. Records: 1/1/2022, 200, 400, 100, 200 2/1/2022, 250, 450, 50, 150 3/1/2022, 300, 500, 0, 100 Automation? Script? Rollup? Also—even if I could find the calculation that would give me those #s, I can’t use a calculated field because it will be current, obviously. I need to the calculation on the 1st of the month and then paste # into those fields. Thanks in advance!