Clear the missing field in the table

Hi Community,

I would like to ask if there is any way to clear the missing field in the table as per screenshot below . Reason being it is missing due to certain data changes every day , some times with in same day it will be like, Day :1 our staff may work 6am to 10pm, day 2 may be 9am to 6pm. When I run with out any table rules the output was correct however if I include table rules then Iam getting error below

IMG_20231117_151313.jpg

IMG_20231117_151330.jpg

Reporting

Common Use Cases

Accepted answers

CoG

Change the formula to this then:

IF REGEX_Match([_CurrentFieldName_], ".*\d.*") && !IsNull([_CurrentField_]) THEN ToNumber([_CurrentField_])<=4 ELSE 0 ENDIF

All comments

Christina_H

Are the column rules the same for all time columns? If you exclude all the time columns you can set the rules on Dynamic or Unknown Fields. Then when you re-add the time columns, whichever ones are present should pick up the rules with no errors.

SGK_TS

Hi Christina,

Thanks for your response. I am just trying to color in red each column in each hour when the count is less than 4 basically .. kindly help me how to arrive this. am getting the error , could you please check.

IMG_20231117_160657.jpg

CoG

Using this formula on Dynamic/Unknown Fields which is first attached to a table with trash column:

IF REGEX_Match([_CurrentFieldName_], "\d:\d{2}") THEN ToNumber([_CurrentField_])<=4 ELSE 0 ENDIF

If you delete the connection to the Table Tool and instead connect it to your table, it should work.

Table Formatting.yxmd

SGK_TS

Hi AndrewDMerrill

Thanks for your response , look like your flow chat can resolve my issue but I am getting below error , could you please guide me

Error: Parse Error at char(n): Formula: tried to apply string operator to numeric value (REGEX MATCH )

My data will be like below

ID	Name	9AM	10AM	11AM	12PM	1PM
123	KSK	8	16	3	15
456	DD	6	44	4	18	12
789	IIO	4	62	4	0	13
125	PKO	2	32	4	20	14
String Data Type	String Data Type	Double Data Type	Double Data Type	Double Data Type	Double Data Type	Double Data Type

CoG

If the column names are different than the form I included in the REGEX_Match function, then that will not work. I'm not sure why you would get that error since the REGEX_Match is running on Field Name which is always string type.

Using the data provided, I had no issues on my end after changing the REGEX expression to ".*\d.*". So the table you include is exactly the format of your data? I even tried changing the field name to just a number (e.g. "2") and it still worked on my end.

SGK_TS

Hi AndrewDMerrill

Thanks for your response, Now it is working fine however small rectification needed, Less than 4 is highlighting in color including blank see attached, i would want only number less than 4 should be highlighted except blank , request you to help me

Thank you so much for your time and help

IMG_20231121_135005.jpg

CoG

Change the formula to this then:

IF REGEX_Match([_CurrentFieldName_], ".*\d.*") && !IsNull([_CurrentField_]) THEN ToNumber([_CurrentField_])<=4 ELSE 0 ENDIF

SGK_TS

Thank you so much Andrew, it's working as expected

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703