Solved

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

I am building a database and keep a history of the membership for every year. For example look up a member to see if he was a member for the year 2015. so, how do I set this up please. Membership Yearly History

Hi all I’m really struggling with this - where is @Bill.French when you need him :-), Bill I need you! (or anyone else that can help please). So I have a view based on my orders table that filters unfulfilled orders I have written some code (with the help of others) that loops through the unfulfilled orders and creates new records in the Prod Req (Producction Required table). This table contains the product sku as the primary field and has a Linked Orders field (linked record field) that contains all unfulfilled orders with their order numbers along with some rollup fields. This code works well but it will create duplicate records in the Prod Req table each time it runs. Ideally, I’d like the code to first compare the Unfulfilled Orders against the Prod Req table. If it finds the same sku in there, then add the associated order number/order record.id to the Linked Orders field. If the sku does not exist in the Prod Req table, then add it and also the linked orders. Here’s the code… le

When using a form to gather input to a linked record field, is there any way to show the end user a field other than the primary field/column? Case use: I have a CHECK IN form that my workers can use to check in when they begin their job. The ‘Name’ field is linked record to my WORKERS Table, where Worker Name is the primary field/column. SO when they visit the form from their phone and fill out the ‘Name’ field on the form, they are essentially choosing their names off the list populated from the WORKERS table. That part is perfect. But the second field on the form asks for ‘location’ - I want that list populated with entries from the ‘location’ field/column in the JOBS table. But I cannot link to a specific column it seems, only the whole record, which means on mobile form, they only see the primary field/column info, which is job number. Is there a way to get it to show the ‘Location’ data instead? Besidies either… a) making ‘location’ the primary field/column in the JOBS table b) c

Hi, while this Airtable Scripting is a good start. Is there any way to get the last logged in date or update the sharing permissions the collaborator might have on the base? Thanks, Nigel