How do you format data in one table based on the v...

Alex_Tashlykov · 10-14-2019 07:45 AM

Hi! I have usial table with ref.

How do you format data in one table based on the value in another table?
Look here:

Suvrutt_Gurjar

Please explore if an expression something like below helps in setting the format rule for the column fruits in your parent table.

ANY([Related Dates][Date])=TODAY()

The expression assumes, there will be only one date for one fruit on a gieven day.

In general, you may wish to note that complex format rules are expensive in terms of app sync time.

Alex_Tashlykov

What if i need two and more dates???

Suvrutt_Gurjar

Hi @Alex_Tashlykov,

Could you please clarify, which date it is not working. From your picture it sounds like it is working for 15/10/2019 which is correct because today is 15/10/2019. The expression was for only one date comparison as mentioned.

Based on your latest requirement of two or more dates conditions, you may please add OR conditions suitably in the format ruleas per example below. I believe the expression something like below below will work for two dates of today and yesterday. Please change that condition suitably as per your needs.

OR(IN(TODAY(),[Related Dates][Date]),IN (TODAY()-1 ,[Related Dates][Date]))