Solved

hello. is there a way to import outlook email attachments directly in Airtable? I have an automation set-up to import the data (e.g. subject, body) from the email, but have been unable to get attachments to come in as well. appreciate any insights.

Hi everyone! As a preface, I’m not a coder and this is new waters for me - but willing and capable to learn! What I’m trying to accomplish: I want to use Airtable as a database to store all my products which will each have their own unique PDF {which I’ll upload to Airtable} and then link said PDF to a QR Code. I’ll print these QR Codes and the expectation is that should a 3rd party {not a contributor} scan the code it links to the PDF in the database. So, I set up the QR app and generate a code pointing to the PDF, when scanned I either get directed to the Appstore to download Airtable, or once I pointed it differently it returned a “[Object object]” string value. In short - I’m against a wall and can’t seem to figure it out! Do I need a unique script or setup from Zapier? Or am I missing something?

Hello, I would like to have some info that is not officially provided by Airtable. I am using airtable to manage a database, which I export to a CSV file. I then use this CSV file as a database for a REST API in this way I am not limited by the maximum 5 requests per seconds imposed by the Airtable API. Where I am wondering is about the files uploaded via Airtable, in my CSV I see that the files are uploaded at this address: https://dl.airtable.com/.attachmentThumbnails/xxxxxxxxxxx If I have a mobile app with 1,000,000 active users viewing the image uploader through Airtable, do I face any limitations or blockages?

Hi, Thanks for your time. I’m looking for some help with a form that allows facilitators to sign up for training sessions. These sessions happen every week and require multiple facilitators. I’m asking for their help, so I want them to have to do them minimum amount of form-filling possible. My ideal situation is: A form in which facilitators can select their name from a drop down list (that bit is fine) A form which lets them select which sessions they are able to attend (this bit is where I’m having issues) And a backend system in which I can see which facilitators are attending a session easily. I’ve been experimenting with three potential situations The facilitator chooses the date from a date field on the form :grinning: Upsides: I know it works :cry: Downsides: They might choose the wrong date, and they also have to submit multiple forms in order to share their availability with me A linked table with the specific dates already input :grinning: Upsides: No danger of faci

Hello fellow airtablers… So, im new to airtable, and i want to set up a base for tracking goods in our warehouse… So I made a row called “total in stock” and now i wonder if its possible to set up another row, that will subtract the number entered, from the “total in stock” row? The number entered here, would preferably dissapear afterwards, so that if someone else picks up from the same item, they can also put in the ammount, and it would get subtracted from the total… Hope I explained this understandable, and that someone is able to help. Have a good day everyone

I’m trying to create a simple automation where a slack message is sent when updates are made to a specific record and I get the error “Message could not be converted to a string”. I’m not sure what I’m doing wrong here but I went over the trigger and the message itself but nothing seems to help my cause. For some added context: There is an automation setup already (which works without any issues) that sends a slack message when the record is no longer empty. I am attempting to set an automation that sends a different message when the same record is updated with new values. These fields are synced from an external table within the same workspace. Not sure if this is too many complications or if there is a way to work around it!

Hi there, I’m using this script by @Justin_Barrett to batch duplicate some records: This is what it looks like:: let table = base.getTable("TaskLog"); let query = await table.selectRecordsAsync() let checked = query.records.filter(record => {return record.getCellValue("Copy") === true}) // Make new records based on those that were checked let newRecords = [] for (let record of checked) { let newRecord = {fields: {}} for (let field of table.fields) { // @ts-ignore if (field.isComputed || field.name === "Copy") continue let value = record.getCellValue(field.name) if (value === record.name) value += "" newRecord.fields[field.name] = value } newRecords.push(newRecord) } while (newRecords.length > 0) { await table.createRecordsAsync(newRecords.slice(0, 50)) newRecords = newRecords.slice(50) } My question is: How should I edit this script so that after the new duplicate records are create

I’m reposting this request because my original was closed 15 days after a single reply by a Mac user who suggested a solution that is Mac specific (thanks for the suggestion, though) that didn’t translate to Windows because as speculated, it maps to the Switch Applications hot key combination (). So let’s try this again and hope that some with Windows experience replies within 15 days. I’m on Chrome (latest) on Windows 10 (21H1). I cannot find a key combination that will move the cursor out of a Long Text field. The usual suspects including Esc, “Tab” in various combinations with Alt, Shift and Ctrl don’t do it! I hate having to take my hands off the keyboard to use the mouse just to move to the next cell and then try to find the “home row” on my keyboard accurately with barely perceptible index finger markers. Thanks in advance, /Gerard

I’m looping over some records and want to increment ‘i’ ONLY if both conditions below are met: let i = 0; for (let record of taskRecords.records) { if(id.includes(record.getCellValue('ID Lookup')) && record.getCellValue('Stage').includes(stage)) { i++; } } console.log(i); My problem is the second condition. The cell value of the field ‘Stage’ is “This is just some dummy text | this is a string” and it’s searching for “this is a string” (this is called ‘stage’ and is a string from a previous step in an automation). i remains 0 in this case. Can anyone explain why includes doesn’t work on the second condition? Thanks!

Hi, (TL;DR "it triggered on all new records, no matter if conditions are met, when they include formula field) I have following issue: table1 (near 1500 records) has button field “Confirm match”. when a key pressed, the record partly copied to table2 (by my script, ~500 records), linked to it’s “parent” in table1 table2 contains formula field “Control”, relying on some data including lookup from linked record in table1, result is “OK” or “_error” “_error” records supposed to be removed, from time to time. I can’t filter at this step, because sometimes “OK” record in table2 may become “_error” after table1 update. it’s usual process, and it worked as expected. Now I decided to automate cleanup for table2 and setup new automation “When record matches condition”, second step is Remove record, where Control contains “error” (by way, I was surprised that Remove action is not available, i did that by scripting) The problem is that trigger works on records, which supposed to be “OK”, while my

I am using the switch formula to have Airtable populate a numerical value into a cell based upon the input chosen from a multiple select option. Prior to this I was typing the amounts in and it was working properly. Now I have set up the switch to populate the cell and it works and puts the correct number into the cell that the formula was pulling data from, But now I receive an error message in the end cells. Why is this? The cell the formula was pulling from previous has the same numerical values showing in the cells, it is just being generated by the switch formula instead of me inputting it into the cell. Thank you for any guidance.

Hey folks, I’m trying to calculate the number of days someone has worked in a job. I’m familiar with the DATETIME_DIFF() function, which works great when you have a Start Date and an End Date, but what if you don’t have an end date? In other words, imagine that someone is currently in their position, therefore the field registering their end date is empty. The theoretical solution I came up with is creating another field with the formula TODAY(), and then, if the field for end date is empty, use the field for today to calculate the difference between today and the start date, and calculate the time that the person has worked. I’m having trouble with the syntax! Any thoughts be greatly appreciated.

I have slowly been developing a custom app that interfaces with several external APIs that supply additional data to airtable entries. I started out with the utility as an automation script - here I was able to use remoteFetchAsync() to avoid any CORS issues with my fetch calls. However, since moving to the custom app and React, I am having to go through the proxy at https://cors-anywhere.herokuapp.com/ to run my API calls (and avoid the CORS preflight errors). The issue is the proxy is only for development - I would like to either duplicate what it does myself or find a similar service that does the same thing. I am relatively new to JS and web development, so I am looking for a well documented solution that would be easy to implement in a few hours. Does anyone have any hints on where to look? Since Airtable has the server fetch functionality built in for scripts, is it also possible to use it in custom apps?

Hi there! I’m trying to do a fairly simple formula but it has quite a lot of conditions. I’m a beginner and not sure where I’m going wrong, could someone help? The board is a basic project overview. I’m trying to set a column to display “on track” or “overdue” depending on what the due date and status of the item is. My current formula is written like so: IF( AND(IS_BEFORE(Due,TODAY(), IF( OR( Status = “In Progress”, Status = “With Client”, Status = “Not yet started”, ), “Overdue!”, “On track” ))) Any help would be greatly appreciated! Meri

Hello! I’m trying to create an automation on Zapier or Airtable: Table 1 View 1 : All my Candidate Onboarded Table 2 View 3 : Job description Published I’d like to create an automation when a job description is published (table 2), send an email to the candidate who matches with “Expertise 1” or “Expertise 2” or “Expertise 3” of the Job description (table 2) is the same as “Expertise 1”(main expertise) or “Expertise 2” or “Expertise 3” of the candidate (table 1). Thanks

This is probably really simple - can someone please help with a formula… What I am trying to achieve: remove space after comma in a string Example of existing string: Kim Jones, Ted Jones, Fred Jones, Sam Jones What I am after is a formula to convert the above to: Kim Jones,Ted Jones,Fred Jones,Sam Jones I have up to 11 names in my string - any advice is greatly appreciated.

Hello, I’m trying to create a formula that returns a workday date after 4 days are added. How do I adjust the field that is feeding the data, and the formula itself to always return a date that is on a weekday? It returns an “#ERROR” every time I try one of the formulas below. DATEADD({Process Vetting Start Date},4,‘days’)) DATEADD(WORKDAY({Process Vetting Start Date},4,‘days’)) WORKDAY(DATEADD({Process Vetting Start Date},4,‘days’)) Thanks in advance

Hi. I would appreciate help with the following: I have the fields Country (required field), Region and Title. I need to concatenate these fields in different ways depending on which fields are filled. -If just Region is filled then Region, Country -If just Title is filled then Country- ‘Title’ -If both Region and Title are filled then Region, Country- ‘Title’ -If neither are filled then Country Thank you in advance for any help. Katy

Hi everyone, I have one “Status” column with different status; I want for each status to be linked to another status, slightly different in another column called “Client Status”. To do so, I wanted to use a Switch formula: for a status A, there will be a status A’ linked, as shown in image attached. I wrote this formula: SWITCH({Statut} ,“ :mailbox: Contact entrant - à traiter”,“ :white_check_mark: En attente de validation”,“ :arrows_counterclockwise: Offre en cours de traitement”,“ :1234: Offre validée → n° d’acquisition à créer (CAP18)”,“ :truck: Collecte à effectuer”,“ :date: Offre validée → collecte à planifier”,“ :truck: Collecte à effectuer”,“ :truck: Collecte planifiée → à effectuer”,“ :truck: Collecte à effectuer”,“ :computer: Collecte effectuée → prestations à faire”,“ :computer: Prestations en cours de réalisation”,“ :email: Prestations effectuées → livrables à envoyer”,“ :computer: Prestations en cours de réalisation”,“ :ok: Livrables envoyés → vérifier montan

I was wondering if it’s possible to add multiple filters in the Airtable API URL - I have figured out the way for one filter, but I am struggling to apply multiple filters. Here’s the URL I made, which has a single filter applied : api.airtable.com/v0/<BASE_ID>/<TABLE_NAME>?api_key=<API_KEY>&filterByFormula={City}="MUMBAI" The above URL works perfectly, but if I try to add another filter (using &), it shows errors. I am looking for a way to add these 3 filters : {City} = “MUMBAI” (field type = single line text) {Age} > 25 (field type = number) {Calculation} = “Ok” (field type = formula, result would be either “Ok” or “NA”) What is the recommended/correct way to add multiple filters? Your guidance would be very appreciated. Thanks!

I’m having trouble getting DATETIME_FORMAT to work, and I can’t figure out what I’m missing. My date field is in local time. I wanted to get week numbers from the date, which I have working fine, but it is seeing dates in UTC I think, and DATETIME_FORMAT did not work. Formula: DATETIME_FORMAT(SET_TIMEZONE(Date,'America/Los Angeles'),'MM/DD/YYYY') Referencing the red box you can see two entries with incorrect format. I’m a little stumped.

Hello- I’d like to create a formula that allows me to track expiration dates status (three possibilities): Due soon, but not within four weeks (blank value in table); Due within four weeks (“Yes”); Past due (“Late”) I’ve been able to create this with the first two status items, but not the third (“Late”). Here’s what I have: IF( AND( DATETIME_DIFF({Expiration}, NOW(), “days”) < 28, DATETIME_DIFF({Expiration}, NOW(), “days”) > 0 ), “Yes” ) Thanks!

This is not a question more so a time saving work around for anyone else that faced this issue. Scenario: We have a column of emails in the format of ‘firstname.lastname@domain.com’ We needed to break this down to their full name in one column but the standard UPPER and LOWER case formulas left the data looking ugly and wasnt great for merging into emails. Alas, this ugly AF formula is what I could piece together from various wild google chases. Enjoy I hope it helps you. REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX

Hi All - This will be my first post. I would like for our category row ‘Summary’ cell to sum the output of our number of work days driven by the following formula IF({Start Date} = BLANK(), “0”, WORKDAY_DIFF({Start Date}, {Finish Date})) The formula currently is working to output the numeric value of the number or work days, but AirTable ‘Summary’ does not recognize it as numeric and thus does offer the option to sum the results into the Summary cell.

Hey :slightly_smiling_face: I would like to save sensitive information in AirTable. Do you know a way to encrypt columns? Thank you, Frank