Solved

Hi everybody! Google Docs automation works for me, but lacks some flexibility. For example, I generate meeting notes digest and would like to add a Date when document was generated in a Title of the document. There is a token TIME which allows inserting complete time, but I have no idea how to format it or truncate unneeded time part. Any ideas how to workaround this? Regards, Andrey

Hi - I’m looking to do an if and statement with two dates. If between X and Y date, then label it as “A” else “B”. But I am having trouble with finding the date value equivalent in airtable. In Excel I would do: IF(AND(CELL1>=DATEVALUE(“04/01/2020”), CELL2<=DATEVALUE(“03/31/2021”)),“FY21”, " ") But I can’t find the equivilant of that in airtable. I currently have the following where timestamp = my field IF(AND(Timestamp>=DATETIME_PARSE('04/01/2020'), Timestamp<=DATETIME_PARSE('03/31/2021')),"FY21", "")

Hi everyone! I am trying to create a formula to figure out an individual’s age when they graduated from our program. I have their date of birth and the graduation year.

I’m trying to set up an automation that will send an email reminder at a later date to complete a task. I have set up one column with “Due Date” another as “Today” and a third as “Send”. I have set up the following formula that when “Due Date” = “Today” it should put an “X” in the “Send” column. My automation is set to send the email when the “Send” field is updated with an X in it. Here is the formula: IF({Due Date} = {Today},“X”) It did not work. I also tried: IF(IS_SAME({Due Date},TODAY()),“X”) That didn’t work either. Just to test it, I tried: IF(IS_SAME({Due Date},TODAY()),“X”,“Y”) and then all the columns filled with Y, even the one where the Due Date matched Today. ???

Ok this seems pretty simple, but I just can’t get my head around it. I am new to formulas, so get the basics, but want to move beyond. Fields are - Member, Age, Clearance, Expiry, Valid, Current Member, Needs attention. Basically, if the Valid field is ‘not valid’ and the current member is ‘yes’ then the needs attention should be ‘yes’ However, if the member is not yet 18 then clearance etc is not required. So far I have IF( Age<18,“Not Required”, IF(AND(Age>17, Clearance,Expiry), “Valid”, “Not Valid”)) But I would like it to only be valid if the Expiry is after ‘today’. I really don’t know if I am explaining it well. I have created an example table here to help explain.

Trying to take Object returns from my PHP endpoint and populate the rows of a table - only the first row is being populated (aka cell fields in first row only) - here is my code: // query for every record in "People" let table = base.getTable("SMS"); let view = table.getView("All"); let query = await view.selectRecordsAsync({fields: ["Contact","URL"]}); var json_payload = []; let individual_injection = {}; for (let record of query.records) { let name = record.getCellValueAsString("Contact"); let URL = record.getCellValueAsString("URL"); individual_injection = { 'ID': record.id, 'Name': name, 'URL': URL }; json_payload.push(individual_injection); } console.log(JSON.stringify(json_payload)); let response = await remoteFetchAsync('http://147.182.192.192/speech.php', { method: 'POST', body: JSON.stringify(json_payload), headers: { 'Content-Type': 'application/json', 'Authorization' : 'Basic d2h5d29udHlvdWNvbm5

Hi all, Hoping to get some ideas on the best way to structure my base to achieve the concept below. I work with property development projects, and use one row for each project (as in the first pic below). Some projects will have more than one dwelling built on it. Each dwelling on a site might have different characteristics (ie. number of bedrooms). Therefore also being able to separate each project into individual dwellings would also be helpful. I’ve set up this second pic manually to demonstrate the sort of thing I’m after, but I’m looking for a way of achieving this automatically. Is there a way to achieve this? I don’t mind if it’s all within one table, or kept in a second table. Any solutions are appreciated. Many thanks in advance! Regards, AC

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!