TeamDesk.SelectView

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

示例:

Retrieve all meetings from List All view

使用情况:

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

输出:

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

示例:

Retrieve today's meetings from List All view

使用情况:

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

输出:

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