Solved

Hi everyone. I am currently using the Slack automation to notify me when a record has been added or updated. Is there a way to include the name of who updated the record last in this notification.

Hi, is Airtable able to do Finish to Start formulas that autofill dates similar to smartsheets? I’d love to have a sheet with the tasks and deadlines are autofilled based on the formula for how many days from Go-Live, so all I would enter is the Go-Live date and all tasks are automatically filled. Is this possible in Airtable?

Hai, can anyone help me to write formula but based on single select column. If single select = Kg will be multiply 1 ( * 1) then If single select = Box will be multiply 5 (* 5) and then if single select = 200 gram will be divide 5 (/ 5)

Hi, I have an automation that is designed to create multiple records from a single row in another table. All but one of the fields will be identical, so I’d like to be able to copy my action step and just adjust the one field that I need to, but I can’t see a way of doing this. Is it possible? Thanks in advance.

I’ve used Airtable before, but never set up my own base before, so pretty new to this. I have two tables Students Daily Submissions Students is a fixed list of enrolled students that is linked to Daily Submissions Daily Submissions is fed by a form that collects a student (selected from a menu from Students), a link, and a description. When someone submits a form, it also collects Created Time in a field called timestamp. In Students, I want to create a field called Most Recent Share that will display the date of the most recent Daily Submission for each student. After reading Rollup field overview and topics including Formula to calculate the latest Date in an array and Roll up max date but show another field I tried creating a Rollup that collects ARRAYUNIQUE(values), which showed nothing, and MAX(ARRAYUNIQUE(values)), which showed a column of zeroes But I don’t know which of those is correct, or what the Formula (or is it Lookup?) in the Most Recent Share field should be, and h

Hi, I’ve set up a scheduled automation to send me an email reminder everyday for open tickets that I need to resolve. The thing is that I’d like to configure this automation to only be triggered if there are open tickets in the first place, i.e. if the count of open tickets > 0 or if one of the views in my table “Open tickets” has any records in it. I don’t want to keep receiving an email daily that says “You have 0 open tickets”. How can I set the Scheduled automation to only run based on a condition? Is this even possible? Any help would be much appreciated. Thank you.

Hi! Having some issues with an automation. In summary: 2 tables: Customer ‘Orders’ table Customer ‘Leads’ table Automation: Step 1 (Trigger) : New record is added to Orders. Step 2 (Action): Find record in ‘Leads’ that has a matching email address (as the record in Step 1). Step 3 (Update): In ‘Leads’, update a field in the record found in Step 2. Outcome: When a matching email address is found, everything works as expected :slightly_smiling_face: However, when there is no match found: Step 2 reports ‘Step Successful’, but returns 0 records found (this is as I would expect) Step 3 throws a ‘Received invalid inputs’ error. I would expect Step 3 to not run at all, if Step 2 doesn’t find any matching records. So I guess the question is, is there conditional logic built into automations that does something like the following: If Step 2 finds record, go to step 3 If Step 2 doesn’t find record, stop. Any help appreciated!

Hey all, In the new automations dashboard, is it possible to add a conditional action - one that only runs if a condition is met. My use case is that I’m trying to create a 2-way sync with a Google calendar. If I create an event in Google Calendar, I want it to first search my base by event ID to see if it already exists. If it does not, then I want it to create a new record. If it does, then I want it to update any fields that have changed in Google. I may be going about this all wrong. Any suggestions? Thanks! Joel

Hi guys I hope some of you scripting geniuses can help me. I have a button In a task list and want to add a button to add a new row in that list under that project instead of clicking the “plus sign” underneath the row. Can someone help me with the script? Sinve I have the button and record picker script we know what row we’re at so to add a row/task shouldn’t be so complicated? But its complicated for me… The script look like this know : // Change this name to use a different table let table = base.getTable(“Tasks”); // Prompt the user to pick a record // If this script is run from a button field, this will use the button’s record instead. let record = await input.recordAsync(‘Select a record to use’, table); if (record) { // Customize this section to handle the selected record // You can use record.getCellValue(“Field name”) to access // cell values from the record output.text(You selected this record: ${record.name}); } else { output.text(‘No record was selected’); } Much appreciate

I’m looking to add “available dates” (pre-defined) into a form for the user to select. Not sure how to go about setting this up. Once the form is submitted, I would like the selected date to fall off the available date list. Also, not sure on how to go about setting this up.

