Ask the Community

I'm building a dataset where i'm taking the total amount of something and breaking it down into a per day calculation.  However on the first couple of days these projected calculations aren't always hit.  Is there a way to build a formula that takes into account a ramp up period of some kind for the first couple of days?Here it is in practice:A brand wants to have a certain amount of budget set against a specific website that they're advertising on.  The budget of $100,000 over 10 days, or $10,000 / day. However in reality, hitting $10,000 in the first day or so is nearly impossible because of certain elements that need to be taken into account.  This is the ramp up period.  In reality it starts off with $1000 for day one, $3000 for day 2, $7000 on day 3, and then hitting the per day spend goal of $10,000.  Sometimes to compensate for this the website may over-spend on Day 4 and 5 to bring the average back to $10,000 a day. Is there any way to build a

I would guess this question has been asked and answered before, but I can't find an answer.I have a table of contacts and a table of campaigns. I would like to be able to filter the contacts by whatever criteria, and then add a bulk cross reference to that filtered group in a row of the campaigns table, populating the 'Link to another record' field.For example, I have a group of individuals I would like to contact for an event mailing. I have a row in the campaigns table that has details of the event mailing (description, date, etc), and I want to keep a record of everyone who was contacted.If that makes sense as a requirement, is it a job for an automations?

Hi, we are getting a "over limits" alert on the top right corner of our database screen. What does this mean and what can we do next? We are still using it to this moment and adding new data, will there be a problem in storing the data safely? Will it affect the current data (for example, get erased or moved somewhere else)? Thank you in advance!  

