Hi Community
May i please ask for a suggestion/advice. i am trying to create a list with advanced formatting which will read 2 layers and colour code the records based on if a record from one table found in the other one.
In other words, i have created a field app which captures data on site and i have a lookup table, need to compare if an ID is found from the lookup table and colour it green as an example.