Solved

Hi, I’ve just started using Airtable. Here’s a list of what I have done and trying to do Imported a CSV of my credit card transactions and added a new column called category. Want to automatically fill in the category column with “KFC” when the transaction description contains the word KFC. Made an automation. See picture for settings I used: Now I have turned the automation on but it will not auto fill for category field for all the existing transactions I already imported from my CSV file. It only works if I test run it and select a matching transaction from the list that comes up. How to fix?

I’m trying to delete a record if my function fails to find a match with the query. //The Record ID I want to find a match for in the sourceTable let recordIDsource = inputConfig.recordIDsource // Find records in sourceTable let query = await sourceTable.selectRecordsAsync({fields: ["Record ID"]}); //Select the records from the query with matching Record ID's let recordTOupdate = query.getRecord(recordIDsource); If there is a matching ID this works great and gives me the record ID of the record containing my matching “Record ID” in a field. (I know, confusing) The problem is when there is not a matching “Record ID”, rather then giving me a value of null or undefined or 0. I launches an ERROR and breaks my script. What I want to do is, if there are no matching record ID’s, I want to delete theRecord that triggered the automation in the first place. if ( query.getRecord(recordIDsource) === Error ) { await table.deleteRecordAsync(theRecord); } I know that code above "

Hi all, I’m using Rollup to find the latest date in a custom CRM. The Max(values) approach always works fine, but in this instance I cannot select “date” as an option under the format menu in Rollup. Any ideas? Many thanks in advance! Cheers, M

I have an app that requires users to add a user token, which it validates against the Gumroad API. But I’m seeing this error. Airtable has a document that introduces the new security policy New: tighter security and network access option for marketplace apps, but it doesn’t actually say how to make sure your app supports the new policy. Is it as simple as setting the Content Security Policy header to include https://api.gumroad.com/v2/licenses/verify?

Inside Airtable (Pro Plan), I click on Help > Message Support. There is no form that pops up, but a blue square with an x pops up. I can click it and it disappears. In Chrome, I do not have pop ups blocked. Is there another way to message support? Thanks in advance.

I have a field that contains either a single date, or a list of dates separated by comma. 2022-08-21 2023-05-01, 2023-06-01 I want to create two formulas: One that extracts the first date and compare it to another One that extracts the second date and compare it to another To do so, I first need to extract the date, and that’s where I’m stuck at the moment. I tried IF( REGEX_MATCH(dates & '', '^(\\d{4}-)(\\d{2}-)(\\d{2})'), REGEX_EXTRACT(dates & '', '^(\\d{4}-)(\\d{2}-)(\\d{2})'), BLANK() ) But I don’t get the expected result: 2023-05-01, 2023-06-01 > returns 2023- (expected 2023-05-01) I used Regex101 which made me assume this would work fine, I also checked on the forum and tried many variations but I don’t get it.

CountryTable.updateRecordAsync(recordId, { "id": 123, "Country (dropdown)": { name: "USA" }, }) This is throwing an error, Error: Field "xadlxpdzw" cannot accept the provided value. Country (dropdown) is a Multiple Select Field.

Hello, I was wondering if there is a way to split a single pdf into multiple pages using Airtable. For example, if I add a 20 page pdf to Airtable, is there a way to have 20 rows of single page documents in Airtable automatically without uploading them separately? Any assistance would be greatly appreciated. Thanks!

I’ve been searching for a solution and it seems like a simple issue but I cannot get it resolved. I am desperately seeking some help! When I scan a UPC barcode, the 12 digits appear in my barcode field. I want my table to automatically populate in another field the product that is associated with that barcode. We use barcodes internally for inventory management so none of them are registered. So, essentially, I just want AirTable to know that X series of 12 digits is X product. I tried using automations as my solution but that doesn’t work because I can only have 50 automations in my Pro plan and I need this to work on thousands of products. Any help would be hugely appreciated. Thank you!