Hey there! 🙂I have a "Customers" table and a "Projects" table and what I'm trying to achieve is to link them. I wan't to know which customer were in each one of my projects, so a costumer may be in more than one project aswell a project will have more than one costumer. To do so, I created a linked record column and what I'm trying to do is to copy the costumer's name (it'll be roughly 100-200 rows) and past them in just one cell in table Projects (to link those 200 customers to that specific Project in the row). Is it possible? There's any better way to do it?

HelloI am in the process of creating a web-based marketplace, and I've chosen to use Airtable to store and manage data. I've also developed an interface that includes a dashboard for vendors and a registration form for new vendors. Additionally, there's a product submission form for vendors to add their products to the marketplace.My question is whether it's possible to share this product submission form with multiple vendors and the interface view , and whether I can provide each vendor with their own table view. In other words, can I customize the experience for each vendor, allowing them to see and manage their specific data within the platform?"

HelloI'd like to know if it's possible to trigger a post_message event when the form is submitted (this is for an embedded form). I've seen that the system is already used to manage iframe scrolling with the "airtableDisableScrollbar" post_message.Having information on whether the form has been sent (and whether it was successful or not) would be very useful for managing other events on the "parent" page on which the form appears.If this is not possible with this solution. Is there another way to do this?Thanks in advance!Sincerely

Dear community,In the company I work for, we have a base which contains a lot of sensitive data about clients. We are currently on the Team plan. I noticed that there is no inactivity log out in Airtable. The only safety measure I could potentially take is 2FA. Although, preferrably I would have 2FA, a inactivity log out and something that makes it only possible for colleagues to log-in when they are on their work MS365 account.I see this last thing is possible with SSO, but that's only applicable for business. Since we are a foundation, that is hard to afford for about 20 employees. I hope someone in the community can help us with this security issueThanks a lot,Sid

Thanks in advance for any help, I am new to Airtable and to using formulas at all. Having trouble figuring this one out, but I’m sure it’s a simple solution. Context: I grow mushrooms, 3 different strains (K, B, L). Every day I prepare a new batch (8 bags, same strain). Every week I prepare 5 batches, 1 batch per day, mon–fri. I need to create a unique record for each batch. Currently, I am using a concatenate formula to combine the strain code (K, B, or L) with the week number it was created. i.e. K.40 My Problem: 2 days of the week, I will repeat the same batch (strain type) I did earlier in the week, which leaves me with two instances of the same thing (K.40). I need a formula or combination of formulas that can identify when the same batch code has appeared twice in one week, and then assign only the second instance of that occurrence with a (.2) i.e. K.40.2. See screenshots below for reference: Screen Shot 2020-10-05 at 17.25.41|700x451 Any help is appreciated, Thanks a lot

I'm trying to do this exact functionality from excel, within airtable: Dependent Drop Down Lists Essentially, the single field drop down list will update depending upon the input to another field, as seen below Fruit & Vegetable have two different list options. Is there an easy way to do this, maybe through linking back to a key in another table? Any suggestions help!   

Hi there! Can anyone tell me what this view in Airtable is called and how I can implement it? Thank you!  

Hi all,I am building a web app with Pory (pory.io) as the frontend and Airtable as the backend.I would like users to log in and enter information into Airtable via Airtable forms.I have been able to set up users on Pory and integrate this with Airtable. However, when I fill out a form as a logged-in user the records that are created have "Anonymous" in the field "created by", and do not appear to be associated with the logged-in user.Is it possible to prefill a field in the the Airtable form with the ID of the logged-in Pory user, or to otherwise to associated the record that is created when the form is submitted with the logged-in user?Best regards,

On the website https://www.airtable.com/partners, it says that one of the benefits of joining the Airtable Partners Program is that "you’ll reach new audiences within our broad customer base and tap into new markets via our channels". Currently, Airtable customers can search through a directory of Airtable Service Providers https://ecosystem.airtable.com/consultants. Are there other ways for them to reach existing Airtable customers?

I am supposed to have data from a Typeform populate two different Airtable sheets through Zapier. The first one is an Airtable base that I created for my own use. The second one is a class-shared base. I believe I have set up my Zap correctly because when I fill out my Typeform, the data is correctly entered into my personal Airtable. I set up the shared Airtable the same way, however, I cannot get any data to show up. Any ideas why this is not working?

Bonjour Madame , Monsieur je suis nouveau sur air table , j'ai du mal avec ma base , est ce que quelqu'un peut m'aider s'il vous plait.Je voudrais réaliser des conditions sur les automatisations , est ce que je peux faire call avec une personne ?

I have an annual Airtable payment due on December 7, 2023. I have to get prior approval for all software purchases, and I need to submit an official invoice for the approval. I can only see my past invoices (Nov. 2023 and before). Is there a way to see an invoice for an upcoming payment?This is crucial because the payment is set to go through automatically. I will get in big trouble if I allow a payment to go through without getting the pre-approval. But I can't get the pre-approval without an invoice!

I’m trying to create a formula field which calculates the number of days in a specific month between two dates. For example, the date range 2020-01-27 to 2020-03-12 has: 5 days in January 29 days in February 12 days in March So in a formula field calculating the “January Days” between the two dates, the value would be “5”. This has me utterly stumped, can anyone help?

Dear all,when I create a record from a form, I need that a field of #Number type is populated with a default value of 1.Unfortunately this does not happen and the cell remains empty; only if I create the record directly from the Grid the default is inserted.Have you any by-pass for the problem or I'm doing an wrong operation?The only by-pass, at the moment, is to insert the field in the form and writing the default manually.Thank you. Best regards. A. Borriero 

I have an airtable base with two fields : name and website. Some of the orgs have website filled and some don't.  I want to do the following1. Check if the website column is empty.2. If no, nothing should be done.3. If yes, look for the name of the org in the 'Name' column               See if it matches with the name in an excelsheet/google sheet               Find the corresponding website from the excel               Update it back in airtable against the nameHow can I proceed with this? I read about API calls. Would the update to each record be considered as 1 API call? Is there a way to find records in bulk, match and then update records in bulk? I am okay to do this using Python script as well. However would like to first know if this is possible through airtable automation , automation using make or airtable script (extension) before looking to write a Pyt

I have a button automation that sends a message to Slack. In this message, I'd like a filtered list in the interface to be included, how do i do this?

Hi all,I'm using the 'Find Records' automation to get a grid of records to email to other people. Though my table is sorted by date, the records are being returned in a completely random order (see attached, specifically the Overtime Worked Date column). Any thoughts on how to make the grid return information that's ordered chronologically instead?Thanks so much !!

Hi guys! Do you experience any issues with the automations these days? Recently, I’m experiencing the slowness of automations. Literally, it takes ages to write anything in the past few weeks. I’ve checked the issues on other machines of my colleagues and they also experienced slowness. Thanks!

I've got a table in one of my bases where I keep a list of what we charge customers for items.  We're a services company, so nothing is set in stone, but we use this table for a guideline (and the prices rarely change much, if ever).I haven't updated the design of this particular table in a while, so I'm reviewing it now and not 100% sure of the best approach.I have a second table where I actually keep every single item we ever put on an invoice.  44 in total.  And then we just reference the table with pricing, but mainly because it has more granular information.  For example, I might have a "Facility Fee" as an invoice item, but then I have multiple "Facility Fee" entries in the Price table for different durations.  I now realize it's a bit silly to split things out in the manner we've done...at least how we're during it currently.Invoice table (each "Item" is a possible invoice item).  Very simple, but more things link off of here in a separate process.&

We have multiple users working on our Base at the same time. Because any changes to a Table View persist across all users, we have to have personalised Table Views for each user. Otherwise users clash with each other when editing a particular Table View. This is fine, but it limits our ability to use Table Views for what they are designed for. If we want to have different Table Views for (example) different film genres. Then we need to create a Table View for every user for every film genre. We then end up with a long, unwieldy list of Table Views. There are some features that we simply don’t use because we don’t want to create more Table Views. This could be avoided by allowing users to hide Table Views that remain hidden every time they log in. That way each user could have their own personal set of Table Views.

Hi, I am using Make to upload a video file in an Airtable record, but for an unknown reason, the video gets deleted automatically as soon as it's uploaded.Has anyone experienced this, and if yes, how can I fix it ?

Hello,Does anyone know how I could make the update function for this button dynamic to the user of the interface? The end goal is to do mass updates to records and I need the user to be able to choose what the update value should be. Perhaps I could tie it to a record picker to choose the update value?Thanks for reading!