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 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
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
Hey folks 👋 We’re looking to bring on a full-time “Airtable Workflow Specialist” to join our growing team. Ideally this person is LATAM-based, bonus points if Argentina-based. The ideal candidate:Experience building complex workflows using Interfaces Experience using scripts within Airtable Experience building automations within Airtable Experience using Airtable formulas Experience with automating processes outside of Airtable (via APIs, Zapier/Make, etc.) Entrepreneurial-minded & curious If you think you or someone you know would be perfect for this, please send me a message here!
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.
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
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
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.