Hi! Hoping if anyone can give me a few pointers, I wanted to create a unique description to a record when linked with another record in another table. The field in the original table is allowed to link multiple records. So… In Table1 it is a link record to Table2. When the user links a record in Table1 to one of the fields in Table2, I want them to populate some description thats unique to the Table1/Table2 connection. Asking the support I have been told this is not possible, but potentially I could script this somehow, but not sure how to do this? Not looking for the specific script but if anyone can give me an idea as to how to do it, would be very helpful! Thanks

I have a table with dates of vacant shifts (let’s call it “Vacancies”). I have a second table to collect form responses for folks who sign up to fill vacant shifts (“Sign-ups”). T he dates in the Vacancies table are set to the Friendly date format. In the Sign-ups table, there is a linked field to the Vacancies, so when a user completes a form, they can see the vacant shifts and select shifts to cover for… Now here’s the problem: when a user selects the drop-down of available dates, they are in this horrid format and I don’t see anywhere I can change it… Does anyone know how I can get the form to display the friendly date format or a form user? It feels silly that I haven’t found how to change it and, if I can’t, then this form isn’t going to work out to fulfill the function I need it for :frowning:

For example table 1 has columns: Email, FB, LI. (which we can refer as Contact Channels) Applicant 1 has only Email and FB accounts Applicant 2 has Email, FB, and LI accounts In table 2 I wanted to create a contact channel dropdown list. Is it possible to have the list depending only on what’s inputted in table 1? For example, applicant one should only have 2 choices in the dropdown while applicant 2 should have 3. Or is there any way that it will automatically list down the channels instead of the dropdown list once the applicant added fields in Table 1 columns?

Hi guys, first post for me and i’m french native so sorry for spelling mistakes I have a base that shows every forms (one record for one form) and I would like to automaticaly fairly attribute a single select choice to each of these forms when they are submited I have 3 developers and I would like to fairly attribute them a form (ex. I have 90 forms/I would like 30 forms per dev) Here I’m attributing it manually Thanks you guys

Hello! I am trying to achieve the following. I would like to update my stock on button press by adding or removing the value given in the cell. Please help. Thank you very much in advance!!!

Hello, I’m creating a maintenance schedule but I’m having difficulties create a formula that shows me the “due status” based on how many days ago an item was serviced. Individual item have different frequency of service: Monthly, Quarterly, Annually, and so on. I have a single select field that dictate the frequency for each type or maintenance. I was able to create a formula to calculate cost using a base cost * how often we perform it, but I’m having trouble applying it to idea I’m trying to perform. What I’m trying to do is IF an item was serviced today, and its frequency is MONTHLY, It will be “On Time” for 30 days, by the 25th to 29th day it will “Be Due Soon”, On the 30th day it will be “Due today”, and on the 31st or passing the 31st day will be “Overdue”. This is what I kind of have but it’s probably wrong.

