I used FLATTEN query and this helped to get rid of the distortion in the output but it’s not what I really need.
What I’m trying to do
I want dataview to apply the following function formula correctly on multi-value key notes just like with single-value keys:
TABLE WITHOUT ID
file.link AS "Name",
ID,
"[" +
"0" +
Phone +
"](tel:" +
Calling_code +
regexreplace(Phone, "[-]", "") +
")"
AS "Phone No."
FROM "4 - Company Staff"
When the note of a person have more than one phone no. the output comes out as in the following image:
Do you want each phone number a person has to be its own link? If so, consider using the map function, maybe, to apply that formatting to each item in the list. However, I am not sure what the behavior will be on people who have only one phone number. You might have to format the single phone numbers as if they were inside a list of size 1, or there might be some other solution.