Ask the Community

I have 2 bases (Payments and Ledger)And on Ledger base i have a sync table from Payments baseI'm making a script that runs on a table in the Ledger database. This script will create a record in the Payments base and then link that record to a table in the Ledger base.But I'm having problems because the synchronization table has a different ID and recordID than the original table in the Payments base.If I pass the recordID from the Payments base to link it to the table in the Ledger base, will that work?

I have a fields called Due date and I am looking to highlight/color the value of this field. ( this is a date field not a single select or multiple select)Is there are way to only color the value of that fields ( not the row )

Hi,Somehow Airtable doesn't understand my dates as dates so grouping goes wrong. In an interface I have a list of booked events that I want to be grouped by their date. That way, I can easily see day by day how many events are booked. The grouping column is based on a formula picking out only the date from another column where the full date/time is stored.As a European I prefer 'DD.MM.YYYY' as the format, so my formula to give only the date is:DATETIME_FORMAT({date/time},'DD.MM.YYYY')This gives me visually 27.5.2024 for May 27, 2024, which is what I want. The grouping result, however, becomes like this:02.06.202414.06.202422.05.202428.5.202431.5.2024Grouping is apparently performed on the first digits, not as dates.Why doesn't Airtable understand a date that is only formatted into DD.MM.YYYY as a date?Rgds,Björn

Hello,I'm looking for a way to filter records dynamically similar to currently available options "Current user" and "Current user's email". What I have in mind is a formula field in the database that outputs something like "@acme.com", "@company.org". Then, in the interface designer I would like to set up a filter that filters all records and shows them to the user of this domain. A similar feature is available in forms sharing permissions, where I can share a form with users from the specific domain.Thanks to this feature, I could have one interface with dynamic filters, where the user with email ending with "@acme.com" would see all records associated to this company.The current workaround would be creating separate interfaces and sharing them with the necessary users, but if I'm providing services to multiple companies and want to implement some changes or upgrades to the interface, I have to reproduce it in all the separate views.

Working with birthdays where I only know the client's Month/Day and not their Year of birth.  So text field is 5/12 for example but I'd like to have an actual date of 5/12 so I can set up reminders 5 days before the actual birthday.  I used the following formula but it's not working correctly.  DATETIME_PARSE(Birthday, 'MM/DD')Thank you in advance

We see that from last three days we are frequently getting 502 Error in spite of no changes on the URL and how we retrieve the data from airtable.It's even seen that Api calls are working for some time of the day and failing for some cases.We would like to know from community what and all trouble shooting can be done.Troubleshooting done.1. Called the API locally and it's working fine.2. Checked the number of calls as well its well in limit only of the Teams subscription.

So let's say I have a table that is going to have different numbers in rows listed in a single column, like below.2331618And in another table, I have some ranges filled into two columns, with a min column and max column, and a third column with a name, like so below.0-10 Sally 11-20 Joe21-30 Bob31-40 JaneNow how do I have the first table use the second table to evaluate a number to determine which range it fits into so that it can show me the name in the first table?23 Bob31 Jane6 Sally18 JoeI'm OK with formulas prior to this need, but now I am totally lost. I don't know if I am supposed to use rollups, lookups, linked tables or what. I've never linked tables before and I need a guru to translate my need into something that gives me a clue on what to try. 1st time here on this forum.It's like I want to say "see which range my number fits into and display the name for

