Yeah, I know - this sounds like a pain in the ass 🙂 But it's more a Figma thing than Bravo limitation. And the more You work with Bravo, the more it's probable you will have to do that at one point.
What I do is:
I create an additional column in Airtable called the same as my original column but with the "(Styled)" suffix
My value --> My value (Styled)
I write my HTML in code editor because writing directly in Airtable sucks 🙂
My value is <span style="color: red;">{My value}</span>
- text in curly brackets is your original column
- text that is not styled using HTML will use Your Figma original styling
Now it's time to add text conjunctions and escape double quotes in your code (Airtable requirement; this is very PHP-like)
"My value is <span style=\"color: red;\">" & {My value} & "</span>"
- ampersand is a text conjunction sign in Airtable
The last thing is to add [component:text:html] tag to the text layer in Figma and it's ready for data binding in Bravo Studio
This may sound complicated at first but I highly recommend trying it at least once because it helps You to understand what are Bravo and Airtable (or any database) roles in this tool stack.
After that, you can create pretty awesome stuff like combining data from different tables, calculating values from different columns, or checking empty values and replacing them with a placeholder (using IF formula in Airtalbe) before sending it to Bravo.