Test-ParserFunctions-in-ExternalData

From sandbox
Revision as of 17:23, 22 May 2020 by Gfc (talk | contribs) (create page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

TEST

Management Organization

Sandbox is managed by small staff and a larger team of volunteer Managers and Advisors.

Staff, Volunteer Managers, and Advisers

  • Staff The current Sandbox staff is made up of:
    • One full-time faculty assistant.
    • Several part-time student employees.
  • Volunteer Managers are the core of the Sandbox workforce. They assist makerspace visitors with a wide-range of functions. For more information about the roles and responsibilities of managers, click here
  • Advisers contribute to the space by leading workshops. For more information about the roles and responsibilities of Advisors, click here

Current Roster

yes

{{#get_web_data:

url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pub?gid=1533673129&single=true&output=csv
|format=CSV with header
|data=Name=Name, Email=BestEmail, Role=Primary Role, FirstName=FirstName, LastName=LastName, NickName=NickName, WikiUsername=WikiUsername

}}

Wiki User Page

{{#for_external_table:

[[User:{{{WikiUsername}}}| {{{WikiUsername}}} Userpage ]] [[YES User:{{{WikiUsername}}}]] | [[NO User:{{{WikiUsername}}}]]}

}}

Role First Name Last Name Wiki User Page
(& Recent Contributions)
Email

{{#for_external_table:

{{{Role}}} {{{FirstName}}} {{{LastName}}} [[User:{{{WikiUsername}}} | User Page for {{{WikiUsername}}}]]
([[special:Contributions/{{{WikiUsername}}} | {{{FirstName}}}'s Wiki Contributions ]])
send email

}}

ExternalData without Table

{{#for_external_table:{{{WikiUsername}}} is {{{Name}}} ["{{{Role}}}" "Staff"] "NO" ({{{Role}}}).

}}

Use Display External Table

Name Role BestEmail WikiUsername

{{#display_external_table:template=ManagerData|data=Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername }}