Solved

I’m coding AT SDK extensions using Visual Studio Code, and most likely I’m missing something but I can’t output to console with console.log() function. There is no output on VSC terminal, debug console or output. I’ve tried running in debug mode, nothing changes. There is also a button “Log component to console” - a small bug icon - on the app editor interface, but clicking it seems to change nothing Thanks ahead for help!

Hello Airtable community! I founded an all-volunteer project to help street cats on the island of Vis, in Croatia, and design a calendar every year to raise money for the project. Last year was my first year dealing with calendar orders via Airtable, and I thought I had a clever set-up where people could fill out a form to order. It DID work for that one year, but I don’t think I designed the base correctly, because it’s not sustainable year-to-year. The base is called CALENDARS+ (in case we start to sell any other fundraising items in the future) and all the data I collected lives in a table called 2022 calendar. Each name entered via the form becomes a record, with the person’s preferred language, email address, postal address and the number of calendars they want. If I do this again for the 2023 calendar, there will be lots of duplicate records, so it’s obviously wrong. I need the people’s data to live in one place so that in following years when they come back to buy another calend

Im attempting to make an app that will allow the user to select a value from a dropdown, and then the table will filter the records for that value. I’ve gotten the dropdown working, however for whatever reason the last return has an error and will not work. The problem function is the one that will update the records. How can I resolve this return error?

Hello! I have an issue with a SUBSTITUTE formula I am using. I started with the following formula: SUBSTITUTE( SUBSTITUTE( {Email Body} & "", "{Appraisal Contingency Date}",{Appraisal Contingency Date} & ""), "{Conditional Approval Due Date}",{Conditional Approval Due Date} & "") It returns the following: Appraisal Contingency Expires: 2022-09-20T00:00:00.000Z Conditional Loan Approval Due: 2022-09-02T00:00:00.000Z Since the dates were not formatted properly, I updated the formula to the following: SUBSTITUTE( SUBSTITUTE( {Email Body} & "", "{Appraisal Contingency Date}",DATETIME_FORMAT({Appraisal Contingency Date},"ddd, MM/DD/YY") & ""), "{Conditional Approval Due Date}",DATETIME_FORMAT({Conditional Approval Due Date},"ddd, MM/DD/YY") & "") It returns the following: Appraisal Contingency Expires: Tue, 09/20/22 Conditional Loan Approval Due: Fri, 09/02/22 All seemed well, BUT, when there is a record that does

I’m getting an invalid hook call error, but I’m unsure as to why. My extension is intending to list all the values in a specific field in a dropdown to then select one to filter buy Error: Invalid hook call. Hooks can only be called inside of the body of a function component. This could happen for one of the following reasons: You might have mismatching versions of React and the renderer (such as React DOM) You might be breaking the Rules of Hooks You might have more than one copy of React in the same app See https://fb.me/react-invalid-hook-call for tips about how to debug and fix this problem. at resolveDispatcher (https://localhost:9000/__runFrame/bundle.js:79388:13) at Object.useContext (https://localhost:9000/__runFrame/bundle.js:79396:20) at useSdk (https://localhost:9000/__runFrame/bundle.js:25061:19) at useBase (https://localhost:9000/__runFrame/bundle.js:32768:41) at ./frontend/filter.tsx (https://localhost:9000/__runFrame/bundle.js:34:74) at webpack_require (https://localho

Currently experience a bug? I think… I’m trying to sort by A-Z on column 1, then sort by selected radio check marks? Just me…?

I am trying to addd an automation that does the following: When a Multiple Select Field has a specific value entered, it then creates a record in a second table with some of the fields from the first table. That part is easy. The problem is that I want it to place today’s date into a field in the receiving table. I cannot see how to tell it to simply place today’s date in that field when creating the record. Thanks!

Hello. This seems like it should be an easy solve but I cannot for the life of me figure it out. I have a table in a base that automatically receives responses from a Typeform survey. It puts the email address (manually entered by person taking the survey) as the main record, and the responses follow in different columns. There is another table in this base where the main record is an employee name, and then we have Department, and 3 columns of 3 different email addresses (there are potentially 3 different ones for each employee, or 2 or 3 can be the same). I have linked the email base to the response base, and as the responses come in, I use a lookup to select the employee and pull in their department. I am trying to get this part to happen automatically. So, when an entry comes in, if that email address matches any of the three emails in the other table, it will bring that employee name in. Hopefully this makes sense and someone has a solution… Thanks!

What is the difference between “one month ago” vs “one month from now”?

I looked everywhere but don’t seem to find how to edit my custom extension I’ve released. I only see instructions how to create a new extension from scratch… I can’t find a list of my extensions as well. Please help!

Hello there! I have made an text field where you can enter a date with a “/” or can input only a week. Only problem is now that because the year is in a seperate column it is hard to get a full date when the record doesn’t have a / and get a full date when the record only has an week. Also the timezone in airtable is american by default but i need european.

I have a formula to store progress on a time period. CONCATENATE(ROUND({closed tasks}/{Total tasks}*100,0),“%”) There is another field called “deadline” What i am trying to solve is to avoid an update of the formula after deadline date, in order to “snapshot” how was the progresssion until deadline date. I tried with an IF NOW() > deadline but then the field is blank and nothing is saved. Some idea? Many thanks in advance

I’m looking for a way to have every other (every 2nd) new record created in a table (the records are being created off of a website from Zapier) be directed to a specific view by having a specific status assigned using a status single select field - I’d like every other new record created in the grid view to get assigned 1 specific option of the many options in the single select drop down. Has anyone ever done something like this? Not seeing an obvious way to automate an action on every other record.

