Ask the Community

Hey everyone. I have a public URL link that I'm trying to use to upload to an airtable attachment field with airtable scripting. This is my code (the URL is obtained from an API call response): "let existingAttachments = recordA.getCellValue('attachmentsA');let updatedAttachments = existingAttachments ? [...existingAttachments, { filename: fileName, url: responseData.pdf }] : [{ filename: fileName, url: responseData.pdf }];await tableA.updateRecordAsync(recordId, { 'attachmentsA': updatedAttachments});"My issue is that sometimes this works and sometimes it doesn't, without any aparent pattern, and I know that the URL from my API call is always correct. When I go to the airtable record and see the activity it shows me that the attachment was uploaded and deleted, but I don't delete it in my code.Does anyone know how to solve this problem? Thank you! 

Hi everyone,Everything works fine, but I would like to have a button that redirects me to the salesforce record when clicked.The JIRA integration has something similar.Has anyone found how to do this?

Hello!I realize that Airtable most likely wants to push forms to be built via Interfaces, but of course, many forms have already been built by users in the standard table views. When going to a form view within the table (not Interface), we get a popup window that states the form has been upgraded and then two buttons: "Edit Form View," which lets us edit in the old form view option within the table, or "Go to form builder," which takes us to the interface version. The user responsible for this base is not interested in using the Interface version at this time and so they click "Edit form view." However, what is annoying is that every time the form view from the table is brought up, the popup has to be cleared yet again.We understand that there are two ways to approach this form now. The interface version hasn't been touched and is not shared, while the older version is linked to and shared.Is there something we're missing that will allow us to click the button once and be do

I'm developing a Block Extension. When I type block release I get"Error: Your Airtable API key is invalid. Please use block set-api-key to update it. Code: airtableApiWithInvalidApiKey"Since api keys are deprecated (I have deleted my key and can't create a new one) I have created a personal access token. But I can't get it to work with block release; running block set-api-key <my-personal-access-token> returns"Error: Invalid Airtable API key specified. Make sure you copied it correctly from airtable.com/account. Code: airtableApiKeyMalformed"How do I use my PAT with Blocks?  

I am trying to updated a linked record via Siri Shortcuts. I keep on getting error “value is not an array of record ids” The update is done vie Get content of URL. Request Boyd JSON. I figured out the id of the record that I am trying to link to. I tried setting the fields text to the record ID but I still get an error.

Hello all ! im trying to send automated messages to whatsapp when a record is matches conditions. Ive been trying to do it via Twilio, but having a hard time, any suggestions? 

Hi everyone,I have a table where I import record from a Salesforce reporte.g. https://support.airtable.com/docs/airtable-sync-integration-salesforceEverything works fine, but I would like to have a button that redirects me to the salesforce record when clicked.The JIRA integration has something similar.Has anyone found how to do this?

Interface designer pages can now be shared publicly. 😁😁😁 This feature is still in beta, and comes with a warning that some hidden data may be exposed.An example that Airtable gave in the docs explains that even if a chart in an interface page shows only combined values, it is possible that individuals could find the specific numbers behind those totals by examining network logs."Consider the dashboard below that shows data for 28 deals in the pipeline. The chart shows the sum of the all the estimated value of each deal per stage. Even though you can’t tell the deal worth for each of the individual deals by looking at the chart, if you inspect the network logs, you could see the individual values for each deal."Personally, I'm holding off on sharing interface pages that contain sensitive or confidential information. If I had to share, I'd check the network logs to make sure no sensitive data is being exposed unintentionally. 

Can anyone figure out why im getting the following? My goal is when a record is updated with a CSV file, I want to convert the CSV file into a list of records that I can then use elsewhere. This is in conjunction with an automation.CONSOLE.LOG"Script started"CONSOLE.LOG"Record ID from input config:"undefinedCONSOLE.ERROR"No record ID provided in input config."CODE BELOW SHOWN BELOWconsole.log('Script started');let tableName = 'Fabrication Package Members';let attachmentFieldName = 'Assembly List';// Function to parse CSV text into an array of objectsfunction parseCSV(csvText) {    const lines = csvText.split('\n');    const headers = lines[0].split(',').map(header => header.trim());    const records = lines.slice(1).map(line => {   &n

