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
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.
I am comfortable creating a prefilled form using two tables. I am having issues getting a prefilled form to work across three tables. The top field in the form is a Link field between the primary and secondary tables using the recordID. Simple enough so far. But I have a third table with records that link back to the primary table. I want users to be able to select records (from this third table) in a second Link field at the bottom of the form. My attempt at doing this is creating Link fields from this third table to both the primary and secondary tables, hoping the record ID would pull through to populate the selection in the prefilled form. My thinking is that the record ID for the Third--->Primary and Third--->Secondary links are the same record ID. This has not been successful. Below is an example of the formula I am trying. CONCATENATE("https://airtable.com/abc/xyz/form?prefill_PrimaryField=",RECORD_ID(),"&prefill_SecondaryTableLinkToThirdTable=",ENCODE_URL_COMPONENT(RE
Hello, I have built a table with links to spotify, Instagram, twitter and tik tok and I also include the number of followers of each of the artists in the table. I update this data by hand and I would like to know if there is a way to automate this update or to do it on demand for a previously selected group of artists. Thank you!
I have a very simple automation that runs every 15 mins. It finds rows from a table that have data in a specific column and then uses a repeating group to send a slack message to each of the channels listed in those rows it found. This typically works 90% of the time but usually a handful of times a day it errors out for Slack API rate limited. Sometimes it errors out with 4 groups that it found but will also error out with 1 group. Experiencing similar issues related to the repeating groups for slack messages. Any help is appreciated.
Hi there, I am looking at creating a line graph in the interface. Is there a way to show multiple teams as the lines? What I am hoping for is X axis to have the months and the Y axis to have the number and each month to populate the number is this possible? Thank you
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
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.
hey all,I try to render an image in page designer. It works fine for uploaded images but if I only have an Image-URL - How can this be shown on the page designer. Thanks for your helpFlorian
Hi Airtable folks, I’ve got this really fun bookkeeping base I’ve created, which I use in conjunction with Fintable.io (a way to push bank transactions into Airtable – highly recommend!). Since Fintable downloads the transaction names from my bank statements in all sorts of different ways depending on how the banks format them, I wanted to create a formula to extract the Vendor name from when I receive or send money through Zelle. The thing is that this can show up in a variety of ways:ZELLE FROM FIRSTNAME LASTNAME ON DATEZELLE TO FIRSTNAME LASTNAME ON DATEZelle Payment to FirstName LastNameZelle Payment from FirstName LastNameZelle Payment to FirstNameZelle Payment from FirstNameAnd so on… What I’m getting stuck on is how to combine two formulas I ended up creating: one that returns both the first name and last name of the person (but when there is no last name, returns some of the random extra characters after the first name), and one that returns only the first name, whether there
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
New to AirtableJust cannot get this to workThe first 3 records….all the same - adds up to 22.In what I hoped would be a summary table - one record the same as those 3 using the MTOX fieldbut this is all I get
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.