Solved

Hi all,I have an automaton where at X time, once a week, records are scanned for any projects that are within the next coming week, the status is to be changed to "Upcoming". I am recieving an error message on the update record part. I have attached a video below for you to see.Does anyone know what the problem is and a solution?Kieran

Title.I am still getting the hang of scripting, Airtable, and scripting for Airtable. Goal of script:User chooses up to two options in multi-select field.Those multi-select options are 1:1 with the names of the records that are being linked. (IDs are included regardless).Link those up to two records from the Signature Hardware Vendor multi-select field into the Vendor(s) linked records field.Ill gladly take hints on updating or fixing my bad code leading up to the portion in question, but I can confirm everything shown below is working BESIDES the linking of two different records.  const { recordId , QASubtype, SHVendor} = input.config(); const table = base.getTable('tblFvUDsFR14aJ8Nu'); if (QASubtype==="Signature Hardware Quick Add"){ await table.updateRecordAsync(recordId,{ "Manufacturer(s)": [{ id: 'recBUCS8K6yzHS1Nd' }] }); if (SHVendor==="Signature_Hardware - 1481"){ await table.updateRecordAsync(recordId,{ "Vendor(s)": [{ id: 'recyW5pRLYxqFIMkt' }]

Hello all!I don't believe this is possible with how automations work with Airtable as I know them, as they seem to be restricted to only automating one table and that one table's records. Regardless, I'm hopeful there's an extension or something that can get around this, as this seems like something that would be extremely useful to most people. I'm going to lay out an example for what I'm trying to do/the parameters around it, rather than trying to explain it with a block of paragraphs.An existing table's records is a list of projects. These projects are labeled as either approved/denied/pending/submitted in this table, and each of the project records were spawned from a submitted form. Once a project is labeled as "approved," it would make my job/my company's job easier if a new table(s) can be spawned, based on pre-saved table templates (though, honestly, I don't even know if it's possible to save a table template). So for example, once a project is labeled "approved," a table label

Hello! Here's my situation.I have a table 'Part List' that is automatically updated with parts from an external base that I do not control. One of the data entries inputted is "version" and "iteration". So I could have the following table:Part #VersionIteration001A1001A2001B1002A1003A1003A2Where the rows in red are the most recent parts (red is only shown here for emphasis, not in airtable). Deleting rows is not an option because I do not control the data source. I want to create a column that will have checkboxes, and it will be checked if it is the most recent iteration.Dedupe does not work because I cannot merge cells that I cannot edit, and I have thousands of entries so that would take too long.I've tried to adapt the Mark Duplicate example but I get the "Api request failed: Request Entity Too Large" error. But also I wouldn't know where to go from there.The closest I've gotten is below where I can mark a checkbox in a "Is Duplicate" column if it is some iteration of a duplicate p

I have a formula that I'm attempting to show "Sold" if tickets to an event have been sold, but if the tickets have not been sold, to display the number of days until the event. I already have another formula that will give me the number of days until the event.Generally, the formula below is working - except for one scenario, when a ticket was sold for $0.00. You may wonder why a ticket would be sold as zero, but that indicates to us that the ticket was given away - as compared to just not used.I've tried to use the presence of a value (my best working version below), and I've also tried to use the =BLANK variable, because if there is no sale at all then the cell has nothing in it, but Airtable seems to treat a value of $0.00 the same as BLANK.So then I tried a variation of this formula with >=0 but then ALL values were returned as true - even values where there's nothing in the cell.Here's what I have for a formula currently:IF({Event Sale Price}, "Sold", {Days till Event})The

Hi all,I have a simple script that is taking some items from the submission of a Gravity Form and updating an AirTable record. It all works great until I get to a section of the form that has checkbox values. INSIDE of one of those checkbox values is a string that contains a commaCheckbox choicesApplesOrangesPearsGrapes, limes and lemonsI can gather all of these out of Gravity Forms and put them in an array and then implode that array to get a comma delimited list, which is what AT wants to absorb that data for checkboxes.$c=Apples, Oranges, Grapes, limes and lemons"records": [{"id": "'.$id.'","fields":{"Committees": "'.$c.'"}}],"typecast":true}';This of course will cause AT to barf when that comes in and tries to split the Grapes out as its own committee and limes and lemons as another committee. I know that in order for AT to treat a Linked Table field items containing commas is to put quotes around it. When I try and quote the incoming data here the update bombs.$c="Apples", "Orange

I'm adding a row in sheets successfully but only 2 of 6 fields are being copied over. What could be the issue? Thanks.

Hi all, I have a two-table base. The first table/screenshot below is for survey responses; each record is an individual survey response. The second table/screenshot is where the responses roll up for each survey. Is there a way within the rollup filed formula to achieve my highlighted desired result? I'm trying to avoid adding multiple rollup fields for each response type and then concatenating all of the information in a new column.    

I am trying to have a formula which give me the possibility to have on the same line two fields separated by a coma. This is tricky, because, i need also to have in the formula that if the field is empty if it not showing the empty space or make a break line.Right now I have this, IF({MARQUES}, " " & {MARQUES} & "\n") &IF({DESIGNER}, " , " & {DESIGNER} & "\n") &IF({DATATION}, "  " & {DATATION} & "\n") &IF({COLLECTION}, " " & {COLLECTION} & "\n") &IF({FABRICATION}, " " & {FABRICATION} & "\n") &IF({PRODUIT}, " " & {PRODUIT} & "\n") &IF({MODELE}, " - " & {MODELE} & "\n") &IF({MATIERES}, " " & {MATIERES} & "\n") &IF({COULEURS}, " " & {COULEURS} & "\n") &IF({DETAIL}, " " & {DETAIL}) &IF({GRIFFES}, " , " & {GRIFFES} & "\n") &IF({PROVENANCE}, " " & {PROVENANCE} & "\n") &IF({TAILLES}, " " & {TAILLES} & "\n") &IF({CONDITION REPORT}, "

https://airtable.com/apprdPguzaBCfjD56/shroyWamJGrG0yeMiIn the sample base above, I have two linked Tables. One is a list of projects, the other is information for a quarterly report. Currently, I am linking the tables to each other manually when updating project start and end dates. For example, if I add a new project scheduled to start today and end 3/1/2024, I'd add a new record with a start date of 11/30/22, the end date of 3/1/24, and then link it to the "2023 Q4" and "2024 Q1" records from the second Table. Projects don't often (if ever) end when planned, so I come back and update the end dates often which means I also have to go back to check the linked Quarter records to make sure they're still accurate. This seems like something that should be easily automatable.I don't necessarily even NEED the Quarter Table. There is no other information about each quarter that I collect. Ultimately, I just need to be able to graph the data points out to count how many projects were in proce

Hi-  I'm a pretty new Airtable user, and have been trying to find solutions via the community posts, but haven't seen anything exactly addressing what I'm attempting to do.I am trying to populate a field with a number of hours to be worked, only if the month for that work falls within a date range.  In Excel, I was able to make this formula work:  =IF(Column's Month<=Completion Date,Average Monthly Software Hours,0)-IF(Start Date>=Column's Month,Average Monthly Software Hours,0)I tried to replicate the formula in Airtable that I successfully did in Excel, but it isn't returning the same values.I've attached a screenshot of the base as well as the formula I tried.  It feels like there's something wrong with how I'm handling the Column's Month formatting, but I can't figure out what...Many thanks in advance!-Robin

I need an automation to remove a linked record from a linked record field, without removing all linked records from that field.For instance, if a student is in enrolled in the courses 'knitting for war, animal husbandry and marriage, ice cream + pies', but drops 'knitting for war', I'd like the automation to leave the field as 'animal husbandry and marriage, ice cream + pies'. I gather from some forum browsing (specifically this thread) that this cannot be done without scripting. The good news is someone posted a script on that thread. Yay!The bad news is that the script looks like hieroglyphs to me. So, my questions:1) Is it even safe to implement a script for someone whose understanding of scripts boils down to 'it's magic, I guess?' Like, do I need to worry about having to debug it if I change some info in my base or similar?2) I assume I'll need to make some basic modifications to the linked script, like updating table names and such. Could somebody point to wha

Hey community, Aundre here. I hope you're all doing well!I found this script on YouTube that works once you're on any table view where applicable. I need to automate it to work without being on a specific view. When I run it from automations, it does not work, I get the error below.The automation I am trying to create is to run whenever a record enters a view. It should run the script which compresses images in the IMAGE column via TinyPNG, and then output them in IMAGE COMPRESSION. However, I find that I have to be on the view itself, click 'run script' for it to work. The automation however is not running from a view standpoint, hence why I believe it's giving an error.After the image has been compressed, I'd like the IMAGE column to clear (delete) the original image, leaving only the compressed one. I've been able to do a simple automation for this by making the action an Update record and leaving the IMAGE field blank. However, I need it to be in one where it will clear the origina

Hi everyone, I am trying to automate an SMS using a basic Twilio script that I found here: Twilio Script This script works when I run it within the script app, even with my changes made to disable to input text. When I run the same code in the automation run script action I get the error code ‘ReferenceError: btoa is not defined’. My code is below: * Twilio send SMS script * * Send a single SMS to a provided telephone number using the Twilio service * * The Airtable "Send SMS" Block (available to customers with a "Pro" account) * is capable of sending many messages in batches based on the contents of the * Airtable Base in which it is installed. * * **Notes on adapting this script.** * * The script prompts for input every time it is run. For some users, one or * more of these values may be the same with every execution. To streamline * their workflow, these users may modify this script by defining the constant * values in the first few lines. The values should be expressed

I am trying to share specific views of my Airtable base, I specifically want users to see the Tables I am sharing collapsed into their groups, as it makes lots more sense for them to be able to drill down. However, despite me collapsing all within the view, my recipients are seeing the tables expanded. This also happened when I tried to share the whole base. How can I ensure recipients of a shared view or base will see the view collapsed by my groups.

Hello!This is my first post, so I hope I'm posting in the right place.I am trying to use Airtable as a production board for my company. When an order comes through Shopify, I have Zapier tell it to upload the information with Line Items, but my team doesn't always know how many items may be in one order to complete it, so I started showing "1 of x" for my guys to know when they view the interface.Is there a way for Airtable to automatically mark a job with the same "Order Number" (as it is grouped right now) to autopopulate the numbers of the line items in a column, even if it just auto-numbers with 1, or 1, 2, 3 etc. then I can reformat the way it looks?Or is there a better way to go about what I'm trying to accomplish? I feel like I'm overcomplicating it.Thank you so much!

We are using two bases to work different steps of a workflow but are having difficulty syncing all the data back to the original record source in “base #1”. “Base #1” has the planning, design request & scheduling executed and “base #2” has the designing, design proofing & final design attachment executed. We have synced a table from base #1 to base #2 but then created new fields to be worked in base #2, how do we update the original record in base #1 to the applicable new fields created in base #2? As a note, we were able to sync all the applicable fields back to base #1 in a new table but that did not fulfill our workflow need as we require the new field data to be included in the original table in base #1. Any ideas on how to build this differently or automate the data to flow full circle? Thank you in advance!

Hi there--I'm trying to setup a three-tiered list in the interface builder. Some of the tiers also leverage linked records. I have enabled click into linked record and even designed the card that should fly out when the record is double clicked, but it is not behaving as expected. Instead, it just reopens (click 1) and closes (click 2) the record when I double click on it. I'm experienced setting up interfaces with openable linked fields in general, but have not worked in the multi-tiered list format before. Does it behave differently here?Thank you 🙂

Hi there, I'm essentially trying to set up two overwrite fields in my formula. So if field 1 is blank, then use the data from field 2, but if field 2 is blank, then use data from field 3.I have the formula for one overwrite which works fine (see below), but I can't seem to work out how to add another condition to it. IF({Company Invoice Contact}, {Company Invoice Contact},Company) I want it to work like;IF Invoice Contact Overwrite is blank then use Company Invoice Contact but IF that is blank, then use Company.  Any help would be much appreciated.

Hi all!I'm out of ideas and I need help. I have an automation which sends an email to a specific staff member (it fetches the email of that staff member in my table) when a date field is updated in a record. When I create a record and update the date field before adding the informations of the staff member, the automation ends up with an error message (which is normal since the email field hasn't been filled yet). Any ideas of how I could do the following by using an automation ? :When a date field is updatedAnd the email field is not emptySend an emailBest! David

Hi AT Community, I'm new to Airtable and ’m trying to create a formula that would display the Monday of the week / "week of" date for a given date. Monday is the start date of the week. I've tried formulas from other posts but when I add the formula to my field, it gives an error.The formulas I've tried are:DATETIME_FORMAT({Date},‘e’)+1,‘days’),‘M/D’))--   CONCATENATE("Week of ", DATETIME_FORMAT(DATEADD({Date},-DATETIME_FORMAT({Date},"e"),"days"),"M/D"))    --DATETIME_FORMAT(IF(WEEKDAY({Date Due})>1,DATEADD({Date Due},-WEEKDAY({Date Due})+1,'days'),IF(WEEKDAY({Date Due})<1,DATEADD({Date Due},-WEEKDAY({Date Due})-6,'days'),{Date Due})),'l')I really just want to get the Monday of the week when the record is created. So if the record was created on, say, January 19, 2023 - the Monday of that week would be January 16, 2023. And the field would display exactly "January 16, 2023."Thank you in advance! 🙏

Hi there.In a field, I have used the formula below: DATETIME_FORMAT({Datum gesprek}, 'DD-MM-YYYY HH:MM')&", "&{Traject begeleider} Weirdly, the outcome makes the time change by a few minutes. I can't figure out why. Setting timezone, or changing other aspect doesn't help.  Could someone give a solution for this? Thank you!

I am working with a subscription table and every row is an entry every time a customer subscribed to an account (It is possible for a customer to have more than 1 account). I have a field for Start Date and End Date, and I want to know the maximum account the customer had at some point, so I am thinking that if I would know which dates overlapped, I can then record it to a different table but is there any formula in airtable  where I can do that? 

I have the followign problem.In a cell I have a list of tags, separated by a comma, i.e.Apple, Banana, GrapeThen I have a control list of allowed tags, that isApple, Banana, StrawberrySo, the formula should eliminate the tags Grape is it is a now allowed tags, and return this resulApple, BananaAny ideas on how to obtain it?Thank you very much in advanceRegards  

I am trying to replicate something that I know I did previously, but cannot find the right options to do it now.I've created an Interface with a page layout that is designed exactly as it needs to be.  (Record Review, but I don't think that matters.)  It is drawing from Table X, with a filter for only records that match Y.I want to duplicate that page exactly, and then change the underlying filter.  So, this page should be identical except that it's drawing from Table X, and filtering for only records that match Z.  (I do not want to add a filtering element that can be toggled by the user of the Interface.)I did this easily about 9 months ago, but cannot figure out how to do it now.  I can duplicate a page, but cannot find where I change anything about the underlying data or filtering.  Anyone know how?  Thanks!