Ask the Community

Take the example below, imagine you have:Category.ProductsProduct.CategoryA product is linked to multiple categories. When you first create the 'Category' field on Product, this creates the other side on Category, lets call it "Products".  If you delete the column "Products" from the Category, is it possible to re-link them later on?Also, if you do not think one will ever need the "many" side of the relationship - does it slow AirTable down if you keep that many-side Field as well? Or it does not make a difference? 

I'm rounding up a field called "Total Hours" using ROUNDUP(). Total Hours is a field that adds 2 decimal numbers together. The decimals numbers have up to 3 decimal places.My understanding is that ROUNDUP({Total Hours}, 2) works like this: it will round up to 2 decimal places if any number after the 2nd decimal place is above 0.Example ROUNDUP(72.001, 2) = 72.01                ROUNDUP(72.000,2) = 72.00The screenshot below shows that this is not what is happening for me.It's rounding up 72.000 to 72.01. In the screenshot, the error fields are circled in red. The original total hours are in the right most field and the rounded hours are on the left field "(Total Hours Rounded ,2)"Any help is appreciated for this.

Hello,I don't know how to perform the following query in a Script code:1. I have a table A of records with field short URLhttps://my.url/path1https://my.url/path2/path32. I have a table B of records with field long URL (like https://my.url/path2/path3/path5?x=y )Given a record from table B, how can I find all records from table A that have a short URL starting like the long URL ?Should I iterate on all records of Table B and check if shortURL indexOf my longURLI can't short/cut my longURL then query Table B (because I don't know where to cut)May be there is an AirTable formula? that check if record's field is part of my longURL ?Thanks

Hello,I want to create membership based table in airtable. I want to know if this is possible in Airtable. I want to master table. lets say tableMaster with 4 column. In master table, values in column 1 and 2 are fixed and can only be changed by the admin but values in column 3 and 4 can be changed by the admin and members. When a new member sign up, the airtable should create instance of tableMaster for this member. We will call it memberA-tableMaster. The member can then enter values for column 3 and 4 to see the view of this table based on his values. When another member join, new instance of tableMAster will be created and we will call it memberB-tablemaster. Is this something possible in Airtable using Softr or any other code platform.

I have 2 tables in my base . Table 1 have multiple records while table 2 only has single record . Table 2 has a field (lets say voucher)  with data type number. Whenever a new record is added in Table 1 ,I would like to Increment the value of a field (voucher ) with 1.

Hi!I'm creating PDFs with Google Docs and DocsAutomator. When I check the field "generate RMA" AirTable create PDF out of Google Doc and save this PDF to the desired attachent field. Of course the data is from AirTable. And this is easy.Then I came across one problem, which I think I handeled it okay. If I have two choices that I have to decide and check in a checkbox) I simply created formula field.So I had two choices "repair" or "servise modification". And I created checkbox field "repair" and "ervise modification". And then formula field for each of these field with IF() function. If the field if checked, it returns checked box, otherwise it returns empty checkbox. And then I connect these two (formula) fields to the PDF. And It worked.But then I came uppon bigger problem.. if I have many choices to check I don't want to create all these fields p

We need to assign staff to shifts. I have a calendar of shifts and can put two staff members on a shift. I want to have the staff confirm that they will do the shift, sort of like inviting them for an event on Google Calendars. I think Interface might be the place to do it. I was looking at using Button and having it change the staff person's name from "Sue?" to "Sue Yes" or something like that. However, with the Set option, I can't have the staff person change just their name but rather changes the whole field. I need to get permission from both assigned staff.Is there a way to make this work?Thanks.

Hi Airtable Dev team.You've royally screwed us freelancers with the latest update to the Interface! 🙎I understand that the idea is that there are now templates but first we had to toggle the permissions to expose the create button. Now! Fields that were mandatory are no longer and many other fields have suddenly appeared.We convince people to use Airtable and now sit with egg on our faces with questions like - "Why is this field no longer there?", "Why can I now see XYZ?", etc.Better QA!

Hi, I need an attendance tracker for a nonprofit organization that organizes different activities throughout the year. I first tried doing a form that our coordinators of each activity would use to report the activity, time, description/impact, and attendance. The attendance is linked to a table that compiles the beneficiaries of the different activities that are run by the Non-profit. We already have some beneficiaries or previous participants in this table and so some of the attendees are already in our records, but when we have new attendees, I would like to be able to generate a new record from a form. I am able to add a new record in the grid view, but not in the Form. I have already tried doing an interface and it still won't give me the option to add new records in both form or interface. I do have a plus plan (not the free version).Our objective is to be able to have a beneficiary registry or a complete list of beneficiaries to

Basically, I have a list of assignments. I need each assignment's due date, day number, and week number (along with other fields). I already calculated formulas so that when I update the day number, it automatically updates the other two "calendar" columns.  My problem is, sometimes I need to "insert" a new assignment before many that I've already done.  So, I need to push the rest of the day numbers/due dates up 1 day to match, but I'd like not to manually change every single day for the rest of the records (this could be hundreds of records to "push" forward).I've searched so many things.  I know it doesn't work like excel where I can do a per cell formula (the one above + 1), but I can't seem to find a way to do this.Also, FYI, there is more than one record with the same day number/due date because I have a record for each subject each day (sometimes more than one per subject). I'm attaching a screen shot in case that helps.

Hi there, I have been searching heavily for some help on what I'm trying to achieve but haven't had any luck. What I am looking to do on Airtable is have an autogenerated number for each line item I add but it needs to have a prefix of 6700. It also needs to start at a specific number, lets say 67006789. Is there anyway to do this? 

Is there way in node js airtable module to query on field Ids and field names, if there is no field Id present in the table , then it should look over the field names provided in the code.For Example , I am looking for field whose name is "event Id" and the field Id is of the same field is "fldtu2298482hs" .. I would include my field Id in the select statement and if my field is not found in the table , the select query should fall back on the field name "event Id"

Hi there,I'm new to the Airtable Community and was hoping someone here might shed some light on a script I'm trying to implement. I am receiving data from a third party form via an AT Webhook. I need to concatenate the image path (ImgPath) submitted from the form when it includes an attachment to create a full URL and then update the PhotoURL field which is set as an attachment in the current record in my AT table . However, when I test my script I get the error:Error: Field "fldAjZqtaQu8IMl9F" cannot accept the provided value.Below is the relevant section of myscript:  let imgURL = `https://mydomain.com/${ImgPath}`; const table = base.getTable("Entries") const query = await table.selectRecordsAsync({fields:["ImgPath", "PhotoURL"]}) let record = query.records[0].id; await table.updateRecordAsync(record, { "PhotoURL": imgURL }) I see plenty of examples where the up

Hi everyone, I am not sure if what I'm trying to do is even possible, but hopefully it is!I am improving my office's Airtable and I have two sheets, for simplicity we will call them "Places Sheet" and "People Sheet" (these are what the records under each are). Under the People sheet, I have a column where one or more Places are linked when relevant. Now, I would like a column in the Places Sheet that shows me which People (ideally through a Linked Record) have that Place as a linked record on the People Sheet. So, in effect, when Record A from the People Sheet links to Record B from the Places Sheet in a specific field, Record B also links back to Record A.I could go through and do this for each individual, but some People have more than one Place linked to them, and there's well over 1000 records under the People Sheet and over 300 records under the Places Sheet, so I'm really hoping I can automate this process.

Hi. I am using Pro plan, which allows syncing between bases.  I've been structuring a lot of parts of our business in one main base.  There is a significant amount of data which needs to be imported from CSVs, for which it is much easier to give direct access to the base to the users, rather than through interfaces, views, etc.  There will also be some sensitive data in the main base, which I do not want to give even view-access to these users.  If you give access to a Base, they automatically get access to all the tables read-only as a minimum. Because of this, I realised it would be better to have a Main Base, and also a base for the Raw Data/CSVs.  I would give any users who need to import bulk data to the Raw Data/CSVs base, and then sync tables from RawData to the MainBase.The issue is that I already have a lot of automations, fields, configuration, etc in Main Base. For example, I have a table called 'Bookings Data'. I would like to

I have an automation where I first create a list of records and sort them by priority, then I put them into a repeating group to run scripts on them one at a time. But, it seems as though the repeating group will run those functions with multiple items being processed at a time, not one at a time.  Is there a workaround so that I can process the items within a list one at a time in the repeating group? Thanks! 

Hey, can anybody think of a way to create a table that consists of a listing of all the records in several other tables in an index format. Something like this: Primary Field Value | Table Name Bob | First Names Goldthwait | Last Names Comedian | Occupations I want to produce a single table like the one above, dynamically and continuously from live data, from a base that contains the following tables: TABLE: First Names RECORDS: 1 Bob TABLE: Last Names RECORDS: 1 Goldthwait TABLE: Occupations RECORDS: 1 Comedian This is just hypothetical data. I know I could this by exporting to a spreadsheet and reimporting but I want it to be automated and real-time. Any ideas?

I'm trying to set up the AirFlow Extension, however it is asking me for an API Key.Since AirTable have depreciated API keys, I'm unable to create one...I have tried using a Personal Access Token (PAT ID) but that is showing the error: "Authentication error - Please be sure your API Key is correct."I also tried to create an OAuth integration but I'm unsure what to use for the "OAuth redirect URL".Any help would be appreciated!

Hi everyone,I'm having trouble migrating data from Excel to airtable I hope someone can help me solve this problem:I am creating a app to manage a betting strategy and it has two tables:Bets table has the amount i have to bet in each round and Strategy table has the minimun bet of the strategy. The objective is that when I change the minimun bet in the second table the firstone updates automatically.In the bets table the structure is:Round: (0-30) identifies in with round am IRestart round: Identifies with an X the rounds when I restart the minimum betPrevios round: Links the round with previous oneNext bet: its a formula with the expressionIF({Restart round}="X",{Minimum bet},ROUNDUP((({Minimu

Hello,I'd like to embed a WebView or iFrame into Interface Designer (passing some fields as URL argument). An other option is to display HTML content (not MarkedDown stored in a field).I wondering where / if there is a documentation to code custom Interface Designer components ?I don't want to buy a third party plugin ... As a workaround, I'm considering coding a ChromeExtension to hack that but it's very kludgeMy usecase is VERY basic ... seeing a field containing HTML or previviewing an URL. I don"t understand why AirTable prevent that feature? (or I might missed it ?)Thanks !

My company, a local city government, uses this service. What steps are needed to secure a government tax exemption?

Based on the wonderful scripting resources here, I wrote my first script with the Scripting extension to send an email via SendGrid with the user clicks a button field.The email recipient is stored as a field in the People table in Airtable. The email body text is stored as a long text field in the Email Templates field.The template contains several fields from the People table to communicate customized information to the recipient.. I surrounded the field names with double curly braces, but they are not being resolved. The sent email is just the raw text.I think I'm missing something obvious...The reason for doing this as a script instead of using the SendGrid extension is that the extension sends to all records in a view. I want to have a button on an interface that the user clicks as they go through their workflow. It's not something that can be automated. The button should send the customized email to just that record.

Hi all, I'm not sure if my aim should be achieved with a formula or an automation but I'm hoping someone can help me. I have a various payment schedules for different companies which show me the dates each one is due to make a payment - I upload these into Airtable.These payments may fall on a weekend. Where they do each company must make the payment either on the proceeding or preceding working day according to on what is stated in their T&Cs. I have a non-working day treatment field which indicates for each company whether it's meant to pay on the proceeding or preceding working day if the original payment due date is a weekend.How can I make a formula that looks at the payment due date and if it falls on a weekend changes the due date (add or minus 1 or 2 days) according to the non-working day treatment field? Alternatively, am I better off doing this in excel before I upload the payment schedule to Ai

Hi! I have two checkbox fields, column A and column B. In the column C, a formula, I would to write: Column A checked and Column B checked. I would like the result as a checked checkbox. Do you know if it is possible to see the result as a checked checkbox? Thanks in advance!

Hello community,I want a formula who counts how many successful candidates (the ones who gets "A" and "AAA") I had today.I was thinking about: IF(AND({Date 1st Interview}, TODAY(), {1st Round Bewertung}, "A" OR "AAA", COUNTALL())But I know the "or" command is on the wrong place.Can you help me? thank youu