I'm trying to put a merge variable in a portal row that gets filled using a SQL query by conditional formatting. That part is working great.
The problem that I'm hitting is when I view the portal the results are shifted one row down. So row 1's data appears on row 2 and so on. Is there a way to make this work? I've attached a screenshot to display what I'm seeing.
I don't think this is something that FileMaker can actually pull off, but I could be (and hope I am) wrong. Thanks!