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,310 Replies
1373 Topics
CKARC
CKARCInspiring
posted in Interface Designer
Creating a very locked down view with automation for our users

Morning.We have a request that seems pretty common but searching the articles the info is a bit conflicting, so asking a fresh question.We have a base with data that we work with.  Think of it like a CRM.What I need is a way to set a view of data (state based) so that a user can only see the cases they are working on. That is pretty easy with a view etc. I also only want those users to only see certain fields from those people to not be able to edit the view or configuration of those fields. Except 2 fields which they are allowed to do a drop down on. Reason is basically to stop users from deleting or changing important data, or viewing other peoples data. Thats the main request. A lock down view for our users that they cant download, change, print, copy. they can only view . . except 2 fields that they can toggle. (our users are very basic).Second part of that, is I want them to have the ability to run one automation in that. A button that will send a locked down message to

442
Sistema_Aotearo
M
Mike_BuckParticipating Frequently
posted in Interface Designer
Field Summary - Sum of Averages?

Is there anyway to do a sum of averages within a selection using the number boxes?Bottom grey number on the left is what I'm trying to tweak.  Over the last 12 months, I've sold 663 units for a total of $4,107,840 (bottom two green #'s).  I need to sell 118 more (top grey #).  Ideally, I want that bottom grey box to not show me the average per, but a sum total of the averages.  So $4,107,840/663 = 6196 * 118 = $731,128.  Any one have an idea on how to get there?I thought maybe build that value into the base itself somehow, but I'm having trouble running sums within the individual records so they all return the 6196 value in real time (or close to it)...

01
Dan_Montoya
E
Erin_AlterInspiring
asked in Interface Designer
Limit the choices for Single Select field in Interface Form

Is it possible to limit the options for a single select field in an interface form? i can definitely do this in a regular airtable form. but i can't seem to figure out the way to do this in an interface form.example: single select fieldOption 1Option 2Option 3Can i make the interface form only offer them the choice of Option 1? or only Option 1 & Option 2, but not display Option 3 as a choice?

683
E
RockyCCChong
RockyCCChongKnown Participant
posted in Interface Designer
How to get record list like the one in Project Tracker template?

Inside the Interface Designer, I've tried many ways to get this Record List from the Project Tracker template, but could not find a way. How do I get this? I have tried creating Record Review, but the behaviour is somewhat different. I tried creating from blank but the only option available is Record Picker. Appreciate your help and expertise. Thank you in advance. 

31
TheTimeSavingCo
Sean_Murphy1
Sean_Murphy1Inspiring
asked in Interface Designer
Conditionally shown fields in interfaces?

I’m curious if there are any plans to add conditionally shown fields to Interfaces, similar to what is possible in form view? For example, if you’re tracking network outages you might use one field to specify that the cause is a power outage, in which case you would want other fields to appear that let you specify when the power outage started and ended (so you can track UPS runtime when the power goes out, and site recovery time when it comes back.)

27517
S
J
Jeanette_SegubaNew Participant
asked in Interface Designer
How to delete published interface?

I’ve been trying to delete a published interface but can’t find where to delete it. I opened the interface and looked for a delete button but couldn’t find one. I exited the interface and went to my workspace to see all of the bases and interfaces I have, but I couldn’t find an option to delete it there. Thank you in advance.

31912
C
S
Sara11Inspiring
asked in Interface Designer
How show an interface without airtable account?

Hi, I'm playing with the interfaces and I have a question. Is there any way I can share an interface with a person that hasn't an Airtable account?I don't want to add them as collaborators, because they should see only that interface (not the base) and I don't want to ask them to create an Airtable account just to see my interface. My final goal is sharing the interface link with an automation through email. Is there any way? Thank you!

17541
M
C
cheneric86New Participant
posted in Interface Designer
Sums in interface pivot table not working

I've created a pivot table in a dashboard interface and I'm trying to summarize cost for projects. Each record is a deliverable which has a corresponding "Brief" that it's tagged to. Each deliverable also has a cost associated with it. Both "Brief" and "Cost" fields are lookups from another table.The pivot table:Rows: BriefColumns: Deliverable TypeSummarize by: FieldField: CostSummary type: SumUnfortunately, the pivot table just shows up completely empty. I created the same pivot table as an extension and that worked perfectly. I can't seem to figure this one out.Also, the Cost field is set as "currency" in the lookup table, if that's important.

200
C
M
mirkolandoInspiring
posted in Interface Designer
Do not show empty fields in timeline overview

Hello Airtable Community, I have a timeline display and group on three levels (market, category, linked event)For some entries, there is no linked event. However, it is very important that it is also displayed for the entries with linked events.Can I somehow prevent the entries without links from always showing (empty)?Thank youMirko   

40
M
M
MatthisParticipating Frequently
posted in Interface Designer
Using Grid/List visualization within record detail for 'self' record.

Currently when viewing a record's details in an interface, Grid/List visualizations can be used to view the record's "linked records", however these visualizations cannot be used on the record itself.I.e, if I have a Customer record with Order linked records, I can view the Orders in Grid/List visualization, however, I cannot view the Customer record itself in a Grid/List on that same page.What I would like to do is to show some of the Customer's fields in Grid/List view. When there are many fields this allows to show selected fields in a neat one-row view. (Rather than having each field one after the other vertically).Currently my workaround is to create a new linked record field where I link the record to itself, but it would be great if this could be done without this workaround.

60
M
Wyatt_Barnett
Wyatt_BarnettInspiring
asked in Interface Designer
iPhones and Interfaces

I’m really excited about the new interface designer features. Airtable has given us the tools to build functional apps without getting people too deep into the database side. Unfortunately I can’t quite fully embrace it yet – it seems like the interfaces don’t work at all on iPhones. Moreover the degradation is pretty un-graceful, users just get a message to login or use the app with little or no explanation of what went wrong and how they could fix it. Our folks – especially some key stakeholders – are on iPhones more than any other platform, making this an important thing to solve for here. Does anyone have any ideas about how to deal with this? Does anyone know what Airtable’s roadmap is? Would love to leverage the features if I can figure out how to manage this challenge.

3411
E
A
albiz94New Participant
posted in Interface Designer
Sharing read-only interfaces without the need for an account

Hello, I designed an interface with some nice stats and graphs only to discover that I can only share it with Airtable registered users. This is very annoying as I cannot ask clients or occasional collaborators, which often aren't even that tech-smart, to sign up to a dedicated service, even if it's free.Can you please allow us the possibility to share an interface in read-only mode with anyone who is provided with the link, just as google docs does?

450
A
Shuyen
ShuyenParticipating Frequently
posted in Interface Designer
Two tables open in same interface based on linked record

I'm building a CRM for my friend running a coaching business. There are two tables I would like to surface at the same time in a single interface "Sessions" & "Client"I want to create a user friendly view where she can see today's sessions - she can take notes etc for each session, and also have relevant client details up. (I've done a little mockup to explain)I know I can use Lookup fields to surface this information, but is there a cleaner way so I can simply open the Client details when a Session is selected (I'm using Record View but there might be another option)Any advice appreciated! 🤗

31
TheTimeSavingCo
A
atnoviceNew Participant
posted in Interface Designer
How to set up interface form to submit multiple records at once

I have an interface form set up as an intake form for employee changes.  There is logic built where different fields show up to be filled in depending on what is selected.  It works well for individual employee change but I would like to enable a requester to submit more than 1 change without filling out a new form. For example, I have 2 employees I would like to promote and want to select different reasons for each and for employee 1 there would be a position number change while employee 2 does not.  Ideally, the same fields/logic already built can show up for employee 2, 3, etc so they can run through the same questions.  Also, is it possible for form / base to have an embedded table (similar to google sheet) where they can fill in for multiple employees at once.  

331
kuovonne
K
KindraNew Participant
posted in Interface Designer
Missing the "add element" button in interface editor

It's past May 17th and I still don't have the left navigation UI referenced in the help article "Getting started with Airtable Interface Designer." I'm missing the "add element" button. Anyone else with this issue?

4143
B
A
Airtable_Padaw1Participating Frequently
asked in Interface Designer
Form doesn't allow user to upload files?

I created an "upgraded" form and gave users commenter access to the base and workspace. However, when they try to upload a file (images to be specific), they get an "invalid permissions" error. Is there a setting that I am missing? I tried out this setup with the old forms and it seemed to work. 

1076
kuovonne
D
degNew Participant
asked in Interface Designer
Newbie question: create a new contact

I know this should be easy, but I'm new to Airtable and apparently missing something obvious.I want to let users add a new contact to my base.I have a People table and a Companies table.  They are joined with a multi-to-multi Roles table [Person, Company, Job Title].I've built a form to accept a new People record, but:1) How do I detect if a matching record already exists.  If it does, I don't want to create a duplicate2) I want the form to also ask for the new contact's company and create a new Role. But, I can't ask for Company in a form on People, If, instead, I put the form on Role, then I can't create a new Person or Company; I can only accept existing ones.My assumption is that I'm trying to force the system to act in a way it doesn't want. And, that's fine. I'm new to Airtable and 100% comfortable restructuring my base to work in a natural way.So, my broader question is: how do I setup a base so I can link to companies (where multiple people can work in one company and

423
TheTimeSavingCo
D
david_zlatoNew Participant
posted in Interface Designer
Is it possible to edit "Link to another record" fields in interfaces in the mobile app?

In the iOS app, I can edit all types of fields in the interfaces except the "Link to another record" fields. I can view related fields, but I can't link or unlink them, although I can do that on the web. Is this a bug?

41
E
Sean_Lake1
Sean_Lake1Inspiring
posted in Interface Designer
Create an interface, but how to setup table(s)

Hey All.Curious how I might set this up.  Here's what I need.I have a form that interested parties need to fill out, an application.We review the potentials, and start the first pass of approvals/denials.The next stage is taking those that enter the next pass to be reviewed by instructors(who have their own base with info that can be a linked record to draw from)So we have a list of of records/attendeesWhat I want to be able to do is have each of the instructors to see the applicant, and make their ratings on each person/attendee/record.I'd thought of setting up like dynamic tables:Then I want an interface that makes it easier for the instructor to quickly rate each individual/potential attendee.  I think I'm almost there, but not sure.Thanks!Sean 

147
Sean_Lake1
B
BenFortunatoKnown Participant
posted in Interface Designer
Create new records / selections in linked fields on an interface - ON / OFF toggle missing??

I used to be able to allow users to create new records on linked fields but now I can't find this functionatlity. There was a toggle, editible and allow users to create a new field. This also applied to single select or multiple select categories. Is there a way to turn this feature back on? 

62
B
Ruchika_Abbi1
Ruchika_Abbi1Inspiring
posted in Interface Designer
Record detail view for same table in different Interfaces is different.

I see a strange behaviour in detail views (when you allow user to open record detail on a list/grid..) in Interfaces. There are 2 pages on separate interfaces. Both pages have a Grid view for the same linked record field. However, when I click on "customize" under allow users to open record details in the properties panel, the detail views available are entirely different. Even if I create a new detail view, it doesn't show up in the other interface. Completely perplexed!  Any clue what's happening here?Can't share any screenshots as there is confidential data. 

331
G
cvoith
cvoithKnown Participant
posted in Interface Designer
Timeline Single date record with 2 date records

Hey guys!I have a question about dates showing up on the timeline view. I have a table for schedules with a start date and an end date. By default if it's a single date (milestone) it fills out the start date if you build the schedule in calendar (as my company does). The calendar can show both records with single dates and records with a start and end date, but the timeline doesn't. It only show records with both start and end dates. Does anyone know of a way around this?My current workaround is I have an automation that changes the default start date to an end date when the record is created, but this causes it's own problems.Thanks!

51
G
M
MatthisParticipating Frequently
asked in Interface Designer
Allow interface creation without creator access

I would like my base's users to be able to create interfaces so that they can work with the data exactly how they need, however I do not want to grant them creator privileges. I also do not want them to be able to share interfaces (or event better if possible, share only within our organization). Is this possible?

132
M
I
iitgradNew Participant
posted in Interface Designer
Linking two lists side by side in airtable interfaces

I'm trying out interfaces for the first time but I am a little lost in the UI for how to do the following. Essentially I want a list of projects as one column and a list of tasks in the 2nd column.  When I select a project on the left I want the right hand list column to show the tasks associated with that selected project.  Is this possible.  I realize I can do this with a drop down picker but that is not the interface I really want.

501
C
D
Damien_BASTINInspiring
posted in Interface Designer
Interface mobile - Détail de liste

Bonjour,J'ai créé une interface mobile avec une "liste", dans laquelle on peut cliquer pour avoir le détail de l'enregistrement.Dans ce détail, j'ai à nouveau une "liste" pour laquelle on peut accéder également au détail.Mon problème est que ce second niveau de détail n'est plus accessible depuis l'appli mobile (avant ça marchait, et je n'ai aucun problème depuis l'interface PC). C'est problématique pour mon appli mobile :- Pourquoi ça ne marche plus : changement chez Airtable ou problème dans mon interface mobile ?- Comment puis-je régler ce problème ?Merci pour vos retours.Damien

41
TheTimeSavingCo

Badge winners

Show all badges
Terms & Conditions