Help

Customize base data fields value before displaying the charts in AirTable Interface

Topic Labels: Data Interface Designer
158 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Yazan
4 - Data Explorer
4 - Data Explorer

Heya,

We have an interface where we display charts from a base. However, I am wondering if there's a possibility to adjust the data incoming from the base before it gets displayed.

For example, there's a field that we need to reformat in a specific way before it gets picked up by the charts.

3 Replies 3

Hmm could you provide an example of this?  May I know what issues you faced using a formula field to format the data and using said formula field in the chart?

It's not the formula field that I'm having an issue with.

There is a field where values follow this pattern: <role> <space> <seniority level>. Since interfaces consume data from a base using this pattern, the charts may appear cluttered and visually unappealing.

I want to reformat the data before the interface picks it up—for example, by removing the <seniority level>.

The only solution I’ve found is to create another base.

After conducting some research, I discovered that customization within the interface does not exist.

 

Hmm, yeah I was thinking you could format the data with a formula field, and so with reference to your example you could remove the seniority level like so:

Screenshot 2025-01-31 at 8.33.19 PM.png

I don't think I understand what you're trying to do though.  Any chance you could provide some screenshots?