Interface Designer

In a barplot grouped by a certain field and counting number of records I would like to filter only the bars that have a count over a threshold. If not, barplot contains way too many bars and it is unreadable. How can I do that?I am doing it in a base interface.The first screenshot shows the issue. The second shows the config of the barplot

Is it possible to update linked records that are shown as a gallery view, within the 'record review' interface layout?I have a "products" table, and each product can be linked to many "POs"Essentially the PO is our various orders of that item.I've built an 'record review' interface (see screenshot) which shows the products on the left hand side, with more details surrounding the product on the right side. Here i display the linked records in a gallery view, grouped by location. My aim is to create a pick list from the various POs so we know when all units relating to each PO has been shipped.Currently i have to click on each PO which takes me to the 'Record Detail' page. It seems a long winded way to update some of the fields, especially if they are the ones i've chosen to show on each gallery card. Is it possible to have editable fields on the card, rather than clicking into the record detail? If this isn't currently a feature, it would be a useful one to consider. Perhaps i

I have a record picker that I want to use to filter a different grid source.For example:1. Picking a project with difficulty of 2/3.2. Filtering a gird of freelancers with ability to work on difficulty of 2/3 and above.I can only manually input the filter for the freelancers grid without connecting it automatically to the picker chosen result. Am I missing something?

New to Airtable here and trialling to see if I can work out a solution for my department.I have two bases, one that tracks People and the other that tracks Activities. Within Activities are fields for 'Participants', 'Facilitators' and 'Guests'. Multiple people can be added to each field.I am trying to create an interface that shows a count of how many people there were across all activities in the participant's column. However, I can only seem to get it to count how many activities there were to have any participants, which is a different number.I can see the next trap would also be that, if I was able to get it to count items within a column, it would count them regardless if they were original or not. This is desirable sometimes but it would be good to only count unique entries across multiple activities because often the same people attend multiple activities. How do I effectively say "count unique entries within the participants' column for all activities"?

I'm creating a client portal in softr. As such I have 5 Projects - Each with 10 potential statuses.Project 1, Project 2 and so on can have Status 1, Status 2, Status 3 etc.How do I count the Number of Statuses for each project and get in it a COUNT column so I can take the number into Softr?I can tally the whole lot - but I can't break it down per project.Thanks

I have a table that contains products and their dimensions (H, W, D/L, etc.) which are displayed for the sales team in an Interface grid. They need to be able to copy the product line or parts of it to paste into another document. However, the interface view doesn't allow copy and pasting in either "View-only" or "Editable" format. Am I doing something wrong? Help!

Hello!In the Airtable interface, when you create an element type that has the ability to "allow users to open record details", for instance in a "gallery" or "grid", and you click on the "configure record details"(see screenshot), it leads you to a "details layout" that displays details of that record's object type. For instance, if you have a "Contacts" object type, the "details layout" allows you to put information about the contact (like name, email, phone, address, etc.) on that details pageMy question: if you have multiple interfaces for a single base, each of which requires those same "details layouts", can you duplicate the "details layouts" across each interface so you don't have to manually duplicate them? If this feature isn't available, it'd be a great addition to reduce the amount of manual labor required!

hiI just wanted to know whether creating records in a bridge table (resolving M:M relationship) can be done only through views attached to the bridge table (like grid view, gallery view..) or can this be done using an Interface, as my users are interested to use Interface than the table views. To explain thisI have two tables "Employee" and "Facilities " (akin to services offered by org). There exists M:N relationship between these 2 tables and a new table "Employee-Opted-Facilities" would be required to capture certain details like dates etc.Is there a way to create a record in this table using Interface, by having button and triggering automation. I tried but I think the trigger would use only source table that would be made available to the automation.Please suggest if there is a workaround with interfaces or else I have to settle with table views.ThanksSri

I am using a formula to subtract one weight (ungraded weight) from another (graded weight). The formula in the dashboard is working fine to make Unaccounted Weight: However, I cannot choose Unaccounted Weight in Interface Designer. I want it to appear just as a number element. Does anyone know what I’m doing wrong?

Hi there, I have a table with unique numeric IDs in the first column. Ideally, people will input data in that table through a form interface, but i really need to be sure that people are not inputting the same ID twice, so that if they do form submission is not sent and we show an error that says that they cannot input a duplicated ID. I have not found any ways to do so anywhere on the net, the only way seems to be throuh Mini Extensions, but i would prefer to not use too many different providers, that’s why i’m using Interfaces. Since we already use Softr i was considering moving the whole interface there, but i cannot find any evidence that Softr provides this kind of check. Any help?

Hi there. I’m facing a problem in some of my interfaces where the value’s are not appearing in the right order whether I change it from Ascending to Descending. For example. I have a bar chart as below where all the weeks are in the wrong order: I’m pulling the 'Week’s from a table as follows. Weeks are a linked record. Can someone explain what I’m doing wrong here? Thanks Dan

