Ask the Community

i can t create an api key I don't even see the option  

Hi all,Ok - new to Airtable.https://airtable.com/appbgoYJec9KPYoqi/shrYzlz5OShqp6xpLBasically, i'm creating a timing sheet for a racing event. I'll add the times manually as the event progresses, and I want the crowd/competitors to see the details on their mobile devices WITHOUT HAVING TO REFRESH PAGE EVERY TIME.I initially thought this could be done by embedding an iFrame on a Wix site, but iFrames don't update automatically. Well, the LINK does, but the page doesn't.So then I thought maybe I could just share the view with the "share link to this view" feature, but that doesn't update automatically either.The only other thing I can think of at this stage is to get everyone to install the Airtable app and have them view it through that? Is there a way to share the link so that they can somehow see it, NOT be able to edit it, and don't have to refresh the page to see the updates that I'll be adding over the course of the event?Kind regards,Jim

HeyI want to build a "lessons" table with all the lessons that I have with my students.I want to recursively schedule an event each week with part of my students (like I can in Google Calendar)Is there any option to do it?thanks

How to Create Formula that Returns the Data in Field 1 (if data exists), or Field 2 (if no data in field 1 and has data in field 2), Same for Sequentially Fields 3-5? I see there are several posts on how to choose a “text” result by writing that text in the nested IF statement. However, I am looking to return the data in field 1 (check this field first and return the data in field 1 if data exists in field 1), and if no data exists in field 1 move on to check field 2 (check this field next and return the data in field 2 if data exists in field 2), and if no data exists in both fields 1 & 2 move on to check field 3 (check this field next and return the data in field 3 if data exists in field 3), and if no data exists in all three of fields 1 & 2 & 3 move on to check field 4 (check this field next and return the data in field 4 if data exists in field 4). There are 5 layers through field 5. Thanks so much in advance for your insight and time! I appreciate it.

I want to sync PDF files via Google Drive however this method renders a low res PDF and the important copy that I need the reviewer to approve is not readable.Is there a way to stop this or is loading the attachments manually the only option?Thanks!

I'm trying to send data with a series of prompts to chatgpt and get a response of each item back into Airtable. I want each subsequent result to be based on the whole conversation so far. When I try and run this as an automation I keep getting a time out error.Can anyone help?Here is the code I have:let table = base.getTable("Brand Guidelines");let view = table.getView("Grid view");let records = await view.selectRecordsAsync({ fields: table.fields });const apiKey = 'OPENAI-API-KEY';const url = 'https://api.openai.com/v1/chat/completions';// Set the batch size (adjust as needed)const batchSize = 10;for (let i = 0; i < records.records.length; i += batchSize) {const batch = records.records.slice(i, i + batchSize);for (let record of batch) {// Initialize the conversation contextlet conversationContext = [];// Start the conversation with clientDescriptionconversationContext.push({role: "system",content: "You are assisting a client with the following request:\n" + record.getCellValue

hai my name basi , from india in my airtable i trying to make summary table for purpose of make an interphase, Our airtable  have a two table name as, 'JOB NO' and 'SUMMERY copy'and in 'JOB NO' have 3 fieldwhich has ,'EMPLOYEE' - employee name'DATE2' - it formula field with like this '9/8/2023 12:00am' in date phrame'DUTY TIME' - duration fiedso i am try  convert the 'JOB NO' data in to another table like thisif  TABLE 'JOB NO' DATA LIKE THIS :-BASI--11/07/2023--2:0SKIL--12/07/2023--5:0BASI--11/07/2023--1:0BASI--12/07/2023--2:0SKIL--13/07/2023--5:0'SUMMERY copy' need BE like this :-BASI--11/07/2023--3:0SKIL--12/07/2023--5:0BASI--12/07/2023--2:0SKIL--13/07/2023--5:0employee name need in 'EMPLOYEE' in table 'SUMMERY copy'date need be in 'DATE' ( date field ) in table 'SUMMERY copy'sum of duty time from JOB NO in 'SUM'( duration field) in table 'SUMMERY copy'this script made by chatgpt   let jobsTable = base.getTable("JOB NO copy"); let summaryTable = ba

