Other Questions

Have resorted to publishing here as I have gone around in circles trying to contact Airtable support. They are attempting to bill me for credits to my account as a result of accidentally selecting an annual plan, then downgrading to a monthly. I followed instructions to navigate to Home, then click Help > Message Support. This opens a chat bot, where every time I ask to speak with support it tells me to click Help > Message Support. Which takes me back to the chat bot.When I follow instructions as guided through by the chat bot about stopping the transaction attempts, it gives me a link to 'Contact Support Here'. Which opens the homepage, and I'm back to where I started. As Airtable have depracated email support, I was left to publish here in hopes someone at Airtable might see it. And also to flag this issue with contacting support. Has overall been a very frustrating process.

Hello....when opening up the thumbnail and going in to edit/rotate the photo, as I was hovering waiting for the three vertical dots to appear I think I accidentally clicked an option that hides that icon and the little circl above it that usually appear in the upper left of the photo if you hover over it.  Now I don't know how to unhide them and get them back so I can use them again.  Help!

Is it possible to edit the <iframe> embed code for a shared Gantt view eg: <iframe class="airtable-embed" src="https://airtable.com/embed/........?backgroundColor=red" frameborder="0" onmousewheel="" width="100%" height="533" style="background: transparent; border: 1px solid #ccc;"></iframe> to assign the date range button to select "Quarter" with the "Today" button action selected.  Currently when I go to the url where the view is embedded it defaults to the "Quarter" date range but for Q2 2022 which is two quarters before any of the dates listed in the view.What it currently shows:What I would like it to show:Here's the date range "Quarter" option selection HTML copied from the developer console <option value="{"notUndefinedValue":"oneQuarter"}">Quarter</option> And here's the "Today" button HTML <button class="white grayLight2-hover stroked1-inset text-darken4 strong events css-1t

Is it possible for the submit button on a form to not be visible until all of the conditional fields are satisfied? 

Hello out there, I am not experienced in writing code and I am hoping that someone can help me make a workflow dream come true! I’ll do my best to explain what the goal is below, but please let me know if it is unclear. In my Program Management base, I recently followed this example to add tasks from a Task Template table to specific projects, just copying/pasting the code: https://www.airscript.dev/2020/10/04/generating-tasks-for-projects The code copies every task from the Task Template table into the project. What I am hoping for help with is: We have several different project types, each that involves its own set of tasks. Is there a way for me to add to the above code so that I can pick a specific set of tasks in the Task Template table, based on an identifier? Currently, to separate out which project types that tasks are associated with in the Task Template table, I have a ‘multiple select’ field that includes types like Solo Exhibition, Juried Exhibition, Traveling Exhibition,

Hi everyone!As far as I can tell the max value for zooming out scale in a GANTT is 5 years. To me it would be valuable to zoom out way further, 20-50-100 years. This is useful when you register people (birthyear-deathyear). Views often have a few centuries span. Is it possible to accomplish this at the moment?Regards,André

I have an airtable view embedded on my site. When I click on Filter-> Add Condition, the webpage jumps down the page a couple hundred pixels, which makes for a terrible user experience - the user can't even see the filter box anymore and has to scroll back up and reclick in it to add a filter. You can reproduce this on our site and see for yourself: https://www.highimpactprofessionals.org/talent-directoryAnything we are doing wrong here? We just copied the embed code, so not sure what could be wrong.In case it is useful, we use Wix to build the site.

I am using the Gantt view. I have 50 tasks. Every 10 tasks has a milestone.  And each set of tasks is marked as dependencies for each milestone they come under. I would like the milestone dates to be updated automatically when the end dates for one of the 10 tasks change. i.e the task with the furthermost date should be the end date of the milestone. How would I do this ?Thank you !

I’m having trouble getting started. I need to link a Google sheet to Airtable. When I select Sheets from the dropdown I get a popup that tells me to sign in to Google. When I click “sign in” it looks like another popup loads and immediately closes then I get a 400 error and it tells me the request is malformed. I have popups and cookies enabled. I’m logged into Google.

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,