Hi everyoneI hope for your help to improve an existing script for automating tasks for projects. I have courses and classes where we always have repetitive tasks in order to organize the courses.In order to avoid creating always the same tasks, I cre...
Hi there I am hoping you can help me.I need to automate Clinician Fees in Airtable according to the Insurance company and whether the patient is a clinic (default fee) or practitioner's own patient (unique). Will it be easier to do an Automation o...
I am working on a massive update to my table 250+ records. Each record has a "terpene profile" field that can contain anywhere from 1-9 terpenes, each with their own associated "effect" , "flavor and aroma profile" and "helps with" fields that all ne...
I am collecting survey results into an airtable base.This includes two tables:The index for all surveys (and including key information such as deadline).The responses for the various surveys (each response is linked to a survey)Each survey has a dead...
Hello, Recently I have got an excel with information about customers and their ordered products and quantities.I have added all the tables and fields in order to turn this information into airtable orders with line items.Is there a way to automate th...
Hello. I'm looking for a script or an automation that I can use in Airtable to automatically upload an attachment to an SFTP/FTP site. I have made it work using Zapier and EasyFTP but I was wondering if there was a script that could do this.
Hello, is there a way of Exactly match a word, I am trying to do an automation that includes Only "Capital" . the condition automatically returns any cell that has Capital, and the whole point is to only return the cells that contain Capital by itse...
I have "table A" that holds clients. "table B" holds items. I want to see if there is a match for a field value. If "value 1A" from table A is < than "value 1B" from table B its considered a match and i like to receive the recordID for both.
Hi,I have been cracking my head for hours trying to find something in Airtable documentation for this.We are trying to upload Airtable attachments to our website (so we don't have to rely on Airtable). Is there a way to:1. display the Expiring Downlo...
I have a formula field in one of my bases that is designed to show us how much work is left to be done before a project's start date.So we have the start date and the number of outstanding tasks. The formula field looks at those two fields and lets ...
Hello,I would like to create a job board with webflow and use Airtable as a backend when an application is submitted and send an automatic email summarizing the application (for the applicant and for me)First question :- Does an airtable form can be ...
I have a work date formula in the 'end date' column.IF(AND({Start Date},{SLA (days)}), WORKDAY({Start Date},{SLA (days)}))When someone changes the SLA number, start dates and end dates changed because I setup a dependency automation.However, I'm seei...
Hi there,Hoping someone can help with something I hope can be automated. I have multiple fields with numbers in, let's say:Field 1A: 100Field 1B: Field 2A: 250Field 2B:Field 3A: 500Field 3B:I then have a % field, based on which I would like an automa...
Javascript baby here. My ultimate goal is that when a record is created and matches conditions, a script will run that will duplicate that record a number of times and update it's status. I've been modifying a duplication script from an extension scr...
Hi there, Im new to airtable and Im having difficulty with formulas in general.Currently on my table is Name, Date and the PromoWhat Im trying to achieve is that every time a new person and the date is added, the person is given a promo based on the ...
Hey there Y'all - I am trying to have Airtable automatically duplicate a record in the SAME table when the status of another record is "approved". The duplicate record would have all the same information except the status would be set to "editing" an...
Howdy AT Community! Hoping a kind soul can provide some assistance with an automation query. I'm trying to track subscription activations for a University cohort, pulling from a large Uni Cohorts table to update a specific cohort tracker table. Desi...
I am trying to insert a formula field for a "friendly name" into an automated email.The formula just looks to see if a person has a nickname and then either uses the first name or the nickname.IF({Nickname},{Nickname},IF({First Name},{First Name}))I ...
Hi All,I am a Recruiter and I stored my candidate details in Airtable like Name/Contact No./Current Company.Now I want to share an automated email to my candidates to update their respective record. Note: My candidates don't have edit permission. Ple...
Hi! I have the following problem I'm trying to solve:I have one Trip table which lists a series of trips, which each have a start and end date and a list of 4 potential locations.I have another Crew table which lists crew members start and end dates,...
