Solved

Hello all, I have a question, and hopefully there's some type of solution to this issue. I managed 3 properties, but for now - we can just focus on 1. Property A has a total of 100+ units. When an end user fills out the form - they type in the unit number - and this is how I have my automation set up:As you can see from the above image, I have a find record and it will update that record for it's respective tenant. Example: The concern here I'm facing is, because Property A has 100+ units, is there a simpler way of creating automations to find records for each unit?Here's a view of the configuration for Property A, finding the "101" integer:Essentially, the goal is to not create 100+ automations for this property to statically assign each unit, but my fear is maybe I have to?I hope I articulated this!Thanks! 

I am working to automate a process that feels like I should be able to script but have been struggling. Admittedly I am new to scripting so I may not be understanding how to structure this, I have asked around, tried to get an assist from Chat GPT, and poked and prodded this along but the final outcome has eluded me. Let me break down the intended function and drop the code in. Any help is greatly appreciated.  Intended function:The automation is initiated when a record enters the "Meetings" view of the "Connections" table, there is a text field called "Attendee Emails" where a formula has collected and concatenated emails using ", " as a delimiter. We are passing that through to the script as an input variable called "attendeeemails". What we need is for the automation to go through the string stored in "attendeeemails" and pull each email out one by one, and check each individual email against the "Email" field in the "Full view" in the "People" table. When any individual e

Hello,Not sure if I overlooked the obvious, but I could not do the following which seems simple :I have a table with contacts (persons) with their mail, function etc. They are linked to 1 Company in the companies tables, companies which have an address and Zip code. I need to display a list of all contacts filtered by the Zip code entered in Filters: how can I retrieve that value from their company ?I already placed all companies in a nice Googlemap addons so salespersons can visualize where clients are, but values were all in the companies table, whereas here I need to show the contacts emails to reach them if someone visits their region. Thank you !

I’m using the Send email action in automations but having a problem with the signature line. I want it to be: Katherine Kasmir Executive Director BRITE But it shows as: Katherine Kasmir Executive Director/n BRITE Is there any way to get it to look like the top version?

I've just read that there will a limit of 1000 calls per month to the API... I use the API on several base to expose data on small website but I can't find where is current state of those usages... So I can't have any idea about my monthly number of calls - How can I check this ? There are statistics of items in base, automations, users... but where is the API consumption state ?Thank you.

Is it possible to have an input Mask in the tables / forms? I want a field to be displayed in the format S0123, or another field to be displayed as 4 digits such as 0025 (not simply 25). Thanks in advance all.

HiI would like to create a number field "recall" that each time the record is update make something like that: recall = recall +1.I used the automation with the update record filter and I try to apply formula on the recall filed by used a formula like tahs: SUM({recall}, 1) but it is returned an error about the format of the value.Do you have idea how to increment the value?For the moment I fixed by add string +1 and the result is "+1+1+1+1+1" for each time the update is execute.Thanks

What types of pushback did you experience/aware of when Airtable was first rolled out. I am ready for AT vs. Excel and "why now, if what we are doing works" any other hints and tips?

If anyone from airtable is reading this my extension was submitted several weeks ago and I've heard nothing so far. thanks. No reply from the reply address I was given when submitting it.

I have a column called “Date”. I’d like another column to look at my date column and if the date is in the same month as TODAY(), then it should say “This Month”. If the date is last month when compared to TODAY(), then it should say “Previous Month”. To be clear, I don’t want it to look at the previous 30 days. So, if a record has a date of 06/30/20 and today is 07/01/20 then that record would say “Previous Month”, but its month is in a previous month when compared to TODAY(). Does that make sense?

Hello, I have a cell with a date picking like "20240204 12:00" and I would like to format the date to "Feb 4th".I don't find how to reformat in this particular format.  Thank you for your help ! 