Hello,Hope someone can help me here. I would like to change one character in the URL when 360 Edition is selected which corresponds to the selected Record. I imagine it would be something like if Record I is selected the URL is "360-Edition-Record-I.pdf" if Record II is selected "360-Edition-Record-II.pdf" etc.How can I achieve this?    IF( {Edition} = "360 Edition", "https://www.dropbox.com/.../360-Edition-Record-I.pdf?...dl=1, "https://....." <- URL for when 360 Edition is not selected )    

Hi everyone, I noticed that when you setup a “link” field that links to the SAME table, the actions are NOT reciprocal. (It is reciprocal if the link fields are on different tables). Any way to create a reciprocal link field within the same table?

Hello everyone,I'm trying to use the filterContains URL parameter in a shared view with linked records. The issue I'm encountering is that this parameter only displays records when they exactly match the value provided in the URL, but I'd like it to function more like the filters in Airtable.For example, the Primary Field contains numbers, and I want to use the URL filter to display all the records containing one number (let's say 1...).That's what my URL looks like right now:https://airtable.com/appFS2avSSJRUpu7Z/shryOSrtr0WQfI3FQ/tblhf3jVTnogU7Yyz?filterContains_Table+2=1  

Hi,I would like to know is it possible to have a roll up or look up for a field that is is multiply tables lets say 3 to 15 the is a number value and have it show up in a primary table that all other tables a linking to?I am hoping to make separate bills of materials (tables) that link to my primary table witch is a list of stocked items and used item that need to be ordered.any help of info would be greatly helpfull. 

Hello,I have an issue and I already asked airtable with no hope for any replies whatsoever. I have over 80$ of credits that I transferred to my workspace. I am subscribed to a Team Plan and it says that my available credits will be automatically deducting the invoices that will come through. Instead, it goes "Charge failed" multiple times and now I have a 3 days notice before they force me to a free plan. I paid with my credit card before, but since I invited my coworkers and applied the credits. It hasn't even deducted anything. Instead it WANTS ME to avail of the plan YEARLY or another plan upgrade MONTHLY in order for the credits to be applied. I just want to remain in the monthly of my current plan.

On September 3rd I received an email that our automation limit had been reached. This is not likely, not in three days, I checked run histories and all is good. The only limit that we exceeded was the 100 external emails a day. This shut off all automations not just emails. Airtable is now unusable for our team.

Is there a way to search for records based on historical data, specifically transitional statuses? Say a record was in Status A, went to B, went to C, went to D. Is there a way to see all records that ever entered status B

I want to display the week like a calendar, but this formula is returning week 1 as starting on a sunday instead of a week starting on a monday and finishing on a sunday, how can i alter this?VALUE(DATETIME_FORMAT(Date,'w'))-VALUE(DATETIME_FORMAT(DATETIME_PARSE('01'&DATETIME_FORMAT(Date,'MM')&YEAR(Date),'DDMMYYYY'),'w'))+1

Newish to AirTable and trying to figure out the best way to do this and can't seem to sort it out. There is a lot going on with my base and I'm stuck with this part. I'm going to try to simplify what I would like to do... On Table 1: I have created an automation to email out an AirTable form to everyone on Table 1 (which has a trigger linked to it for something else) with the AirTable form and data populating Table 2 All of that is set up and is running smoothly - This is where I'm getting stuck. I would like to create an automation to RESEND a reminder to complete the form X number of days later to anyone who has not completed the form yet. Is there a way to do this? Workarounds, formulas, ideas all welcomed. *Extra info: Reason its going into Table 2 is other people who are not on the Table 1 list may also be completing the survey 

Hi,I am making what to me seems like a simple change to a simple IF Formula. The prior version of the formula was: IF({Money Out},-ABS({Money Out}),IF({Money In},ABS({Money In})))This is the new formula. IF({Money Out},-ABS({Money Out}),IF({Money In},ABS({Money In})),IF({Debit or Credit},{Debit or Credit})) For some reason, even after I press "SAVE" after updating the formula, when I go out of the field and come back to the field, I see the prior version of the formula. I do NOT get any ERROR messages.  And tried repeatedly to update the formula. I have tried the cache refresh with Com + Shift + R I even closed all AirTable browser windows, and logged out and logged back in to AirTable. No Joy. Any help would be welcome.   

