Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

Topic Labels: Data Interface Designer
192 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?