Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Discussions Activity
Quick and very dumb question about using date fields
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 ...
- 11 Views
- 1 replies
- 0 kudos
automating the population of fields
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...
- 7 Views
- 0 replies
- 0 kudos
Formula field to split text into 3 ways
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...
- 12 Views
- 1 replies
- 0 kudos
Automation only works when Test Step: Run as configured
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...
- 8 Views
- 0 replies
- 0 kudos
Resolved! Delete first matching characters in a column
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...
- 28 Views
- 4 replies
- 0 kudos
Adding records to a linked table
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...
- 19 Views
- 1 replies
- 0 kudos
Multiple date roll-up to long text bullet format
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...
- 26 Views
- 0 replies
- 0 kudos
Remove TM from front of recipe
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...
- 22 Views
- 1 replies
- 0 kudos
Is there a way to expand the size of the Single & Multiple Field Select Editor Windows?
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...
- 27 Views
- 2 replies
- 1 kudos
Comparing a value with its history
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...
- 32 Views
- 2 replies
- 0 kudos
Retrieve deleted interfaces?
I seem to have deleted all the interfaces I spent the entire day working on. Is there a way to recover this work? I feel quite stupid!
- 24 Views
- 2 replies
- 0 kudos
Resolved! Concatenate with IF statements, blanks, and inserting ";" in between data,
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...
- 62 Views
- 4 replies
- 0 kudos
Attempting to Automate an Email Form After A Date Is Entered
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...
- 20 Views
- 2 replies
- 0 kudos
Resolved! lookup - most recent entry
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...
- 40 Views
- 3 replies
- 0 kudos
Help with script...
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...
- 43 Views
- 2 replies
- 0 kudos
Changing username within settings
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...
- 23 Views
- 0 replies
- 0 kudos
🗺️ I made an extension that lets you visualize your records on a custom map
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...
- 53 Views
- 1 replies
- 3 kudos
Total in colums and send email
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 ? .
- 21 Views
- 1 replies
- 0 kudos
Can I send an email to a record & button click in email updates record field?
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...
- 42 Views
- 7 replies
- 1 kudos
Automatically copy a value to another record
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 ...
- 50 Views
- 1 replies
- 0 kudos
| User | Count |
|---|---|
| 3120 | |
| 2679 | |
| 2626 | |
| 1905 | |
| 1852 |