Context.  End user tool to help filter many products to a manageable few, filtered by users' selected constraints.  They can then drill into detail (data sheet attachment column) and ideally, select a subset of filtered products to get more info on.   Single table. ~400 products. 8-10 attributes any of which may or may not be selected/filter-constrained by user. *Dynamic filter:  from https://support.airtable.com/docs/shared-view-url-filters  I figured out how to collate filters   (  ..airtable form URL....?filter_sensitivity=presence&filter_colour=silver&filter_mount=wallCurrent thinking (please guide/correct me):1)  Customer (on mobile) clicks through to form  (imagine 10 drop down (attribute) boxes, appropriately labelled)2) Submit/Find button generates dynamic URL from user selection which filters shared grid view *(above)A)  My understanding is Airtable is unable to generate dynamic URL from a form submi

Hi,This is my interface page where I select investor from the dropdown. I have added a filter below and I want the filter to have the value selected from the dropdown.I understand that this kind of dynamic value setup is not possible in airtable interfaces as of today. So I am thinking of using airtable automation.Now when the user clicks the Set Carrier button, a script runs saving the name of the selected carrier in a variable. I can add a 'Find Records' step in the automation to use the same variable and filter the results. Now is there a way to publish the output of Find Records back to the interface page? I am able to see the records while testing automation. However a feature that can publish these as a list on the interface page would really be helpful. Any thoughts/suggestions? Or is this kind of setup possible only through a third party tool?

All of a sudden, Airtable is freezing and only loading a small subset of the web interface.] I've tried clearing all browsing history in Chrome, and still same issue. I also tried with Edge, same issue. Anyone experienced the same issue? I'm completely stuck.d

Hello all! Been struggling with this for a while with my current base. Subject of this post is a decent summary, but for explanation sake I've drastically simplified my base design:Link to the simplified base I'm describingtl;dr: The end goal is to look at a project, and total the number of hours spent on each task over the multiple scheduled events related to that project. There are three Employees:Employee AEmployee BEmployee CThere are three Tasks:Task ATask BTask CThere are three Projects:Project AProject BProject CThere are Scheduled Events.Each Scheduled Event assigns an Employee to a single Project, and various Tasks for that project. For instance... Employee A is scheduled on Jan 1 to work on Project B. They are assigned to tackle Task A and Task C. This is what I'm calling a scheduled event.Each day will have multiple scheduled events. Any combination of Employee, Project, or Task is possible for each day. Each employee mi

I am trying to pull all the data from one of my tables and dump it into a json. Is their an easy way to do this? I have read and tried to follow the github for airtable.js but seem to be a bit lost. Thank you.

Hi everyone, I use Zapier to run a large amount of automations in my Airtable bases. It looks like nothing is working anymore and the reason I’m thinking is because it is listing Airtable as ‘Deprecated’. The only way I can reconnect the zaps is to literally redo them from scratch with a new connection to Airtable. Does anyone have any idea what’s going on here? Also, does anyone have any guidance on how to batch the updated airtable into my existing zaps? I don’t want to have to redo every single zap as I have dozens and redoing them seems to be fastest way to get something wrong. Help would be appreciated!

Is there an airtable formula that combines linked records from a column (say column 1) and another column (say column 2) and outputs it as linked records in column 3?  If not formula is there a way to do this without scripting?

Happy Holidays everyone! I have a table that includes columns for both Start Date and End Date. Date format for both date fields is "Local". My gmail automation is setup so that when 'today' is 10 days from the End Date, the client will receive an automated email.This example, the End date is January 6, 2024 and the email automation triggered December 26th, which is 11 days from the End Date.How can I fix this so that it triggers when 'today' is 10 days from the End date? 

