Have other Airtable related questions? Post here!
Recently active
Hello,I, like many here in the AirTable forums, have dealt with seemingly "random" file deletions. One of the issues with this bug is that it is often sporadic. However, I have recently refactored one of my cloud processes that processes data from a record, generates a data file (application/json type) and puts it back into the record. I have a consistent set of records that I can run this process on, and I can literally watch my process write in all of the files, and then anywhere from 1-20 seconds later I see the files deleted realtime! I know that my code is doing nothing to actually delete the files, and you can even tell from the record history that something is awry because the original file write is by our "Software" user and it specifies the Users token, and then the deletion is also done by the "Software" user but no token is specified (see attached screenshot). I feel confident that I have no old API key based processes that would be doing this action. (As an aside
Hello community!I have a problem, which I've been unable to resolve myself.I have two different tables, of which one table contains different entrees (table 1), which get combined in the other table in groups (table 2).Now, in the first table (table 1) with different entrees all entrees have a name connected to it.But in the other table (table 2) that groups these entrees the name should also be shown (rollup from table 1).Now the problem is that the groups of tables exists mainly from entrees with the same name. And if I show the name through rollup, I see the name many times, not just one time. I would like to only show the name once if the entrees all contain the same name.Hope my explanation is clear.Does anyone know how to do this?
I have attached below all the images.In number, it gives me 100.In percentage, it gives me 10000%but I want only 100%
The Team plan is $20 per seat/month billed annually. Does the "per seat" mean users? So if we have 10 editors, it'll be $200 per month? But the plan also says it includes unlimited editors. It's very confusing...
I often copy data from several fields at once, so I need to use a horizontal scroll to select all the data, which is not really user-friendly. That’s why I thought maybe it’s possible to create a button field that copies data from some fields of the same row and sends it to the clipboard. I did some research and figured out it can’t be made with built-in Airtable features. I guess custom scripting may help, but I’m not familiar with JS, so I have no idea where to start or if it’ll even work:sweat_smile: Any help would be greatly appreciated!
Hi Community, I am attempting to develop a QC DB for my international QC inspectors, in my dept we manage over 18,000 unique item id’s manufactured by over 400 factories, in 20 different countries . I keep a list of Item IDs and Factory IDs on a source of truth database which I have synced to my prototype inspection DB. For Simplicity Sake, these two tables, within source of truth DB, are as follow, Item IDs Table Primary Field( ITEM IDS) Secondary Field(Factory IDs-linked to Factory IDs table) Factory IDs Table Primary Field(Factory IDs) Secondary Field(Item IDs-linked to item IDs table) Within my inspection database, I’ve created 2 linked fields within the inspection table. Filed One(Factory ID-linked to factory IDs) Field two(Item IDs-Linked to item IDs) I would like the QC inspector to enter a factory ID in field one… after which I would like the QC inspector to select an item ID in field two… And alas we reach the issue, how the heck to I configure field 2(item IDs) to only popul
Hi guys, I have created a "date field". 3:19 pm is my current time, but once I had it created, it showed the wrong time - 12:00am, I tried to click "use the same time zone for all collaborators> GMT/UTC", but the time was still wrong. I don't understand which step I had made wrong.
Is there any way to change different versions of domains to its root domains? example: If we add Column 1 https://www.domain.com/ https://domain.com/ https://www.domain.com https://domain.com http://www.domain.com/ http://domain.com/ http://www.domain.com http://domain.com Column 2 Result in all rows of above domain.com
Anyone found a way to control the font size on Print View?
Hi there, I'm having issues with formatting when pulling data from Airtable into Formstack Documents (integration via Zapier). Detailed explanation below.The Profile field in Airtable has a large body of text and is formatted with line spacing between each paragraph. However, when I create a document merge via Zapier into Formstack, the formatting is gone in the merged PDF. All the other content in the document is fine as it's part of the PDF template, whereas this Profile section is dynamic so it must be pulled from Airtable. Other fields are pulled from Airtable, but they usually only go over one line so I haven't noticed any line spacing issues.I'm not sure if this needs to be resolved via Formstack itself, or if it's the way I've set up the PDF template in Adobe Acrobat. Or perhaps something else entirely.Any suggestions would be much appreciated!
Hi there -- I'm using Airtable to build a database of jounalists on Meta's Threads. I've made a form so people can submit their details: https://airtable.com/appWgEz1pjYySqFTj/pagzqw2grYU9luJob/form My base consists of four tables: Journalists, locations, publications and beats. The form primary creates a new record in the Journalists table, but I'd like to use the same form to add new records in the other three when necessasry -- i.e. if someone works for a publication that isn't listed.Is this possible? With apologies if this has been answered before -- I did a search around but couldn't see anything relevant.CheersDave
I’m trying to automate an order ID. So when a new row is added, it is given an automatic ID. The existing ID from pre-AirTable looks like: LS000000 E.g. LS and then six zeros. The first order should look like LS000001, the next order like LS000002 etc Currently I use: Field 1 - AutoNumber (AutoID) Field 2 - Formula = CONCATENATE(“LS00”, (AutoID)) Which gives LS001, LS002 etc. It looks right when we get to LS001000 e.g. all 6 digits now present. Any ideas how to force the six zeros from the start?
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
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?
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!
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.&
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
Who knows how to achieve this? If you have two tables that are linked together where each record can be linked to multiple records in the other table...My question and goal is... How can I quickly see one table in a way that shows each/one record with the sub.linked records one per line below it? When all the linked records are just in one field bunched up, it's hard to see all of them clearly. Also, my text is 'long test' and I'd like to be able to see it all. How do I get to see this...? Table 1 parent record #1- table 2 linked record 1 (linked under parent table 1 record #1)- table 2 linked record 2 (linked under parent table 1 record #1)- table 2 linked record 3 (linked under parent table 1 record #1) Table 1 parent record #2 - table 2 linked record 4 (linked under parent table 1 record #2) - table 2 linked record 5 (linked under parent table 1 record #2) - table 2 linked record 6 (linked under parent table 1 record #2) Background: I have two tables ('Ideas' tab
When I’m adding records, and I need to add a record in a related table, I have the option to do so through the gallery view but not in the form view. I would like to have that option in the form view as well. How?
Hi,I believe it's been asked many times but I'd like to see if there's any update.I'm trying to count how many records I have within a day and add the sum number to automation emails.So the recipients can have the sum numbers from their emails every day. I've figured out some ways to do so:1) Summary barHowever, I can only have the sum in the summary bar, which can't be added to the automation emails. 2)Count fieldBut can only be applied to linked records. It can be done by linking the records to a new table, but that leads to 2 problems:1. requires linking the records manually2. requires creating new records in the new table manually every dayI need to make them fully automated.I wonder if there's a way to count all the records and put them into email automation, thank you.
I duplicate my base, but find that my custom extensions are not in new base. How can I duplicate base with custom extension? Much appreciated
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.