Which itself is generated from another table which calculates the payment dates using a button and FormulaMap/AddRows. I’m trying to make a document formula to display some information from this table. For example: “You have 4 missed payments from ADNOC, XXX, YYY”. Doing this:
Filter([Payment Verification],Date< Today() AND Received=false).BulletedList()
Results in this:
unique(Filter([Payment Verification],Date<Today() AND Received=false ))
Results in this:
And this:
Filter([Payment Verification],Date< Today() AND Received=false).List()
Give me:
Now I can’t figure out:
Why does using BulletedList() at the end of the formula return Clickable Links which open the Investment, where List() returns the dates
Why does Unique() not work to filter out the second ADNOC? I assume it’s because the Filter() returns 3 dates? What does Unique() look at in the returned list, if one thing i’m getting printed is a name and the other is a date
How could I combine these returns to display something like:
You have X missed payments from [ADNOC] and [PETROFAC]
Those two being clickable so I can mark a payment as received?
My understanding is that the Display column uniquely identifies the row. I think this is why you were having issues with the Unique() formula. An investment name used repeatedly in the Display column is, by definition, not unique. Pairing it with a payment date using Concatenate() creates a value in the Display column that is actually unique to that column.
Ah. I actually noticed a difference; ADNOC now opens the row from another table (containing investments) not the row from Payment Verification which lets me click the checkbox.
I’m not sure how creating the row is actually pulling the @ADNOC for a reference when i create the row, and then in the two formula references.
For the list types, how is:
BulletedList(value) - Renders a bulleted list from the provided list or array.
List(item) - Creates a list from the provided items.
Substantially different? One makes a list from a list or an array and has (value) and one make a list from items (different than lists or arrays?) and has (item) (also different than value?). Not sure what the differentiation is there.
You’re basically there – when I opened your doc, it was working as you’d wanted. You’ve achieved that by hard coding “@” references as shown below. This works, but you have to hard code it, which isn’t user friendly.
All that remains now is to change that column from hard coded “@” references to a Lookup column, as shown below.
