Other Questions

Hi everyone. I’m dealing with Excel/CSV files that contain 1+ million of data and each file is 40+ MB in size. Is this something Airtable can cover? Thanks and all the best to everyone during these mad times.

I’m modeling a process in a table. Each record is a step in the process, there’s a field “Group” for steps done sequentially as a unit, and a field “Phase” that collects groups done in a particular order. Since it’s a process, it’s important to show the steps in the order in which they must be done in the group and the groups in the order in which they must be done in the phase. I’m adding step records to a grid view and want to show them stacked by group in a kanban view. It seems like by default, the items in a stack are shown in creation order in the table. That means if I figure out a step I forgot in a group, I add it to the grid and manually reorder it to be at the right spot in the grid view. It’s still at the end of the group in the kanban view though, so I’d need to manually reorder it there, too. Given that I’m going to have a bunch of kanban views and that I’m going to have a fair number of editors, I don’t want to trust that everyone will remember to go in and update every

Hi, Airtable folks! I’m having a trouble in setting view description. I am Japanese so I use Japanese alphabet for all of meta settings, such as table names, view names and they work fine. But when it comes to view description, they work fine at first but after a couple of minutes, they suddenly become all question marks like “???”. Does anyone know why this happens? I need a help!!!

Hi community, I’m trying to automatically pull Files uploaded to Salesforce into an Airtable record. Currently, I’m using Zapier to create a record in Airtable every time a Salesforce opportunity moves to Closed Won. When this happens, I have some automation in Salesforce that checks a box on the Opportunity Products which prompts Zapier to create a new Airtable record for each Opportunity Product. The one thing I can’t figure out how to pull in automatically is attachments. We attach the contract to the Salesforce opportunity, and I’d like this to pull into Airtable and attach to the relevant Opportunity Products. Has anyone had luck automatically attaching files using Zapier, Tray.io, or another tool? Thank you!

I have a project management base I’ve built over the years. I store project specific information in a ‘Project’ table, which relates to a ‘Proposals’ table. Each project can have multiple proposals, but each proposal can relate to only one project. Each proposal contains a linked record to an organization in a separate ‘Organization’ table. When I check a proposal as awarded, the record in the ‘Project’ table then displays the corresponding awarded organization (we bid out to several general contractors per project, but only one is awarded). What I am trying to accomplish is a page designer block that is based on the ‘Project’ table but can display the fields from the organization referenced in the awarded proposal, without having to pull in the contractor information into the ‘Proposals’ table and then into the ‘Project’ table. I hope there is a simple solution, but I have not found it yet. @Jeremy_Oglesby – any chance you have an idea on this?

Inside of my Airtable base I have two fields that log the timestamp when certain fields are updated like this: From there I take the two timestamp fields and calculate the difference, the calculations reveals the time different for a product to move from “status 1” to “status 2” in minutes. With this calculation, I would like to have a conditional SMS message ideally or email if the time difference exceeds a certain threshold. If the above is possible, there are further items I would like to improve upon.

Hi there, I am experimenting a bit with the XML block. Is it correct to say that you can only create records based on single elements? So if I have an XML order, I can create for instance just one record with the customer information or multiple records containing ordered items. As far as I can see I have to make a choice there. I cannot combine it to create just one record for customer x with multiple items in the items field bases on the XML order. Or is there something that I am missing?

I am using the URL preview block in the gallery view. It works as designed when I am in Airtable. I have embedded my Airtable base, gallery view within my website here: sideprojectstack.com/bubble-review. However, when I select the “preview video” button it does not open a preview video. It does not respond when tapped. Is there something I am missing that I need to install additionally to the airtable embed code? I am using a youtube URL, which is supported, it works when I am in Airtable base, but not on my website. I’ve researched and found that the preview url is supported in the gallery view. Thank you in advance for any help or insights you can provide. Experiencing it here is probably the easiest way to see the issue: sideprojectstack.com/bubble-review . Scroll about halfway down and you will see the Airtable gallery view and light blue buttons labeled “preview video”.

Hey all, I’ve embedded the Gallery view to my website and no matter what I try on the iframe embed code, the background remains grey. Can we change this or is it a bug?

So in the chart block, how does one exclude custom data categories? I feel like I am likely missing something. I have created custom categories using a multi-select field to code some qualitative data. I want to exclude certain categories or ones below a certain count. (Only display if there are more than 5 of a type.) Thanks

Hey there, I’ve got a Gallery view of people with biography info, name, and other mutli-select data points. The labels of those columns are used to form a survey. The survey asks questions like “what would you like your Bio to be?” and then in the Gallery view, I would want the label of the card to be displayed as “Bio” instead of showing the entire question in a card. Is this possible?

We would like to share a table with a client to collaborate. Is there a way to notify someone whenever the collaborator updates anything in the table? I understand the revision history is viewable if the record is expanded, but we would have to expand every record to see which were changed. Is there a way to do this within Airtable? I’ve tried Integromat but it is also unable to identify which field was changed. Also, I can’t figure out how to convert the ‘Modified By’ field into text (so that I know who made the update).

