Ask the Community

How can I change the primary field of a base using the API?

Hey everyone!I’m managing a project with around 40 part-time team members and could really use some help with setting up a simple but effective task allocation system.Here’s what I’m hoping to achieve:I want to create a task sheet where, once a user marks the “Status” column as “Claimed,” the task either disappears or becomes locked so that other users can no longer edit it (but they can still view it).As the manager, I’d like to be able to continuously add tasks to this sheet, keeping my workload minimal.The goal is to reduce the time spent manually managing who’s claimed what, so the system becomes a bit more self-sufficient. Does anyone know a good tool or method to set this up? I’m open to using spreadsheets, scripts, or any other automation tools that might help make this easier.Thanks in advance for your suggestions!

Hello,I need to trigger a webhook to Make.com, but I need to avoid the confirm tab being opened. Therefore, I cannot simply use button + webhook and I probably need to use a script. And this is the part I cannot do by myself.So here is the situation - I have a button as one column and what I need to achieve is to send a webhook with recordID to Make. In the interface, I have a "record view", where the button is for each record. The button works fine with this: "https://hook.eu2.make.com/myhook?ID=" & RECORD_ID()But it also opens a new tab, which is unacceptable for my use case.So I tried three scripts, but none of them worked. Some of them want to pick an item, that is probably not the right solution for my case.Can someone help, please?SCRIPT 1&n

Hello everyone, I hope you can help me with this. I have a table with many records related to Spotify listeners or Instagram followers of various profiles. I usually review and update a lot of data daily. I have created an automation to generate a copy of all records that are modified in the source table and move them to another table so that I can track the evolution, for example, if the monthly listeners of an artist grow or decrease.The problem is that in the destination table, it creates a new line every time there is the slightest modification in any value of the source table. I would need to modify the automation so that, for example, it creates new records in the destination table only once a day, with the lines that have been modified in the source table during the previous 24 hours. This way, I would have in the destination table only one line with the most updated results of everything I have reviewed that day.Of course, if you can think of any other way to k

hello, i’m new to this and i’m wondering what the best way to approach putting lists of songs in here! basically i have too many playlists on spotify and i don’t listen to all of them anyway, because it is more like categorising them. on spotify i have different folders and multiple playlists within them, e.g instruments: piano, guitar etc. i’d like to transfer that over to here and have the fields be the song names of those categories. what’s the best way i can make this without it getting too overwhelming? just for reference i have at least 100 playlists that i’d want to transfer, over like 15 folders. thanks!

Hi,I wonder if anyone else has had this use case and if they managed to solve it.My base has a collection of deals, and each deal will always be assigned a stage. I want to track time spent (in days) in the current stage and time spent in each subsequent stage as the transaction progresses through the deal lifecycle.  I want to be able to report on this data.Some reports I would like to run include:how many deals are in stage A, in Augusthow many deals are in stage B in July vs August vs Septemberhow much time is spent in each stage? What are the averageshow much time is spent moving from stage A to B and C to D, and what are the averages over timeAnother similar use case: for these deals, I would like to count the number of deals captured each month and the average over time. I would also like to include the monthly financial position for these deals and track them over time, too.Any pearls of

Hello. I'm trying to find information as to whether I can use Airtable only to create a customer/client portal. I've seen some videos but I need clearer instructions, meaning where do I go to create this portal, how do I add information, linking clients, creating login page etc. Is there any information that is useful on here or is a walkthrough video that you can point me in? Your help is greatly appreciated. Thanks

I have a base used to track conservation information about media in different formats. Each format has its own table. The tables are: Film, Video, and Computer Media.Across the tables, each record is an individual item. The fields for each table differ, as the conservation data in those fields is different depending on the media. (For example, Computer Media like a floppy disk does not have a film gauge of 35mm, 16mm, etc.)I want to create a fourth table that pulls in select records from all three tables. I want to pull in only records that have "reformatting candidate" checkbox field selected.I know this could possibly work by having all the records in a single table, but the amount of fields would grow quite large and would require multiple different views with various fields left empty and hidden. It is also more user friendly for us to have each table be delineated by media type.So, is there a way to pull select records from multiple tables into anoth

Hello! I am pulling stats for an interface dashboard and I am trying to make sure I know what some of the terms mean exactly and have searched for term definitions but can't find a list. Does anyone know if one exists? Here are a couple of examples of what I mean. When I put in "is within" "this past week" I want to know exactly what days we are talking about what is "this past week" is it Sun - Sat of the previous week? Also terms like "this past month" Does that mean the past 30 days or all days in the month prior to the current month.Thanks,Debbie

Hi there,We have acquired another company that also uses Airtable. Both we and the new company have our own client lists in Airtable and we would like to combine these, as we have some shared clients already, without (at this stage) merging the Airtable bases in their entirety.We would like people from both sides of the business to see each other's clients in one place, so that:1. we can see which clients are shared2. we don't create records for clients that already exist in one of the basesNew clients added in one base should be updated in the other base too.Ideally, clients should be able to be created in the existing 2 bases and update across, rather than created in a new 3rd base, but if that's not possible then that's fine.The clients will be linked to other tables in the respective bases and these linked fields should be displayed (via plain text if needed) in all bases.Does anyone have any ideas how we can do this? We've c

