Widget Data Sources

Widget displays content based on data it gets from its data sources. It is possible to specify more data sources for one widget.

Widget will determine data source it will use for the logged in user by matching user & data source attributes. Matching algorithm looks for the first data source where user has all at least attributes specified on the data source and all attributes have matching values.

User-matching Example

For user A application selects DS3

For user B application selects DS4

For user C application fails to determine data source - DS1 and DS2 have attribute Department equal D2, but both have attribute Group, which user C does not have specified.

Editing Data Source

Data sources read data from specified Google spreadsheet. 

Enter sheet address/url and range which does contain the data. Range example Sheet1!A1:B3 or sheet name enclosed in apostrophes in case it contains spaces e.g. 'My Sheet'!A1:B3.

Specify any number of attributes.