Hi!So I'm trying to set up a table for our home school group to house everyone's birthdays. I've scoured the forums and can't work out why I'm getting an error on all dates on or after 13/05/2019. All dates prior to this work fine and I just can't figure it out! I also wanted to see if I can incorporate a set_timezone formula to ensure it's based on my Australian timezone. Here's what I have set up:DOB field (members will enter their DOB via a form) and a formula field "Birthday (this year)" with the following formula: DATETIME_PARSE(DATETIME_FORMAT({DOB},"DD/MM")&"/"&YEAR(NOW())) Questions:1. I'm getting an ERROR for any DOBs that are from 13/05/2019 onwards. 2. Do I need to add a SET_TIMEZONE formula to set the timezone to Brisbane, Australia to ensure the 'NOW' portion of the above formula will be correct throughout the year? 3. If I wanted to add another field titled "Birthday (next year)" how would I add 1 year to the above formula? Thank

I'm in the process of building a first app and suddenly I'm having a weird problem which is driving me nuts.In the past I was able to edit the record details page layout at will. Ie. resizing elements, reordering them to be side by side and adding text elements etc. Now for all the new record details pages I add (new and old interfaces), I can't seem to do that at all. Additionally in the side menu I have a text "This is a new record details layout experience." when it doesn't work. On the old record details pages no such text exists. Also the add element button is missing entirely on these problem pages so I can't eg. add any clarifying texts anywhere on the page. Did Airtable really kill that major bit of functionality or am I just doing something stupid? I can't find anywhere any info on what the heck this "new record details layout experience" is actually supposed to mean compared to old way.  

HiI have a script which exports data from Airtable to Make.It exports 3 record columns in total.The trigger is a new created record.The output returns the same record every time, which is not even the newest, just a random out of the list.I'm quite clueless at the moment and appreciate any assistance in this matter. The script is attached: let apiKey = 'XXXXXX'; // Replace with your Airtable API keylet baseId = 'XXXXXX'; // Replace with your Airtable base IDlet tableName = 'Data'; // Replace with your table namelet integromatWebhookURL = 'https://hook.eu1.make.com/lltvxgqpxuvehximley444ibk3vcqkw9'; // Replace with your Integromat webhook URLlet table = base.getTable(tableName);let query = await table.selectRecordsAsync({fields: ['Quote Number', 'ID', 'Client Name'],sort: [{ field: 'Quote Number', direction: 'desc' }],});if (query.records.length > 0) {let record = query.records[0];console.log('Client Name:', record.getCellValue('Client Name'));let dataToSend = {'Quote Numbe

Hi there!I am trying to create a formula that will pull the Last Modified date and combine it with my initials and my Pending Items column. The formula I'm using right now works, but the Last Modified date is pulling tomorrow's date. I'm assuming this has something to do with time zones because it doesn't switch the date until 6pm CST, but I'm not sure how to fix it! Please help 😊Table:Formula:CONCATENATE(DATETIME_FORMAT({Last Modified},'M/D/YY')," ","RE: ",{Pending Items}) 

I'm working on my graduation project, using Airtable as an API. In the API documentation, specifically in the "create records" section, I'm having an issue. When I try to copy the 'YOUR_SECRET_API_TOKEN' for authentication, it stays as plain text and doesn't convert into the expected key format.Has anyone else run into this problem? Any ideas on how to fix it?Thanks for your help!

Hi folks,I'm looking for ideas on base design(s) for chemical formulations. I've taken one stab at this where I hardcoded some columns, but that fell apart pretty fast. I'm hoping some Airtable creatives have ideas. Here's the general problem:An ingredient inventory has some number of ingredients A, B, C, D, E, F... etc and can have an arbitrarily large number of entriesA formulation has some number of ingredients (an arbitrary subset of the ingredient inventory, so maybe B, C, F as a random example) and a defined amount of each included ingredient (xB, xC, xF). That amount could be a fraction or a mass in most casesSimple case: how do I deal with a formulation having arbitrary composition of ingredients?More complex case: How do I deal with the above, but ingredient inventory can also include formulations (so it's getting recursive)?Any ideas are most appreciated!Regards,Scott