Interface Designer

I have an interface to track our sales, and I group the results by "Source".Source is built in Customer Records, then linked into Quotes, from there it is linked into Sales. My data still shows grouping within Customer Records, but stopped displaying the data in my Sales graphs (it was displaying fine until 4/2). As you can see, the graph populates with the correct premium Y axis, but the data doesn't show up as it does in leads. When I deselect grouping by source, the data populates, but disappears when I group by source again. Any ideas?

I have an interface chart that displays bar data grouped by a "Linked Records" field. In the table where these records exist, I have color-coded entries in this field (it is a "Single Select" dropdown). Here are some things that I've noticed:(doesn't work) In the interface, if I group by this linked field, and choose "Use colors from base", then the data in the graph disappears (the axes remain, but there are no bars displayed, no elements in the legend). This is my main problem.(works) If I choose a "manual AirTable colormap", the bar graph shows up.(works) If I choose a non-linked Single Select field that also has custom colors, then the bar graph shows up with the appropriately colored lines.(works) If I make a bar graph from the records in the *original* table and use the same field, but now the original (non-linked) version, then the colors also show up appropriately.Can somebody explain what is going on?

I have searched and can't find an answer to this one.I am creating bar charts in one of my interfaces using a Look Up field, it won't return any data, it brings through the look up field lables in the X axis but no data comes through.  Am I doing something wrong or will Look Ups not work with charts within an interface?

Hi all, Thank you in advance for your help 🙂 I'd love to get some suggestions for removing all the labels at the bottom of this chart in one of my interfaces. It has got the dates as the x-axis. I can't find a way to remove the labels so they don't look cluttered. Any suggestions? 

Is there a way to create a view (grid view) that you can drag and drop records into with out having to use the "filter by"?

Hi,Loving the new interface designer, and itchy to update current interfaces to take advantage...but for some reason most of the existing interfaces seem to be stuck in the old designer - none of the new features (like easy user filtering, mini tabs or view toggle features) are available.Am I doing something wrong or will it just take some time to roll out to existing interfaces?

I created a record detail interface a while back to look at the details of our members. However, now that we have the record review interface, I'd like to convert it without deleting all of my hard work. Is there a way to "upgrade" the interface without having to redo everything?

Hello,I have this simple problem with filtering by date. When I try to filter Date - is within - past year I also got records from this year.Also If I try to filter Date - is within - past month I got only some of the records from the previous month.What am I missing here, please?

Hi there, I'm not sure if this is possible or if I'm approaching correctly the solution, but here it goes: I'd like to create some sort of dynamic filter that when I input a date, everything else in this table will update accordingly. The link records that won't meet the filter criteria will be excluded, therefore, updating the COUNT calculation and all related formulas. To give you more context about the base setup, there are two tables: TicketsSuppliersWhat you see in the screenshot above is the Suppliers table, which is aggregating all the tickets. Is there a way to exclude linked records based on a filter?Thanks everyone!

Hi all, Is there a way to auto populate a linked field (from a parent table) in the child table through Interface Forms?I have a parent table 'Projects'. Each record can be selected and viewed in Interface Designer. There, the collaborators can click on a button which takes them to a Interface Form which will create a record in child table 'Tasks'.Is there a way that, after clicking the button, system knows from which parent record the button is clicked and it auto selects the record from which the form is opened? 

Hey! This is driving me mad and I'm sure it's either: - I've been working on this for too long and I am overlooking the obvious / need a break- A bugContext: I have an interface where there are requests from form submissions. There is a 2 step approval process, where approvers should set a status by clicking a button. These users are "editors" in the interface, so permissions should not be the issue.When I "View As" / Preview as one of these approvers, I see that the buttons function correctly and I can set the statuses. Image below.  This approver though has a different view - they cannot click the buttons. I'm a bit at a loss for what to do in terms of troubleshooting. The tricky part is, there are 5 or so approvers, and ONE of them is able to interact with the buttons and set the status (calibrated / flagged / clear).  Any suggestions/thoughts? 

What is the purpose of the built-in line select checkbox in an interface using list view?  I can't find any reference to it or samples of its use.  Is it just a relic from the data view?

Hey there, Fairly simple, but building a chart based on form submissions. For this use case, we want to represent the level that someone is being promoted into. The way this is represented on the chart element has the "10" before 3, 4, 5, etc. and I cannot figure out how to rearrange this. Thanks! 