So I have still not heard back from Customer Support with my question regarding upgrading to a Business Plan. It's quite frustrating as it's an honest question on how to transition to the Business Plan from the Pro Plan. I have a client that just paid for an annual subscription around month prior to the announcement of the restructuring of Airtable plans. So in essence, there would be around 9ish months remaining on their Pro Plan.I want to know if anyone has upgraded from the Pro Plan to the Business Plan and already had money remaining on an annual subscription. More specifically transitioning from one annual subscription to a new one.If YES, how did you transition from the Pro Plan to the Business Plan?Thanks in advance! 👌

Hello, I am struggling to connect Matlab to Airtable's API. All calls that I make to post are returned with 422: Unprocessable Entity, no matter how I configure the data structure. I can successfully make get calls with Matlab's webread(), but fail with all webwrite() posts. I have also performed posts with python using the same authorization key. This tells me that my link, authorization, and write access are all working and it is a problem with webwrite(). I have tried formatting the data in many ways as shown by the screenshot, primarily attempting using structs or nested structs as the data entry. Even using a key value pair directly in webwrite() all gives the same 422 error. Following the Matlab documentation on these functions explicitly yields these same results so any further insight would be greatly appreciated. Thank you. 

Hi. Can I send emails to my customers via Airtable?I mean, can I do it directly from the client's profile and have the entire email history stored in the client's profile? Also, I would like the emails that the client sends to me to be immediately delivered to the client's account in Airtable. The idea is that I can correspond with the client without using my Gmail account.Thanks.

I am sure it is quite simple, but for some reason, I can't find the way to do it.Let us say I have Table A. In the Table A, I have, amongst many others, a Date field.I also have Table B, with two fields in it. One field is a (unique) Date. The other field is just a number. Let us call it [Day Number].[Table A/Date] and [Table B/Date] are not linked.I just want [Table A] to look at its own [Date] field, then search for the corresponding [Date] in [Table B] and retrieve the corresponding [Day Number].Must not be very difficult, but I can't find the way! 

In airtable it is possible to take an extented free trial (similar to team plan) if you are a student. In the discription on the website of Airtable.com can you find that this trail is '6 months to 24 months'. How long is this student free trial then? 6 months or 24 months? Or somewhere in between?

Even though I believe this is an Airtable support question, I'm posting here because that's the option I have.I have a client with about 10 interface pages. On one of these pages, the graphs are in a constant loading state, or say "Internal error, please refresh". All other pages are loading graphs just fine.These graphs are from different tables within the base, so it's not just one table causing issues. I tried duplicating the charts and deleting the older ones, but that didn't help. Wondering if anyone else has experienced this? Is this a result of pricing tier changes? This client is on PRO (Teams).

Hi, I wonder if you can help me.  I’m stuck with a linking problem between tables in bases.Scenario:  We have several clients and some of them have completed a feedback survey(s).  I wish to create a column that counts the total number of feedback surveys completed by each client.  Clients are stored in BASE1 and completed surveys are stored in BASE2.  I have activated ‘Sync data to another base’ to make the survey table data available in BASE1 and that is all working fine.I then created a ‘Link to’ column in the Clients table and pointed it at the synced Survey table (both in BASE1).  I was expecting this ‘Link to’ column to be automatically populated with a unique reference to the survey number(s) or be blank if no survey existed.  Instead, the ‘Link to’ column is entirely blank and when I click into it, I get a pop-up to create a relationship between individual data points in the Clients and Surveys tables.  I don’t want to create individual r

Hi, When using the Slack actionable messages integration in Airtable automations, I receive the following message in Slack after pressing a button : "You do not have access to this Airtable record, or it has been deleted."I set up the automation to send the validation to a specified user when a new record is created.The user can choose between "Option 1" and "Option 2". They update the same select field having the values "Option 1" and "Option 2" in Airtables.Yet after pressing the button, the update is denied in Slack.I have the Airtable app installed.Any idea ?