Interface Designer

 I have a table that lists sponsorships that we receive every year for our conference. This may not have been the best way to do it, but the way i have it is that a sponsor is added as a record every year and the year is listed in the next column. The result is that the sponsor may show up a few times but when sorted by year i see their history (i.e- Sponsor A sponsored for 3 years in a row and increased their sponsorship every year).Now i have an interface that shows lots of data as a dashboard ($ we received every year, # of sponsors this year etc). From the sponsorship table, I want to have a number element that shows how many sponsors sponsored us more than 1 time (as in- looking at those records that show up more than once and have a matching name and understanding from that they've come back). Any ideas on how to do this?

So, I have some columns in one of my bases that are complex formulas working something out based on year. These particular formulas are necessary as there is no quick workaround via rollups etc., it's not pretty - and there is something better involving linked records in the works - but they are doing the job for now. Each of these columns show the data for one calendar year, and on an interface I used a number element to sum the column. This way a member of my team has a tidy way of seeing numbers for previous years (each year column has its own number element).They are all exactly the same column, with the same formula (adjusted for dates), with no options for formatting. I've been able to make four number elements using these going back to 2018.At the start of the year, I duplicated the 2021 column (which has a number element), and adjusted the formula to cover 2022. But this new column is not available to select within the number element Field Summary field list.Does anyone ha

I work for a small private adult education institution. We have about 180 students in 10 class groups. We need a way to send those class groups important time-sensitive messages and updates (ie: class cancellations due to inclement weather). We want to do this via text message to the students phones. They have all agreed to be contacted in this way for these purposes. I am in the process of building a database environment in Airtable for the institution to manage our contact lists, student files etc. I have started building an interface to access this database because our faculty is not very tech savvy and needs a user friendly visual design. I am aiming to keep them out of the actual bases all together.Within my master contact list base, I have added the Send SMS extension and connected it to our Twilio account. I've set it up to create contact list groups. I've tested it. It works. Is there any way that I can have that feature - the ability to Send SMS through the table I h

See picture.Now... 8 losers out of 250 is 3.2%... HOW do I get this to calculate inside of the interface? Instead of displaying "8" as the number of losers, I want it to display 3.2%. I swear Interface "use" to have the ability to do custom formula's... if not, what a major weakness. Any help?I flat-out can not figure this out. 

I am creating a dashboard interface for a donor management base.  There are fundraising campaigns which have receive donations towards a goal.  If the goal is, for instance, $1,000 and I receive $100, that's 10% of my goal and I'd like the dashboard donut chart to move the colored section up to 10%.Is this possible???  Thanks!

I have a list of donations made to an organization.  I have created a Dashboard Interface to report monthly donations received.  I would like to add a number widget that sums the number of all donations received in the current month.  I've already worked out how to filter to the current month, but I cannot find any option within the number widget to allow me to SUM.  I can only display the Record Count or a Field Summary.  Yet I have seen the post linked below that has the ability to do what I want:https://community.airtable.com/t5/interface-designer/interface-cannot-use-formula-result-in-number-element/td-p/76935What am I missing???  TIA!

So I noticed that a grid view can support multi-selection on its first column.I'm wondering if there's a way to run an automation based on what is ticked? This would be great since I can run batch operations. I did notice that in Interfaces a button is not able to connect to a Grid View at all though, so I'm wondering if this is even possible? 

I'm struggling to work out how to dynamically set the domain of my chart. Ideally I'd be able to do something like:https://stackoverflow.com/questions/66170320/dynamic-scale-domain-in-vega-lite{ "scale": { "domain": [rangeMin * 0.8, rangeMax * 1.1] } }I've found this question on StackOverflow and I hit exactly the same problem. When I try to use `expr`, I get the error "Incorrect type. Expected "null". What version of Vega Lite does this integration use and is there a link to the documentation for this version?

Hello.I have a database of people who are taking part in a series of activities over a couple of months.In Airtable I have two tables - one which has all of their information (contacts etc) - and another which is the schedule.  I have allocated individuals to the different activities in  the schedule by creating linked tables.I would like to produce an Interface (I think in the Record Review format) that allows me to select an individual from the list on the left.  On the right I would like a Calendar to appear that is bespoke to them.  ie. it shows them only the activities that they have been allocated to.At the moment the only way I can do it is to create an additional filter on the Calendar but is there anyway to bypass this step and just use the names on the left to do the filtering automatically? 

Hello I am creating a time to value metric reporting system for our course.Our goal is for our students to complete their first submission within our course in 14 days.  I have created a formula field that calculates the days from the student's enrollment date to the date they submit their first submission within our course. (see below).So my question is; how should I create reporting in the base interface that reports the number/percentage of students who completed their submission within 14 days? 

As title says, every time I make a change to a new record in the record list or something that filters/moves record in the list... the list jumps to default to bottom of list. then I have to scroll all the way to the top and find my spot to select the next record.Any reason it doesn't default to top of list or a setting?

Hi  good day everyone,I wanted to ask if Airtable has a feature similar to click-up docs editor.  or somehow that field that can be opened on a Microsoft word like editor. Especially when you are building documentation for the selected row that can also be read by other people.

Hi, I am using a timeline view in my interface to view the holiday status of our crew.I'm having an issue trying to find out how to keep one field per line - in this case my "Name" field.Currently, the names are all over the pace in terms of layout, and it's confusing for our users.I've attached a screenshot of the issue, with names redacted to protect the innocent.I am currently sorting by the Name field, since that's what makes most sense in our business. I am also grouping by department and role.Any ideas how I can tidy up this view to make it easier to view?Thanks in advance.

This is odd. If I create a Timeline view under the Data tab, I can group by a multi-select, and there is a handy option: "Split multiple values into individual groups". So if I have this data:option1, option2  A  B  Coption3           D  E  FThis option gives me this instead:option1           A  B  Coption2           A  B  Coption3           D  E  Fwhich is exactly what I want!But this option is not available for grouping a Timeline created as an interface?Why the discrepancy? Will this be fixed?

Tell me, please, is it possible to show one of the fields of the table in the Form, under the condition that it links with another field?I.e. if the first field is an organization, then the second field allows you to choose only from the employees of this organization?Making separate Grids for each organization, as I see it, is not a very interesting option....

I was making adjustments to an existing interface this evening and when I went to add a new record inside of a linked record field in the interface there was no longer an "Add New Record" button at the bottom of the linked record window.  See screenshots:Original Functionality:  Limited Functionality:Everything is setup the same, and I've tested this in multiple tables.  Was this functionality removed on all new or edited interfaces?  Please help because my sales workflows are using this functionality to operate.

I'm loving the new Current User on Interface.But is there a way to get Roll Ups to reflect the data for that user?Use Case:I currently assign different users tasks. I have a Roll Up that shows the last date the task was done.So if Dwight did the task on 15th, and Kevin did it on the 20th the current Last Date would say 20th.I need it to show the last day Dwight shot it when he's looking at the data.Alternatively, Is there a way to include Current User in a formula? I could possibly make a field that reflects that, and then filter the Roll Up based off of that. 

Hello Airtable people,I have a ticket management system. To manage this, I have a joint table that allows me to link a group of Items to a single ticket (2015, 2016 ...). So I have to enter each Item in the Items table and assign them to the actual ticket.My problem is that when I change the ticket current ticket, the same information is displayed in the Items grid and I would like to create a display condition that filters the records from the Grid to the currently edited ticket.Something like: only displays records whose Ticket ID in the Items table is the same as the Actual Record in the Tickets table.Thanks for your help 🙏

Hi there, Is anyone using a formula field to create an interface page for each record? The formula looks like this : 'https://airtable.com/app.../pag...?...=' & {record_id} This way, the record picker picks up the record automatically, so each link can function as a customized page. I use this to control our projects. The record_id of each project gets picked to create a page with all-round information of the project. :cry: BUT it stopped working recently, the link opens the interface page, but the record_id automatically changes back to the default (the first record in the record picker list) … I am waiting for Airtable support team to answer by email. Meanwhile I wondered if anyone was using interface designer by configuring URL with record_id AND if anyone is experiencing the same problem as me.

Hi, I'm facing issues with the footer on my website on mobile. It works great on desktop, but on mobile, its background disappears. This is my site link: (https://howtowatchstreaming.com/). Any tips on how to fix it?  

We have a record summary interface that has a couple of conditions built in. We have added three filter elements at the top of the interface screen so that users can filter things on the fly, hopefully by multiple filters at once. It seems like only one can be active at a time, but I can’t find documentation for this. Is this true? I hope not because applying multiple filters on the fly in the interface helps the users find the records they need to work on.

hey this is MAJORLY needed to look at: major feature issue for interface designer!!!you need to allow for the feature show only "current user" to be applicable to fields and or views in a grid on interface designer. !!without it, you see a bunch of fields you might not want your user to see on a grid view in your app.!!e.g. if i add a grid to an interface:Solution 1: show only view assigned to current viewer (best option)Solution 2: show only records by current viewer AND show only FIELDs for current user two ways to get the same thing. option one can mean only 1 time assign a user to a view -- OK --- or offer gird view options available to current user. best option: control permissions of which views (that the current user can see) you want available to that current user in that specific interface element)you basically have the feature (see pics) but you did it for edit record permissions, specific filters. just make this for VIEWING permissions, by a view, with control on select

Hello here,I have created a database that I have formatted via the interface. Great tools. Is it possible to share this interface in 'guest' mode (without the client having to subscribe for example)? 

Hi all,I've been re-doing my interfaces as i've update my tables, and i've noticed that the way records are shown in a gallery view has changed. Orignally i used to click a card, and the record would pop up. As far as i remember i used to be able to customise what fields were visible on the pop out.The new way opens a record on the page (rather than a pop out) but i'm limited in terms of customising this. Yes i can change what fields are visible, however this then applies to ALL record views for that table. As my data is essentially a warehouse stock system, i have a number of gallery views.First, i have a gallery where only records with certain information is missing, with the intention that i can go in, and add the relevant information (Order value, supplier, order qty etc)I then have another gallery where my "Stock on hold" records show. Here i am adding in the number of units delivered to me. In both cases, i do not need the same fields visible when i want to edit the rec

My friend showed me her Airtable and I swear there was a layout like the image attached. A big table layout with graphs, notes, and documents. You could zoom out to see the relationships and organizational structure or you could zoom in and actually read the documents and spreadsheets themselves.Can anyone help me find this?