Hello, completely new to Airtable and fairly new on dealing with APIs. I was super excited that I was able to get an API connection to work and successfully pull the data I needed a few weeks ago. Today I went back because I forgot to include two fields in the original pull of the data. I amended my Body JSON query to include these two new fields and when I use the “Open Field Mapping” button in the Data Fetcher app everything actually looks fine (it’s pulling in the new fields). But, when I run the query, I receive the following warning with the yellow exclamation: Can’t update field: invalid field config. Failed schema validation: symbol is not included in the .(type=number).options schema Because I’m fairly new both APIs and Airtable, is someone able to give me a “laymans” explanation of what I can search for to troubleshoot this warning. Interestingly, while I see Airtable successfully pulling in the two new fields (and with the right data populating), when I go to the actu

Hello! I’m trying to edit a script that I already have. To do so, I need to be able to get values from a Link to Another Record. The linked record is on a different table. I’ve been using .getCellValue() for most cases, but it doesn’t seem to be helping me here. Right now, when I run the .getCellValue, it returns an Object, and when I run .getCellValue().values, it outputs “function”. How can I get a specific field off of the linked record?

Hey all! I am trying to set up an automation that will update multiple records using a script. From reading around the forum, I think I’m definitely almost there but need help crossing the finish line. Here’s the breakdown: I have two two tables: one has pieces written by authors, while the other has feedback notes for those pieces. They have a one-to-many relationship: via linked record, several notes can be associated with one story. Each time a new note comes in via submission form, it receives a number via automation. So the first note submitted for a piece has its note # set to “1”, the second to “2”, etc. This is a number field, not multiple select, single select, etc. I’d like to set up another automation that renumbers notes whenever one is flagged for content. So, say that record A has 8 notes linked to it. Note #6 has inappropriate content, so I don’t want it to count towards the tally. I have two of three parts set up. When a note is flagged, it prompts the automation to cha

I have a base I am using for rehearsing a play. I have several tables including a character table, which I linked to the scene table, inputting which characters appear in each scene, finally linking a rehearsal table which has which scenes are being rehearsed on any given day. In the rehearsals table, I am trying to find any characters that will appear in any of the scenes rehearsed that day, without duplicates. I have tried a rollup command and a function command. I have played with ARRAYFLATTEN and ARRAYUNIQUE to no avail. Can anyone help?

We have a funding database that we update regularly for our charity members. On our website is an embedded gallery view that shows all the current opportunities, which incluldes links to the funders external websites - as shown here: Find funding | Community Southwark For our monitoring and record keeping I’d like to know how many users take action to visit those funders - is there any way of tracking this using airtable, or should I be looking at something like bit.ly for individual link tracking? Thanks in advance, Alex

Hi Everyone, I had previously accomplished this in Google Sheets, but since moving to Airtable, I’ve had a bit of trouble replicating it. We’re a dog training company, and want to count the number of packages that each trainer sells in a given month. My table has a column with a date field that contains when the package is sold, a column with the trainer’s name (a linked record to a trainer’s table), and a column if the package has been paid for. Previously in Google Sheets, I used a table that contained the date range for each month (ex. 1/1/22 to 1/31/22). The formula would see if the date the package was sold was between these dates, checked the trainer’s name matches, and if the payment contained the word “Paid”. Would love some help trying to get this working with Airtable :slightly_smiling_face: Thank you

I’m guessing this scenario has already been covered, but I couldn’t find it anywhere. Feel free to point me to the relevant article if so. I’ve got 5 status fields, one for each of 5 teams. When a new project is added, the person adding needs to identify whether or not each team has any tasks to do in association with the project. If so, they pick “Yes”; if not, “No”. Then each team is responsible to update the status in the field from there. I want to create an AutoStatus column that put out the following: “In Progress”: if any of the team statuses is “In Progress” “On Hold”: if any of the team statuses is “On Hold” “Complete”: if all 5 statuses are either “Complete” or “No” (ignore "NA "- I’m taking that one out of the list) “Not Started”: if all 5 statuses are either “Yes” or “Reviewing” This level of complexity in formulas is beyond me at this point, but I’m confident that someone here will know how to do what I’m looking for! This will be an awesome step forward from what we’re

I currently have an IF statement formula nested into a longer SWITCH formula, and am looking for a way to modify it some. Currently it is IF({Total Order Sold Price} < 15, 2.95, IF({Total Order Sold Price}>= 15, {Sold Price} * .2)) I want to first check for data in the {Total Order Sold Price} field. If there is data, I want it to run this set of IF statements. If there is no data, I want it to run the same IF statements, with a slight modification: IF({Sold Price} < 15, 2.95, IF({Sold Price}>= 15, {Sold Price} * .2)) I’ve tried writing it a few different ways, the best I came up with is this: IF({Total Order Sold Price}, IF({Total Order Sold Price} < 15, 2.95, IF({Total Order Sold Price}>=15, {Sold Price} * .2))), IF({Total Order Sold Price}=BLANK(), IF({Sold Price} < 15, 2.95, IF({Sold Price}>=15,{Sold Price} * .2))) Nothing is working so far though. Any help is appreciated