Is there a way to format the items in the rollup field to look like this (including brackets on either side): [“Choice1”,“Choice2”,“Choice3”,“Choice4”,“Choice5”] I have this formula but it does not work in a rollup field: '["' & SUBSTITUTE( Choices, ', ', '","' ) & '"]' Then I found this sample code: IF( ARRAYJOIN(values), "- " & ARRAYJOIN(values, "\n- ") ) But I can’t figure out how to combine them without an error. IF( ARRAYUNIQUE(values), '["' & ARRAYUNIQUE(values, ', ', '",") & '"]' ) All these “,”"’’ are making me go cross eyed. Please help me! :rofl:

I have a single select field named “STATUS” and I want to configure a button that would copy a record with all the following attributes and then make that new duplicate record’s STATUS set to “Voucher Re-Issued”. Below is the script I use to duplicate the record, I just not sure where or how to configure the STATUS to “Voucher Re-Issued” let table = base.getTable("Relocation") let query = await table.selectRecordsAsync() let records = query.records let fields = table.fields let exclude = ["UNIT ADDRESS [FULL]", "BR", "UNIT FAILED OUTCOME", "Voucher Expiration Date", "STATUS", "UNIT QUALITIES", "PENDING PO DOCS", "LEASE-UP SELECT", "PENDING DOC/VERIFICATION (TENANT)", "STREET ADDRESS", "CITY", "ZIP CODE", "YEAR", "W9", "Owner Name", "UNIT #", "Lease Up", "Data Entry Complete"] let filteredFields = fields.filter(x => !exclude.includes(x.name) && x.isComputed == false) let original = await input.recordAsync("Original Record", table) let obj = {} filteredFields.map(x =>

Hi guys, I need help because have an issue because with a Gmail > Send email automation… On the technical part it works quite well! However since I’ve been using this Automation, my collaborators are telling me that my emails are received in spams! Internally, that’s not a problem because they added me to their ‘not spam list’ but it is a huge issue as I use them for recontacting my leads and clients… Do you know what I can do ? Thanks in advance!

I have a multi-select field that has a large number of choices. I have decided it would be better to separate them into different categories (fields). Is there a way to do this? I have a master list of choices in a separate table (if that helps). These choices have a name and a description and a category. Is it possible to do something like this: Category 1 Field Look at the main select fields and find all choices. Look at the master choice list and find the choice name that matches the category. Place the choice that matches the field category into the field. I am on a free plan and have no access to paid tools. Example base for explanation purposes: Airtable Example Base - Airtable Explore the "Example Base" base on Airtable.

I signed into a collaborator’s account today and noticed that my personal views can be seen. This is not normal, right? See photo below. I checked my account to see if I could see the collaborator’s personal views on my account and I cannot. Hope this issue can be resolved quickly. Airtable Support Personal views Personal views are a special view configuration type that allows collaborators with creator, editor, or commenter permissions to create views that can only be customized by the view's current owner...

I have an open-access data collection form that my members can fill in. Members are in different organisations with their own email domain. I want to be able to restrict views of the results by domain so that people can only see the responses from others in their organisation - which Airtable lets me do via the restrictions options built in to the view. So I created a View, gave it the name of the company in question and restricted the view by domain. However when somebody is invited to collaborate on the base they just see everything in the table/view and the view itself isn’t restricted by domain - I think the difference between being invited as a full base collaborator (with commenter permissions) and simply having a link to a view without being invited to to the base. I believe I need these members to be collaborators, as opposed to simply being sent a link. If they only had a link to a restricted view they wouldn’t (necessarily) have an Airtable account and the domain-restricted

Hello, I’m relatively new to Airtable, so I have a question if something I’m doing can be improved: I have a base where I am counting the number of checked boxes (so far so good) However, I will create a large number of bases where the task name varies and won’t be a simple Task1 etc. Is there a way to count the no. of checked boxes without referencing the Task1, but something along the lines of referencing the cells (like in excel) This way I can just duplicate the base and change the “task” name for each base as needed, without needing to change the formula all the time. But the formula would work regardless of what the task name is. Thanks!

I have set up and automation to email a client when their job is marked as done, and it is working. However, I just want to make it more intuitive if possible. Currently - When marked as done and there is an email in the ‘client email’ field there is an email generated, in the email I reference job title, notes etc (all pulled from data in the table) I would like - 2 emails set up, email ‘a’ gets sent if there is a url in the url field filled in the job. email ‘b’ gets sent if there is NOT a url in the url field in the job data. Hopefully I am explaining that correctly. So I know how to do the automation, I have one working well, I just want some more detail and not sure how to add the additional conditions, or if I need two automations set up and only the one matching the specific condition would be triggered.

Good morning, I’m discovering the automations, with sending an email when a record matches a defined condition - so far so good. But the little problem (or limit I should say) is that I have multiple tables with many entries, and I’d like to add some details to the email sent: at least the table / base name, and ideally some way to identify the concerned record, with for example the first or second column value. Do you think it’s possible, please ? Thanks in advance for your help, Regards. Nicolas Caplat

Hello, I’m starting on airtable and I can’t find the right formula to perform an operation. I would like to extract the link in the second column IMAGE to insert it at the planned location in the third column JSON. Can someone help me with this ? Thank you :slightly_smiling_face: