Solved

Thanks in advance for any answers I might get to this. In summary I have: 1 Table 1 Grid View with all the data 1 Grid View with the trigger for zapier (Last Modified Time is Today) What zapier does is when I get a new record on the “Trigger” view it sends an email to all salespeople. My “problem” is, I updated a record on the Grid View with all the data and the Last Modified Time is Today but it didn’t send the email as it usually does. Is it because it isn’t actually a new record, and just an update? Is that why it didn’t work for that specific result?

Hey there. I’m trying to create a field that populates the fiscal year that a project is published in, as it’s different from the actual year. So if the date of the project is between December 1, 2003 and November 30, 2004, it’s FY04. And so on for the following years ad infinitum. Any help would be appreciated; I’m having trouble with date formulas and I trawled through posts but couldn’t find a solution that worked for me. Thanks in advance.

I’m trying to use a formula field to calculate a date for benefits eligibility like health insurance. For example, if an employee starts on August 6th, 2020 we require them to wait until the first of the month following their first 90 days of employment until they are eligible. With the DATEADD formula, I can add 90 days, but I’m not sure how to take the result from 90 days to the first of the following month. With the example above the result I’m looking for would be December 1st, 2020.

It can be one using Coupler.io or some paid Airtable addon but I am looking for ways to do that with Integromat (free version). (Zapier doesn’t offer free multi-levels, so Integromat is the only option in town offering for free multilevel flow albeit with limited number of runs). Airtable stores images (and attachments) in one field together separated by commas. I can instruct Integromat to only retrieve the URL’s but they are all in the same cell in Google Sheets. (So ULR1,URL2,URL3…URLx all together). I wish the integration included instructions how to deal with that to separate. I’m trying to play with text various tools in Integromat but I don’t know how to make it work because Integromat instructions lack examples of scenarios and results and there is no guidance how to create flows (compared to Zapier). I want URL1 be in separate column, URL2 in separate column, etc… As I said works fine with Coupler addon but I am trying to do with Intromat. If I can get under 3 credits per succ

Hi - I am trying to write out a long nested IF statement and am having issues! Can anyone help with this formula? IF(AND({What category survey did you work on?}=“Category 1”,{Did you also conduct Qual Coding?}=“No”),{Cat 1 Survey Rate (LC) (from Countries | 60dB base)}, IF(AND({What category survey did you work on?}=“Category 1”,{Did you also conduct Qual Coding?}=“Yes”),{Cat 1 QC Survey Rate (LC) (from Countries | 60dB base)}, IF(AND({What category survey did you work on?}=“Category 2”,{Did you also conduct Qual Coding?}=“No”), {Cat 2 Survey Rate (LC) (from Countries | 60dB base)}, IF(AND( {What category survey did you work on?}=“Category 2”,{Did you also conduct Qual Coding?}=“Yes”),{Cat 2 QC Survey Rate (LC) (from Countries | 60dB base)}, IF(AND({What category survey did you work on?}=“Category 3”,{Did you also conduct Qual Coding?}=“Yes”),{Cat 3 QC Survey Rate (LC) (from Countries | 60dB base)}, IF(AND({What category survey did you work on?}=“Category 3”,{Did you also conduct Qual

Is it possible to convert textual data within a column as you change the field type from single line text to checkbox. I’ve uploaded a pre-existing spreadsheet that contained the text “complete” to show the status of processing. I would like to convert the field to checkbox and therefore, convert any data marked complete to a checkbox.

I’m getting stuck on this formula, please help! I have the following fields: Status (single select) Due Date (date) I would like to have a new field “days past due” that shows the number of days past the due date IF the status is “past due”. Otherwise, leave the field blank. I’m probably close (??) , but I tried the following two methods and am getting an error. IF({{Due Date} >= TODAY()}, (DATETIME_DIFF()({Due Date},TODAY,‘day’)), " ") IF({Status} = “Past Due”), ((DATETIME_DIFF()({Due Date},TODAY,‘day’)), " ")

Hi airtable team, I am using the current iOS 14 Beta and was wondering whether you are planning on building widgets for the app. I think That would be great. Best regards

Hi everyone! My coding skills are pretty limited :pensive: Here’s my problem: I have 2 tables. Table 1: a list of companies (records) with various fields. Table 2: I use this table to perform various statistics on all the companies in table 1 through many “Count” fields. Both tables are linked: in table 1, I have field with a “Stats” for each record. That field is linked to table 2 where I only have one record (“Stats”). My problem: every time I create a new record in table 1, I have to populate the linked field with “Stats” to make sure my stats in table 2 are updated. It’s OK to do that manually for a few new records, but I have to enter dozens of new records a day. I am looking for a simple script that would automatically populate my linked field in table 1 with “Stats” (i.e link it to the sole record ID of the record in table 2). I would be eternally grateful to anyone who could help me on this ! I have read lots of posts on this but I can’t find any solution that fits my s

This is the current formula I am using; IF({3P Impressions}>0,{Booked Revenue}-({Booked Revenue}{3P Pacing}),{Booked Revenue}-({Booked Revenue}{1P Pacing})) But when the value returned is negative, I’d like to display “0.” The format of the field is currency.

Hello, with the new custom blocks or automation feature, is it possible to make a script that will automatically change a single-select field of all records (or records in a certain view) to a certain value? It serves the same purpose as the batch-update block, but the batch update block runs manually. I’m looking for something that runs automatically at a specified time (e.g. at 12 am every night) with the automation feature or through custom blocks Any help in this will be very much appreciated :slightly_smiling_face:

HELP PLEASE!! I have a table with a LOOKUP FIELD, pulling a date from another table. The date in the original table is correct…but the lookup field in the second table is pulling a date one day earlier. I cannot figure why this would be! Any help is appreciated.

Hey folks, I’m working on a scripting action step for an Automation. It feels like querying the whole table just to search through the records is inefficient. I’m a frequent user of the Airtable API and am very used to simply asking for the record object by its ID. Can I make this simpler? I’m literally only trying to retrieve the field values of records that are linked to the record which triggered the automation. The Automation builder UI doesn’t allow for “looking up” fields from linked records. // Get collaborator email from Client record. let clients_table = base.getTable("Clients"); let queryResult = await clients_table.selectRecordsAsync(); // get all records in Clients table let client_record = queryResult.getRecord(`${inputConfig.client_id}`) // find the one with the client_id from input output.set("am", client_record.getCellValue("Account Manager").email) // Get Site record linked to the Project record let projects_table = base.getTable("Projects"); let projectQueryResult =

Using the new automations feature, I am trying to trigger an Integromat webhook when a new record enters a view. However even though I have configured an input variable, and it is processing just fine, it won’t parse into the webhook URL. I’ve attached some screenshots which hopefully explain what I mean. The code I’m using is: let data = input.config(); let response = await fetch('WEBHOOKURL?id=${data.ID}'); console.log(await response.text()); The test output shows the variable is picked up: However the webhook receives only the code: Would love some help - I’m sure I’m missing something very simple here…

How can I edit the Cover image of a Base?

Hi there! I’m trying to build out a formula that allows me to use checkboxes to update an application status column. As of now, this is my current formula: IF( AND({Reviewed}, {Accepted}), ‘Accepted’, IF( {Accepted}, ‘Error!’, IF( NOT({Reviewed}), ‘Pending Review’, ‘Rejected’ ) ) ) My hope is to have a three-column system where if you check {Reviewed} it displays the formula column as ‘Reviewed’, {Reviewed} and {Accepted} as ‘Accepted’, {Reviewed} and {Rejected} as ‘Rejected’, and {Reviewed} and {Accepted} and {Rejected} as ‘Error!’. Please let me know how to go about this. Major thanks!

Hi Airtable community! I am planning a conference that has multiple sessions per day over multiple days, and as we tweak the schedule, I don’t want to have to manually compute the session start/end times. The duration of each session is pretty set in stone. I need a formula that will calculate the END TIME of an event based on the START TIME and DURATION of that event. For example, I have a session starting on 10/19/20 at 12:00pm. It lasts 20 minutes. It ends on 10/19/20 at 12:20pm. But that might change, and I’d like to be able to update either the start time or duration and not have to manually update the end time. Any assistance here would be much appreciated! Thank you, Jennifer

Hi everyone! I was wondering if someone may be able to assist. I am quite new to Airtable and just getting my head around formulas. I am looking to create a formula to auto-update the STATUS of a client depending on how many jobs we have done for them. I have created a STATUS column which contains the three single-line field options of HOT WARM and COLD. I have another column which records the AMOUNT OF JOBS we have done as a number. COLD would = 0 visits, WARM = 1-4 visits, HOT = 5+ visits. Is there is a formula I could use for this? Thank you so much in advance :slightly_smiling_face:

Hi there I have created a table for a client who needs to record the dates visits are made to a site. We note the dates in one cell, separated by commas. We would like to use this data to view the total number of visits. Is there are way to count comma separated values in Airtable? Thank you!

I’m looking for a way to have a calendar view of upcoming birthdays. I can use the formula below to show the CURRENT year’s birthdays but I also want the calendar to show NEXT year’s birthdays so that in December 2020, I could look at the Calendar and see the January 2021 birthdays. I know I need a separate field and have the calendar us both fields but I can’t figure out how to add 1 year to the formula below for the second field., DATETIME_PARSE( DATETIME_FORMAT( BirthDate, ‘MMMM D’ )& ’ '& YEAR( TODAY() ), ‘MMMM D YYYY’ )

Hi, I exported a view to csv file so I could work on it and ID duplicates for some of my data. However, when I compare the csv export with the data in the table, the order of the rows in the csv appears to be random and does not follow the same order in my table. How can I export to csv and maintain the same order I have in my table? Thanks in advance

Hello Airtable community! due to corona pandemic in Germany the sales tax was decreased from 19% to 16 % during the period from 01.07.2020 to 31.12.2020 (DD/MM/YYYY). I have a column which shows the date of performance which is decisive for the tax rate. My formula is accepted by AT but it just seem not to calculate because the result is always 19%. My formula is: IF(AND({Date of Perfomance}>06/30/2020,{Date of Perfomance}<01/01/2021),16,19) Can you find the mistake I made? Thank you for your help in advance! Avi

I’ve set up a few automated scripting actions using the beta automations features but keep receiving the same error message when I try to run the automation. The same script runs without issue in the scripting block, so I’m not sure how to resolve this. Any pointers? I’m also a JavaScript novice.

With my business, I have WAY too many deals that come across that are unique and individual from others. I am in DESPERATE need to find a way to create a formula, (or simply type in a number for that matter) and NOT have it affect ANY OTHER record. Just change the formula on that one particular record instead of every single one. For example. Right now my formula to figure out commissions looks like this: IF({PPW}=“4.35”,500, IF({PPW}=“4.25”,450,IF({PPW}=“4.15”,400, IF({PPW}=“4.05”, 350, IF({PPW}=“3.95”,300, IF({PPW}=“3.85”, 250,0)) ))))*kW This morning we sold a deal at $4.79. So none of the formula triggers did anything and they didn’t calculate. However, I want to pay him $600 at that price. So if I typed in $600, it would change that cell for every single record to $600 and completely ruin all our accounting. This happens multiple times a week, and I’m fear I may have to go back to an excel spreadsheet where I can do individual cells like that. I REALLY don’t want to go back to exc

Hello everyone! I’m having significant challenges with getting an automation to run on a schedule. Airtable says: " Can I set up a script to run on a schedule using Automations? At the moment, there isn’t a built-in way to set up a script that runs on a regular time-based schedule (e.g. every day at 9am). A workaround is to use a time-based filter on a view." However, the time filter doesn’t seem to work very well for more frequent than daily. I was able to get ~ every minutes, but I was hoping to get something more real-time. To test the concept, I made a table where the first column is the “age” of the record using the following formula: DATETIME_DIFF(NOW(),CREATED_TIME(),"seconds") I then set up the automation to trigger when a record enters a view which filters all records newer than 10 seconds. The automation adds a new record to the same table. In theory, the automation should be running every 10 seconds continuously. But, that formula only updates every 5 minutes or so. I’m