Hello,I need help ☹, here a the scenario :"Real Estate" table has several fields (A1,A2, A3=( link(recordId of the "owner" table)), the "Intervention" table has several fields (B1,B2, B3=(link(recordID of the "owner" table) "Real Estate"), B4=(Lookup(recordId of the "Owner" table which is linked to the "Real Estate" table), B5=(link(recordID of the "Owner" table), . list in field B3 based on the equivalence between fields B4 and B5, and integrate this new list into a new field. Do you have any ideas for a formula or automation?I'm building an app with softr and airtable, i'm an owner and i want to create some cleaning intervention in my homes with a formula.   i would like when i whant to create a new record "intervention" with a formula, only show   the real estat list that belong to the owner (me) not all the list of real estat in the database.

Hi I cant get Airtable to load today. I cant get to my boards or even onto www.airtable.com. The page is just white!!! HELP!

HiThis must be possible!?So I want to populate an Airtable from a Softr.io front end? I want users to be able to create records.As part of the user sign up process, I will capture their address/location.When they create a record, I want airtable to populate a field with location. This location should be pulled from the user record.Does that make sense?

I have a JSON array in a field called 'Output' in a table called 'Assessmnt converter'. I am trying to create new records into a table called 'Submissions test' and populate the data into four respective fields; Question number raw, Question raw, Number of marks raw and Student answer raw. I have created an automation whereby if the 'Output is not empty', it runs the following script. However, every time I run the script, I'm getting the following error:CONSOLE.ERROR"Error parsing JSON data:"▶Error {name: "SyntaxError"}Here is my script:// Load the Airtable scripting environmentlet assessmentTable = base.getTable(

Hi, I have an issue with transferring personal credits to my workspace. I just updated my plan to a business one, and now I want to transfer all my personal credits, but it doesn't work. I already resublmitted my card details, still no success. Please sort this out for me ASAP! 

Hello!Have a bit of a challenge and wondering if anyone else has been in a similar situation / need, and how they may have addressed it.Scenario(1) Simplified case: Say I have a Projects table that specifies a StartDate, EndDate, and EstimatedHours. I have one record (Project#1) that starts in JAN and ends in AUG with 800 hours. Assuming a simple linear average, how [would we get Airtable to tell me how] many hours should I expect to spend in MAY?(2) The first complication: There are many projects (of course), each with their own overlapping StartDate, EndDate, and EstimatedHours. How I can get Airtable to report what our total monthly commitment is for MAY? JUN? etc?(3) The second complication: Say there is also a Resources table (i.e. the labour that will be working down the commitments). Each of these records has their own StartDate, EndDate, and AvailableHours (not actually,

Hi guys!I am using Record Templates to auto-populate long text fields in existing records, but it doesn't seem to be working. I have a bunch of long text fields that I want to have templates for to auto fill them out when a project hits a certain phase. A manager will hit a Apply Template button on an interface to apply the template they want to a project. Current it only changes a single select option I have in the template. Do record templates not work with long text fields? If so does anyone know of a way to make this work? Thanks!

Ever since personal token system came in Airtable, my data is not showing in Kodular. I have tried everything, tried putting personal token instead of api key but got no result, can't understand where is the problem. 

I have created a base to track various components of our commercial kitchen operation.I have bases for Menu Items, Prep Items and Ingredients.I have created various columns for the quantity of ingredients for each dish and need to roll them up into the quantity of ingredients in total for a given period, using sales data.Because there may be multiple meats involved in a dish, I have created separate groups of columns with Qty Meat 1, Single Select Meat 1 and a formula column that multiplies Qty by average weekly sales. I need to roll this up into the meat table so that we can calculate the total quantity of each meat we use per week using a formula to sum the four columns for each meat.This all works fine for the first meat, and works fine for the initial calculations for the remaining columns (to Meat 4).However, when I roll up these columns to calculate the total, the second, third and fourth columns are grabbing the Meat single-select from Meat

Does anyone know of documentation that has an example of creating each field type using Node.js?There are certain field types I am running into issues with such as date fields and currency fields and I can not find much documentation of when an example for each field completed looks like.

I've done a lot of searching and tried a variety of suggestions but I can't get this to work.  I'm trying to make the viewing of record details in an interface very intuitive for the user.  Here is what I've tried:1. Button Field URL Formula: CONCATENATE("https://airtable.com/appxxxxxxx/pagxxxxxxxx" & RECORD_ID()) and CONCATENATE("https://airtable.com/appxxxxxx/pagxxxxxx?detail=" & RECORD_ID()) 2. Created a URL field that contains variations of the URL shown above in #1, along with a Button field that references that field in the formula.3. I found some information that suggested how to get the URL of the record detail view in an interface, but the format of the URL looks nothing like what is posted.  This is the format I read that I'd find when I got the

Hello. I am having issue with my formula returning errors instead of 0. I tried using adding If to the beginning of the formula and also the ISERROR but nothing is working the way I need it to. My formula is returning 1 if Purchase Close Date was last month. Below is what the formula currently looks like. Thanks in advance for any help! DATETIME_FORMAT({Purchase Close Date}, “YYYY-MM”) = DATETIME_FORMAT(DATEADD(NOW(), “month”, -1), “YYYY-MM”)

One of my tables is “Accounts” and it has gotten really wide (40+ fields) and growing. (Name, ID, Address Complete, Address1, Address2, City, State, Zip, Phone, Fax, Comments, Attachments, COD status, Credit Terms, Tax Exempt, Tax Exempt Number…) I’ve backed up the table and started playing with linking sub-sets of account information in multiple tables (a 2nd table for Address information, a 2nd table for Credit/Billing information, a 2nd table for interests/category information… so each table can be limited to 15 or fewer fields) What are the pros and cons of wide tables? The way I see it, going wide is: Pros: Everything can be entered in one record (I don’t need to go to multiple tables and re-type the account name to continue entering information) No confusion over whether the additional records have already been made in the additional tables Can use custom views to make the data more visually manageable

Hi there,I'm trying to find out if there's a way to share a view link for an entire workspace (i.e., not just a base). Thank you.

Interface designer is nice but on mobile it’s quite pointless and I hope I’m mmissing something. Wouldn’t want to use a 3rd party for building interfaces. the list views show a random number of fields see sceenshot below. How can this be fixed? Also, to add a record - you need to ba an editor. So bad 😞 I have loads of people only doing that. Submitting records. Now I must make a workaround - because through a form it works  

Hello all,Within a Project Management table and related interface, I have a collaborator field ("Watchers") which is intended to allow users to receive alerts whenever a project they are "watching" is updated.I do not want to show everyone who is watching - I would like only to display information about whether the signed-in user is watching the project, so people don't feel shy about watching projects.I am stumped though, about how to display a "Yes"/"No" answer to the question, does the signed-in user appear in the collaborator list field. Any tips? 

I have built an automation and it works very well. When I open a new row in the "Projects" table, it automatically adds the necessary tasks in the "Tasks" table. It also fills in the default values. Great. Unfortunately, I cannot insert a default value from the "Projects" table as a lookup. I can select it, but nothing happens. Does anyone have a tip?When I do the preview, the value appears, but only the one already created. In my case "test".Or is this only possible via the "Create child linked records" script?    

Hi,I have a series of lookup fields that return multiple dates.  I'd like to combine those fields into one, listing all of the dates returned in M/D/YYYY.  I've messed with datetime_parse and format with a concatenate, but the formatting is either not M/D/YYYY or it only returns the first date listed in a series in the lookup field.Thanks for any help!