I saw what looks like support for type script in airtables online IDE but I couldn't find any documentation on it. I'd like to get rid of some of these type errors that are populating my code.  

I have 5 supervisors that I am wanting them to "review" workers for each shift of an event.  Ideally, I want a way for the supervisors to be shown a blank table where they write their own notes for 6 different fields for each worker without seeing the notes that other supervisors have written.I don't care if they see their old notes...or if their entries disappear from their view altogether after filling in the data.I would need to be able to see the entire table with everyone's entry.Is this a possibility?   

Hello!I have a formula field that calculates the number of hours between two date fields. I want to then parse this into categories based on the duration:A = hours ae greater than 96B = hours are greater than 24, but less than 96C = all remaining positive values less than 24D = hours are negativeThank you!!

Hey there people,I have been browsing the community forums and YouTube videos to fix my problem, but I can't figure it out. I always get errors I don't manage to fix, I'm hoping someone can explain me what I'm doing wrong.Context & Goals :I ingest data from a real estate website that provides me properties from 2 sources, Source A and Source B.I put this data in Table 1.I have everything I need for Source A, however I have very limited data for Source B.I therefore set up a distinct data (Table 2) ingestion for Source B, that contains the most important data I need (Description).My goal is to push into Table 1 the descriptions from Source B I have in my Table 2.The best I found to match entriesIn my Table 1, I have records is the URLhttp://www.sourceA.com/recordIDhttp://www.sourceB.com/recordIDtooIn my Table 2, I also have URLs, but it's not precisely the same formathttp://www.sourceB.com/recordIDtoo/?alotofthingsI therefore created a formula column, truncating http://www.sour

