Solved

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 us know how many tasks per day are due.What I would like to do is drive an automation flow in the event that formula field spits out a number that is higher than it was before.  In other words, if we've been at 2 tasks per day but it jumps to 3 tasks per day, I'd want to know that.But I don't see any straightforward way to monitor a formula in this manner.  Anyone have any creative ideas?

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 dynamic depending on the job page ? I don't want to create a new form for each job

I have tried wrapping both fields in VALUE(field), ABS(field), etc. How do I get this to behave? What is the reasoning behind this?

We are setting up a Booking system with Airtable and trying to find a way to hide / disallow our customers from selecting weekends on the Form View. We want to be able to see weekends on our end in the calendar view, but the customer should not be able to select a weekend as a start or end date. Any ideas?

Howdy AT community!Hoping an AT wizard can assist with the below forms automation conundrum:I have a subscription activation request form for a particular subscription product whereby customer organisations/managers can submit up to 10 nominated subscribers.  Form record fields are minimal, just nominated subscriber emails and organisation are required (with subscription product name hidden on the backend). I have set up an automation that creates records in a Product Slices table as submissions are received. However, the automation creates 10 records in the table regardless of nominated subscribers submitted (resulting in a lot of blank records!) Furthermore, the Organisation name does not populate for the first record created for some reason (see attached images). Can anyone advise on a way to tweak the automation to only create records against submitted nominated subscriber emails? 

Hello everyone, Pretty new to Airtable but I am enjoying the platform and the features it offers. Currently I have a table with data for when we last saw specific people. The date is being entered as February 13, 2023 for example and I am converting it to a different format for reporting purposes. I am currently using the formula:DATETIME_FORMAT({Date of Entry},"YYYYMMDD") which outputs the date as 20230213 which is exactly what is needed. The problem is that there are other sections where specific people will not have dates entered so it is returning errors in the table "#ERROR!" How do I make the formula only activate when there is a date entered?

Hi there. Has anyone figured out how to filter records in Interfaces for current week? I want to summarize values for this ongoing week and don't really know how right now. Thanks!

Hey all! Working on making Page Designer work hard to create the thing I need 🙂 A couple of limitations I have run into that I haven't found a workaround for yet:1) Flowthrough to another column. Currently I have this list of information:But I want to be able to run it over 2 columns like this (duplicated the field to illustrate what I want):The information would flow from the bottom of the first column to the top of the second in my perfect world.2) Grouping within the field in Page DesignerI love being able to do this in the regular tables, and this particular list I need to have grouped by Department in the same way:So the table above that I want in 2 columns...I also want sub-grouped by Department. The simple sort by department is ok, but not ideal because I need this form to look like what my film guys are used to seeing. Any thoughts?Thanks!!  

Hi all, I’d appreciate some guidance on how can I change the filenames of my attachments. I have a table with 500 records. Every record has a name and multiple images (attachments). The attachments have identical file names in multiple records, e.g I might have a file called 1.jpg in one record, then a different attachment in a different record with the same name of1.jpg. I managed to find a script that does that, but it changes the name only for one attachment. Ideally, would be to create a rule that adds to the current filename, the name from another field. e.g: Gorge 1 + current filename.jpg // Setup const mainTable = base.getTable("Test") const mainQuery = await mainTable.selectRecordsAsync() // Build new attachment data let updates = [] for (let record of mainQuery.records) { let attachments = record.getCellValue("images") if (attachments.length) { updates.push({ id: record.id, fields: { "images": [{

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 seeing that some of the end dates are on weekends even though there is a work day formula in the end date column. Any insight? Also including a screenshot of the dependency roll up. Thank you!

Hello friends, I’ve had an automation running correctly in the past. Today, I’m getting the following error" The Automation is simple: When Condition is Met > Send Gmail Email. I tried reconnecting my Gmail Account, but problem still isn’t solved. Clicking on Learn how to fix common issues doesn’t provide a solution. My assumption is that this is an external error to Airtable, but I haven’t changed a thing in Gmail to possibly cause an error to this automation. Any suggestions? Solutions? Thanks

I am building an automated script that fetches two properties from an external API and subsequently upserts those data points into distinct fields in Airtable. The input is a URL field in the relevant record, and entering a URL in the field triggers the script.So far, I've put together a getData() function that retrieves the data from the external API and stores it as two variables: name and owner.I'm stuck as to how I actually populate the fields. In basic terms, I want to populate the "Name" field in Airtable with name and the "Owner" field in Airtable with owner.I've found the following snippets that may be the key, but I would appreciate some guidance:  let table = base.getTable("Records list"); let record = await input.recordAsync("Converting record", table); and base('Records list').update([...]); I can't find a learning resource for understanding the .recordAsync() method nor for the base.update() syntax. Is either of these what I'm looking for? Furtherm

