Solved

How would you go about configuring a field so that you can create a dropdown list of years inside of a form? Is it possible for it to dynamically update with the {current year} + {10 subsequent years}? For example, the form field might read something like: 2021 2022 2023 2024 2025 etc…

I have a table with a multiselect field for stages: Submitted, Reviewed, Approved, Completed. I would like to track the date of each stage change in separate fields. So Date Submitted, Date Reviewed, Date Approved, Date Completed. I am using this formula to populate those fields… IF({Stage}=“Reviewed”, LAST_MODIFIED_TIME({Stage})) The problem I am now running into is keeping those date entries even as the stages changes. So when the multiselect is changed from Reviewed to Approved, I would like both the Reviewed Dates and Approved Dates to remain. With the above formula, only the date of the current stage remains. Please help! Thank you!\ -Vicki

Hello, I am trying to substitute all the occurrences of ", " (comma, space) in a Lookup field with “%20” and place that into the formula field.

Hey! I know you can rearrange the options in the multiple select FIELD. But I need to somehow organize the actual records with selected options. Take a look at the example: You see, it’s a mess! And my actual table has even more different options - it’s not feasible to do this by hand. I would love to find a way to have them all in order. Thanks!

This is so dumb but driving me crazy-- how do I just grab and drop a section to move it??? It doesn’t seem to work like in excel. Thank you!

Hi all I’m trying to update records in a table using vanilla javascript (because I’m building a Bookmarklet, so curl or node won’t work). I’m stuck on a user error “Unprocessable Entity” and the response is of type “cors”, so perhaps there is something wrong with my request headers? fetch("https://api.airtable.com/v0/appfiPFiZHqEAsjAJ/Table%201", { method: "patch", headers: { "Authorization": "Bearer MY_KEY", "Content-type": "application/json", "accept": "application/json" }, body: { "records": [ { "id": "recSKCdIGgAGRUc5c", "fields": { "Field One": "Bla", "Field Two": "BlaBla", "Field Three": "Blubb", } } ] } }) This returns: Any pointers would be much appreciated.

Hi community, I noticed toward the end of last week that some of my go-to apps aren’t working within my Airtable bases. I recognize today that the issue is related to using the Firefox browser, which has never been a problem before. (Using Chrome, all is well.) Anyone else experiencing this? My browser is updated and I hope this is a temporary bug. Ex1) I can submit text in the search app, but no results are generated. I have the ability to change the view being searched, but it makes no difference. Ex2) The map app is nearly unresponsive. When I expand to full screen I can see the settings, but it doesn’t make any difference if I modify the fields. In each case, the formatting within the app is wonky, too. I’ve included two screenshots to demonstrate. Anyone have any thoughts?? Leads? --Thanks for any insights!

Hello, Not sure how to phrase this-How do I lock across several fields then sort alphabetically by the first field? I want all the information organized by name in the first column but don’t want to lose all the websites in other columns. Thank you!

Hi there, I am looking to use the Button run script field in Airtable to send specific data from my table into Zapier. Does anyone have a template script they can share? This is what I have so far. let url = "https://hooks.zapier.com/hooks/catch/TKID?recordID=?name=?"; let table = base.getTable("Table 1"); let view = table.getView("Grid view"); let record = await input.recordAsync("Pick a record", view); let name = record.getCellValueAsString("Name") let email = record.getCellValueAsString ("Email") await fetch(url + record.id + "%name=" + name + "%email=" + email); My understanding is the steps are: Create Button field Add in script that posts to Zapier webhook Catch data from Airtable Run rest of the Zap Just looking for help on the Airtable script side. Thank you.

Hello all! I’m new to Airtable and need your help. I’m using two tables with responses from Typeform. Both tables have similar fields, the difference being only the language. So I have Table 1 [english] and Table 2 [Portuguese] populate with similar information. My problem is: I need to populate a third table with both Table 1 and Table 2 data combined. I’m using Zapier to combine the responses for Typefome and send it to Airtable, but Zapier seems pretty unstable, so I’m looking for a way to populate directly from Typerform. Someone know if it’s possible?

Hi, I’m trying to get familiar with the SWITCH formula by taking a shot at using it instead of a nested IF but can’t seem to figure out the following. I have a field called “Expiry Date” (type Date) and another field called “Expired?”, which is a formula field where I’m trying to use the SWITCH formula. My goal is that the “Expired?” field formula should output “Expired” if the “Expiry Date” is lesser than TODAY(); it should output “Expires today” if the “Expiry Date” equal to TODAY(); and should output “Still Active” if the "Expiry Date is greater than TODAY(). The formula I’m using is SWITCH({Expiry Date},<TODAY(),"Expired",=TODAY(),"Expires Today", >TODAY()"Still Active","N/A") I’m definitely doing something wrong because I’m getting a formula error. Can somebody please help me with this. Thanks, Sean

Hi all, maybe a stupid question but I’m confused about how to format my automated mail. What my Airtable looks like: What my Mail looks like: What should i do that both look the same way?

Hi all, I’m looking to display the result of a formula as a read-only check box. The result of the formula is always a 0 or 1. Here is the formula: IF(AND(OR({Meal Plan Shopping List Recipe}, {Non Meal Plan Shopping List}), NOT({In Pantry})), 1, 0) Adding a screenshot for reference. I’d love it if the 1/0 column could show a checkbox if 1 and nothing if 0, like the other columns. Thanks in advance!

Hi community, I see that the API has a limitation (5 requests per second). We are facing some issues with our API calls and suspect that the limitation of the API is causing the issues. We are using Zapier, AirTable automations and some other API calls via our own platform. Is there an overview where we can see if we (often) reach the API limits and which call is responsible for that? Such an overview would be very helpful in understanding how we burden the system. Thanks in advance for your help