So im having an awful hard time trying to figure this out. I only need the price in “Monto Texto”, im trying very hard to get only the number but for some reason “Monto2 Cut” is not formatting into number. My other guess was that its the comma that makes it unable to treat it as a currency or number, so I created a third column where I deleted the comma and still no luck. Any help is appreciated. I just need to be a number to make some calculations.

I have a date field that imports like this: 2021-09-13 00:00 I need to extract the year and month and day from there … in different columns. Is there an automation for this?

Hi, I’m learning how to use the scripting block, not too successfully. I have tried to adapt the scripting block “select a record” and one from the thread about linked fields from @capt & @JonathanBowen but I can’t seem to get it to work. I am trying to copy the text output by a formula field (EQ3) into the text field Notes using a button. Any help or advice would be much appreciated! Many thanks, Alastair This is what I have so far: // Name of table let table = base.getTable("Requisitions"); // This script is run from a button field & will use the button's record let record = await input.recordAsync('Select a record to use', table); if (record) { // You can use record.getCellValue("Field name") to access let oldValue = record.getCellValue("EQ3"); let newValue = oldValue; output.text(newValue); table.updateRecordAsync(record,{"Notes": newValue}); } else { output.text('No record was selected'); }

Hello everyone! I have an email address column. I want to create a formula column that will search each email domain for a specific text string; if that specific string exists, the formula column will print a pre-determined ID (also as a text/string). To illustrate: If an email address comes from abcd@paypal.com, input “PAYPAL” into the formula column. If an email address comes from zyxw@vrbo.com, input “VRBO.” I’ve tried combinations of Nested IF statements, SEARCH and FIND formulas, etc. but I’m stuck and would appreciate help. Here’s a screenshot showing the end result I’m looking for.

Hello Airtable Community! We have a situation where I am trying to create a “pass” of “fail” grade on wether or not an estimate was submitted by a certain date and time. Our table is structured as follows: There is a field called “24 Hour Deadline for Estimate” that is the deadline we are holding our estimator to as far as his deadline to submit to our customers. There are a few other fields that show the two different estimates and their correspond totals, as well as the roll up of the two types for a grand total. We also have two lookup fields that are filled out when we actually submit each type - “(MIT) Date Submitted (LU” and ““CON” Date Submitted (LU)” are these two fields. When our estimator submits one or the other on another table, he puts in the date. That is what these two fields are looking up. The ultimate goal of the formula that I am stuck on is to grade as “Pass” or “Fail” if we submit both of the estimates before the deadline. This field is named “Grade on 24 Hour Sub

I am able to use the API to obtain URLS for images. I can access those URLs from my browser when logged in. However, my API is unable to access the images when using a GET (I am sending the authorization token header): <?xml version="1.0" encoding="UTF-8"?> <Error><Code>AccessDenied</Code><Message>Access Denied</Message><RequestId>XXXXXXXX</RequestId><HostId>YYYYYYYYYY=</HostId></Error> HTTP/1.1 403 Forbidden Content-Type: application/xml Transfer-Encoding: chunked Connection: keep-alive Date: Fri, 14 Jan 2022 02:36:39 GMT Server: AmazonS3 Content-Security-Policy: default-src 'none'; style-src 'unsafe-inline'; img-src https://*/favicon.ico; sandbox Access-Control-Allow-Origin: * X-Robots-Tag: none X-Xss-Protection: 1; mode=block X-Content-Type-Options: nosniff Referrer-Policy: no-referrer X-Cache: Error from cloudfront Via: 1.1 61e47cd082bb04a8fb8ae61dd54f6b32.cloudfront.net (CloudFront) X-Amz-Cf-Pop: SFO5-P1 X-Amz-Cf

Hello! I’m working with a client that currently uses an Airtable Form to collect data from applicants to a job posting. All fields are required in the form. We are receiving form submissions that have the email field or other fields completely empty. What is causing this? Does this happen when forms are refreshed or a tab is closed in a browser? I’m really not sure. I’m thinking it may be best for the client to use a third-party form, but I’m perplexed by this issue of empty required fields. Thanks for your help!