Hello, I want to use forms to let people outside my organization link records among my existing tables. I don’t want to let them create new records. Just let them link one field to another. Is there a way to achieve this through forms? I’m having trouble with the primary field being just a string of text. Ideally, someone could select the primary field from a dropdown, and then link whatever they want to to that specific primary field, without creating a new record. Use case example I have a list of companies as my primary field. I want someone to use forms to pick a company and associate it to a topic (currently linked to a Topics table, it basically acts as a multiple select).

Hi. I've not really used forms very much, so please bear with me!I would like to have a form, accessed from a unique form-record-URL, that allows anyone with the link to access only the attachment field in a record, so they can view or download (but not edit or delete) the attachment.Is this something that can be done with forms?Very many thanks.

Hey everyone,I have a 2 formula fields that generate prefilled form links. The forms are nearly identical and contain a number of linked record fields. I have noted that some of the prefilled linked record fields fail to prefill when opened with different Chrome profiles, or on Safari, on my own computer. Here is the spread of variation:Chrome Profile 1: Everything works as expected across both formsChrome Profile 2: For given records, both form links failed to load (Chrome says the page is unresponsive). I have not determined a common cause across records who's links fail yet. When the form links do load, there are (2) linked record fields that do not prefill.Incognito: All form links load (including those that do not load in Profile 2). 1 form works fully as expected, the other has (1) linked record field that does not prefill.Safari:  An inconsistent mixture of all anomalous behavior referenced above.I understand tha

Not all data records are stored in my table A, so some fields are empty. Now I would like to fill the empty fields using a form. is this possible?Approach: I would have to select the data record or data from the primary field so that the data records to be updated can be assigned correctly. so that the missing data is added when submitting the form.

Hi Airtable Community,I’m currently managing a database where payments are recorded in a “Payments” table, attendance is tracked in a “Attendance” table, and student information is kept in a “Students” table, all to maintain good data normalization. However, I’ve run into a significant issue when trying to create a “Debtors” table. Creating a unique list of student-class combinations from the “Attendance” table was not as straightforward as I had hoped. It required exporting the data to Google Sheets to generate that unique list. Additionally, I was able to automatically link each payment to the attendance records by using an automation based on a shared key (student-class-period) between the payment records and the attendance records. These challenges were overcome, but they clearly could have been handled more efficiently if Airtable allowed data from payments to be transferred indirectly. However, since relationships i

Hello, our team is using AirTable in a Scrum environment. Each sprint we point our stories and calculate our velocity. Currently this is a manual process. Is there a way to automate in in AirTable?

I want to monitor a specific field in a table called countries that stores comma-separated country codes like “GB, US, ES, SG” etc. If the data in the field changes in some way (i.e. a new territory code appears) then I want to trigger an automation (e.g. send a slack message) but I ideally want that automation to flag exactly what changed (e.g. “TH was added to the country list of record x”). Is that possible with Airtable’s existing functionality? i.e. that you can catch the specific change that triggered the change event? Thanks for any thoughts!

Is there a way for notification automation to send link to the record from interface instead of base?

Hi. I've a simple contact us form and that form also records date and time of a new entry. Is there a way for a new record to show up automatically on top of the base as opposed to bottom?

I need to create a form that includes a dynamic table-like structures within a question, where you can input multiple rows of data (objects) and assign a different value (like a dropdown selection) to each row in a grid format, and syncs this data to Airtable with one object per row and each selection per field. Furthermore, I need the system to recognize if an object has been submitted more than once and not add another row, but rather add the 2nd requester name to an existing row. Has anyone been able to figure this out? Thank you,

Here's the context1) - Send a weekly form to the teacher to update the student's training progress.2) - allow each teacher to access student data only3) - Teachers must be able to update fields or data at any time4) Student fields should be pre-filled when the teacher selects the student (e.g. from the student's @email).5) Send a reminder message to the teacher if the weekly Feedback is not filled in (e.g.: start date+ xdays). 

Hi guys, Just trying to achieve the following. No luck so far. It’s a way to reduce inventory numbers of products based on the available qty of the parts that make up that product. I’d like for this to be nested. So if we have a wheel that is made of [tyre,tube,rim] and a bike that is made of [2 x wheel,1 frame etc], if we increase the qty of tyres, we will increase the qty of the wheels which will increase the quantity of the bikes buildable.eg. Table 1. (Products) Tyre Tube Rim Wheel Frame Seat Handlebars Bike Table 2 (Bill of Materials) Wheel - 1 x tire, 1 x tube, 1 x rim. Bike - 2 x wheels, 1 x frame etc. I can get it to work with one level of BOM. So if I had it as Bike = 2 x tires, 2 x tubes, 2 x rims, 1 x frame etc it works well. I’ve tried countless things to try have it work with nesting but I haven’t solved it yet. Any tips of the method to use would be great. Obviously, it has to

As I'm not entirely confident of the following, grateful if anyone can confirm if my understanding is correct before I upgrade to the Business plan.On the Business Plan:I can share all pages in an interface via a read-only link where users cannot access/duplicate the base dataI can prevent these read-only users from sharing the interfaceI do not have to pay extra for read-only usersNote: In my use case, all users will be airtable users and I'm not considering the public link option as I want to keep the Overview page viewable to my users@Vic_Airtable 

For the audit log events API, when I submit a startTime and EndTime .. the answer back is in UTC or local time ? if it is in local time, according to what setting is set ?

Hi guys,I currently have a status filed (New, Opened, Responded). I have the "New" and "Responded" sorted via automations, but is there anyway to update the "Status" from "New" to "Open" when someone opens the record within an interface screen.Any thoughts or help would help massively!