Hello Community, I am having an issue with an automation and would love some guidance. The automation is intended as follows (w/ pics below). Trigger: When Production Status field IS “Scheduled” AND Review Status field IS “Approved” AND Publish Date field (actually called Archived Publish Date in my table) IS “before today” Action: Update records’ Production Status to “Live” I can see that the tests are working, and the automation triggers when I add a new record meeting the above conditions, but when I run the automation, nothing changes to my existing records meeting those conditions. I was really hoping that it would update all pre-existing “Scheduled” records to “Live” to save time on data entry.

I have a table with a multiselect field for stages: Submitted, Reviewed, Approved, Completed. I would like to track the date of each stage change in separate fields. So Date Submitted, Date Reviewed, Date Approved, Date Completed. I used the Last Modified Date field type, but it overwrites each time the stage is changed and that does not work for our needs. Any suggestions? Thank you!

I’ve scoured the message boards and cannot find a workaround for this. I have a formula to calculate a Due Date in a formula field; however, the filtering options for the formula field is quite unhelpful. I would love the option to filter for due dates within a week from now (etc) but the only options I have are “contains” and “empty” - which prevents me from creating filtered lists of Tasks that need to be done soon. The best I can do is sort the entire list - which isn’t nearly as helpful. Anyone have a workaround or idea here (I would like to keep the formula as is - it tracks when items need to be done based on a final date)? I could copy and paste all the values into a date field, but that extra step might be unnecessary (hopefully)? Here’s the formula I’m using if helpful: DATETIME_FORMAT(DATEADD({Event Date},({Days Before Event}*-1), ‘days’),“M/D/YYYY”)

Hello, I’m pulling my hair out… I have the following formula: REGEX_MATCH({Products},"Personal") {Products} is a ‘A Name’ column and the above formula produces a 0 if “Personal” is not present in the column’s field and a 1 if “Personal” is present in the column’s field. Using the same formula on a different table: REGEX_MATCH({Products},"Personal") {Products} is a ‘Lookup’ column and the above formula produces a 0 if field is blank and a #ERROR! if not blank. The only difference between the two scenarios is the top formula is checking a ‘A Name’ column and the bottom formula is checking a ‘Lookup’ column. What am I missing? Why am I getting an #ERROR!?

Is there a formula I can use to replace, say, " with " ? I find myself often having to go in and do this manually. Thanks in advance for your suggestions! :slightly_smiling_face:

Hello! I cannot figure this out, would be grateful for any help. I embed a view on our website and I want to include a button that will send an email to the collaborator named on the record. However, I can’t seem to get the URL to incorporate the collaborators email address. When I use the ‘owner/collaborater’ field in the URL it won’t save. I then added a new field (consultant contact) with the collaborators email and used that field in the URL code, but the email it creates uses the name of the field (i.e. consultant contact) in the “to:” section instead of the actual information included in that field, i.e. the email address. It’s entirely possible I have the script wrong, but I’ve studied and studied the examples I could find and i’m at a brick wall now. It’s probably worth noting I don’t really have any idea how to write code or scripts of any kind and the fact I’ve gotten this far is a miracle. I’d love to cross the line though! My ideal scenario would be to be able to refere

Hi! I’m trying to create in the same base a master table (that could later help me to create a dashboard by apps) with tables that are synced from other bases in the same base. For the purpose of giving you a bit of context, 3 teams have their own base where they list their projects, start-end dates, etc. that I compile on my own table by syncing them. So I want to aggregate that information that I can see from each team in one table avoiding copy-paste the data. Does somebody have any clue on how to do this? Thanks in advance

Hi everyone I’m relying on using the TODAY() formula to mark fields true or false if a date = today. The trouble is, the formula is not working as I expect. Although I can clearly see the date is today, the formula shows FALSE, and if I change the date to yesterday, it becomes TRUE. I am based in Asia, so I expect there is a conflict of timezones somewhere? Does anyone know how I can correct this? Thanks

New to airtable and a novice to formulas, so please ignore my ignorance. I am trying to come up with a formula to apply a fee based on the difference in days between two fields. I have been unable to get it to work. I think I can just create a chart and calculate fee based on results, but I am trying to avoid that. Basically i an trying variations of IF(DATETIME_DIFF({Cancellation Date},{Order Date},‘day’)=1,50,DATETIME_DIFF{Cancellation Date},{Order Date},‘day’)=2,75,)etc… No mater what I try, I can get the first part of the formula to work, displaying the first result. I cant figure out how to continue the formula! I need to end up grouping 1-2,3-5,>5. ANY help would be appreciated as I am going nuts!

Hello community, I’m as stuck as that cargo ship in Suez, if you know what I mean :ship: I have a table T1 linked to a table T2: T1 → (link field:‘T2records’) → T2 I need to delete all linked records in T2 at once, using the link field on T1. I’m trying something like this: let linkedT2records = T1record.getCellValue('T2records'); let T2recordsIds = linkedT2records.map(T2record => { return { id: T2record.id }; }) await T2.deleteRecordsAsync(T2recordsIds); Script checker flags the parameter in the delete command and pops up: Argument of type '{ id: string; }[]' is not assignable to parameter of type '(string | T2Table_Record)[]'. And if executed, it halts there throwing: TypeError: Invalid arguments passed to table.deleteRecordsAsync(recordsOrRecordIds): • recordsOrRecordIds[0] should be a Record, not an object or recordsOrRecordIds[0] should be a string, not an object The syntax definition for deleteRecordsAsync reads: async function (recordsOrRecordIds: Array<Recor

Hi there, I am trying to use the Matrix app, but I can only see the matrix when it’s fullscreen. No matter how wide I make it, it isn’t showing up. Anyone have any ideas on how to view without making it fullscreen?