I ran across a problem I’ve encountered before - and was hoping to figure out the “best practice” for solving it.
Essentially it comes from copying data from one table to another (where the data can be changed in the “copy”)
I’m getting lists of lists of lists… and lists where I’d rather a single item etc.
So I’m wondering where to use .first() and .list() and .totext() etc.
This particular version of the problem Its a slightly difficult one to describe simply in a message - so instead I’ve mocked up a new feature for our project management system which shows the problem very clearly. The feature is a little complicated, but I’ve annotated the entire page / described each table, and showed where the problem is occurring.
Help would be much appreciated - and I’d even like to create a simple reference page on when to setup lookup formulas in particular ways. I’m guessing for those here who are used to programming, these things come quite easily. However, for those of us like me who are NOT programmers, understanding conceptually whats going on with the solution is key to being able to work on problems like this. And at least I think I understand conceptually what is going wrong thanks to a bunch of posts in this forum (and replies to previous topics of my own)