Ask the Community

I have searched Airtable Help and Google and haven’t located a solution for the following issue: I have created simple formulas in Currency and Number fields. The results are always rounded up. I’ve tried different options (Integer, decimal places) but they made no difference. How do I get Airtable to show the correct result without rounding up? Thank you!

I have a target base in a Workspace that is synced to several other bases all in one separate workspace. If I move this target base into the same workspace as the others, will this cause any issues with syncing or interface design?

Created a basic table in Grid View. Shared and embedded the List and was able to select multiple records, then select Download CSV and export the selected records. Nothing changed in the table, share, etc but now when selecting download CSV the selected rows are unselected. Even if all Rows are selected as soon as Download CSV is clicked the selection clears. In have searched the community and entered a support ticket and it does not seem like anyone has an answer here- I can download my entire table as a csv but that is not what I want- just want to choose the selected rows

First post here- I know I can easily build a form and connect results to Airtable- but can I connect a Form to an existing table for the user to select data from it? I have a table of workers by department with email address- I want the user to be able see and search this table (no problem) and then select users by email address from the table entries that will be submitted with the form.

I have a co-worker who can't "star" any bases on his homepage to favorite them. He can star the one workspace he has, but not the bases. When you hover over the base, the greyed-out star isn't there. When you click the three dots, there is no option there to "star." He has creator permissions for the workspace. What am I missing?

Hoping for some expert guidance on this approach building a reference Table to our BOX folders. AirTable created based on a BOX file report. Zapier BOX Find by filename is working. Import of text fields works as expected. looking for assistance on how to capture a “thumbnail” image (.png 94x94) in an attachment field. Is there a way through Zapier to pull and populate an attachment? I may be jumping too far ahead, but would this require an automation/scripting block using GET? developer.box.com Get file thumbnail - API Reference - Box Developer Documentation Explore the Box APIs and SDKs to use for app development, API documentation, developer support resources, and access the Box Developer Console Thank you! p.s. we have other AirTable direct BOX syncs that are great since thumbnails are imported, but this table contains files distributed throughout hundreds of BOX sub-folders.

I use the Mac Os App and I'm used to have several windows for several bases/interfaces open at the same time but, for a few days now, I can't do it anymore. The option in the "File" menu of the app is unavailable and I have no idea why. I tried to uninstall/reinstall the app and it's still the same...Anyone have the same problem ? Any solution ?Thanks in advance

Hi, I am trying to count the number of months from the Start Date till today.  The actual day of the 'Start Date' doesn't matter.  For example, if 'Start Date' is 9/20/23 and today is 12/11/23, I want to count the number of months that have passed: Sept, Oct, Nov, Dec = 4.  I have tried this formula: DATETIME_DIFF(TODAY(),{Start Date},'months') but, I know that doesn't work. I have been searching the community and haven't found the right solution.  Any help would be appreciated.

I have added the collaburators by mistake and I got charged from Airtable about $1,200 so Can I get a refund? please help me… :disappointed_relieved:

If you pay for a Team Plan for your Workspace and another person adds you as a Collaborator to a Base they own (and they also pay for a Team Plan), are they charged for you as a Billable Collaborator too?

Hi Team,Would it be possible to limit the number of decimals in Interfaces charts? Please see the example below. The data is not very legible because there are too many decimals after the coma, when calculating an average. Thanks

Hey Community, i have created a Base for placing Orders. Next step was to create a Formular for easyer placing a Order for everyone.  CheckI have a Question. I would like, when someone start to place a Order wirt Formular an check/select one Field/option (like "oversea" ) that a Explanation pops and show a long Text (like "Please place this and take this and after thant send email to yada yada yada thanks") Some kind of "how to" before he submit the Order to Base.Maybe is posible to define some Text chunks and display them in some sorf ot IF-THEN when different Fields/Options are selected.Thanks for any ideas or advice!

Preamble: I’m still working on implementing some features in the Scripting/Custom blocks which I think would remove the need for most of the Airtable API calls the proxy server is making. But even with custom blocks, I think I will still need a “get records for base” call that needs authentication. Setup: Node.js app (12.x), Airtable.js (0.8.1). API key stored in .env file that’s loaded into process.env. My application relies on a setup like @Bill.French described here where there is a central “directory” that has a record per Airtable base. My proxy server can return a list of these records, which in turn gives me the Base ID to make CRUD calls to that individual base. This works great and performs cross-base operations that suit my need. The question: Until now, authentication hasn’t been much of a concern. Most of the execution has been run locally, so I haven’t needed to worry about a 3rd-party user accessing/updating my bases by hitting random endpoints if they know the URL. And a

