I am trying to add conditions to my repeating group based on search results.
I have integrated Exa.ai into a search bar and would like to colour different cells within the repeating group based on search returns.
For example (Australian based hence returns);
If one URL has org.au in it, the cell within repeating group turns blue.
If another URL has gov.au in it, the cell within repeating group turns green.
Now, I can get the results to show the URL however no change in colour even when adding conditional formatting.
Some research showed I perhaps need these “changes to a thing” in the workflow as well to reflect the conditional formatting.
Along the way trying to make it work, I think I got lost between trying to trigger text and using hex code for colours between workflow and conditions.
Any help would be great, I feel like I am going in circles.
Hey there! This should absolutely be possible with conditional formatting (no need to do anything in the workflows, I don’t think!) I’m curious about the structure of your repeating group… I bet you might just be putting the conditional formatting on the wrong thing. Here’s a screenshot of a little test I did in one of my apps to just see if I could do what you’re describing… I put the conditional formatting on the text field where I’m displaying the text that I want to be a different color depending on what the content is (so, it’s a couple of levels down from the repeating group in the UI Builder). If you share I screenshot of the UI Builder, I can probably tell you where that conditional formatting should go!
I thought perhaps my conditioning isn’t reading my arbitrary text correctly or possibly could be from my data set, however it’s purely changing colour based on results so I didn’t think it could be that.
Is it possible to conditionally change the cell’s background colour within repeating group, say I have 5 results per search? I may have different conditional colours appear inside the same search (green, blue etc) If not, I can revisit my design when it comes to building the visuals.
Here is a screenshot of my UI Builder and current conditional format.
Hiya, from what I can see, you’re trying to do conditional formatting on the Repeating Group as a whole… which I don’t thinks is possible/right in your situation.
Try putting the conditional either on the text cell in your RG, or if that’s in a group, put the conditional on that group. ie. the thing you want to change the background of.
The idea is to put multiple conditional statements there.
For instance:
First Conditional - If current cell’s AI Search result’s url contains arbitrary text ".gov.au’, then background colour [whatever].
Second Conditional - If current cell’s AI Search result’s url contains arbitrary text ".org.au’, then background colour [whatever, next colour].
Third Conditional - etc.,
So to recap, you don’t apply conditionals to the RG as a whole, you apply the conditional to the specific thing you want to change, i.e. the background of the text, or the group the text is sitting in.
I’ve got one other tip for you if you try that successfully. Just start with 1 conditional and then hit me up for the tip