Not sure why I’m getting this error. Using an empty array works and removes the values. Essentially what I’m doing is, I’m matching companies to different events. I want to add the companies that are matched when found in the loop into my field called “Mail_Chimp_Company_LookUp”. This script is automatically updating all records every time an event is created. The results variable is an array of companies that are matched to the event tags.

I’m capturing leads from a webform in airtable I can’t keep people from submitting information multiple times (the webform is a drawing for a prize). How can I create an automation for the original names entering a new view - that will check on email address as a unique identifier, for any other record already in the view with that email address before copying from the grid view/original view to the new “deduped” view?

Hello - I am using a simple formula of: DATETIME_DIFF({Today},{Start Date :star: },‘days’) to calculate the number of days from the Start Date to Today. I would like to combine an IF statement to do the following: I only want to return a number IF the Field ‘SOP Status’ contains the words ‘On Ramp’, otherwise return a blank result. Any help is greatly appreciated. Thank you

Hello, I believe this is simple, but I don’t understand what syntax is needed. I’m trying to read the results of a single-select field as a string. I’m doing a running total calculation, but resetting it whenever a certain reading is found. The running total part was working, but I can’t figure out how to get the single select output as a string. When I run this, I get: typeof respGroup.records[0] returns “Object” output.text(typeof respGroup.records[0].getCellValueAsString) returns “Function” let table = base.getTable(‘Prints’); let view = table.getView(‘MTBF layout’); let respGroup = await view.selectRecordsAsync({fields: [‘NDD - Responsible Group’]}); //NDD - Responsible Group must be manually filled out! let elapsedTime = await view.selectRecordsAsync({fields: [‘NDD - Elapsed print time’]}); //NDD - Elapsed print time is a calculated field let groupRecords = respGroup.records; //trying to understand how to get the group records into a string format output.text(typeof respGroup.re

How do I remove a comma from in front of an email that has been extracted from a rollup. I am very new to this formula writing. I have a rollup field that has two emails in it. I have extracted the first email by itself. However, the second email alway has a comma in front of it. I need to remove that comma. How do I do that? Can I do it by altering this formula in any way? REGEX_REPLACE({Email Roll Up from Educator}, “([^,])(.)”, “$2”) Again, thank you for any help on this.

Hello! I would like to calculate a ‘winning streak’. Each row has the result of a game with a column for wins/losses, as well as a column for the dates of the games. I would like to calculate a winning streak. In Excel, I would do this with a self-referencing formula: IF({Win/Loss}=“Win”,{Win/Loss}+1,0), How might I do this in Airtable? Thanks! Here’s a sample table: https://airtable.com/invite/l?inviteId=invEhMSt3pM1PhMUr&inviteToken=022c846bffe765f7904cc3124920d800b61f879f25b7d41b5030bfabcc64b7bb

Hi I would like to use the extension to convert URLs to PDFs. It works for sharepoint URLs but I can’t get it to work for google docs - any idea how I do this? thanks! Clare

Is there a way to achieve this kind of view or similar where I can easily track the release status of my Product? I have two types of releases I need to track, a “Beta Release” and a “Final Release”. Each release consists of many different type of tasks. The tasks are predefined and I would like to enter them at once and be able to glance at them just like the picture here to be able to tell what I need to focus on. I could have many different Products going on at the same time. I would appreciate it if there are any examples

I have a field with multiple select; I need to get a count of EACH selection AND would like to display each response with the count. For background: the field is part of a survey and those filling out the form choose all that apply to them. I tried the linked field route and it counts everything in the field; doesn’t separate them. Do I have to do a linked field for EACH option? I’ve looked at several related items in the community but it all reads like a foreign language that I don’t speak to me…

I’m hoping the community can help me out. I think that my formula is a bit off. Here’s the logic I’m trying to do in the Difference field: If Baseline Value is empty, leave Difference empty If Baseline Value is 0, use the value in Target value If Baseline Value is NOT empty, calculate Target value minus Baseline value divided by Baseline value so I can get the percentage difference As you can see, if Baseline Value is 0 or empty, there’s an error My current formula: IF({Baseline} != BLANK(), IF({Baseline value} != BLANK(), (INT({Target value}-{Baseline value})/{Baseline value}), IF({Baseline value} = 0, INT({Target value}), BLANK() ) )

How can I detect the number of records in each status: Todo In progress Done So that I can notify team members when there’s too many in a column. Example: if more than 5 In progress, notify team Any suggestions?

Hi all - I know dates and timezones are complex, and I’ve tried to do my homework but I’m really stumped. My end goal is to identify records created yesterday and send off a notification. To start, I’m attempting to calculate how many days are between Created Date (w/o time) and Today (without time). Ideally, I would say if Today - Created Date = 1, then that record was created yesterday and I can filter on those records in a view. Trial 1: ‘Created Date’ is set to use GMT for all collaborators, and does not include time I created a formula variable called ‘Today’ with formula “TODAY()”, which is set to use GMT for all collaborators and does not include time. The value shows as 8/31/22. In a formula field I compared the 2 dates: DATETIME_DIFF(Today,{Created Date},‘days’) For both yesterday and today, the value of that comparison was zero with Detail: today is 8/31/22. The record created yesterday on 8/30/22 had a calculated value of 0. The record created today on 8/31/22 had a ca