When I click on the "Interface" button I am guided to a page that has two links, "tell me more" and '"start building" but when I click on the "start building" button, I'm shown a graphic describing the three steps but no path from there to actually building a database. I notice that my top bar (see screen capture) is different from the one shown in the "how to..." video, FWIW

We have built a nearly 20 interfaces.  Is there a way to alphabetize or even group them?

Hello there! Someone figured out a way to add a predefined horizontal line to a chart? I’m trying to create a dashboard in Interfaces and one of my charts could use a fixed horizontal line to indicate a threshold value I’ve been looking everywhere and I see no way of adding it to the chart Thanks!

I've got an interface showing a list of all customers who we are awaiting information from.How would I go about sending those customers an email, when I click a button to do so in an interface? I don't want to do it automatically when they enter a view because there's a manual review step beforehand.I thought I'd found a solution via the sendgrid extension but it looks like that's only possible via data tables, not interfaces. I also tried triggering an automation via a button click but I could only get that to work with the record picker (i.e. one record at a time), rather than in bulk.I feel like I'm not seeing a relatively obvious solution here!Any guidance appreciated.Thanks

Hi there,We currently have a candidate pipeline interface that looks like this:The numbers are based on a formula that outputs the stage based on the latest date set, so the 11 candidates in stage 2 all have the latest date added as 'Stage 2 start date'. As soon as we add a date to a candidate to 'Stage 3 start date', it will add take 1 of stage 2 in the interface and add 1 to stage 3. Here's the database view of that, where you can see the formula and the some example date fields: This works well, but: now we want to be able to add a filter where we select a date, displaying the pipeline from that date, so how many candidates on that day were in each stage.Does anyone have a clue how to get this, let's say, historical snapshot view of the pipeline?Thanks in advance!

Hi all, my interfaces crash whenever I use the Filter elements on the Grid view in Interface mode. Is anyone else having this issue? 

Hello,Can I use the Interface Designer to build an HTML Template to copy/past into Substack ?As you can see it is bery basic but it seems the ListView lack of configuration:How to hide the Table Header ?How to combine Title + URL into a Link ?Is there some kind of HTML Template that let us decide how to display a ListView Record ? Or may be I should create a script that write the HTML into an hidden field that I display (seems overcomplicated)

Hello,I have a base for our sales CRM. In the CRM I have 3 key tables:DealsTasksReportsEach Tasks and Report is linked to a Deal. In Deals we have a field "Owner" which is a User field. In both Tasks and Reports we have a linked field "Owner (from Deals)".I want to create a dashboard for our weekly meeting with one filter to select one or more users from the "Owner" field and then based on that I have 3 grids one each for Deals, Tasks and Reports display records based on the "Owner" filter. (the next step after I solve this would be then to filter records based on a date field, but I believe this isn't going to be a problem).I can't find any way to cascade the filtering from the Deal Owner to the Tasks and Reports.The only way I can mentally come up with a model that would work is if I had a table "Owners" and linked the Deals to an Owner. Then I should be able to use a record picker to select the Owner from the Owners table and cascade the filtering down to Tasks and Reports as well.B

I'm using a multi-select field to capture grade levels taught (Pre-K - 12th) and added this data into a chart in an Interface. When sorting Ascending or Descending (the only options), the logic of the sort seems to be treating the numbers as single digits and sorting them based on the first digit. (ie: "10" is read as "1" then "0") Is there a way to get this to display grades 1-12 in order? A similar post questioned if this was a bug....and surely it is some type of logical but sorting numerically seems quite basic. 

I am trying to add numbers and percentages to a chart. I know there is a similar post here, but this is from 2020 so I wanted to see if this feature is now available in Airtable. Any help on this would be appreciated 🙂

Hi! Any help with this would be greatly appreciated - I'm having a data vis problem in one of our table interfaces. We keep records of individuals we've helped (Stronger Storytellers) and the ideas we've helped grow (Good Ideas) and we tag each record with any number of our 7 impact areas.I want to create a visual e.g. pie chart that shows the total number of Stronger Storytellers by impact area, and Good Ideas by impact area. Currently, rather than including every Stronger Storyteller (we have 1498 on record as of right now) it will total the number of records instead (currently 524) which means the visualisations don't accurately represent our impact areas. TIA for any tips on how to approach this 🙂

HI Everyone, I'm looking for ways to sort a Donut chart so that pieces are in order of percentage i.e. smallest percent to largest. Doesn't seem to be possible. I've created a view, sorted and then copied from view but doesn't seen to change.  Any advise greatly appreciated