User View Functions

User View functions include:

RowCount Function

The RowCount function receives a user view reference as input and returns the number of rows in the user view per recipient.

Syntax:

RowCount([UV Name])

Example:

RowCount([MyUV]) returns the value 2

UV2STR Function

The UV2Str function creates a formatted string from a user view.

You can also use this function to format a user view into a string and then use this string as a parameter for another function that will be exported by a QLingo extension.

Syntax:

UV2Str([UV Name], 'string before new row', 'string after row is ended', 'string to add between columns', 'Boolean true/false indicating whether to add column names as first row')

Example:

Say, for example, we have a table of the form:

 

First Name

Last Name

John

Smith

Jin

Sonoma

And this table is in the user view UV.

If we call the function:

UV2Str([UV], '\"', '\" | ', '\", \"', true)

The resulting string will appear as follows:

"First Name", "Last Name" | "John", "Smith" | "Jin", "Sonoma" |