Hi. I've bumped into an issue when I want to send an automated email based on a field containing an email address. I've got two fields, one lookup that shows me the email address based on a selection from Email-Committee List. Help articles suggest using this formula -->> CONCATENATE({Committee's email (from Email-Committee List 2)}, "") but when putting --Calculation-- field in the --to-- field in the automation it comes back with the message that "The "To" input is empty" and I don't know what I'm doing wrong there.

I am creating a budget and have amounts incoming at various frequencies. I want to create a field that calculates the monthly amount based on a formula. This is the formula I have got but I get an Invalid Formula error message:IF({Frequency} = "Daily", {Amount} * 30,IF({Frequency} = "Weekly", {Amount} * 4.33,IF({Frequency} = "Bi-weekly", {Amount} * 2.167,IF({Frequency} = "Monthly", {Amount},IF({Frequency} = "Quarterly", {Amount} / 3,IF({Frequency} = "Twice-Annually", {Amount} / 6,IF({Frequency} = "Annually", {Amount} / 12,0 // Default case, if none of the above matches)))))))How do I need to correct it?

Hello, this is an airtable newbie question:I have searched here, watched videos, and am completely failing with the following problem:I want to create an automation that sends a mail to ALL mail addresses contained in table 2 when a data record is added to table 1.I have the trigger, it works, it's simple.In the actions, I only have access to the data of table 1 in the To: field (where the mail addresses should go), not table 2.How can I access the data of table 2 at this point?Does anyone have a comprehensible tip for me?Many thanks in advance for your timeBoris

Beginner here, asking a question which has no doubt been asked a lot and probably has a simple, obvious answer! Apologies in advance...I have one table containing all of our customer bookings. In this table there is a formula field that takes the date that the booking was made and assigns it a week number based on a weeknum formula.I have another table where I have the week numbers listed from 1-52 in a field. The outcome I want is to have other fields that adds up figures from the customer bookings that took place in the same week number. Simple SUM-like formulas that add up how long the bookings went for, how much they cost etc (all of which are fields in the original customer bookings tables).I'm not sure if I'm using the correct terms when I am googling this info but I haven't found anything that helps as yet.I made a mock base that might better show what I've got and what I want Basically, I was hoping to have those Total hours and Total $$ fields autofill with the details based o

Bar graphs are super useful at looking on your data. Often, a 100% bar graph is really needed to compare categories.In this example, I'm comparing the effectiveness of different messages. Currently, as each message type was sent a different number of times, a precise comparison is not fully visible. If the graph was a 100% graph, the comparison would be obvious and easy. This is why Google Looker studio and other products are offering 100% bar graph and not just the regular bar graph.Attached is the bar graph from my example, and a (random) 100% bar graph.

 Hi there, I hope I'll find a smart head here that will help me tackle this issue. I have two automation working on the same basis, we get an import from G Sheet, there are numbers there and we want to make the specific fields into a unified table, to create a 'clear' view with all crucial data in one place.One automation takes the numbers and places them like it's asked, but the second one keeps on screaming at me "Field cannot accept the provided value: Could not parse number." This is really confusing as there are no operations run on both of them, just simple data, and one works, whereas the other is just being difficult. Any idea what can be causing that? I thought that it just can't do numbers but one works so it's not that, both are done the same way and the issue still occurs. 

Hi All I’m creating a budget database and need some help trying to figure out how to create a formula in one table that pulls values from another (not even sure I can do this). I have 3 tables: Income table where horizontally the months are listed with a value and two wage types are listed vertically and it is auto-summing at the bottom of the table. I need the combined monthly income to pull into Bill table where each month is listed horizontally and each bill vertically…and the amount of each bill for a given month is listed. Budget to Income table…here’s where it gets messy for me. I need the combined income from the Income table for each month to drop to the appropriate month field… I need the combined value of each month from the Bill table to drop to an expense line by month Is there a way to do this? Emma

Hi, I don't know if it is possible and I don't how to do it, or if it is a feature that is still not available in airtable.I have 2 tables: Reports and Users.I divided the reports by categories (1,2,3 etc), and I created different views for each category.I would like to lookup or rollup the category in the user table based on the different views that I created in the report table. In this way, I will filter the users by the categories, and I can apply some automation. Without this feature, I have, for example a person that has this: I would like, for example, that this person has only the code "5" and filter all the other data based on that.Is there any way that I can do this? Thank you 🙏

HI there–this question has come up before but there has been no useful reply from Airtable. Seems like several people would find very useful the ability to remove the “view larger” link from web site embeds. This option takes users away from one’s web site and also I have a private group so I don’t want people outside the group sharing the table with anyone. Can the “view larger” link be disabled? I am a pro member and I’m surprised this is not part of the customization option. Thanks!

I want to store the total number of employees in the programs table to calculate the participation rate. Additionally, I'd like to break down the number of employees by position to calculate the participation rate for each position. I have three tables: Programs, Employees, and Tasks. While I can easily count the number of employees who complete each program or task, I am struggling with creating a field that sums the number of employees from the employee's table and places that total in the program's table to calculate the participation percentage.

Hello everybody,Until know, what I've been doing on my Airtable databases in terms of naming is I use:- the singular for fields that contain only a single valueVS.- the plural for both fields that contain multiples values and tablesEx.: In my 'Invoices' database (see attachments), I use 'Service' in the Line Items table because each line item matches only one particular service, but I use 'Services' in the 'Invoices Receivable' table because there are usually multiple charged services on one invoice.While battling with Documint in order to automate the generation of PDF invoices, I figured that this discrepancy might be the cause for problems in data retrieval.=> Do you have best practices to suggest in terms of field/table naming?I would very much appreciate our help on this one.

Hi Community, Relatively new with Airtable (6 months or so) and struggling to create an automation that in theory seems quite simple, but I've tried everything and can't seem to crack it...ContextI have a table for invoices, where each invoice can be set as either an "Invoice" or "Additional Invoice". the invoices table also has fields called "Original Invoice" (Linked to other records) and "Additional Invoice" (Linked to other records).Desired Automation/ExampleI create a new record in the invoices table (Record B) and set it as an "Additional Invoice", and then, in the "Original Record" field, I link to Record A. (In other words, I am setting that Record B is an "Additional Invoice", and it's "Original Invoice" was Record A) When Record A is linked to Record B as above, I want Record A's "Additional Invoice" field to be populated (linked with) Record B automatically. - Rather than having to go into Record A, and linking it with Record B manually.If anyone could work out the