Skip to main content

Interface Designer

Take your work to the next level with Airtable interfaces! Learn how from your peers here.

  • 1,373 Topics
  • 4,311 Replies
1373 Topics
M
mmj-916New Participant
asked in Interface Designer
Interface Form - Using Date Field results to help filter Linked Record Options

I have a form that is letting people create Inventory Request Records, choosing Item Records they would like to check out from our inventory. We would like to have a way that will automatically prevent them from choosing an item that will be checked out during the dates they have selected.Using the filters and conditional options for these fields, I only see being able to toggle visibility for the results of the "check in date" and "return date". I would like to use the values from the questions asking for the dates to compare to the records in our "Items" grid so "Items" checked out will not be visible but I cannot find a way to do this. We are not able to use a 3rd party platform.Any guidance on maybe how to rework the fields to allow us to use the info from previous answers to help filter their selection? Is there any way to have formulas or more advanced coding in these forms?

173
M
K
KaterieInspiring
posted in Interface Designer
Request: Access Revision History in Interfaces

My team uses the revision history function a lot when editing records. Currently, that function is not available in an Interface, as far as I can tell. I hope that it can be added ASAP. I have a workaround that embeds a link to the record in the base, and directs the team member to click on the link and open up the Activity pane to see the track changes. This is a workable solution, but far from an ideal one, as it requires the team member to interact with the base itself rather than the much more streamlined—and much less confusing—Interface.

17317
T
N
ninjaben53New Participant
asked in Interface Designer
Sharing different interfaces with different people

Hi all,I feel like this question may have a very easy solution, however I have been unsuccessful with my attempts so far. Basically, I have created three interfaces with one or two pages in each. I want to share a couple of my interfaces with some of my team members, and the other interface with my other team members. I am struggling to understand how to accomplish this, such that they do not have access to the other's interfaces.In the sharing options, it gives me the option to share to individual bases via link, however when I test the link i can click back and open the other interfaces (I also tried with another account I can access to test it and the same result happened) I am sure I am missing something. And if there isn't a solution, a work around where I only get one page/interface is acceptable. Thank you,Ben

2157
Dan_Montoya
D
danilarooParticipating Frequently
asked in Interface Designer
Restricting interfaces to certain creators

My client has a team of several Creators and one Owner. They want to make an Interface that is only viewable to the Owner. When I create a new Interface and choose not to share with users (I click "Not Now" on the dialogue box shown below), then I go to Manage Permissions, it shows that all Creators have permissions to the new Interface. I can't figure out a way to remove access to Interfaces for Creators. Is this even possible? Or do they need to be downgraded to have permissions set for them? 

313
ScottWorld
P
perfectNew Participant
posted in Interface Designer
Add conditions in form filtering

My table has 3 fields:One field is country selection - e.g. USA, EU, Canada..One field is product - e.g. table, chair, cabinet...One field is supplier - e.g. supplier A, supplier B, supplier C. Does anyone know how to set rules/conditions in SAME field of airtable FORM INTERFACE at below scenarios?  Scenario 1 - select USA and table, filtered option is supplier AScenario 2 - select EU and table, filtered options are supplier B and supplier C I am not familiar "add condition" or "add condition group" in form filtering. Pls. advise if you know how to do it. Thank you.   

61
ScottWorld
N
Nadege_BOINNARDKnown Participant
posted in Interface Designer
Recent change : impossible to add new record although the option is activated...

Hi, my interface was working fine before (like a couple of weeks ago).I created an interface where I can add a "payment" to a given "instalment".As you can see in the screenshot : allow users to create new records is activated.But in reality, I cannot... To me this is a bug... How do I report this for a (fast) fix please ? 

239
N
I
idodanParticipating Frequently
posted in Interface Designer
How to avoid Interface users from viewing Base data?

Hi friends,I built a pretty robust Interface app for 4 types of users. I applied permissions so the Interface shows only records that are relevant to the current logged in user only. However, I can't get rid of the option for the users to view the Base data (they have the "View Data" option when clicking on the upper left icon in the Interface suite.This jeopardizes my whole Interface app, as users being able to see other users data is a business show stopper.Please advise!

614
TheTimeSavingCo
B
babyBrickNew Participant
posted in Interface Designer
Interface Record Expanded View padding

Hi!I'm trying to remove whitespace on the sides of a full-screen expanded view of a record in my interface to make the expanded view of a record more condensed - is there any possible way to do this? I think it was a possibility in the old interface designer but I haven't figured out an intuitive way to do it in this one.

61
TheTimeSavingCo
A
Andrea_BorrieroParticipating Frequently
asked in Interface Designer
Calendar view in interface - more items not visible