Hey guys, Not sure if I have posted here before but thank you all for the wealth of information as I have absolutely learnt a whole heap from all your contributions. I’m trying to create an interfrace to speed up my creating of user stories by using templates. Basically I want to have one list of templates and then one list of the user stories for the scoping document I am making. See below for an image. I want to be able to click\select\other a template item and that then copies (has to be a copy as I may modify it a little and I don’t want the template to be modified) that item to the working user story list. For bonus points I’d love to be able to unselect the template and it remove the working user story item related.

Hello, Is there a way to add a fixed image, a company logo for example, to an interface Layout? This operation seems straightforward but I do not find how to do it. Thanks Pascal

Hi all, First of all, my name is Sebastiaan and we are new to the Airtable Community. We are running a company in building Home Cinema Seats. At the moment we are developing our workflow in Airtable. One of the things we want to do is creating a order-system for your chairs. Because we want to get rid of the spreadsheet feeling, we want to use Airtable Interface Designer to create quotes, purchase orders and invoices. We offer modulair built seats with different combination and we want to have an overview of the products, description and prices. Is it possible to develop this in Airtable or do we need 3th party apps? Thanks for your reaction in advance and all the best, Sebastiaan

I use the Record Review template for almost all of my interfaces, and while I love that template, grouping records needs some love (I feel). I have records groups by their status (‘In Progress’, ‘Complete’, ‘Referred’, etc.) and regardless of their importance, all groups collapse immediately upon opening the interface. I would really love the ability to either have all groups not collapsed upon opening the interface (as the easiest solution), or selecting which groups are automatically collapsed, and which groups stay shut (or whatever the opposite of collapsed is)… Heck, I’d love to be able to organize the groups too, but I use a formula for my grouping so that may be a massive headache. Either way, thanks for a super slick product!

Hi everyone, You may have noticed that if you create a gallery of records within interface designer, you can show the buttons that you might have created for those records. The button fields work as intended and are perfect - however… If you allow to go into record details onClick for a record in the gallery component, the button will work and execute, but you go into the record details also. This might not be intended behaviour. If it is intended, do we have a workaround to open a button from that gallery view without accidently going into the record details?

When I build an Interface with my data, the date format shows up differently from how I’ve set it up in the data in the original Base and my system preferences on macOS. Date in Base Date field setting in Base Date and time setting on macOS Date on Interface

I gave people read-only access to an interface before the rollout of the feature allowing me to restrict access to the underlying database. Can I restrict that access retroactively?

Is it possible to add multiple views under same page ? For example, I have a page called “X project” and I want to create multiple views under this page as we did same on previous Airtable base.

The “record picker” allows one to search for and select a record by the primary field only, it seems. I would like to see a true search element that can be configured to search multiple fields, or all fields within the specific view.

Hello! I am working on a family archiving project. I have made comments directly on attachments and want my family members to review each record and reply to my attachment comments. On the interface designer, using the Record review template, I want to display Attachment Comments for a given Record so that my family members know where to look in the attachment (these are old documents that can be hard to read). Thank you!

Hi everyone, here’s my situation: I click on my base (in Windows app) Top of the screen, I can see ‘Data’ - ‘Automations’ - ‘Interfaces’ I click ‘Interfaces’ I am presented with my Interface ‘categories’ I click on ‘DRCs and Trades’ Interface but it opens up my last opened form I was expecting to see a list of forms/interfaces I had created? I’m sure this used to appear? Is it something I’m doing wrong?

I’ve been using airtable for a couple of years on my own and have developed some cool and useful interfaces that I use. It turns out a bunch of others would love to have access to the dashboards I’ve built. I understand I can’t share the interfaces without making those viewers paid collaborators, which is ridiculous for some managers who want to view a page once per month. So what are my options? Screenshots? Stacker?

Hi all, Have been playing around with the Airtable Interface designer for a bit and am stuck on showing aggregated data on a line chart. The sketch out the situation: I have a table of events. I have a linked table of people who registered for an event. These records have a ‘created’ time field. I want to show the growth in registrations for an event. So I want to line chart to show the total registrations for that event on a certain day, not just the amount of registrations of that single day. Any clue if this is possible or just somehting that hasn’t been implemented yet?

I have a problem that I think should be solved through interfaces. I’m tracking attendance and need to be able to build rankings of attendees, and calculate attendance percentages, flag people below a certain percentage, etc. I have a database with two tables: a list of employees and a list of events. The events table is a collection of records (date, attendee, type of event). It links to the employee list, so it rolls up the events and counts how many of those they attended. In fact there’s an extra record calculating the percentage over totals. So far so good, I can tell how many events and of which type everyone got. Problem is, the list is growing and all the data I have is YTD. I need my boss to be able to select a date range and check the percentages, ie quarterly or whatever range they want. So I built an interface, from which I’m able to make a filter (from date, to date) and even filter which type of event (meeting, conference, workshop), then show a number element that counts