Important Update: Single Sign-On (SSO) for the Airtable Community will be required effective June 2n...
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
Hi all, Is it possible to prevent the creation of record under certain condition during form submission?Like upon button click, there will be a check against the database for certain condition and throw back error message.
Hi! I might just be silly, but is there not a way to copy and paste a status across several records in list view? In grid view it’s easy, just copy a cell and paste. Is there not an easy and quick way to do this in list view?
Good DayI have generated a base and from that base a form. Once submitted the form automatically adds the information to the base. When the new record is generated in the base I want to send an email to the person submitting the form. There is a field in the form where the person adds there ID I used that field in the To part of the automation and I am getting an error. The below is the layout of my automation In the Body of the text is a member number that is automatically generated when the form is submitted.When Generating a Preview I get an Error Message I have checked the field of the new record and the email address is displayed.. I dont know how to resolve this. Many thanks
I have many linked records and lookup tables from one table to another. However, if the name of the source table or field changes, the linked table name or field name does not change. It is now very confusing to know what is actually linked. Is there a way to update names automatically?
Hello AirTable Fam, I am trying figure out when a form is filled out and it’s linked to a client, their email address can be populate into another cell. Any help would be greatly appreciated.
Hello,I have a base and I want to create forms that allow some to suggest new entries into the base. Once the suggestion comes through I would approve it then merge it into the base. However I need to know who that person is and limit access to the form to okta users. Whats the best way to go about doing this?
I have a Master Inventory of all line items for a project. We then create Material Requests where we collate a number of these line items (maybe a few hundred) per vessel sailing. I need a way of effectively viewing the Inventory and selecting a checkbox or similar, then allocating these items to that Material Request. This creates a new record for that item. I can go into my material request currently and select individual items that are added, but cannot find a method of bulk selection and allocation.
Hi there, If I have data that is pulled in from another file and in one column it is showing this - Project department (John Smith)How do I grab the (John Smith) part and let it populate into the column next to it? Adding to that once I have the names do these names need to be added to the base in order for them to view their assigned things in an interface? Many thanks
Feeling a little stupid because I can’t figure out how to do this. It is a simple task on a spreadsheet, but I have failed in all my attempts to get it to work. I am managing a construction project and I have creating 2 tables, One for electrical costs and another for Sprinklers Cost. I then created a third table, which I call it Dashboard. The intention with that table is to show the sums of all costs from the other tables. For example, on the sprinklers table, I have a column (Quote) with all the costs I have incurred so far. I did the same thing on the Electrical table. On the Dashboard table I have created a record for Sprinklers and another for Electrical, and for each record I need to show the sum of the costs for the tables Electrical and Sprinklers As per the images attached, I want to be able to show the value of $14,300 (sum of all costs on the column “Quote” of the Electrical table) on the record of Electrical #200, at column “Total Paid so far” on the Dashboard Table. I als
Hello all, We have recently implemented Airtable on our team to account for hours worked by employees. To gather the information, I created a form in which they answer at the end of every work-day to take into account the actual hours worked. These answers feed a database that groups every reply by week/employee. In the database, I created a column of “Work-day” which is the employee’s weekly hours divided by 5 business days. This way, when they answer the form, I would have the daily overtime and then it would be grouped weekly and it would give me the weekly overtime.However, the team is mainly composed by part-time workers and that’s where it becomes tricky. We don’t really enforce a fixed start/finish hour, so a person who has a contract of 18 hours/week, may work only 2 days one week and then 5 days the next week, picture below. What I would like for it to do, and that I wasn’t able to, is to calculate how much overtime (or time they didn’t work) they are doing per week, based of
The bases I create are labeled “External” (even after accepting my Organization's invite) and lack the same functionality as bases created by the Big Boss. Are there currently settings that ensure bases created by users within the organization are internal (and benefit from the functionality associated with our price plan)? Would changing my permissions level from “Creator” to “Owner” make a difference? I guess I’m confused that a user can belong to an organization, yet the bases they create do not. Put another way, in practice, every user other than the Big Boss is individually on the “free” plan and creates only stripped-down “External” bases. I'm told we're in the process of migrating from Teams to Business. Will that remedy this? It doesn't make sense to me that only one person has full functionality, regardless of number of users in the plan. I don't have access to the organization's settings. Are the ones with access simply overlooking something?I appreciate any clarity provided.
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.