![]() ![]() The variable "this" is simply set to the region of the portal row this conditional formatting is evaluating in. So, what is going on here? The calculation is broken down into simpler chunks using a Let statement to make it easier to follow: Previous = GetNthRecord ( Customers Filter::Region Record - 1 ) Record = Customers Filter::zRecordNumber The conditional formatting calculation I am going to attach to the Region field in the portal is as follows: Also, is there any reason for the region to appear in each row? What if we could have the region appear in the first row for those customers only? Indeed, this is possible with a little conditional formatting. Now, this could be the end of the story - the records are sorted as you wish, and you can clearly see the region for each customer, but is it really that nice visually? The region name is appearing multiple times in each row, which is quite distracting, and also makes the portal feel cluttered. The relationship this portal is based upon, is sorted by Region, so that in our portal, all customers who belong to the same region, will appear together as shown: On our layout, we have a portal showing all customers. In this table, there are 3 main fields:Įach customer has a specific region, so it stands that a region may contain multiple customers. In this example I will be using a very simple Customers table. ![]() The easiest way to explain it is to just get stuck in with an example, so here we go. This method is suitable for portals whose underlying relationship is sorted by a grouping/category field - similar to if it were like a sub-summary report. ![]() In this article I will demonstrate a very nice way to format a portal using conditional formatting. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |