Using CONTAINS to reference custom data in a conditional formatting rule in Lucid

Question

I have successfully setup conditional formatting to display a status icon on a shape based on custom data. The first is a data field on the shape that contains a version number (in text). Next, the page has a similar data field with a version number.

In the condition, I have been able to check if one version is higher or lower than the other and display a corresponding icon. I’m using THIS.”Version Updated” = PAGE.”Version”. The shape data is from a dataset, and the page data is custom.

I would like to change the shape data to be a string of values (probably comma separated but that could be defined).

I then want to use CONTAINS to find the PAGE.’Version’ in the THIS.’Version Updated’.

Is it possible to use CONTAINS with these type of references? And if so, what would be the syntax?

Humas1985 · Accepted Answer

Hi​@David WilsonConditional formatting supports the use of the CONTAINS function for both shape-level and page-level custom data fields. This allows you to check if a field includes a specific substring, which is especially useful when working with comma-separated values or similar lists.For example, if a shape’s data field contains "1.0,1.2,1.3", you can use a conditional rule to check whether a particular version (e.g., "1.2") from the page-level data is included.The correct syntax is:CONTAINS(THIS."Field Name", PAGE."Field Name")This checks whether the value in the page-level field exists as a substring within the shape’s field.This function is case-sensitive and does a simple substring match, so be cautious with values like "1.2" vs "1.23".Hope this helps - Happy to help further!!Thank you very much and have a great one!Warm regards

Reply

Create an account in the community

Log in to the community

Scanning file for viruses.

This file cannot be downloaded