Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
Bonjour, J'ai un fichier d'import à intégrer et j'aimerais savoir s'il y a une application ou un script pour éviter les données en double ?
Hello everyone,I’m trying to replicate a process I set up a year ago that is working well. I have a formula that opens a form for a responses table that automatically links it to the main table. The formula uses the form address and prefill, with the record id of the main table record. When I open one of those links it works perfectly. It is not editable, but shows the linked record information.I’m trying to replicate it on a new base, but the same prefill option isn’t bringing up anything unless I make the group editable and then anyone with the form would be able to see all our records. Here are the differences I can spot, but I don’t know how to make them match:In my working form I see this in the group settingsThe line “some fields are editable...” doesn’t show in my new form. The other difference is that the new form gives me this warning under Rules, which is not present in my working form, but I think that’s because I had create a filter in the past. Any thoughts on what I mi
I am reaching out here in desperation because the “contact support” feature in Airtable does not work at all in my workspace, across multiple browsers and devices. Firstly, my “Team” plan workspace has a base, and my base has a form. It is the only form present in the base.After the recent UI update, that form is not visible in the “Forms” tab on the top middle. The system pretends that my base doesn’t have any forms.However, I can still access the form via my bookmarked public link. Additionally, I can submit the form and it successfully will add a record to my base.I need to edit this form, but it is currently not possible to access the edit page of the form. Normally, I would reach out to Support about this. However, when I click the “?” icon on the bottom left and then select “Message Support”, it opens up a blank white rectangle on the bottom right of the screen that does nothing.I know from experience that this should be a chatbot interface. But instead, it is a blank white box t
Hi, can someone please help with my formula? I’d like to calculate the number of days between two dates, but if the dates are the same then they should display 0. The formula below works to show the ones with the same date as 0, however it then shows the ones with different dates as being one figure too little. DATETIME_DIFF( {Post Sale Date}, {Auction Date/Time (Local)}, 'days') To fix this I added +1 to the formula, which of course, solves the latter issue but not the issue for same dates need to show 0. DATETIME_DIFF( {Post Sale Date}, {Auction Date/Time (Local)}, 'days') +1 Can someone please assist 😊
Bonjour à tous,Je suis tout nouveau sur Airtable et je découvre petit à petit l’outil, que je trouve vraiment intéressant.J’aurais besoin de votre aide pour un point précis : j’ai une base dans laquelle j’ai déjà enregistré plusieurs prix de vente, et je voudrais faire la somme totale de ces prix.Je ne sais pas encore comment m’y prendre correctement. Pouvez-vous m’indiquer la méthode la plus simple pour faire ce calcul dans Airtable ?Merci d’avance pour votre aide précieuse !Bien cordialement,
Hi,I’m newbie so I really need help on changing or renaming the records of my table. As far as I know, you can name the records while creating a table, but whatif I already have a table, what should I do to changing the name of my records?
bonjour la communauté, la nouvelle mise à jour des champs de formule permet des sorties à sélection unique pour les champs de formule. J'ai un champs ou est concaténé plusieurs informations incluant une sélection unique. J'ai testé cette nouvelle fonctionnalité et apparaît la sélection unique en couleur, mais les autres informations concaténer n'apparaissent plus.merci de votre retour 😉
Is anyone else having this experience? The new UI (besides for being a steep learning curve) is loading base and interfaces really slowly???Best part of AT was the instant response….
Hello, I am wondering if I stumbled upon a bug, or if this is a setup error or limitation of some kind: I have a dashboard interface with a pivot table, and while it looks great on desktop, it shows up on the mobile view, but missing some key elements - the labels for all columns and rows display as “(Empty)” even though on desktop those values show up just fine. Any ideas why that is? My only guess is that maybe it’s because the fields I’ve chosen are not supported somehow? I’m using a lookup of a single-select value, maybe that’s the issue? Any ideas or fixes welcome. Thanks so much!
This is an Opt-in / Reference Check form:https://airtable.com/appDms8x0QIhxU2F5/pagg3esZJjn6ytUSK/form For some reason, its no longer clickable.. you can’t type on any field. I already made a dupe and its still the same. I tried to revert to yesterday’s version and the old form worked. But Im trying to find out the difference on the settings and visibility, there’s no difference. Im just confused.. another problem is that we sent out this form to plenty of people already that doesnt work.. Can anyone help me please?
I am an Airtable First-Timer and am having a really hard time understanding how to build what I want. I think Airtable is the solution, but I’m just an idiot. I own a small business and need help creating a Food Ordering and Management System. I have a project scope, our current SOP to share if someone would help me build it or I would happily pay someone to build this for me! Can you please message me back if you’re interested? Thank you!
Hi, I’m building a page to track hours — comparing what we’ve budgeted versus the actual hours spent. We’re tracking time in Harvest, and at the moment I’m manually entering that data to match it up, which means there’s no direct link between the two systems. We use the same standard phases for every project (example: B01-B09). Each time a client signs a fee proposal, I want to add these same phases to the new project and allocate the initial budgeted hours. In Excel, I’d simply copy and paste multiple rows, but in this system I can’t duplicate more than one row at a time, which is slowing things down.Ideally, I’d like to be able to duplicate all phases (B01-B09) and assign them to a new project in one go, then input the hours. I also update the actual hours weekly, so it needs to be easy to maintain. I’ve been exploring whether an interface with a button (plus an automation) could do this — so that with one click it would add all the phases for me — but I’m a bit stuck on how to set t
Hi Dear community i’m facing a scipting error pleaase help mei need to connect my ingredients tables to the API open food factsThanks let tableIngredients = base.getTable("Ingrédients");let tableOFF = base.getTable("Open Food Facts");let ingredients = await tableIngredients.selectRecordsAsync();let offRecords = await tableOFF.selectRecordsAsync();for (let record of ingredients.records) { let ingredientName = record.getCellValue("Nom ingrédient"); if (!ingredientName) continue; let response = await fetch(https://world.openfoodfacts.org/cgi/search.pl?search_terms=${encodeURIComponent(ingredientName)}&search_simple=1&action=process&json=1); let data = await response.json(); let product = data.products && data.products.length > 0 ? data.products[0] : null; if (!product) continue; let nutriments = product.nutriments; let energie = nutriments["energy-kcal_100g"] || null; let proteines = nutriments["proteins_100g"] ||
Hello!In the data layer, I can no longer find how to toggle on the setting to view other user’s Personal Views. There used to be a gear icon to the right of “Find a View”, however, I can no longer find it or figure out how to toggle this setting on/off.Can someone please help?Thanks!Sarah
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