I am trying to format decimals in a formula to no avail: To the left is the number the 3rd column is what happens when this number is used in a formula (the end is cut off for numbers ending in 0) (e.g. 12.50 > £12.5 middle column is where I have formatted the number with this formula: so this was a solution found on another thread: IF({Refill / lowest price}, “£” & {Refill / lowest price} & IF(FIND(".", {Refill / lowest price} & “”) = LEN({Refill / lowest price} & “”) - 1, “0”)) However, if you now look at the middle column it works for the £12.50, but for any round numbers under 10 it misses the decimal place. (i.e. 5.00 > £50. Any help with tweaking this formula would be greatly appreciated! THANKS! :grinning_face_with_big_eyes:

HELP! I have a base with a table where I have collected submissions for an upcoming conference. There are fields for Speaker 1 Name, Speaker 1 Email, Speaker 2 Name, Speaker 2 Email, etc. I am trying to pull all the data from every record to another "Speaker Management" table. So I need all the Speaker Name fields (Speaker 1 Name, Speaker 2 Name, etc) to go to a singular field (Speaker Name) in this "Speaker Management" table along with the corresponding email contact for the record. The records are already there, but may update because I am using FillOut for people to update their submission content. I appreciate any thoughts!

My company is working to centralize our Zaps now that there's a service account feature through Airtable. However, we're running into the question if we should create separate service accounts with specific bases given access to (with the idea of least privilege), or just authorize a general Zapier service account that has access to all current and future bases?The latter seems to be a lot more permissions than necessary, but it is also easier. Would love to hear how others are approaching this. 

Hello Airtable community,I hope this message finds you well. I am currently experiencing an issue with creating a Vega-Lite visualization in Airtable, and I'm seeking guidance from the community.Problem Description: I am attempting to create a simple pie chart using Vega-Lite within Airtable. The goal is to visualize two categories, "With Tape" and "Without Tape," based on a "product_title" field.Vega-Lite Code: Screenshot attached. Issue: Despite trying various configurations, the visualization is not rendering. I have attempted simplifying the code, but no luck so far.Question: Is there anything specific to consider when using Vega-Lite within Airtable? Any guidance or insights into what might be causing the issue would be greatly appreciated.Thank you in advance for your assistance!Best regards, Lewis

Hey All, I built an Airtable base for a consulting client and their flow relies heavily on being able to print information from Airtable. I set them up with 6 separate Page Designer extensions for them to do so. They're having a consistent problem when trying to print a custom size paper.- it jams in the printer every single time. They've tried it on multiple printers and had their printer tech review as well. They're not having any issues printing when the page is a typical 8x11in size. The size dimensions for the custom page is 545x545 px and I've set the printing size also to 545x545px. When they try to print this page as an 8x11 it does print and there's no issue except that the content is only at the top of the page and they already have custom size printer paper they want to print on (not print and cut each page). Can anyone see why this may be happening? I've run out of all printing thoughts and they're a remote team, so I can't review the printer in person.&

Hi,I have a database with special dates of each month (Christmas, Halloween, etc). I'm using the DATEADD formula to add 1 year to a date field.For example, for Christmas I have the date 24/12/2023 and I expect the DATEADD formula to result in 24/12/2024 (field "Próxima Fecha" of my attached screenshot).However, I'm getting 23/12/2024 as a result. This happens with all the dates (gives 1 day difference).Is it a bug or I'm missing something?Thanks!

I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a like that goes to the favorites page, user B and C log in and see A's likes and vice versa. After speaking with the no-code platform, they tell us that the solution must be found by Airtable because it's the backend -> I'll share with you what XANO is doing. The idea is the same principle, but with Airtable if possible: https://www.xano.com/snippet/qCmG9KcL/J I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a like that goes to the favorites page, user B and C log in and see A's likes and vice versa. After speaking with the No-code pla

Hello,I have this javascript that i want to add in my automation in order to transpose a table but i always have this error message "Exceed quota 30 table queries". How to solve it? // Get the "Forecast artikel" table and the "Transposed" tableconst tableForecastArtikel = base.getTable("Forecast Artikel");const tableTransposed = base.getTable("Transposé");// Retrieve all records from the "Forecast artikel" tableconst queryForecastArtikel = await tableForecastArtikel.selectRecordsAsync();// Array to store updateslet updates = [];// Iterate through records in the "Forecast artikel" tablefor (const recordForecastArtikel of queryForecastArtikel.records) {// Get the article name from the "Name" column of "Forecast artikel"const articleName = recordForecastArtikel.getCellValue("Name");// Iterate through columns like "Tag 1," "Tag 2," "Tag 3," and so on in "Forecast artikel"for (let i = 1; i <= 31; i++) { // Make sure to adjust the upper limit based on the number of columns in "Foreca

I am working on a budget base, where each month has it's own amount connected to a milestone. I'm wondering how I can link a multiple choice field which refers to specific budget lines, to specific fields in the same row, which indicate monthly amounts. So if the multiple field refers to e.g. 'A' and the monthly amount for December field is e.g. '200', how do I make it e.g. '200A', while at the same time in the same row, I want November field amount e.g. '100' to be referring only to 'B' in the same multiple dropdown field, making it therefore e.g. '100B'. Just keep in mind that the milestone amounts are always different, while budget lines have fixed value. Thank you!

Trying to figure a code flow so that i can move some automation away from zapier and have them automated in scripting. the 1pm in delay just make it doesn’t work for our team.

HelloI'm looking for a solution to automate the transmission of a document "report of an interview" to a client.I had the idea to use the lookup but I can only import the name of the candidate. I would like to add a report in pdf or text (information in a table 2) in addition to his name 

Hey all, I'm looking at creating an order for that take information for our tables for internal orders. I've attached  a picture of what we are trying to create. Any help would be great. I'm stuck on adding additional line that can pull all the details; it seems to just pull the item detail