Ask the Community

I imported (not thinking) over 1,000 .csv records into one of my Free dBases.What will happen to the excess records?

I'd like to build a field that returns the days until due if >0, or "Assign Due Date" if Nan, or "Passed Due" if <0.I am struggling to combine the IF statement with the following formula:DATETIME_DIFF({Deadline},TODAY(),'days')Any tips on how to accomplish this? 

Hi, community! I'm sure you'll be able to give me some ideas to figure out the best way to accomplish what I'm trying to.I have a base with 6 tables: Check-in, Market, Business, Operations, Traction and Finance.Forms with data will arrive in Check-in table. Since is a lot of data for the customer to fill in one time, we had to split fields in 5 forms which collect the real values of customer business and 5 forms collecting projection values.Customer will answer this every month, so we have an Evaluation Month field in every table. Also, and that's one messed up thing, they need customer be able to send data in more than one form. So this would work something like, on first month, customer knows 4 of the 8 questions, he will send a form with these 4 answers; then, when he gets the other 4, he will send another form with the other 4 answers. Please, consider we can't ask our customer to send only one form per month, despite this was the easiest way to solve the pr

Time zones are difficult to handle within AirTable. Here is an example that gives me a headache. I have a table (let's call this table Calendar) in which there is, among other things, a Date Field associated with an event occurring at a Location. Strangely (in my opinion), I cannot set the time zone in the Date Field in question.In another table (let's call it Locations), I have the list of Locations in question. I also have a Cumulative Field that aggregates all the event dates related to this Location in my Calendar table. However, in this Cumulative Field, I can choose the Time Zone. Naturally, I choose the time zone in which we work.The result is that the event dates in these two tables are in different time zones. The Locations table operates in the EDT time zone while the Calendar table operates in the GMT time zone.How can I make my CALENDER table work in EDT? 

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 }];

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'r

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

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 in

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/recordID

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

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 🙏