Interface Designer

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 nu

I don’t see the option to select the field to update in a Record Picker Interface. In a different base I am able to set this correctly. What could be the issue?

When I open a filter option in Interface Designer, my choices are never provided in alphabetical order, wondering how I can choose this? I also have a filter for year (2021, 2022, etc.) but the options show in a random order 2022,2021,2023. Thanks for the help!

Does it make any sense that I can set up a form in interface designer for new records (for example “Tasks”) which is used from the record review, including required fields, but when I create a Task from another record (for example from a “Project”) that form is no longer used? And also when editing a “Task” I can’t specify which fields are required? Or am I missing something?

The question mentions it all: I have a piechart that summarizes a distribution of my records over some categories. Now there are quite a few that have 0 records so that category doesn’t show up in the chart, but it does in the legend. Since there are quite a lot of categories, the chart becomes cluttered. Is there a way to hide the unused categories in the legend?

I am using AT to keep track of parts in manufacturing. My systems use the API to create a single part record in one table, and then add multiple “update” records that keep track of tests or comments. It’s working well. Now I want to create a manual interface so that users can add tests from the AT website. I have created an interface with a record picker that selects the Part *using Serial Number). I then have a table element that is attached to all those updates in the other table. But from there, I want to be able to easily add a new update to the updates table. The grid allows me to edit, but not create an update. I tried another page, and that would work, but I would have to get the user to search for the part with a new record picker. So either I want to be able to insert a record in the grid (the user can then edit it) or I want to have the record picker on one page set the record picker on a form page. Is there a good way to do this?

I am creating a directory of artists that have the following tags medium (painting, ceramics, etc) location (CA, NY, OH) gender (female, male, nonbinary) In the interface, I am able to create a record picker for gender that connects to the record list, however I am stuck on trying to connect the other tags to this same record list. I want to be able to use the dropdown record pickers to filter the table via multiple values. How can I do this?

Hi all – sorry if this has been discussed before, I had a search around and couldn’t find anything. I’m using an Interface as the front-end to an Airtable → Zapier → Webflow CMS integration. The interface contains a bunch of fields for content — headlines, body text, banner images etc – that I want users to be able to tinker with. However, I’d like to prevent changes from being sent to my Zapier automation until a user clicks “Save” … rather than the cells updating one-by-one as the user works their way through the interface. Is there a straightforward way to make an Interface only commit the changes to the base on a button click? Or is my best bet to do this manually … i.e. make my Last Modified column only update when a certain button is pressed? Many thanks in advance Dave

Does anyone know if you can add custom code in Interface Designer? Would love to add in some custom elements.

I’m hoping to create an activity tracker across my different consulting contracts. The hierarchy for submitting an activity is as follows: Contract 1 > Possible Tasks (“WBS”) → Activity related to task Contract 2 > Possible Tasks → Activity related to task In an interface form designed to submit a user activity for a task/contract, I’d like to filter a drop down of WBS possibilities based on a user-selected contract. I understand this feature doesn’t exist yet; is it currently in development? I see that I’m not the only one that has sought similar functionality across airtable features.

I’m trying to take or save a picture of the pie chart in interface to use in a report. How do I do this? Thanks for your help!!

Hi there ! Here is my case, which seems pretty simple but I couldn’t find any solution for now : I have a table called “Talents” and a table called “Positions”. Both have the same fields as “Seniority”, “Department”, “Skills”, “Salary Range”, etc. I want to be able to filter my Talents using the fields of a position. I basically want to get the Talents who match the position. And I would like to create this Matching tool in the interface. Any idea on how to do this ? Thanks a lot ! Best, Kevin

I created links using the text element to make navigating from one interface page to another. However, they open in a new tab or instance of the App window. Is there an HTML syntax I can use so it opens in the same tab or instance of the APP so I don’t get dozens of windows open while navigating? I googled the answer but it doesn’t seem to be working.

Hello! When I add a text element to an interface, and format it as a checklist, I am unable to check/uncheck the boxes when the interface is published. I am only able to do so in edit mode. Is there something I am missing? Thanks!

In the Interface Designer, in a Line Chart, is it possible to set a custom range for the X and Y axes? For example, in the image below, I would like the Y axis to go all the way up to 100%, although there is no data in the table that goes that high. And I would like the X axis to extend to the end of 2023, although again there is no data in the table with a date that far in the future.

Would love to add images to the Interface, isn’t there a way to do that other than adding it as a field?

Hello, Is it possible to make this nested condition an AND instead of an OR? I cannot figure this out!

Greetings dear Airtable colleague users I need to have my Airtable content accessible via the web by the public and also by the registered users that I already have on Airtable. I have seen a number of tools exist today and now that Airtable is going to offer also a UX designer option. I have seen these sites listed can you share some experiences on the use of any of them? stackerhq.com → TESTING Table2Site

Hello, I have shared an interface (hence a base) with read only external collaborators. Everything is working fine, but I would like to deny permission to these collaborators to enter the base itself, but i cannot find out how to invalidate the “Go to base option”. Can anyone help me on that matter. Thanks Pascal

The more I use interfaces with Linked Records, the more I wish we had better, more direct options for creating, viewing and editing Linked Field records. When I compare editing mock-up Text fields whilst pretending that they’re Linked Record fields, I can’t help but insist that this method of editing Linked Fields becomes a reality sooner than later… (pleeeease… :smiling_face_with_halo: ) Below is a mock-up interface that I’ve created and edited (in MS Paint) to hopefully relay the idea. I always feel that working with Linked Records/Fields within an Interface is somewhat back-to-front… Users should be able to work on their primary record, and the associated Linked Fields, without being interrupted with pop-up windows, or forms, or taken to different interfaces etc… instead, why not just let them edit the data directly, let the interface expand/

Hi community, Sorry to bother, I’ve been trying to work this out by myself for hours now… I’m surprised I’m the first to bring that up, or maybe it’s just a simple function I did not find yet? I’m in a record review layout. When creating a new record, I’d love it immediately displayed in the record review. Current (annoying) use: the “create new record” button of the record list opens a new record form. Once validated, this newly created record is somewhere (lost) in the record list; I have to find it to have it displayed on record review, and start populating the fields the way I want to. I’ve been thinking of adding a button to run an automation with something like create new record find record ID open interface record ID url https://airtable.com/baseId/interfacePageId?recordPickerId=recordId …but I’m not familiar with scripting at all.

I want to build a “Send iMessage” button into my interface, but it doesn’t look like it’s going to work. I have a {Phone} field, so generating a link to send an iMessage is easy enough with this formula: IF( {Phone}, SUBSTITUTE( CONCATENATE("iMessage://", {Phone}), " ", "") ) This works great as a button in the regular Airtable interface. Can it be made to work in an interface? If not, consider this a feature request. :slightly_smiling_face:

Hi there. I’m trying to create an interface designer graph element that has year on the x-axis. The data I would like to pull from for the x-axis is a formula field formatted as a date, grouped by year. Every time I’ve tried to create an interface designer graph element using a formula field that’s formatted as a date it has collapsed (see below screenshot - refreshing the page does nothing) and also caused all the other graph elements to never populate (perpetual wheel, also see below). I created a new column in my data that copy and pasted the output data in the formula column, but now in a date field type. I used this date field to as the x-axis data instead and everything worked perfectly (see below). This makes me think something’s wrong with