How do I conditionally format text field being populated using Google Sheet plugin?

Question

Hi all. I’m new to Figma and currently working on a project where I’m generating cards using text pulled from a Google Sheet via a plugin like Google Sheets Sync.

The sync is working fine. Each card is receiving the correct text from the sheet. However, I’d like to go a step further and apply specific font colors to certain words or patterns within the text.

Here is the data in sheets:

Here’s a screenshot of the cards in Figma:

The 2 cards in the frame are populating with the text correctly. However I would like the font to have certain colors based on certain keywords. For example,

In Line 1: “Some” and “line” should be red, everything else in line 1 should be white.
In Line 2: “Some” should be red, anything text in bracket should be orange, etc.

My Questions:

Is this type of partial, inline text formatting (color changes) possible when using data from Google Sheets?
Are there any beginner-friendly tips or best practices to achieve this?

I’m hoping to avoid having to manually change the colors of individual words in each card.

Thanks in advance!

Thanks.

Ellwood · Answer

Hi ​@LOkwu,I’ve been using the google sheets plugin for a while and to the best of my knowledge, there’s no way to conditionally format portions of text within a singleimported data field.You could cutup the string into different data cells to target a specific ordering (ie first word)depending how you cut up the string (could be a lot of manual work to manipulate the data especially if using a large data set), and create an autolayout to bring the sentence together. This way you could style words given a specific order in the sentence, but still, this doesn’t allow you to essentially ‘search’ for specific words or patterns of words to style differently.Hope that helps.

Sign up

Login with SSO

Login to the community

Login with SSO