Hi Support, I have a Date field, and wants to get day diff of it till now. Yet when I set ‘d’, ‘days’, “d”,”days”, it’s always said error in formula. Without unit parameter, it works fine with second unit. Is it possibly a bug? Thanks, Elaine

Hi there ! Maybe it’s too early in the mornin here but I have a troublie with a field with condition. I’m sure my condition is right but when I’m trying, it’s just not working. Asking him IF the single select field “Type de partenariat prioritaire” is “Intervenant”, then don’t show the field in the form view. But it don’t. Thanks a lot for your help, really hope that I’m kind of blind on this one.

Does anyone know if you can change the inner column colors when using a table in Page Designer? You can change the border color of the field box itself but I can’t seem to be able to change the inner column colors. any ideas?

Hi. I’ve emedded a form using the autosize embed code and usually it works fine. However sometimes on page load it sets the height of the iframe slightly less than form’s actual height and cuts off some of the text at the bottom. Refreshing the page will usually fix it. This problem occurs regardless of the width of the container the iframe is in and regardless of the initial height set. Normally the bottom of the form looks like this where the height is set to 913 Sometimes it loads like this where the height gets set to 829 My embed code is this Anyone seen this problem before and know what can be done about it? Thanks

Hi there, New to airbase and wanting to start off learning it a little by creating a small personal project. To that end, I’m starting to build a database for my liquor & spirits and such … yaaay. Here are my questions: I have setup the upc function and it works great … wondering if there is anyway to use the upc to pull in any other information such as manufacturer or MSRP or anything like that? I would like to have 2 fields - one of them is a price field and the other one is a range field (so like $25.01-$75, $75.01-$100), etc… etc… Is it possible to have it so that when i enter the price the range field is automatically updated? Thanks so much

Hi All Is there a “Custom” E-mail Block to connect to your own Provider, or own Smtp? Tnx!

add new table with the name when add new record Could this happen? if this is possible then how do I do it

A huge draw back for me of Airtable is its limited Zapier integration - and the fact that it can only trigger on new record (and in view) - I really need this to trigger on updated field / record. I know I can do this with Integromat but don’t want to introduce a new app to my stack. There seems to have been some discussion of this some time ago… but quiet recently - is there another hack or imminent zapier development? Thanks

Hi everyone! I have a table with a list of 6 different release dates - I’m trying to create a field that looks at all of those dates and picks the earliest/first one as “Initial Launch.” IS_BEFORE only seems to work with 2 dates and the factorial of 6 dates is 720 possibilities of combinations so I don’t think I can do a workaround combining multiple nested IF and IS_BEFORE functions. Maybe I’m over thinking this though. I also thought about self-linking and doing a rollup field? Anyway, any advice or recommendations welcome!

Scenario Goal/Context: I have set up an Annual Gardening Calendar for my area for 2021 for the typical earliest and latest frost dates, dates to sow vegetable and herb seeds indoors and plant seedlings and sow seeds outdoors (based on Farmer’s Almanac and local Master Gardening resources). Global warming and local microclimates will move these dates slightly but they tend to trend close to the same dates every year (and can, of course, be refined as specific conditions are observed and/or change). Q: How do I replicate this for each subsequent year to come? I’m sure I must be missing the obvious. There must be a simple duplicate solution but I’m an Airtable Rookie and I haven’t been able to dig up amongst the resources how to copy the calendar for future years while retaining the integrity of the Gantt chart begin and end dates with the respective category fields (and color codes). Please… edify me! THANK YOU!

Hi, Airtable folks! I have a trouble with sharing blocks in Public. I was given a beta feature to share blocks in Public but all of the records are also automatically shared in Public. There is a button saying “Show data” in the top right corner in the shared public page, which I want to hide. Does anyone know how to hide it? If I can’t do it, I want to vote for the feature which we can hide it with.

I am having issues with matching the typeform questions to the airtable: “You can now match typeform questions to specific Airtable fields to easily send answers from A to B” Even when I went to look for the compatible typeform options (Dropdown) to the airtable (Single select or multiple select) - I am still no getting it to work. Any idea’s? Thanks!

hello airtable family: i wanted to ask you about the new button field 1 I have a private and paying community to buy and sell things to us 2 the payments of the things I manage with stripe generating checkouts With the new button field I thought of the following 1 when a person registers and pays the community fee their data is stored on stripe 2 I want to create a base in airtable with the things that are for sale and add the field airtable button 3 I would invite my community to the airtable base so they can buy from there automatically 4 the button on each record I want to be a button connected to stripe 5 when you press the button, it picks up the customer ID of the person who pressed it (which I have saved in another table in the base) and generates in a new view a new record with the customer ID that pressed it (bought) 6 with integromat I will create a scenario where if there is a new record in a view I will generate a new charge to that customer id automatically Do you think it