Things I have tried
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",
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.
This is exactly what I needed. I used
map function and that works. Thank you very much.
P.S. People who have 1 number didn’t show up at all until I formatted them as a list as you kindly mentioned. But that’s ok for me.
Yay, I’m glad that worked. Thanks for reporting back on what happened with contacts with just one number - now we have both learned something!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.