Dear all,I'm using the calendar in the interface; in the month view, if there are more items, accondingly to the zoom setting, only some items are visible, while others are not visible, even though the label "+ x more" is present.Even by clicking in the day the other items appear only for less than 1 sec, after the click.Are there some ways in order to see the title of the items withuot open the right summarize column? Thank you. Best regards. A. Borriero

93
A
R
RayThacherNew Participant
asked in Interface Designer
Prevent interface users from seeing all other users

In the Airtable interface it came to my attention today that Read Only users can see all other users who have access to the same interface. I simply assumed they couldn't share or see this information.Does anyone know how I disable sharing for read only users, or the ability to see who it is shared with?This is totally work stopping for me on my current project. In fact this is preventing me from wanting to use Airtable interfaces for any public facing work, even for people who have paid Airtable accounts. 

2265
I
F
Fabian_WinklerNew Participant
posted in Interface Designer
Sprint Interface - need help

Hi, I am trying to create a sprint base / interface. The base is most likely already done, but I am facing issues with the interface, since I can set up only 3 hierarchy level.My Goal is to have an interface as a list with following "grouping" or nestingSprint - <DATE>Category (e.g. Webinars, Product Launch, Marketing Events)Project (e.g. <Product Name> Webinar)Tasks (e.g. Create Webinar Slides)Every level shown above is a separate table in my base and they are linked to each other.I tried several ways to solve this, e.g. with Grouping, but grouping is always on the lowest hierarchy level (Tasks), but I would need it for the Projects. Then I could group by Category and my problem would be solved. Another way would be to have no Projects, but instead nested Tasks (only 2 levels required then (Sprint + Tasks). However, this is also not ideal.. because without an interface it is difficult to read the data. Another way would be to have again 2 levels (S

90
F
I
itsmeayyubNew Participant
posted in Interface Designer
Airtable Interface Limit crossed of 50. What should I do now?

I have a data in airtable of clients.For each clients I want to create a dashboard and share with them so they can check-in daily and see the progress.Let's say I have 100 clients.But airtable interface has limit of 50. What should I do now?

1433
ScottWorld
M
megnarNew Participant
posted in Interface Designer
Mobile Interface 2/15/24 article...anyone able to access your interface from the app today?

I just found this article today: https://support.airtable.com/docs/mobile-interfaces-in-airtableLike many/everyone, we really, really need a mobile interface view for our Non-profit organization. We're looking at purchasing a cheap laptop to keep onsite, but it would be so much easier to have ONE iPad, which we can easily get donated. I was searching about whether we could use chrome to view our interface on a chromebook, and I came across the above article that was posted yesterday. I have messaged support, but though I'd check here as well. The airtable version in the app store is 2 weeks old, and I am still getting the "view on desktop" message.  Looks like google play store was updated on 2/14...guess I need to wait and download it on my kid's android when she gets home from school 🙂 

192
M
S
spancakesInspiring
posted in Interface Designer
Chart of Active Customers

I am trying to figure out a way to generate a bar chart of our active customers.Each of our customer records have a "start date" and an "end date" when they were active. I can easily graph the "start dates" (see attachment) but this doesn't show our cumulative numbers including people who are still active customers. If someone stops being a customer, I still want them to be counted for the years they were active, but not from their cutoff date.The closest I have come to doing this is by linking to another table that has a list of years and basically manually adding customers to years they were active, but surely there is a better way to do this. We have hundreds and hundreds of people. Maybe there's a formula that can do something clever, dunno.Ideas?

131
TheTimeSavingCo
G
GMMMNew Participant
posted in Interface Designer
Displaying the Percentage of a Total in Interface

 Hi, this should be really simple but there doesn't seem to be a way of displaying percentage of a total (fields meeting certain conditions).Basically I have a list of leads. Each one is labelled as "converted to customer", "converted to partner" or has a blank field.Instead of just counting the number of records meeting the conditions above, I would like to know the percentage of conversions to customer and conversions to partner,  and display this on an interface page.Thanks. 

3278
A
W
wootiKnown Participant
posted in Interface Designer
Timelines formatted as Gantt need option to select multiple records

Without the option to select multiple records, we are required to set dependencies to move more than 1 record at a time. We need the option to click/drag to highlight the records we want directly on the timeline, and then grab and move them all at once.This is available in the non-interface Gantt view. Please make it available in the Interface Timelines too!

60
W
Calvin_Young2
Calvin_Young2Known Participant
posted in Interface Designer
Limitations with New Linked Record Picker

Today there was an update called Refreshed linked record picker in Interfaces which makes the record picker for linked fields more compact and consistent.  I like the idea, but it breaks some important things in our workflow.Namely, it does not show images, and it truncates the record names.Here you can see a snippet of an interface which shows a linked field.  There are a few records already linked (circled in green) with image thumbnails appearing on the right side of the card (red arrow).  Clicking the "Add group" button opens the new record picker (circled in blue) which severely truncates the record name and does not show image thumbnails.  To confirm the configuration of this field, here are the settings which show that "Part Image" is the first visible field.  (Regardless of the position, it always shows up to the right on the cards, which is a handy feature.  Here I put it first in line to try to force it to show up in the new record pick

11116
Calvin_Young2
C
ChrisBNew Participant
posted in Interface Designer
Per record edit permissions

Is there any mechanism which can be used to allow only some records within a list view to be editable? I would like my team to be able to edit records until they are marked as complete, after which editing should no longer be allowed. I'd also like to be able to show the completed records in the same view, so work arounds such as using different views (which is what we are doing currently) make our workflow less easy to follow.

743
Dan_Montoya
E
emilylyNew Participant
posted in Interface Designer
Track viewership and engagement on an interface

Is there a way to track viewership, clicks, or engagement in general for an interface? I'm currently using Interfaces for a Project Status Update site, and it would be quite interesting to see how users are engaging with its content. I'd love to see a heatmap of sorts as to what pages or content is being viewed most, or where the drop-off is to inform if what I've created is providing value. I could otherwise solicit written or vebal feedback through an Airtable form, but figured data would be another compelling way to gain that feedback. 

1281
K
C
ChrisBNew Participant
posted in Interface Designer
Filtering by the top level view in a hierarchical list

I make extensive use of the hierarchical list function, but there is one thing I can't work out how to do. I've made a minimal example here: I have three tables, projects, groups and records. Projects can have several groups, and groups contain several records. I would like to be able to filter the view based on which project a group is assigned to. I can add a lookup field inside the record (which is what is shown in my screenshot filtering for project Bob), but I would like to have groups A, B and C hidden in this view, because they are on project Alice. I can't use the 'hide sections with no additional rows' option, because I would like my users to be able to add new records to group F, which is a member of project Bob but empty. Are there any features which would allow me to achieve this goal?  

630
C
Wchapin
WchapinNew Participant
posted in Interface Designer
List Interface forms metadata across workspaces

Is it possible to consolidate a list of all forms (and links) to administer from one place?

10
Wchapin
C
ClarenceKNew Participant
asked in Interface Designer
How to create a new interface?

Hello everyone,I can't find the old page where I could see my published interfaces, my unpublished ones, and create a new one. For a few days now, when I click on Interfaces, I'm redirected on the new interfaces page where I can see all my published interfaces on the left menu, but I don't have any option to create a new one.Has something changed?

21911
CJSmith
Kenneth_Raghuna
Kenneth_RaghunaInspiring
asked in Interface Designer
Duplicating Bases and Interfaces Simultaneously

Here's the system:Base A: Used for Project Management for an event in January.Interface A: Created on top of Base A for use by other members on the team where data access needs to be considered.Base B: Use for Project Management for an event in February. It is created by Duplicating Base A after the completion of January's event, so that the base undergoes an iterative design process, benefiting from the additions/improvements made to the base during the last event.❌  What I'd Like to Do: Upon creation of Base B by duplicating Base A, create Interface B that is a duplicate of Interface A.I am aware that Airtable does not support duplicating Interfaces to other bases for fear that the underlying data structure will be different (on Airtable's end, I imagine that at the least they should be able to offer the option to duplicate the interface associated with the base at the time that the base is duplicated).Has anyone else found a way to work around this? Re-creating the inter

1253
TheTimeSavingCo
J
jeffrey_chenNew Participant
posted in Interface Designer
New Linked Record Picker

Hi all, today we’re beginning to roll out some redesigns to the linked record picker in Interfaces. These redesigns should make it easier to identify the data you need to make a selection, reduce some unnecessary clutter, and bring a more flexible experience as you can now easily resize it to fit your screen real estate needs. This redesign unlocks some future features for linked records, so stay tuned for more soon!  

11
C
P
PeterJNCKParticipating Frequently
posted in Interface Designer
List view - Hierarchy levels

Hello, this is my first post here, so I apologize in advance if I have chosen the wrong location or have too lame question.I am designing a database to track people's time on projects. I have three tables: People, Time, and Projects (which is synced from another base). In the Time table, there is a list of time entries. Alongside other fields, each entry is linked to one People record and one Projects record.What I would like to achieve is a List view of the Projects with the following structure:- Project (sum of all time - this I can accomplish with Rollup)--- People (with the sum of time spent on the particular project)------ Time entriesHowever, it's not working because there is no direct linked connection between People and Projects. I can create a Lookup field to show me this data, but that doesn't work in a hierarchical structure.Only solution I have so far is to manually add each person to specific project, but I don't like that workflow 🙂 I would like to know how many h

2831
TheTimeSavingCo

Badge winners

Show all badges
Terms & Conditions