Other Questions

Hello everyone.one of our critical bases got deleted and no one can find it.it was in this URL:airtable.com/apppoE9v0FOCBcCGsAirtable support is not responding. anyone can help me figure out how to fix it?

Context:I have three tables. Customers, subscriptions, and orders. A customer can have multiple subscriptions, and a subscription can have multiple orders. Every time a customer fills out the order form, it is created in the order table. So a 1-month subscription will have 12 orders for the year. I have columns in my subscription table that track the expiry date and formulate the days remaining for the subscription. This way, I can automate email reminders as the subscription is set to expire. What I'm trying to automate: When I complete an order. I want to automatically update the expiry date for the subscription. This is my thought process thus far. Scenario 1: The subscription has already expired. The customer orders a 3-month subscription. I activate the subscription and mark the checkbox complete on the table. I timestamp when the order was completed / subscription was activated. The subscriptions can be 1,3,6 or 12 months. I need to ch

Hi there - thank you for your comments and help in advance.My setting: I have 2 tables in one base, containing product information.My goal: to enrich one table (main-table) with the details of the other table (detail-table).context: The main table contains the product name (e.g. Solvent black 27). The detail table contains that name as well (Solvent black 27) - but additional details, like e.g. color index.How can I enrich the data in the main-table with further details of the detail-table.I tried to do a lookup, of course, but the I dont find a way how I can ensure, that the lookup field always has the same name as the name of the main-table.To make it more understandable: In SQL I would be a "clasical" join.Thank you for your support

We are using Airtable to inventory and create our perfume formulas. We have one Base for the Working Formulas. We would like to create a table that automatically creates a record whenever a new table is created in the base. This way we will be able to track its progress, etc. Is that doable or should we just create the records manually?

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