Other Questions

I am working on an org chart built using the startup org chart template - my base is available here. I am looking to roll up the salaries for everyone who sits below a certain person in an org chart. Is this possible? For example, I want for Tawana Muro in the org chart below I would want a column that has the salaries of everyone contained in the red box. I need to be able to do this for many different levels – for example, I would also want to be able to know the salaries of all of Bonnie’s reports. If helpful, I have already found a way to get the parent and children of each of the employees and I am able to roll-up the salaries for the direct reports. Each of Bonnie’s 4 reports make $100k per year, so you can see that the rollup in column “Children – Total Salary” is $400k tot

Hey everyone, I’m running into a problem adding .ics attachments to an email from an Airtable to Outlook zap. Background: I created a form for an event with different sessions, people can choose up to 10 sessions in the form, and it’ll send a custom schedule with their picked events through Outlook, I formated it so the sessions they don’t pick just look like free space in the schedule, but are still technically present in the zap. Originally I planned to just have the links to the video chat for each session, but the client would like those replaced with an outlook calendar event. I tried adding an .ics file as an attachment in AT, and then putting that into the Zap, but it doesn’t work. It doesn’t look like a multistep zap would work since they want different events for each session chosen, which can be random. Does anyone have a suggestion, or is this not possible? so I guess the basic question boiled down is: how do I add an .ics file, or other outlook calendar

Hello! Does anyone know how to add a table to a block for my Dashboard?

Im having trouble searching on mobile. When I scan my barcode with a 5 digit number, it puts a space after the number. Without the space, it finds the item, but with the space I get no results. It works fine on desktop and I have a similar table in another base which does not do this. the new base I started with the “inventory tracking” template. Any ideas? is it a settings thing? Any advice would help. Thanks.

Hi, I have an accommodation business, I am trying to calculate a due date for the final payment which is based on the number of days (generally 60) prior to their arrival date. I appreciate any assistance. Thanks!

If there a way to write a formula that queries, basically, IF value X is in column C OR column D, then Y. I just want to be able to filter a base to show only the records where a Name appears in either one of two columns, if that makes sense. I wish the filter options weren’t by default AND, and could show all records that meet one of two filter conditions. Am I overlooking an easy way to do this? Javier

My base is designed to track testing results across multiple applications. All application testing results are housed in a single table with a column to identify which application the test results refer to. We have testers in the field that complete a test form for each test case which writes back to the results table. I am able to create grid views to show the results for each different application. I’d like to create form views on each of these grid views. When I try to limit the record selection to a view, my only option is the standard Grid view. My newly created and filtered grid views are not listed as options. Any suggestions?

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

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_

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 t

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!