Nhảy tới nội dung

TeamDesk.SelectView

Syntax

TeamDesk.SelectView(
url as Uri.Type,
optional table as text,
optional view as text,
optional filter as text
) as table

Remarks

Retrieves the data from provided table and view. You can also apply an additional filter for results.

Examples

Example #1

Retrieve all meetings from List All view

TeamDesk.SelectView("https://www.teamdesk.net/secure/db/57692", "Meeting", "List All")

Result:

#table(
{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date(2018, 10, 12), 10 },
// ...
}
)

Example #2

Retrieve today's meetings from List All view

TeamDesk.SelectView("https://www.teamdesk.net/secure/db/57692", "Meeting", "List All", "[Start Date] = Today()")

Result:

#table(
{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date(2018, 10, 12), 10 },
// ...
}
)