Hi all,Wanted to see if anyone had any ideas why the following isn't working.BackgroundI have a table of issues each with a specific codeI also have a table that takes form submissions for the yes/no output of questions in the form.When the a question is answered "yes" I want to create a link in a lookup field to the issues table to record the specific issue found.IssueUpon the form submission the automation I have set up only works for the first question. After the first question none of the other questions answered yes are linking to the specific record.Any ideas why this is?

I have a long text field where I copy source material. I have seen mentiononed ways to extract URLs with REGEX when they are written out in a text field, but occationaly links are copied in hyperlink form. Is there a way to extract the URL from the hyperlink?Ideally I would need a formula that can extract both hyperlink URLs and written URLs. If there is a way to only extract links from one, specified, domain as well, then that would be the ultimate cherry on top. 

Is it just me or is this the worst placed delete button ever? That's where the close button goes, guys... Good job there's an undo feature! 

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 automation to populate the 'B' fields (as a % of the 'A' fields), when the % field is updated. The reason I would like to do this as an automation rather than formula is that I would like the B fields to be editable to allow for bespoke amounts. Usually, the % will be the same for all B fields (there are around 10), but not always. Therefore, if I enter 10% in the % field, the numbers will populate as follows:'B' columns as % of 'A' columns: 10%Field 1A: 100Field 1B: 10Field 2A: 250Field 2B: 25Field 3A: 500Field 3B: 50The only way I can think to do this would be to have a formula field for each one that sums the % by the 'A' field, then a manual override field, then an if formula that says "if({override field}="",{sum field},{override f

I'm afraid I don't love the new lefthand sidebar menu which is due to be rolled out next week. It takes up valuable space which would be better used for interface elements and data. The reduction in available space means that we'd need to redesign some interfaces, as data and field names are now truncated and don't display correctly.Perhaps it could be adjusted so the sidebar rolls out when the user hovers over the far left of the screen, or similar?

Hello,We are creating an interface that is filtered by collaborator is current user. But collaborators can be of 2 kinds (from a simple select: commercial and analyst).  And both fields have to appear in the record in the interface. So that a Commercial collaborator knows who is the analyst assigned to this process, and vice versa. And also, so that in the collaborator field only a Commercial collaborator can be chosen for that field, and only an Analyst can be chosen for the other field.We have tried to use linked fields to a different table with User, Type of user (commercial, analyst). And then we do get the right people in the right role... but of course, then you don't get the current user filter in the interface.Looking around and with many tries, we have found no way to do this.How would we be able to do this?

Hello Airtable community!I have created a Jira integration with Airtable. There is a field for Sprint, however, if a ticket was included in more than one sprints, all sprints appears seperated by commas. I want to extract only the sprint that is the highest number. I tried doing this by taking the last one (with the RIGHT() function) but unfortunately the string is not always alpahbetically sorted within the cell. Please see below:Essentialy, I'm trying to find a way to extract the highest sprint. Any ideas how to either sort alphabetically within the cell or how to extract the highest using a formula? Many thanks!

Hi. I am using the Find Records action to return what is frequently a more than 1 item long list of results.I understand that the results are returned in an array, so when I try and append the results to a Google Sheet, they will all be listed in the same Sheet row.Has someone figured out a way to create a new row for every record in the array? Or is there some completely different way of doing this?Thanks!

Howdy, I am trying to append my airtable records to a google sheet at regular intervals, including my last modified column. How can I get it to append the actual value, and not just the character length of the value. I’m getting results like 29, 30, 29, 29… for my rows instead of 8/18/2021 10:27:31 or whatever

Hey guys im really dumb in Excel, I need some help. First column is the item, then next one I have records for each, that is the stock. I’m struggling for an hour to find a formula which COUNTS how many rows are there, therefore I have the exact numbers of the rows, which is the stock for each item. Thanks!

I need to be able to interface general information, name, email address, title, phone number, to external clients so that they can edit the data and the changes are also automatically made on our end, on our base. 

Hi! How do I individually concatenate fields if one of the fields is comma-separated? For example, I want to take “red, blue” and concatenate this with “shoe” to come up with ““red shoe”,“blue shoe”” with the quotation marks instead of “red, blue shoe”. Any ideas? Thank you in advance!

Hello,I would like a formula to convert date fild  into quarter and  add display it in full text.Exemple:Dates between 01/01/23 to 31/03/23  will display " first quarter"Dates between 01/04/23 to 31/07/23  will display " second quarter"and so on...Thanks for your precious help. Remy