I have a "main" table, call it A. It holds client names. I have a second table, call it "B." It will hold deadlines. For every A record, i.e. client, Table B should have one corresponding record where a lookup field (call it "Name") populates wit...
Dear AllI am trying to automate "master project status" in the base, hopefully through creating a formula. "Master project" is a made of all small "projects". Logic as below: - If all of "project status" is "concluded", then "master project status" i...
Hello!I'm fairly new to Airtable, but I have found myself stuck on something and I'm unsure the best approach. I have a base that is receiving data from submitted forms for security requests. These requests are worked on by 3 different staff member...
Hello everyone, I need help with automation. 1. I have Table 1 with the primary field 'Date' where I receive in a column 'Complete Description' a long and annoying detail2. I want to simplify step 1. based on the primary field of Table 2 'Expense' wh...
Hello Airtable Community,I’m currently working on improving our Airtable system and could use your expertise. We have a setup where participants sign up for trips, and upon signup, we need to automatically generate a billing record. Here's the challe...
Is it possible to do a header / group each section? I am looking to put a few points under different sections but I cant seem to find the option to add a heading or a divider. Kindly assist.
Hi all! I am reaching out in hope of finding a solution. So I work for a music instrument manufacturer where we track each job (all instrument specifics) in our airtable database. I am trying to find a way to have a price column that calculates as yo...
I am wondering if it is possible to create an automation where a pool of 10 freelance job candidates are prioritized according to distance from an added Japan Postal Code, and then emailed one after another with a 24 hour deadline to respond if avail...
Hello,I am designing a base that needs URLs with markdown in this format:[text to display](https://my.url.com)However, when I try that... that's exactly what it looks like. I'm using long text fields with rich text enabled. I've tried a bunch of vari...
Hi! I think this is simple, but can't figure it out...I have a base where I have a “Sales“ tab, here I have the date, client, and price sold. This tab has all the sales for the entire month. I can make a new “Daily view“ and filter by date, so now I ...
HII'd like to update my current job submission form to collect extra details on certain projects. I only want this new field to appear if Job Type "XYZ" is selected (I know how to do that part!)Part I need help with:I need the submitter to answer a ...
Hi I'm trying to set up my base (I have a separate Reminder base just for this purpose) so that it should sync my Airtable to the Outlook calendar, it should show up all my reminders that I have in that base, is there a possibility that it should wor...
Looking to add an automation to an interface that will assign a record to someone based on an order. I found an article explaining how to set up the automation, but am getting stuck! In your collaborators field, have the following fieldsa checkbox fi...
Hi everyone,I have an automation here that works perfectly fine when I add a new dataset into my grid view. Once I switch to a form to add a new dataset the automation doesn't work properly. The automation I duplicated starts but the value is wrong. ...
Hi all, I've been a fly on the wall in the community for a while now, today I need some help. I reviewed this post to help me with my problem, however I'm still running into issues I can't seem to get around with my current ability. For reference, I'...
I am trying to set up an employee scheduling table. The table has links to my events table and to my employee table. The events have a "Start date" and "end date". Is there a way to create new records in the scheduling table pulled from events in the...
I have a rogue automation that is running outside of the trigger I set. This video shows the issue.Any ideas on what's happening here?Thanks in advance!
HelloI was hoping for some advice on how to best approach this use-case we have. Some background:Our marketing team manages all of their accounts through Airtable. We have a primary table called "All Locations" which is our "source of truth" for loca...
I would like to send an email to my team whenever an event in the airtable calendar/grid has a change made within 7 days before the event date listed in the grid/calendar. We used the system to put all our event notes. Example, if I change the gues...
Hello! I'm a new Airtable user so I'm still getting used to the terminology of the platform, so I appreciate your patience.I book travel for a company that hosts 28 events during the year. I have set up my base to reflect the information for each eve...
