Heya, I'm setting up my first timeline view and using date fields for the first time, and feeling like a complete moron because I cannot figure out for the life of me where I am supposed to enter the actual date here, this UI is not making any sense ...
Hi, warning! I'm new to Airtable and using the basic tier.I'm trying to create a website that will show different lists depending on the answers submitted in a form. I have created the website in Softr and a Form in Tally. The website connects to t...
Hey, I am looking for a formula field to extract city, state and zip code from a full address fieldThis is how a full address looks like "New York, NY, 10031". I want to split them 3 ways using formula, how can I do thatI used this formula to get the...
Hello, I'm trying to create a "create record" automation when a new record is added to table A (Seeds); a new linked record is created in table B (Web Archiving_QA). The input data in table A (Seeds) to create the new record is a website URL.The auto...
Hi allIs there a way to delete the certain matching characters that might appear in a column? For example I have a column of data (800+ cells) of company names, and 90% of them are prefixed with a 'number' (that run between 1 and 9), followed by a 'p...
I have a customer (athlete) table that is one row per customer. And a comms table, that logs when each customer posts something in our community (circle) via Zapier.Then, in the customer table I use a rollup to display the date of each customer's las...
Hello-I am trying to roll up 10 date fields that are all deadline dates to a long text field in a bullet format.Ideally I would want the field name to be visible as well as the date like this (Field name/Date):- Designer due date: 1-2-23- Submittal d...
Hi there, I know how to get things off the end of a string but not the start!!! I have recipes that look like this Easy veggie, lentil and quinoa dahl with pita toasts (KIDS)Greek salad with crispy chickpeas and potatoesMiso eggplant with broccolini...
I love using Single & Multiple Select Fields when designing my bases. This option helps keep the data consistent and saves some data entry time. My list of possible options tends to be long in these fields and I am struggling to edit them in the spac...
I'm working an automation where I need to compare a numerical value with its History should the value change. Is it possible to iterate over the history of a cell/record to create the comparison. If that is not possible, how can I create a second c...
I have a series of fields I want to concatenate together. The final result needs to include a semi-colon in between each piece of data, but not all columns have data. So I was working to do an IF statement to check if the last of the columns (far rig...
Hi All, I’m trying to automate a trigger that emails a form the day after the date that has been entered in a specific record/field (which I guess you could think of as a “cell” in Excel).So for example, say 1/26 is entered as a date in a specific fi...
I have a 'customer' table (one row per customer - name, email etc), and I have a 'contact' table that records the date of every instance of a customer contacting us (customer ID, date of contact etc). How would I pull in 'date of contact' into the cu...
I had a script configured to generate a task list on a button trigger based on the one in the Airtable Marketplace that had the settings input. I have moved everyone out of the base and into Interfaces, so the button won't work.I tried to write a ne...
For those having trouble changing their username, I've been informed by Airtable that community members need to first: -Provide at least 1 kudos-Apply 5 or more message tags (they can apply tags when they create a post). Let's see if this works...
Hey everyone!My name is Minas and I run a map-making website, where you click on a map, add your legend, and download it as an image.A few months ago, one of my users, who is also using Airtable every day, suggested creating an Airtable extension wit...
hi !! can someone help me? i need to send a email dayli, a greed whit total sales in determinate date, how i can get a total for each colums, and send in the email ? .
I have 100 people in my database, I want to send an email to each (email is in record) and in the email have a button (webhook or form) that updates another field in their record. Example: Do you support the project? Button or form could either just...
Hello,I have been using Airtable for a long time - but am new to the community. Nice to be here! I would like to copy a value in a cell to another record when a condition is met.(The image as an example)If a product (e.g. product 1 in group A) gets ...